MySQL replication has been available for years, and even though a number of new clustering technologies showed up recently, replication is still very common among MySQL users. It is understandable as replication is a reliable way of moving your data between MySQL instances. Even if you use Galera or NDB cluster, you still may have to rely on MySQL replication to distribute your databases across WAN.
In this blog post we’d like to discuss one of the most common operations DBA has to handle - replication topology changes and planned failover.
This is the fifth installment in the ‘Become a MySQL …[Read more...]