Rows or columns

Flow 07

Choose

The shop database answers 4,000 queries/s with 8 vCPU. A new dashboard runs 5 queries/s. Each query sums 2 columns over 200 million order rows. Choose where the dashboard runs. Keep shop p99 below 50 ms and dashboard p99 below 2 s.

Goals

Not tested yet

99 of 100 requests finish faster than this.99 of 100 requests finish faster than this.The share of requests that fail or get no answer.What the servers and services cost each month.
Choose a design
Query the shop database
Query a read replica of the shop database
Query a columnar analytics store