ACID: Isolation, Transactions and what can go wrong with your data

Description

What is an ACID database and why is serializable isolation so important for database transactions. In this webinar Jim Walker explains the concept of ACID and why it's a problem for your transactions if the isolation level is not super strict. 0:00 Introduction 3:07 Stages of an (OLTP) database transaction 4:29 What could possibly go wrong? 5:35 Atomicity 10:07 Database isolation levels 12:12 Weak isolation levels result in common issues 15:38 Default isolation levels for a few databases 17:43 Transactions - Update account balance Two simultaneous transactions 18:15 Transactions: read_committed 19:40 Transactions: serializable 20:47 A difficult anomaly: Write Skew 23:05 Hackers exploit isolation issues 24:23 Raft 26:07 MVCC - Multiversion concurrency control 26:34 MVCC - VERY Basic flow 28:04 MVCC - Conflict 32:37 Distributed Transactions 35:59 Create a CockroachDB instance now... #CockroachDB #ACIDDatabase #DistribtuedSQL Related content: https://www.cockroachlabs.com/blog/consistency-model/ https://www.cockroachlabs.com/blog/how-cockroachdb-distributes-atomic-transactions/