principlesqlMinor
MySQL Cluster On Cloud vs MySQL Cluster On Dedicated Cluster
Viewed 0 times
dedicatedmysqlcloudcluster
Problem
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
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
Thanks
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
Solution
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
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
Context
StackExchange Database Administrators Q#19384, answer score: 2
Revisions (0)
No revisions yet.