Debug and Fix Replication Issues Like a Pro

Replication and High Availability Strategies
23 April 11:30am - 12:20pm @ Ballroom D

Replication is a powerful feature of MySQL that makes it possible to bring up copies of a master database for different purposes: backups, high availability, scaling, and so on. One of the greatest benefits of MySQL Replication is simplicity. It is easy to set up and maintain, but why do so many DBAs out there struggle with replication errors, trying to fix data discrepancies between master and slave databases over and over again? This presentation focuses on analyzing the most-common replication problems: duplicate key issues, missing data, and the like. It also includes examples of how mixing transactional and nontransactional statements can cause unpredictable replication errors and how analyzing binary logs helps identify the root cause of a problem.


Francisco Bordenave
MySQL Consultant, Percona
Born and working from Argentina, I've more than 7 years of experience working as DBA, I've been started with SQL Server 2000 then moved to MySQL from 4.1 and going through latest releases. I'm currently working as a MySQL Consultant at Percona, active collaborator of Argentina groups, I've been speaking in Argentinian conferences and also have participated as speaker in PLMCE 2013.