I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post.
Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster?
Answer for this: yes and no.
Galera assigns its own GTID for the operations, replicated to all nodes of the cluster. Such operations include DML (
INSERT/UPDATE/DELETE
) on InnoDB tables and DDL commands, executed with default TOI method. You can find more details on how GTIDs work in the Percona XtraDB Cluster in this blog post.
However, DDL commands, executed with RSU method, are …
[Read more]