Skip navigation links

User Comments

Posted by Nathan Moon on November 2 2009 10:41pm[Delete] [Edit]

I got a little confused by the part that says that UPDATE and DELETE triggers don't execute on BLACKHOLE tables. If you are using a BLACKHOLE replica to relay binlogs to other "real" replicas, this does not mean that changes from UPDATE and DELETE triggers won't be applied on the real replicas, just that the triggers won't actually fire on the BLACKHOLE replica. At least that's my understanding.

Posted by Ruben Cardenal on October 1 2012 11:45am[Delete] [Edit]

According to Nathan's comment, an UPDATE trigger on a BLACKHOLE table does work in certain cases. For example: a BEFORE trigger (the AFTER one won't work) that updates data on other non-BLACKHOLE table.