Guarding Data Integrity: Transactional Behaviour in MySQL

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.