MySQL Forums
Forum List  »  Replication

Replicate_Ignore_DB does not take effect
Posted by: Shobri Utomo
Date: March 24, 2022 02:31AM

Hi All,

I have a replication setup where the Master is multiple Mysql 5.7 server and the Slave is Mysql 8, I've separate each master by channel, in general the replication can works.

I set the replication to not include the changes from certain DB from the master by having a replicate_ignore_db directive in the Slave. However, changes from the ignored DB still causing the replication to break (making the Slave_SQL_running into "No" and the Last_SQL_Error indicates it because of the changes from Ignored DB).

What am I doing wrong? because it seems although the Replicate_Ignore_DB is set, the slave still trying to excute the chnages from it.

additional info:
the master is MysSQL 5.7.34
and the Slave is MySQL 8.0.28

and the replicate_ignore_DB is set into the Slave my.cnf config file

Options: ReplyQuote


Subject
Views
Written By
Posted
Replicate_Ignore_DB does not take effect
196
March 24, 2022 02:31AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.