3 · IN PROGRESS · CASE STUDIES
ClickHouse in the Industry
YANDEX · 2009–2016
AZUR GAMES · 2024
EXITLAG · 2023
Origin
Mobile Game Analytics
Online Gaming Service
A Yandex experimental project for Metrica reports based on unaggregated data; open source under the Apache 2.0 license since 2016. Developed by ClickHouse Inc. since 2021.
They migrated 120 TB of telemetry data from more than 20 of their own ClickHouse servers to ClickHouse Cloud in three months without any downtime. The administrator freed up 60% of his time.
About 6 million events per day on player behavior and network routes. We moved away from MySQL because the analytics were too slow. We use MV for pre-aggregation and Grafana for dashboards.
wikipedia.org →
aws.amazon.com · blog →
clickhouse.com · blog →
ROBLOX
SIMILAR PRODUCTS
A PLACE IN ARCHITECTURE
Platform Security
The same class of problems
Alongside, not instead of
"Core real-time OLAP": approximately 100 million security events per day. Migration from on-premises servers to ClickHouse Cloud; the schema is supported by MV.
Apache Druid, Apache Pinot; cloud-based BigQuery, Snowflake, Redshift; embedded DuckDB. Common concepts: columns, compression, pre-aggregation.
Services write data to PostgreSQL and send events; ClickHouse responds to analysts and dashboards with a delay of seconds or minutes.
clickhouse.com · presentation →
clickhouse.com · docs →
→ slides 19, 21
General: event streams, questions about “how much and how it’s distributed” over long periods, dashboards. Case studies—based on materials from ClickHouse, AWS, and the companies themselves; the figures are provided by them.