TrackSSA0013

Replica Lag During Import

Hard

Problem

Paradox Shop runs a nightly bulk import worker that writes at 8,000 rows/second to the primary, while the storefront keeps serving 500 requests/second of customer-facing reads from a read replica. The primary has to absorb those 8,000 writes/second directly, and the replica needs to stay caught up through the import, not fall minutes behind and leave those reads stale until it recovers. Build both paths, and size the primary and 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.

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