Tagged Questions
0
votes
0answers
21 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
0
votes
1answer
22 views
Load balancing MySQL ndbcluster
I have successfully setup ndbcluster version 7.1.26. This contains 2 data nodes[NDBD], 2 mysql [MYSQLD] nodes and one management [MGMD] node. Replication works successfully. My Web application is ...
0
votes
1answer
37 views
Redo Logs Mysql Cluster
The mysql cluster has 4 directories namely D8 D9 D10 D11 for redo logfiles.
But while inserting into table only one redo directory is used.
I ran following command to get redo information "all dump ...
1
vote
0answers
22 views
Error in alter table reorganize partition for MySQL Cluster
My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition.
Some parameters of ...
0
votes
0answers
24 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
18 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
20 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
1
vote
1answer
53 views
Data usage increases initially when reorganize partition mysql cluster
In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes.
But before ...
0
votes
0answers
29 views
MYSQL Clutser (NDB) varchar storage requirement if indexed(Unique Index)
In MySQL Cluster (ndb engine) disk based table, if a column is varchar(255) with UNIQUE INDEX defined then,
For Latin(default) char set, does varchar column takes fixed size?
For UTF-8 (3 char ...
0
votes
2answers
67 views
MySQL Cluster - partitions on disk
I have question about MySQL Cluster:
Is it possible to have database larger than amount of RAM? (to not have all cluster data in-memory, but some data will reside on clusters nodes hard disks)
...
0
votes
3answers
70 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
1
vote
0answers
37 views
memcached+mysql cluster maximum memory
I'm deploying a system with memcached and mysql cluster.
The command line is:
memcached -E lib/ndb_engine.so -e "connectstring=maddy:1186;role=dev"
I can't specify the -m argument since I used -E ...
3
votes
1answer
118 views
MySQL licensing
I have looked at a few questions posted in stackoverflow
http://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme
...
0
votes
1answer
66 views
How to removing or reduce the size of redo logs in MySQL cluster
Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
2
votes
1answer
94 views
How to solve the error “Error 'Got error 0 'No error' from NDBCLUSTER' on query”?
I'm currently working with a large network of MySQL 5.1 DBs (using MyISAM tables) and I'm evaluating a move to MySQL Cluster. I would like to have the MySQL Cluster replicate off of one of the ...
1
vote
1answer
81 views
MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs
I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
1
vote
2answers
85 views
Distributing MySQL database on n systems
I have a webserver in my application which talks to a single MySQL node. Instead of having just one MySQL node, I want to have a cluster of n nodes which form my database.
Is it possible to do ...
0
votes
0answers
571 views
MySQL Cluster: Problem Connecting Nodes to Manager [closed]
After successfully setting up a test MySQL Cluster on Ubuntu I am now attempting it on Centos and have successfully started the management node, however I cannot get the data nodes to connect to the ...
3
votes
2answers
208 views
Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years?
We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB.
When we created a test enviornment with the DB size as 200GB, NDB Cluster took more ...
2
votes
2answers
689 views
MySQL Cluster: Problem Connecting the SQL node
In a MySQL cluster I have three hosts, one with a manager node, and the other two are each both a data node and sql node. Connecting to the manager is possible, however only as [ndbd] and not ...
3
votes
1answer
206 views
Slow-running query on clustered MySQL environment
I've got a very simple query, directly equivalent to
SELECT * FROM sometable t WHERE somecol = 'somevalue' ORDER BY createdon DESC LIMIT 0,20000;
When I run this query on my non-clustered ...
1
vote
2answers
404 views
MySQL Cluster On Cloud vs MySQL Cluster On Dedicated Cluster
I saw this interesting article : http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-mysql-cluster-72.html and it made me get interested in MySQL Cluster.
After little chat with hosting ...
2
votes
2answers
279 views
MySQL Cluster Installation
I am very new to mysql-cluster.I downloaded the binaries and was trying to configure it on my local machine.
Can anybody suggest how to install it on single machine with the 1 management node,2 data ...
