ProblemsFTS0009

Checkout vs Analytics

Hard

Problem

Paradox Shop's checkout system still serves 1,600 RPS correctly through its pooled connection. Someone wired the new analytics worker directly to the same primary to unblock reporting, and it works, until a report actually runs: analytics' 70% load lands on the primary, combined utilization blows past 75%, and checkout latency spikes every time. Give analytics its own read replica instead.

Required components

Click to add a component to the canvas.

Additional components

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

Current Production Metrics
Snapshot of the system before any changes.
Traffic
1,600 RPS
Monthly cost
$2,030
DB CPU
111%

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 / $2,250