Diagnosing & Fixing MySQL Replication

Replication is one of MySQL's most widely-used features, and despite significant improvements over the years, it can still fail. When this happens, it can be due to any number of factors, either internal or external to your MySQL database. 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. The first portion of this talk presents a detailed review of the replication architecture, while the main portion of the talk will show you how to recover a replication slave from some real-world failures.

Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Room: 
Tribeca

Schedule Info

2 October 16:00 - 16:50 @
Tribeca

Speakers

Devananda van der Veen's picture
-, HP Cloud Services

Deva joined HP Cloud Services in 2012 and contributes to OpenStack. Previously he worked as a Principal MySQL Consultant at Percona. He studied computer science at the College of Creative Studies at UC Santa Barbara, and has worked in the internet technology space since '99.


Sponsored By