Scenario

Partition key selection under skewed tenants

You are sharding a write-heavy table. Tenant sizes follow the usual power law: your largest tenant is forty times your median one, and it is also your most important customer. Shards are added by rebalancing, which is slow and manual. No shard may carry more than about 1.5x the average load.

partition keyWriterslockedRouter2 decisionsShards3 decisionsWrite pathlocked