In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived.
Let us consider our architecture below with async replication from PXC to Percona Server for MySQL:
PXC PS-MySQL ============== ============== node1 +----> node4 node2 | node3 -----+
Our goal is to set node3 as the async replication primary source. Then, upon failure, VIP can move to node2 and then node1 when node2 also fails. Once node3 becomes available again, the virtual IP should come …[Read more]