ClickHouse
Case Studies
Instabug's Successful Migration to ClickHouse for Enhanced APM Performance
Overview
Instabug's Successful Migration to ClickHouse for Enhanced APM PerformanceClickHouse |
Application Infrastructure & Middleware - Data Visualization Application Infrastructure & Middleware - Database Management & Storage | |
Cement Construction & Infrastructure | |
Product Research & Development Quality Assurance | |
Infrastructure Inspection Time Sensitive Networking | |
Data Science Services Testing & Certification | |
Operational Impact
The migration to ClickHouse has significantly improved Instabug's operational efficiency. ClickHouse's columnar database design for heavy analytics matched Instabug's use case, enabling them to achieve much better response times than with Elasticsearch. ClickHouse's support for Materialized Views (MVs) was crucial for achieving good response times, as they never query the original raw tables but always read from MVs, which are much smaller in size and have the data already aggregated. ClickHouse's support for a family of MergeTree table engines, known for their good write throughput, was also crucial for handling their high write throughput. ClickHouse's data compression feature helped save at least 30% in disk space. The SQL-like query interface of ClickHouse made re-writing their Elasticsearch queries into ClickHouse easier. ClickHouse's aggregate functions also helped them write new features into ClickHouse. The migration to ClickHouse has been serving them well for almost a year and is expected to continue to serve them well in the future. | |
Quantitative Benefit
Improved response times by 10x | |
Reduced storage requirements by 30% | |
Reduced the number of machines required, leading to significant cost savings | |