Using Multi-Master Replication
MySQL replication can be used for many benefits, including supporting scalability and higher availability. By default, MySQL replication does not support an environment that manages failover situations, or writing concurrently to multiple servers in a replication topology, without additional configuration and management.
In this chapter we will discuss:
•   Configuring MySQL replication to support failover
•   Demonstrating the manual steps for failover and failback
•   More advanced replication topologies
MySQL ...

Get Effective MySQL Replication Techniques in Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.