Replication is one of MySQL’s most widely-used features, and despite significant improvements over the years, it still fails. When this happens, it can be due to any number of factors, either internal or external to your MySQL database. No matter how it fails, it is always a problem that should be taken seriously. For those who do not have a thorough understanding of the MySQL binary log format or the slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be a daunting task. This talk will show you how to interpret SHOWSLAVESTATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many types of real-world failures. This talk will also cover situations from which it is currently impossible to recover without some data loss, and briefly show you a tool which might be able to help in some of these, mk-table-sync.

Devananda Van Der Veen

Percona

Deva joined Percona in July 2009 as a Principal Consultant, with a focus on scalability and performance tuning. In addition to consulting, he also assists with documentation and internal training of the SSC team. Deva has a background in physics and computer science from the College of Creative Studies at UC Santa Barbara, where he also studied eastern religions. He has worked in the internet technology space since ‘99. Prior to joining Percona, he was the sole DBA at HydraNetwork, an online ad/media company, where he helped grow the company’s revenue to over $100M by creating a scalable and fault-tolerant MySQL database network. Deva also consulted for a number of Southern California startups before he moved to Washington state. He now works from his home in the Olympic Mountains where he lives with his wife and two beloved huskies.

Justin Swanhart

Percona

I’m a Principal Consultant at Percona. I’ve worked for Proven Scaling, Yahoo, AdBrite and other high volume web sites. My expertise is in scaling high volume websites through horizontal partitioning, data aggregation and query parallelism.