The mysql-cluster tag has no wiki summary.
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
1answer
40 views
MySql Cluster for educational use
I am student and I am writing Master of Science paper about in-memory databases. I want to use MySql Cluster for benchmarks in my work.
Can I use MySql Cluster free of charge for educational purposes ...
1
vote
1answer
54 views
Error on data node startup in MySQL-cluster
Running a 24 core server (with HT enabled) I tried increasing MaxNoOfExecutionThreads to 24 to perform some benchmarks and got the following error:
2013-02-27 11:21:44 [ndbd] INFO -- Trying to ...
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)
...
2
votes
1answer
140 views
Which database to use? [closed]
Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order:
Auto-Sharding (getting more free space by adding more server ...
0
votes
3answers
71 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 ...
1
vote
0answers
143 views
MySQL cluster stuck in start phase 4, how to proceed?
Over the weekend our cluster we set up for evaluation had one of its data nodes lose network connectivity briefly. This was while another data node was in the middle of a restart (which had been going ...
1
vote
0answers
147 views
Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?
As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query?
LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
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
82 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
573 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
692 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
0answers
330 views
MySQL Cluster LOAD DATA too slow
mysql-5.5.22 ndb-7.2.6 cluster 64bit running on Centos 6 with each node installed on the same Citrix Xen Server communicating via a virtual private network. Each node has 4GB of RAM, 4 vCPUs and 10GB ...
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 ...
0
votes
1answer
90 views
Better diagnostics when starting ndb nodes?
I have an ubuntu linux server that uses mysql cluster 7.2.5 x64.
Whenever I start an ndb node and check with ndb_mgm -e show, it stays in "starting" state for a long time. When I use top to check the ...
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 ...
