Mariadb replication issue.
 

Hi all,

I am using Mariadb 5.5.56 version and configured statement based replication, also there is one master server and other is slave server, the issue faced by me is whenever the grant is executed for particular Mariadb user on master server the same grant is being executed on slave server for the same Mariadb user.

It should't be executed as i have ignored mysql db in my.cnf file of both the servers,
please look at my.cnf file of both the servers.

Master server

# Replication (Master)
# -- modify iptables to allow port 3306 connections
log-bin
server-id=1
log-basename=mysqlbinarylog
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=test
binlog-ignore-db=tracs_testdata
innodb_flush_log_at_trx_commit=1
sync_binlog=1
expire_logs_days=14
#expire_logs_days=0
#
key_buffer_size=4G


Slave server

# Replication (Slave)
server-id=3
relay-log=mysqlrelaylog
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=test
replicate-ignore-db=tracs_testdata
replicate-ignore-table=tracs_dataG.camasterd
replicate-wild-ignore-table=tracs%.norep%
### Only super and repl can write ###
read_only
#########

Please help me with the issue and do let me know in case of any required info.

Regards,
Akshayj