MySQL Parallel Replication: inventory, use-case and limitations
- Track: MySQL and Friends devroom
- Room: H.1308 (Rolin)
- Day: Saturday
- Start: 16:35
- End: 17:15
I will discuss MySQL and MariaDB parallel replication implementation, including their strengths, weaknesses and tuning parameters. I will also present benchmark results from real Booking.com workloads.
In the last 24 months, MySQL replication speed has improved a lot thanks to implementing parallel replication. MySQL and MariaDB have different types of parallel replication; in this talk, I present in detail the different implementations, with their limitations and the corresponding tuning parameters (covering MySQL 5.6, MariaDB 10.0, MariaDB 10.1 and MySQL 5.7). I also present benchmark results from real Booking.com workloads. Finally, I discuss some deployments at Booking.com that benefits from parallel replication speed improvements.
Speakers
Jean-François Gagné |