https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves Blog by Shlomi Noach Wed, 11 Mar 2015 08:40:04 +0000 hourly 1 https://wordpress.org/?v=5.3.3 https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves/comment-page-1#comment-311672 Wed, 11 Mar 2015 08:40:04 +0000 https://shlomi-noach.github.io/blog/?p=4860#comment-311672 […] Do you have foreign keys on your InnoDB tables? If so, you’re in to integrity issues. If you happen to have ON DELETE CASCADE or ON DELETE SET NULL – prepare for bad news — the cascading will not propagate on slave. See: Impact of foreign keys absence on replicating slaves […]

]]> https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves/comment-page-1#comment-286182 Sun, 02 Nov 2014 10:11:59 +0000 https://shlomi-noach.github.io/blog/?p=4860#comment-286182 […] https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves 要严格保证主从一致才能用外键, 应用中用了事务就不要再用外键了, […]

]]> https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves/comment-page-1#comment-91136 Mon, 14 May 2012 19:22:12 +0000 https://shlomi-noach.github.io/blog/?p=4860#comment-91136 @XL,
Nevertheless it does not.

]]> https://shlomi-noach.github.io/blog/mysql/impact-of-foreign-keys-absence-on-replicating-slaves/comment-page-1#comment-91130 Mon, 14 May 2012 18:38:12 +0000 https://shlomi-noach.github.io/blog/?p=4860#comment-91130 If you use row based replication, then the cascading update should make it to the slave.

]]>