Synchronous multi-master replication with the Galera plugin. Your application connects to the load balancer and it redirects read/write traffic to the various MySQL Galera nodes. Tested a setup with 17 SQL nodes and you can have even more. Scaling reads and also a little bit for scaling writes is what Galera is good for.
If one node fails, the other two nodes still communicates with each other and the load balancer is aware of the failed node.
Why Galera? …[Read more...]