Sean Hull

MySQL Replication: Audit, Test, & Verify

Date: This event took place live on January 22 2009

Presented by: Sean Hull

Duration: Approximately 60 minutes.

Cost: Free

Questions? Please send email to

Description:

Audience: MySQL DBAs and developers

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.

About Sean Hull

Sean Hull is a business and technology consultant, author and speaker. He is the founder and senior consultant at Heavyweight Internet Group in New York and has worked as a database consultant and expert for ten years. He is the author of "Oracle and Open Source" (O'Reilly) and his articles appear on Oracle Technology Network, Database Journal, DBA Zine, ChangeThis.com, and many others. Using techniques, technologies, and perspectives discussed in his book, articles, and seminars, he has taken his career into exciting areas. He has served as Technology Consultant, Project Manager, CEO, and mentor with a background in programming, systems integration & administration, project development and management.