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
02
Databases Advanced

Replica Consistency Router

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
04
05
Databases Intermediate

Recovery Objective Drill

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

Deadlock Detective

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

Transaction Isolation Arena

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

Schema Migration Runbook

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