HTAP live dashboards
Dashboards read a columnar analytics replica kept fresh by replication and incremental view maintenance — the OLTP primary never sees a GROUP BY.
What this design does
Hybrid transactional/analytical processing without melting production: writes hit the row-store primary, replication feeds a columnar replica, and incremental view maintenance keeps aggregates current by applying deltas instead of recomputing. Sub-second dashboards on seconds-old data, zero analyst queries on the OLTP path.
The patterns it composes
- Analytics replicas over OLTP — the primary serves transactions; analytics reads a replica
- Dual-format engines (row + column) — row store for point writes, column store for scans
- Incremental view maintenance — views update by delta — no full recompute per refresh
- Bounded-staleness reads — dashboards declare how stale is acceptable
Import it, attach your own numbers, and verify the design against failures — or read the engineering notes.