Playbooks

Read replicas before sharding

When read load is the bottleneck, the cheapest correct answer is almost never sharding.

Problem
Database is saturating and the team is proposing a sharding project.
Context
Single-region OLTP Postgres/MySQL, under ~2 TB, read-heavy (>80% reads).

Problem

Context

Approach

Tradeoffs

When this stops working