achieving cluster benchmarks
I will like to know what exactly are the advantages of using MySQL cluster.
http://www.mysql.com/why-mysql/benchmarks/mysql-cluster/
I have read the benchmarks mentioned above. But in my test environment, I do not get anything close to this. I used "mysqlslap" utility to check the select load an NDBcluster table type can handle as against MyISAM table. And found that NDB engine was no better than MyISAM. What am I missing?
-
Hi Shantanu,
Latency on single queries will always be higher in NDB, since it is a distributed database and the request goes through the SQL and Data Nodes. The network hop adds to the latency.
However, a single MySQL node will max out at a certain number of requests whereas NDB will be able to handle higher throughputs through its ability to have more nodes.
High availability is another advantage, NDB has inbuilt synchronous replication within the data nodes and automatically handles failovers.
Hope this helps.
Vinay
Please sign in to leave a comment.
Comments
1 comment