Subscribe to the
Percona Newsletter

Subscribe Now!
  Thursday, August 25, 2016    Sveta Smirnova

Replication is one of the features that made MySQL the most popular relational database management system. It is easy to set up. By default, it enables read/write access on both master and slave, and allows you to easily create complicated deployments such as circular replication. MySQL Replication is asymmetrical but has a semi-sync replication plugin. Since MySQL 5.7, it supports multimaster slaves.

All these features are fairly simple and easy to implement. However, you run a huge risk of making the wrong replication strategy decision if you don’t understand the ins-and-outs of each. In this webinar, you will learn about common replication errors and methods to help resolve them.

We will discuss both unexpected database behavior and performance issues. We’ll also study how IO and SQL threads work, and how to resolve issues specific to each of the replication threads.

About the Author

Sveta Smirnova

Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.