…between master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to check his slave data…using two triggers on that table. select trigger_name, event_object_table, Event_Manipulation from information_schema.triggers where trigger…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…triggers and most likely switching to row based replication would have help. @Ryan H: Yes, my discussion is about a single database…Replication are two different ways of replicating data, from my experience, DRBD is more reliable than replication…use SSL between your application servers and your MySQL…
