- MySQL & MariaDB
- Relational Databases
- Next week in Brussels: Parallel Replication at the MySQL Pre-FOSDEM Day
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 !
- 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
The commit rate above increases when the slave crosses the point where Write Set Parallelism Identification is enabled on its master. So it is not exactly as I wrote above: parallel replication is enabled for the whole graph but no parallelism is identified by the master on the left (Write Set is disabled) and parallelism is identified on the right (Write Set is enabled). We can see the impact of this in the graph below where I show the Average Modified Interval Size/Length metric before and after enabling Write Set (the parallelism intervals are of size one on the left and much larger on the right). To know more about this metric, you can read my previous post.
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.