Replicate_Ignore_DB does not take effect
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
Subject
Views
Written By
Posted
Replicate_Ignore_DB does not take effect
732
March 24, 2022 02:31AM
390
March 24, 2022 08:47AM
368
March 24, 2022 08:13PM
Sorry, you can't reply to this topic. It has been closed.
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.