ProblemsFTS0014

Fail the Primary

Hard

Problem

Paradox Shop's checkout writes already flow correctly through a connection pool to a single PostgreSQL primary at 1,000 RPS. There's no replica at all, so if that primary fails, recovery means a human has to notice, decide, and manually stand up a new one; realistically minutes to hours of outage. Add exactly one replica for automatic, data-safe failover, without touching the pooled write path around it.

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,000 RPS
Monthly cost
$1,300
DB CPU
0%

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