Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Parallel Replication: inventory, use-case and limitations

MySQL Parallel Replication: inventory, use-case and limitations

 21 April 12:50 PM - 01:40 PM @ Ballroom A
Experience level: 
50 minutes conference
Case Stories
New and Trending Topics
Tools and Techniques


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 details the different implementations, with their limitations and the corresponding tuning parameters. I also present benchmark results from real workloads. Finally, I discuss some deployments at that benefits from parallel replication speed improvements.


Jean-François Gagné's picture

Jean-François Gagné

Senior System Engineer,


Since joining in October 2013, Jean-François is working on growing the MySQL/MariaDB installations by removing replication bottlenecks (he also works on other engineering problems that are less relevant here). Some of his latest projects are making Parallel Replication run faster and deploying Binlog Servers. He also has a good understanding of replication in general and a respectable understanding of InnoDB, Linux and TCP/IP. Before, he worked as a System/Network/Storage Administrator in a Linux/VMWare environment, as an Architect for a Mobile Services Provider, and as a C and Java Programmer in an IT Service Company. Even before that, when he was learning computer science, J-F studied cache consistency in distributed systems and network group communication protocols.

Share this talk