ProblemsFTS0068

Materialized View Is Behind

Hard

Problem

Paradox Shop's order-history dashboard reads from a materialized view; a read-optimized projection kept current by a projector worker consuming a change-event queue, already wired up below. During today's write spike the projector fell behind: 90,000 change events are backed up and the queue keeps growing, so the dashboard shows numbers that are minutes stale. Fix the projector worker pool so it keeps up with new change events (750/sec) and catches the read model up to a fresh state within 30 minutes. Keep the projector wired to the read-model store as part of a complete design; note that only projector throughput, drain time, and cost are graded, not the read-model wiring itself.

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
750 jobs/sec
Monthly cost
$180

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 / $330