Transactions
ACID, isolation levels, MVCC
Isolation levels & anomalies
plannedTwo transactions on parallel timelines: dirty reads, non-repeatable reads, lost updates and write skew at each isolation level.
ACIDMVCCisolation
WAL & crash recovery
plannedWhy a committed transaction survives a crash: write-ahead log, fsync, checkpoints and replay.
ACIDdurability