Hy there,
I'm planing to to build a small "partial replication" on MySQL 5.0 using the Spread
Toolkit and the Message API for MySQL. Therefore I'll create a trigger (on insert) which
fetches the row and sends it to the message group XY.
I was wondering if there is a way to tell MySQL in an SQL statement to not fire the
trigger, for example if a message from Server B arrives on A - and contrariwise - I don't
want the trigger to be launched to avoid loops and such.
I actually couldn't find anything about this topic. So, my question: is it possible at
all?
Regards and thanks in advance,
Toby

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.