MySQL Forums
Forum List  »  Replication

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


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

Written By
Mysql replication failure during the delete operation
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.