May 22, 2012

Post: Why audit logging with triggers in MySQL is bad for replication

… I was tasked with investigating slippage between master and slave in a standard replication setup. The client was using Maatkit’s… see this table is actually an audit table for changes to the Foo table. The trail is kept using two triggers on… you can see from the above, the updates were performed in a different order, with the inserts being assigned a different…