Mikaël Francoeur

Mikaël Francoeur

Mikaël is currently a senior software developer at Ticketmaster. Before working as a software developer, he was a musician and a researcher.

Sessions Montréal 2024

Guarding Data Integrity: Transactional Behaviour in MySQL

Session en anglais - Débutant

How can we deal with concurrent transactions in MySQL without compromising data integrity and performance? In this talk, we’ll answer this question by looking at MySQL’s InnoDB storage engine and by exploring aspects such as Multi-Version Concurrency Control (MVCC), read phenomena, and transaction isolation levels. Through live examples, we’ll see how each of these core concepts can help guarantee your data’s integrity in the face of concurrency.

Sessions Montréal 2023