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 provider and i was told i may not be able to achieve to such performance on the Cloud Architecture which brings me to my question :
MySQL Cluster On Cloud vs MySQL Cluster On Dedicated Cluster
- Are there really any performance difference
- Which is better and why ( using different factors eg. Scalability , Cost Implication etc)
Thanks
Best Answer
The biggest difference will come from networking - Mikael's tests were run over Infiniband whereas most hosting or cloud providers will not give you that type of dedicated bandwidth. As a distributed database, MySQL Cluster needs high network bandwidth to support message passing between the nodes, so the higher the network latency, the lower the read or write performance, though this can be offset by increasing concurrent load to the database
If you want to know more about the benchmark itself and how to run it on your own cloud vendors environment, check out this blog: https://blogs.oracle.com/MySQL/entry/performance_testing_of_mysql_cluster