Why MySQL Replication Fails, and How to Get it Back

Tuesday 12:20PM-1:10PM

@ Goldsmith 2

MySQL / MariaDBOpen Source Databases

50 minutes conference

Beginner

Tracks:
Business / Case Studies, Operations

Replication is one of the features that made MySQL a popular RDBMS. It is easy to setup, and by default it allows read-write access on both the master and slave. It is also easily creates complicated deployments, such as circular replication.

By default, MySQL Replication is asymmetrical, but it has semi-sync replication plugin. Since version 5.7 it supports multi-master slaves. All these features implement a quick start, but there is also a huge risk of making the wrong decision.

In this session, I will demonstrate why one or another replication solution can fail with data loss or perform slowly. I will show methods that will help you to diagnose and resolve these issues.

This session uses built-in, then command-line tools, because knowledge of how they work is essential for effective troubleshooting.


Speakers

Sveta Smirnova

Sveta Smirnova (Percona)

Principal Support Engineer

Biography:

Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book "MySQL Troubleshooting" (http://shop.oreilly.com/product/0636920021964.do) and author of JSON UDF functions for MySQL. In years 2006 - 2015 she worked in in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority in Oracle, in year 2016 she restarted this role at Percona. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as web developer on several closed CRM systems. In years 2012-2015 she worked on MySQL Labs project "JSON UDFs for MySQL". She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA