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