Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Jean-François Gagné

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.


This short talk will be about an incident that kept DBAs working on a weekend. Two bugs, one in our application code and one in the database, joined force and almost brought down And this occurred at one of the worst possible times. Curious about what happened: come to this talk to learn more.
26 April - 1:00 PM - 1:50 PM at Ballroom E
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... [read more]
27 April - 11:00 AM - 11:50 AM at Room 210
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... [read more]
27 April - 9:25 AM - 9:50 AM at Main Scenario
Join Jean-François Gagné as he presents a metric for observing’s system health. This metric is not technical (not MySQL or Linux related) but it is one of the most important metric has to detect a problem on the website. Many things impact this metric, including the time of the day, the day of the week or the season of the year. Moreover, some external events (political... [read more]
25 April - 6:00 PM - 7:00 PM at Ballroom A
Mariella Di Giacomo - Successful stories around MySQL and MariaDB Multi-Source Replication Manjot Singh - What is Sharding Michael Wang - Use slow logs to collect unique queries and their performance continuously Jean-François Gagné - The two little bugs that almost brought down