List:Replication« Previous MessageNext Message »
From:Parrie Date:February 15 2005 1:08am
Subject:Why does DELETE CASCADE cause problems with replication?
View as plain text  
Hey all,

In the manual under open bugs
(http://dev.mysql.com/doc/mysql/en/open-bugs.html), it mentions that
there may be replication problems if you do a delete cascade

DELETE if you are deleting rows from a table that has foreign keys
with ON DELETE CASCADE properties.

I can't figure out why this might cause problems.

Is it perhaps only a problem if your tables are InnoDB in the Master
and MyISAM in the slave?

Thanks if anyone can shed some light!

-Parrie
Thread
Why does DELETE CASCADE cause problems with replication?Parrie15 Feb