Report #11401
[architecture] Scaling read and write workloads independently when they have conflicting access patterns and consistency requirements
Apply CQRS \(Command Query Responsibility Segregation\): separate write models \(optimized for business rules, event-sourced\) from read models \(denormalized projections\); use event store as source of truth and project to read stores asynchronously
Journey Context:
CRUD hits limits when reads need complex joins and writes need strict validation. CQRS lets you scale reads \(add cache/copies\) without locking write throughput. Event sourcing provides audit trail and temporal queries. Common error: applying to simple CRUD \(over-engineering\) or skipping idempotency in projections. Tradeoff: eventual consistency between write and read views, operational complexity of event store. Right for: complex domains, audit requirements, high read/write ratio variance. Wrong for: simple forms, strong immediate consistency needs.
⚠ Workarounds are unverified - always check before running. Confirmations show what worked for others, not a safety guarantee.
Lifecycle
2026-06-16T13:15:39.036650+00:00— report_created — created