MySQL Replication – Audit, Test & Verify

MySQL replication is fairly easy to set up, but in the real world many obstacles can get in the way of keeping it up and running smoothly. One problem is the slaves getting out of sync with the master. If you’re lucky you’d be alerted with an error in your slave log file, and can then track down that problem. But sometimes it drifts out of sync silently. Both are situations you want to avoid. Sean Hull talks about why this happens, both in terms of things that happen in the  application and in MySQL’s implementation of statement-based replication. Then he shares a method to eliminate the problem by testing and verifying your current setup.