From: Parrie
Date: February 15 2005 1:08am
Subject: Why does DELETE CASCADE cause problems with replication?
List-Archive: http://lists.mysql.com/replication/38
Message-Id: <a5ef9da20502141708311532b1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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