MySQL replication mystery

Posted on

Question :

May I ask if its possible to have a table on Slave server. But it does not exist on Master Servers? how come this one happens? Thank you.

Answer :

If the data is currently being updated on the replica, it could be due to a trigger (show triggers from [database];) or a replication rewrite flag (look at the my.cnf for master and slave).

Leave a Reply

Your email address will not be published. Required fields are marked *