Cloud Architecture

CQRS with Read Replicas and Search Indexes

Cloud Architecture diagram · made in Skemio

Architecture diagram showing API Gateway splitting commands to a Write Service and PostgreSQL, and queries to a Read Service and OpenSearch via a CDC pipeline.
Architecture diagram showing API Gateway splitting commands to a Write Service and PostgreSQL, and queries to a Read Service and OpenSearch via a CDC pipeline.
Open it in SkemioMake your own

What it shows

  • Relational engines excel at ACID writes, not complex fuzzy searches.
  • Change Data Capture streams table updates to OpenSearch asynchronously.
  • Read models can be scaled or rebuilt without impacting ingest throughput.

The takeaway

Separate your write path from your read path to scale search latency and ingestion independently.

More cloud architecture diagrams