Transactions

Apr 28, 2024 Databases 42 min read

Databases (7): Distributed Transactions — 2PC, Saga, and Why Consensus Is Hard

How distributed databases coordinate transactions across machines — two-phase commit, Raft consensus, the Saga pattern, and practical patterns like outbox and CDC.

Apr 21, 2024 Databases 40 min read

Databases (3): Transactions and Concurrency — ACID, Isolation Levels, and Locking

A thorough guide to ACID properties, isolation levels, MVCC, locking strategies, and deadlock prevention — with concrete SQL examples for every concept.