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 Consultant, Percona
Biography: 
Born and working in Argentina, Francisco has been working as DBA for over 8 years. Started in the health industry with SQL Server Francisco has collaborated as DBA testing and deploying backend solutions. In 2008 Francisco moved to Mobile Marketing industry where he started with MySQL 4.1 in high volume environments, he successfully collaborated on version upgrading to 5.x series. With additional experience in gaming world Francisco moved to The Pythian Group in 2011 becoming a Remote DBA, this opportunity helped to improve DBA skills in complex environments. Finally in 2013 Francisco moved to Percona becoming a MySQL consultant where highly complex environments are part of the daily work and MySQL is just one of the moving pieces. He is also an active collaborator of Argentina groups and an active participant of Argentina and Uruguay conferences, and also participated as speaker in PLMCE 2013.

Slides