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.

Speakers

Francisco Bordenave
MySQL DBA - Team Technical Leader, The Pythian Group Inc.
Biography: 
Born and working from Argentina, I've more than 6 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. Currently I'm technically supporting a DBA team for The Pythian Group, active collaborator for some MySQL groups. I've spoke at first Latin American MySQL, MariaDB and NO-SQL conference. Collaborated with MariaDB spanish documentation.

Slides