Re: Triggers and mysql replication

[Walter Vrey]

Hi,

Just to update our findings on triggers on server only and not on slaves:

1. Some records are being replicated when the trigger insert the record

2. Most tables stay unchanged on the slaves. The trigger events will update and insert records on the master as designed, but replication of those records fails.

So, a very expensive lesson learned :)
Back to the drawing board, now to sort out how the db should handle autonumbers and triggers on master / slave environment...

Regards
Walter