Diagnosing MySQL Replication Failures

Average rating: ****.
(4.14, 7 ratings)

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 SHOW SLAVE STATUS, 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.

Photo of Devananda Van Der Veen

Devananda Van Der Veen


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.

Photo of Justin Swanhart

Justin Swanhart


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.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts