replication filters in galera cluster

203 views

Skip to first unread message

trupti mali

unread,

Dec 10, 2015, 6:30:56 AM12/10/15

to codership

Hi,

I have gone through the below link of known galera limitations.

https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/

Highlighting the one of my interest

Replication filters: Within Galera cluster, replication filters should be used with caution. As a general rule except for InnoDB DML updates, the following replication filters are not honored in a Galera cluster : binlog-do-db , binlog-ignore-db,replicate-wild-do-db, replicate-wild-ignore-db. However, replicate-do-db, replicate-ignore-db filters are honored for DDL and DML for both InnoDB & MyISAM engines. Having said that, caution must be taken while using replication filters as they might create discrepancies and replication may abort (see MDEV-421, MDEV-6229).

As suggested there, I am trying to use replicate-ignore-db filter in a galera cluster. I have added this filter in the my.cnf file as well as I treid to set it up explicitly in the db as well - "set global replicate-ignore-db="test" "

But this doesnt see to work for me. As suggested above both DDL and DML are supported in these filters. But doesnt seem to be the case with me.