Sharding & Partitioning

Range by time

Audit logs are append-only; admins query “events between T1 and T2.” Writes never update old rows. Compare hash sharding vs range sharding by month for this workload. Which do you pick and what hotspot appears on the latest range?

Intermediate drill question.

Write it as you would say it in the interview: assumptions, the design, tradeoffs, and what you would do next. The draft saves in this browser.

Review the lesson