Session
Diagnosing and Fixing MySQL Replication

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 25th, 4:00 PM
Fleet Suite

Abstract

Replication is one of MySQL's most widely-used features, and despite significant improvements over the years, it still fails occasionally. 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. 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.

Slides

Diagnosing and Fixing MySQL Replication

Download Slides

Speaker

Devananda van der Veen

Devananda van der Veen

Consultant, Percona

Deva joined Percona in July 2009 as a Principal Consultant, with a focus on scalability and performance tuning. He studied computer science at the College of Creative Studies at UC Santa Barbara, and has worked in the internet technology space since '99. Prior to joining Percona, he was the sole DBA at HydraNetwork for several years, and also provided consulting for a number of Southern California startups. He now works from his home in Washington's Olympic Mountains where he lives with his wife and two beloved huskies.

 

]]> ]]>