Sunday, January 18, 2009
MySQL Replication: Audit, Test, & Verify
Webcast - 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 that seems to bog down a lot of DBAs is the slaves getting out of sync with the master. If you're lucky you would 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. In this live online event, we'll talk about why this happens, both in terms of things that happen in the application and in MySQL's implementation of statement-based replication. We'll then discuss a method to eliminate the problem by testing and verifying your current setup."