ProblemsFTS0023

The Newest Shard Is Always Hot

Hard

Problem

Paradox Shop streams 24,000 events/second through a message queue into a sharded events table that's Range-partitioned by created_at. Every write from today lands on today's shard, which is permanently hot no matter how many shards exist in total. Fix the partition strategy so new writes spread across every shard, without touching the ingestion pipeline above it.

Required components

Click to add a component to the canvas.

Additional components

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

Production Alert
Monthly cost is at $7,850, over the $1,340 budget.
Traffic
24,000 events/sec
Monthly cost
$7,850
DB CPU
100%

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