ProblemsFTS0013

Replica Lag During Import

Hard

Problem

Paradox Shop's nightly bulk import worker writes at 8,000 rows/second to the primary, while the storefront now serves 500 requests/second of customer-facing reads from a Small read replica. The app tier was sized for launch-day traffic, the primary itself can't absorb 8,000 writes/second directly, and the replica's apply capacity is badly outrun by the import on top of that, leaving customer-facing reads minutes stale until it recovers. Resize the storefront's fleet, the primary, and the replica so this actually holds up.

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
500 RPS
App CPU
100%
Monthly cost
$830

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