Brussels / 30 & 31 January 2016

schedule

MySQL Parallel Replication: inventory, use-case and limitations


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

Photo of Jean-François Gagné Jean-François Gagné

Attachments

Links