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.