Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL/MariaDB Parallel Replication: inventory, use-cases and limitations

MySQL/MariaDB Parallel Replication: inventory, use-cases and limitations

 4 October 4:20 PM - 5:10 PM @ Matterhorn 2
Experience level: 
50 minutes conference
New and Trending Topics
Tools and Techniques


In the last 24 months, MySQL/MariaDB replication speed has improved a lot thanks to parallel replication. MySQL and MariaDB have different types of parallel replication; in this talk, I present the different implementations, with their limitations and the corresponding tuning parameters. I cover what to do to make parallel replication faster and what to avoid for maximizing parallel replication benefits. I also present benchmark results from real workloads. Finally, I discuss some deployments at that take advantage of 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 installations by removing replication bottlenecks (he also works on other engineering problems that are less relevant here). One of his latest project is the Binlog Server but he also has an in deep understanding of GTIDs and parallel replication (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 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 system and network group communication protocols.

Share this talk