The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

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

Answer Answered by Ian Gilfillan in this comment.

See Statement-Based Logging. Statement-based logging works by using the default database, i.e. the one set with USE.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.