ProblemsSSA0014

Fail the Primary

Hard

Problem

Paradox Shop's checkout writes flow through a connection pool to a single PostgreSQL primary at 1,000 RPS. That primary needs to be able to fail, whether from a bad deploy, a host dying, or anything else, without turning into a multi-hour outage or ambiguity about which node is actually in charge afterward. Build the pooled write path, and designate exactly one replica for automatic, data-safe failover.

Required components

Click to add a component to the canvas.

Additional components

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

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