Mariadb 5.5.56 replication issue

Hi Team,

We are using the mariadb replication in our environment, where is one master and one slave server. The issue we are facing is that we had added to ignore the replication of mysql database from master to slave server.

The issue although the mysql database is added to ignore for replication both my.cnf file of master and slave server, whenever we are executing any grant statement on master the same, the same query is also executing on slave server, as per the configuration is should not happen.

We are using statement based replication, please find the below configuration of my.cnf file for master and salve server.

1.Master server to ignore mysql database. log-bin server-id=1 log-basename=mysqlbinarylog binlog-ignore-db=mysql

2.Slave server to ignore mysql database.

server-id=3 relay-log=mysqlrelaylog replicate-ignore-db=mysql

Whenever we running any grant statement on master server, the same query is getting executed on slave also.

We troubleshooted the issue from our side and it is mention to add binlog-ignore-db=mysql in my.cnf file of master but the same is not working.

https://dba.stackexchange.com/questions/584/how-can-you-stop-mysql-slave-from-replicating-changes-to-the-mysql-database https://stackoverflow.com/questions/18830964/filter-mysql-replication-ignore-db

Kindly hep us on this issue. Thanks and Regards, Vijay Maurya