ProblemsSSA0023

The Newest Shard Is Always Hot

Hard

Problem

Paradox Shop streams 24,000 events/second through a message queue into a sharded events table. Range-partitioning by created_at (one range per day) would put every write from today on today's shard, so no matter how many shards exist in total, the newest one becomes the permanent write hotspot. Build the ingestion pipeline, and design an events table that spreads new writes across every shard, not just the newest one.

Required components

Click to add a component to the canvas.

Additional components

Browse by category. Click or drag a component onto the canvas.

Drag components from the library onto the canvas, then drag from a component's right handle to connect it to another.

100%

Design canvas

Sign up to start designing

Sign up free

Premium is free for 58 more days.

$0 / $1,340