Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, February 25, 2015    Stephane Combaudon

Multi-threaded Replication in MySQL 5.6 and 5.7

Replication is used everywhere with MySQL. However, applying writes in a single thread is often a bottleneck as replicas have a hard time keeping up with the master that can execute writes in parallel.

Enter MySQL 5.6. You can use several threads to apply writes on replicas as long as you have several schemas. MySQL 5.7 goes even further: by introducing a logical clock and by changing the scheduling logic, you can apply writes in parallel in a single schema. The result is a much better replication throughput. However, this feature also raises a lot of questions which we will address during this webinar:

  • How does it work internally?
  • Does it play well with GTIDs?
  • How can you monitor replication status?
  • How do you recover from a replication error?
  • If you want to take a backup from a replica, how can you make sure you will get a consistent snapshot?

By the end of the session, you will have a better understanding about how multi-threaded replication can be used in your organization.


About the Author

Stephane Combaudon

Stéphane joined Percona in July 2012, after working as a MySQL DBA for leading French companies. In real life, he lives in Paris with his wife and their twin daughters. When not in front of a computer or not spending time with his family, he likes playing chess and hiking.