Say you have a cluster with 3 nodes using Percona XtraDB Cluster (PXC) 5.6 and one asynchronous replica connected to node1. If asynchronous replication is using GTIDs, moving the replica so that it is connected to node2 is trivial, right? Actually replication can easily break for reasons that may not be obvious at first sight.
Summary
Let’s assume we have the following setup with 3 PXC nodes and one asynchronous replica:
Regarding MySQL GTIDs, a Galera cluster behaves like a
distributed master: transactions coming from any node will use
the same auto-generated uuid. This auto-generated uuid is related
to the Galera uuid, it’s neither ABC, nor DEF, nor GHI.
Transactions executed for …
[Read more]