Re: High availability scenario scrutiny sought

[Ted Wennmark]

Hi Sandeep,

This kind of setup will not work with MySQL Cluster, MySQL Cluster needs reliable network between data nodes and you need to guarantee predicable latency on the network. MySQL Cluster send heartbeats between data nodes and if you loose network connectivity between data nodes parts or whole cluster will die depending on network failure. Furthermore if one office gets isolated that part of the cluster would die and only be possible to start once you have connectivity again, at this point data nodes would automatically resynchronize and join the cluster.

Please start by reading our evaluation guide, you can get a copy here: http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/

Kind Regards,
Ted