Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

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

Sponsor Percona Live Open Source Database Conference

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

 26 April - 1:00 PM - 1:50 PM @ Ballroom E
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Business / Case Studies
Topics:
MariaDB
MySQL
Tools and Techniques
Replication

Description

In the last 24 months, MySQL/MariaDB replication speed has improved a lot, thanks to parallel replication. MySQL and MariaDB Server have different types of parallel replication; in this talk, I present the different implementations which will allow us to understand their limitations and tuning parameters. I am covering how to make parallel replication faster and what to avoid for maximizing its benefits. I also present benchmark results from Booking.com workloads. Finally, I discuss some deployments at Booking.com that take advantage of parallel replication speed improvements.

Speakers

Jean-François Gagné's picture

Jean-François Gagné

Senior System Engineer, Booking.com

Biography:

Since joining Booking.com 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 Booking.com, 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