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.