Distributed SQL & NewSQL

Can SQL transactions survive global distribution?

Combine relational semantics with sharding, consensus, distributed transactions, clocks, rebalancing, and regional failure.

Systems compared

• Spanner
• CockroachDB
• TiDB
• YugabyteDB
• FoundationDB

Open the engine

1. Consensus and replication
2. Distributed transactions
3. Clock and ordering models
4. Range sharding
5. Rebalancing and failover

Reconstruction lab

Trace a transaction across replicas and defend a topology for a multi-region product.