Buy Percona ServicesBuy 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.

Stephane Combaudon
Senior Architect
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.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.