I am using replication in a MYSQL database. I have read some where DELETE IGNORE command on Tables with Foreign Keys can break Replication. Is it true? If it is true then how can workaround this?
-
Actually, I have put this question as there is nothing found about this topic here. – Pankaj Kumar Mar 22 '18 at 5:33
-
(You can "accept" your answer.) – Rick James Mar 27 '18 at 15:37
I have read it here: https://www.percona.com/blog/2012/02/02/stop-delete-ignore-on-tables-with-foreign-keys-can-break-replication/
The details of how DELETE IGNORE can be unsafe for replication is shown in that blog.
The solution to work around the issues to do either one of:
Don't use DELETE IGNORE
Use Row-Based Replication by setting binlog-format=ROW
-
Since the default is moving toward RBR, this problem will become rare. – Rick James Mar 27 '18 at 15:36