MySQL Forums
Forum List  »  Replication

MIXED format not replicating Inserts events
Posted by: Eruc Lstar
Date: May 10, 2019 03:39AM


First of all I want to thanks in advance to that forum creators and contributors.

I've a big problem. We have a Master replicating into a Replica
The master DB Binlog-format is MIXED and since we had some problems with triggers, we deleted those triggers from the Replica.

Now we've found that some tables are not well replicated on the Replica.
Checking the binary log, we saw that Inserts events launched by triggers were not logged into.

This is the regular behaviour or it is a bug?

We are thinking in two possibilities:
- change that format to ROW or STATEMENT
- create those triggers on the replica (but someday it will break the replica again)

Please help!!


Options: ReplyQuote

Written By
MIXED format not replicating Inserts events
May 10, 2019 03:39AM

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.