MySQL Forums
Forum List  »  Replication

Mysql replication failure during the delete operation
Posted by: Alex N
Date: April 02, 2018 04:59AM

Hello,

We have Mysql Master and 2 full Slave:
When delete some entity on Master associated by foreign key with many tables, on Slave all records for all this tables delete, but on the master not delete. Errors on master there are no.
The next update or delete this entity on master slave broken, because on slave have already been deleted.

Mysql Distrib 5.7.21
...
gtid-mode = on
binlog_format = row
enforce-gtid-consistency= true
slave_compressed_protocol = 1
slave_preserve_commit_order = 1
slave-parallel-type = LOGICAL_CLOCK
...

Why this can happen?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql replication failure during the delete operation
960
April 02, 2018 04:59AM


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.