System design
Learning paths
Topics
Roadmaps
Games
Search articles, topics...
⌘K
Library
Topics
Storage and indexes
How data sits on disk: B-trees, LSM-trees, indexes and columns.
Path
System design
Databases
Articles
Level
Foundation
Core
Senior
Staff
Design questions only
Patterns
Hot key
Append now, merge later
Replicas that vote
Precompute the read
Bytes first, pointer last
Narrow
Scaling
1
Reliability
1
Replication
2
Sharding
2
Consistency
1
SQL
2
Observability
1
Search
1
Files and media
1
Analytics
3
10 pages
Design a key value store
System design · Senior · 34 min
Replication
Sharding
Consistency
Design Google Search
System design · Staff · 35 min
Search
Sharding
Design a metrics system
System design · Staff · 35 min
Observability
Analytics
Design object storage
System design · Staff · 35 min
Files and media
Replication
How a database runs a query
Databases · Foundation · 8 min
SQL
Indexes
Databases · Core · 9 min
SQL
Storage engines
Databases · Senior · 8 min
Backups and recovery
Databases · Core · 8 min
Reliability
OLTP vs OLAP
Articles · Core · 8 min
Analytics
Bloom vs HyperLogLog vs CMS
Articles · Senior · 12 min
Analytics
Scaling