MIXED format not replicating Inserts events
Hello!
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!!
Thanks!
Subject
Views
Written By
Posted
MIXED format not replicating Inserts events
1360
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.