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?
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