ClickHouse
Case Studies
Leveraging ClickHouse for Efficient OpenTelemetry Tracing: A Resmo Case Study
Overview
Leveraging ClickHouse for Efficient OpenTelemetry Tracing: A Resmo Case StudyClickHouse |
Application Infrastructure & Middleware - Database Management & Storage Infrastructure as a Service (IaaS) - Cloud Storage Services | |
Equipment & Machinery Retail | |
Intrusion Detection Systems Time Sensitive Networking | |
System Integration | |
Operational Impact
The implementation of ClickHouse and OpenTelemetry for full tracing has significantly improved Resmo's observability game. The solution has allowed Resmo to efficiently store and query traces, providing a better view of the flow of requests and their associated responses. The addition of materialized columns for frequently used fields has significantly improved query performance without affecting storage or the compression rate. The ability to connect ClickHouse to Postgres has enabled Resmo to use it in their observability queries, joining user and tenant IDs in their spans to the actual account names and account status in the Postgres database. This has provided unprecedented flexibility and allowed Resmo to expose this flexibility to their customers so they can easily ask arbitrary questions. The use of Grafana for visualizing data and IntelliJ IDEA & DataGrip for writing queries has further enhanced the efficiency and effectiveness of Resmo's observability strategy. | |
Quantitative Benefit
Resmo's ClickHouse instance can store more than 4 billion spans. | |
The data stored in ClickHouse consumes 275 GiB on disk, which uncompressed is 3.40 TiB - a 92% compression percentage. | |
Queries which scan all of the data complete rather quickly, and are mostly limited by the disk bandwidth. | |