TrackFTS0024

Cross-Shard Checkout

Medium

Problem

Checkout now serves 600 requests/second, joining an order's Orders row with its Order Items rows. Orders is sharded by order_id, but Order Items is sharded by its own row id, so a checkout query has no way to know which shard holds a given order's items and has to fan out across the whole cluster. Resize the app tier, and repartition Order Items so a single order's rows always land on the same shard.

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
App CPU is at 100%, over the 80% target.
Traffic
600 RPS
App CPU
100%
Monthly cost
$360

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,000