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.

Montreal 2024 sessions

Guarding Data Integrity: Transactional Behaviour in MySQL

English session - Beginner

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.

Montreal 2023 sessions