hard20 pts · first answer countssystem-designdatabasesscalability

Sharding orders by creation date

A team shards the orders table by created_at month, so each shard holds a range of months. What problem will appear first under heavy traffic?

A.Every new order lands on the shard for the current month, so one shard takes all the write load while the others sit idleB.Queries for one customer's orders become impossible, because the database cannot route any query that spans several shardsC.The shards will run out of primary key valuesD.Joins inside a single shard stop working

Discussion 0

Join free to post in the discussion.

Sharding orders by creation date

Discussion 0

Related questions