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

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

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?

Thanks.

2

An existing bug/feature request confirms this behavior and there is no fix nor workaround AFAIK.

[url]https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1371565[/url]

I hope this helps.