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

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/co...

https://www.cockroachlabs.com/blog/ho...