Reason about partitions, replica lag, recovery objectives, deadlocks, isolation, and safe schema evolution.
Practice path · 8 games
Database Reliability
Reason about partitions, replica lag, recovery objectives, deadlocks, isolation, and safe schema evolution.
For learners preparing to operate stateful production systems.
Start this path 01 Databases Advanced
Choose explicit consistency or availability behavior for concrete network-partition scenarios.
- Time
- 7-10 minutes
- Concept
- CAP theorem and partition-time tradeoffs
- Database Reliability
- cap theorem
- partitions
- consistency
Play Partition Tradeoff Commander 02 Databases Advanced
Route reads across primary and replicas while respecting lag, freshness contracts, failover, and workload isolation.
- Time
- 8-12 minutes
- Concept
- Read replicas and consistency-aware routing
- Database Reliability
- replication
- consistency
- routing
Play Replica Consistency Router 03 Databases Advanced
Connect durability, MVCC, plan evidence, and connection budgets.
- Time
- 10-12 minutes
- Concept
- database engine capacity
- Database Reliability
- Databases
- MVCC
- Query Plans
Play Database Engine & Capacity Lab 04 Databases Advanced
Recover pool, lock, replication, and failover incidents without losing business truth.
- Time
- 10-12 minutes
- Concept
- database failover and contention
- Database Reliability
- Databases
- Failover
- Contention
Play Database Failover & Contention War Room 05 Databases Intermediate
Translate RPO and RTO into backup, point-in-time recovery, restore testing, and isolation decisions.
- Time
- 7-10 minutes
- Concept
- Database backup and restore objectives
- Database Reliability
- backups
- rpo
- rto
Play Recovery Objective Drill 06 Databases Advanced
Read waits-for cycles, choose safe victims, retry complete transactions, and prevent recurring deadlocks.
- Time
- 7-11 minutes
- Concept
- Database deadlocks and lock ordering
- Database Reliability
- deadlocks
- locks
- transactions
Play Deadlock Detective 07 Databases Advanced
Defend database invariants from concurrent requests by choosing transactions, locks, constraints, snapshot reads, and optimistic concurrency.
- Time
- 7-10 minutes
- Concept
- Database transactions, isolation anomalies, locks, and invariant protection
- Data & Performance
- Database Reliability
- SQL
- transactions
- isolation
Play Transaction Isolation Arena 08 Databases Intermediate
Choose safe zero-downtime database migration steps for expanding schemas, backfilling data, rolling out indexes, enforcing constraints, and recovering from failures.
- Time
- 6-9 minutes
- Concept
- Zero-downtime schema migration planning and expand-contract releases
- Data & Performance
- Database Reliability
- migrations
- schema design
- backfill
Play Schema Migration Runbook