Recently, I’ve been looking into issues with the interactions
between MySQL asynchronous replication and Galera replication. In
this blog post, I’d like to share what I’ve learned.
MySQL asynchronous replication and Galera
replication interactions are complicated due to the number
of factors involved (Galera replication vs. asynchronous
replication, replication filters, and row-based vs.
statement-based replication). So as a start, I’ll look at an
issue that came up with setting up an asynchronous replication
channel between two Percona XtraDB Cluster (PXC) clusters.
Here’s a view of the desired topology:
We want to set up an asynchronous replication channel between two
PXC …[Read more]