I am using PXC 5.7.x MySQL multi-master cluster which is also configured to be master slave with other clusters across geographical regions. I am using RSU. For DB change automation and tracking I am testing liquibase S/W automation which creates its own meta-data tables on each node for tracking purpose. Is there a way for me to not replicate any meta-data inserted (DML operations) on those tables created by liquibase to any other nodes which are part of multi-master replication or master slave replication setup i.e. filter them. But I want rest of the data to be replicated as usual. And how I can achieve this?
1 Like
Hello @rahulsri_percona,
For asynchronous replication you can use the normal replication filters. Just put that meta db to ignore and you’re set.
1 Like
Thanks. We are using Multi-master Galera replication within a cluster. So it is synchronous replication in other words, when a transaction commits, all nodes have the same value. What option is available in this particular situation?
1 Like
That is an invalid statement; that’s why I assumed you were talking about async replication. Galera can only be multi-master, there is no other option, so saying “multi-master galera replication” doesn’t make sense.
There is no built-in way to filter galera replication. That defeats the entire purpose behind galera replication. The purpose is that every node always has the same data. Any violation of this is a cluster-wide violation.
1 Like
I got it that -->There is no built-in way to filter galera replication. Thanks
1 Like