ProblemsSSA0009

Checkout vs Analytics

Hard

Problem

Paradox Shop's checkout system serves 1,600 RPS through a pooled connection to one PostgreSQL primary. Now analytics needs to run large reports against the same order data. Reports add 70% load; on the primary, that pushes combined utilization past 75% and checkout latency past its target. Build the full checkout path, and give analytics its own read replica so its load never touches checkout's database capacity.

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