Jean-François Gagné
I am Jean-François (J-F), a System Engineer and MySQL Expert with 23 years of experience, recognised as a MySQL Rockstar (2024) and MySQL Community Contributor Award recipient (2018). Over the last 12 years, I have solved reliability and scalability challenges at Booking.com, HubSpot, MessageBird, Aiven, and Proton. Before MySQL, I worked as a Linux SysAdmin, Telco Architect, and Programmer. At university, I studied Cache Consistency in Distributed Systems and Group Communication Protocols.
Montreal 2027 sessions
All I Wanted to Know About Sharding
English session - Intermediate
Covers sharding functions beyond simple modulo and hashing, vertical (split) and horizontal sharding, rebalancing and resharding, and post-sharding reliability considerations. Lessons are drawn from 12 years of working with MySQL at scale and are broadly applicable to other databases. Will discuss considerations for Vitess and TiDB, many of which are likely also applicable to PostgreSQL Neki and other distributed solutions.
Autopsy of a Cascading Outage caused by a MySQL Crashing Bug
English session - Intermediate
Once upon a time, a query triggered a crashing bug. After automated failure handling, the application re-sent the query, and MySQL crashed again. This triggered a cascading failure, which resulted in datastore unavailability. Unfortunately, mistakes made during incident response led to avoidable data loss. This talk covers what happened, how we handled the incident, what we learned, and the infrastructure changes we made to prevent recurrence.
