Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL Parallel Replication (LOGICAL_CLOCK): all the 5.7 (and some of the 8.0) details

MySQL Parallel Replication (LOGICAL_CLOCK): all the 5.7 (and some of the 8.0) details

 27 April - 11:00 AM - 11:50 AM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Business / Case Studies
Topics:
MySQL
Tools and Techniques
Replication

Description

Since 5.7.2, MySQL implements parallel replication in the same schema, also known as LOGICAL_CLOCK (DATABASE based parallel replication is also implemented in 5.6 but this is not covered in this talk). In early 5.7 versions, parallel replication was based on group commit (like MariaDB) and 5.7.6 changed that to intervals. Intervals are more complicated but they are also more powerful. In this talk, I will explain in detail how they work and why intervals are better than group commit. I will also cover how to optimize parallel replication in MySQL 5.7 and what improvements are coming in MySQL 8.0. I will also explain why Group Replication is replicating faster than standard asynchronous replication. Come to this talk to get all the details about MySQL 5.7 Parallel Replication.

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