ClickHouse
Case Studies
DeepL’s Transformation Journey with ClickHouse: A Case Study
Overview
DeepL’s Transformation Journey with ClickHouse: A Case StudyClickHouse |
Application Infrastructure & Middleware - Middleware, SDKs & Libraries Platform as a Service (PaaS) - Application Development Platforms | |
Buildings E-Commerce | |
Maintenance Product Research & Development | |
Building Automation & Control Experimentation Automation | |
System Integration Training | |
Operational Impact
The implementation of ClickHouse has brought about significant operational benefits for DeepL. The system has enabled the company to create complex events and queries that provide a deeper understanding of how users interact with their services. This is something that traditional tools like Google Analytics couldn't achieve. The automation of changing table schemas has saved the team from getting overwhelmed with toil. The protobuf schema file has reduced errors and saved the team time to focus on important things. ClickHouse has also played a crucial role in DeepL's experimentation framework, enabling the company to rapidly iterate on frontend or algorithmic backend changes. This has contributed towards a cultural shift within the company. Furthermore, ClickHouse has been instrumental in DeepL's ML-Infrastructure of Personalization, providing excellent performance even when reading tens of millions of rows. | |
Quantitative Benefit
DeepL was able to set up an MVP in just a few weeks, proving that the system could easily handle the amount of data they were dealing with and that query times were excellent. | |
DeepL expanded from a single node setup to a cluster of 3 shards with 3 replicas after 16 months of usage. | |
Currently, DeepL's setup ingests about half a billion raw rows per day. | |