ClickHouse
Case Studies
Admixer's Transformation: Handling Over 1 Billion Unique Users a Day with ClickHouse
Overview
Admixer's Transformation: Handling Over 1 Billion Unique Users a Day with ClickHouseClickHouse |
Application Infrastructure & Middleware - Database Management & Storage Infrastructure as a Service (IaaS) - Cloud Storage Services | |
Cement Construction & Infrastructure | |
Sales & Marketing Warehouse & Inventory Management | |
Inventory Management Time Sensitive Networking | |
Data Science Services System Integration | |
Operational Impact
The implementation of ClickHouse has significantly improved Admixer's operational efficiency. The company can now handle a massive influx of data and display real-time advertising transaction statistics. The solution has also allowed Admixer to scale their data warehouse as requests grow, giving them full control over their costs. The use of ClickHouse has also enabled Admixer to count unique users by a large number of keys in one report, a significant improvement over their previous system. Furthermore, the company has been able to migrate from the cloud, which has provided them with more flexibility and control over their operations. The solution has also proven to be financially optimal, allowing Admixer to manage their costs effectively. Overall, the implementation of ClickHouse has enabled Admixer to handle their increasing load efficiently and effectively, improving their operational performance and customer service. | |
Quantitative Benefit
Inserting around 100 billion records per day, over 1 million records per second | |
Able to aggregate over 1 billion unique users a day | |
ClickHouse is deployed on 15 servers with 2 TB total RAM | |