FOSDEM is next weekend and I am talking about Parallel Replication on Friday, February 2nd at the MySQL Pre-FOSDEM Day (there might be tickets left in case of cancellation, attendance is free of charge). During this talk, I will show benchmark results of MySQL 8.0 parallel replication on Booking.com real production environments. I thought I could share a few things before the talk so here it is.
Below and on the left, you can see the commit rate of single-threaded replication. On the right, it is the improved throughput with Multi-Threaded Slave (also known as MTS or Parallel Replication). It is obviously much better !
This increased throughput is obtained with enabling Write Set Parallelism Identification on a MySQL 8.0.3 intermediate master. I have previously blogged about Write Set so you can read more about it in my previous posts:
- An update on Write Set (parallel replication) bug fix in MySQL 8.0
- Write Set in MySQL 5.7: Group Replication
- More Write Set in MySQL: Group Replication Certification
Finally, below is the CPU graph matching the commit rate graph above. As you can see, the increased throughput comes at the cost of using more CPU, which is expected.
In addition to the Pre-FOSDEM MySQL Day, I am also attending the MySQL Community Dinner on Friday, February 2nd (one of the sponsors is Booking.com). I do not know yet where I will be on Saturday (I might attend Peter Zaitsev talk about Methodologies for Databases Performance Analysis and Troubleshooting) but on Sunday and most of the day, I will be in the MySQL and Friend devroom.