Brussels / 30 & 31 January 2016


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 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 workloads. Finally, I discuss some deployments at that benefits from parallel replication speed improvements.


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