Performance· Case study 11
Distributed load testing & performance benchmarking
A containerized k6 load-testing harness on Kubernetes that replays realistic dashboard query traffic against Rill and its OLAP backends, plus benchmarks for comparing engines, schemas, and cluster sizes.
Before go-live
every engine, schema, and cluster size tested
Architecture at a glance
- k6 scenarios
- Helm on Kubernetes
- Rill + OLAP
- Query benchmarks
01 The problem
Customer go-lives and upgrades needed evidence that dashboards would stay fast under real traffic, before real users arrived.
02 What I built
- 1A containerized k6 load-testing harness deployed on Kubernetes with Helm.
- 2Replays of realistic dashboard query traffic against Rill and its OLAP backends.
- 3A benchmarking project that records query metrics for comparing engines, schemas, and cluster sizes.
03 Impact
Sizing and schema decisions before go-lives and upgrades are based on measured query performance instead of guesses.
Related case studies
- PlatformSelf-hosted ClickHouse platform on Kubernetes14 production ClickHouse clusters
- AIAI-assisted ClickHouse optimization with MCPMulti-TB single columns found in one audit pass
- MigrationWarehouse & lakehouse to ClickHouse, with reverse ETL and integrity checksEvery hop reconciled for drift, hourly