Section 01
Relational Databases
0 / 4
Indexes
Selectivity
Continue Here
The Query Gets Slower Every Month
Medium
Build from Scratch
Fix Existing Design
Connection pooling
Bounded DB concurrency
Available
Too Many Connections
Medium
Build from Scratch
Fix Existing Design
OLTP vs. analytical workloads
Workload isolation
Available
Checkout vs Analytics
Hard
Build from Scratch
Fix Existing Design
Relational modeling
Foreign keys
Available
Choose the Relational Model
Medium
Build from Scratch
Fix Existing Design
Section 02
Database Scaling & Replication
0 / 4
Read replicas
Read/write splitting
Available
Reads Are Crushing the Primary
Medium
Build from Scratch
Fix Existing Design
Replication lag
Read-after-write consistency
Available
The Replica Is Stale
Medium
Build from Scratch
Fix Existing Design
Replication throughput
Lag as a capacity metric
Available
Replica Lag During Import
Hard
Build from Scratch
Fix Existing Design
Primary failover
Replica promotion
Available
Fail the Primary
Hard
Build from Scratch
Fix Existing Design
Section 03
Partitioning & Sharding
0 / 4
Horizontal write sharding
Shard count vs. per-shard capacity
Available
The Write Ceiling
Medium
Build from Scratch
Fix Existing Design
Hotspot partition keys
Composite partition keys
Available
Shard 7 Is Melting
Hard
Build from Scratch
Fix Existing Design
Range vs. Hash partitioning
Why time-based ranges create a permanent hotspot
Available
The Newest Shard Is Always Hot
Hard
Build from Scratch
Fix Existing Design
Shard locality
Colocating related tables
Available
Cross-Shard Checkout
Medium
Build from Scratch
Fix Existing Design
Section 04
Object Storage & File Systems
0 / 4
Direct-to-storage uploads
Signed URLs
Available
Stop Putting Videos in PostgreSQL
Medium
Build from Scratch
Fix Existing Design
Object storage request-rate limits
Key layout & partition hotspots
Available
Millions of Tiny Files
Medium
Build from Scratch
Fix Existing Design
Shared filesystem IOPS ceilings
Provisioned IOPS vs. Standard tier
Available
Shared Filesystem Bottleneck
Medium
Build from Scratch
Fix Existing Design
Storage class trade-offs
Durability vs. cost
Available
Durability vs. Temporary Data
Easy
Build from Scratch
Fix Existing Design