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