Mobility · EU tolling provider
Overnight reports, now done in two minutes
daily report runtime
Bars to scale. Two minutes is 0.3% of the original runtime.
- MySQL
- Debezium
- Kafka
- Spring Boot ETL
- ClickHouse
The problem
Regulatory reports ran overnight, and the fleet was about to grow from 200k to 10M on-board units.
What I did
Captured changes straight from MySQL, streamed them through Kafka and stored denormalised telemetry in ClickHouse, with a small reporting service on top that BI teams query directly.
Result
Two-minute reports at fifty times the fleet size.
Stack Kafka, ClickHouse, Spring Boot, Debezium, Docker, PostgreSQL

