Not the answer you need?
Register and ask your own question!

Master-master asyn replication between two PXC clusters and replicate-ignore-table

pxc127pxc127 EntrantCurrent User Role Beginner

We have set up master-master async replication between two 3 node 5.6.24 PXC clusters.
One table contains environment specific data and we need to exclude this table from the bi-directional replication.
However, if we set replicate-ignore-table on the async slave node, the table is out of sync between the nodes in the same cluster.

It seems replicate-ignore-table affects async Mysql replication between the clusters and Galera replication within the cluster.

Is there any way we can work around this problem?



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.