The Full MySQL (5.6, 5.7 and 8.0) and MariaDB (10.0 and 10.1) Parallel Replication Tutorial

Monday 1:30PM-4:30PM

@ Room M1

MySQL / MariaDB

3 hours tutorial

Intermediate

Tracks:
Business / Case Studies, Operations

This tutorial covers all parallel replication implementation in MariaDB 10.0 and 10.1 and MySQL 5.6, 5.7 and 8.0 (including how it works in Group Replication).

MySQL and MariaDB have different types of parallel replication. In this tutorial, we present the different implementations that allow us to understand their limitations and tuning parameters. We cover how to make parallel replication faster and what to avoid for maximizing its benefits. We also present tests from Booking.com workloads.

Some of the subjects that are covered are group commit and optimistic parallel replication in MariaDB, the parallelism interval of MySQL and its Write Set optimization, and the ?slowing down the master to speed up the slave? optimization.

After this tutorial, you will know everything you need to implement and tune parallel replication in your environment. But more importantly, we will show how you can test parallel replication benefit in a non-disruptive way before deployment.


Speakers

Jean-François Gagné

Jean-François Gagné (Booking.com)

Senior System Engineer

Biography:

Since joining Booking.com in October 2013, Jean-François worked 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 promoting 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.


Eduardo Ortega

Eduardo Ortega (Booking.com)

MySQL Database Engineer

Biography:

Eduardo is an open source-loving geek. With a background in Physics and Systems Computer Engineering, he joined the Booking.com DBA team in the end of 2016 and has been mostly focused on automation, monitoring and, more recently, performance optimization, including making replication faster. His previous experience includes systems, network and storage administration, development, architecture design and project management.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA