Solving real business cases with ClickHouse

on YouTube ↗49m

" summary

Using ClickHouse to solve real business cases: describes problems encountered when building a service with ClickHouse—difficulty with updates, huge data volumes requiring massive hardware, performance limits even with sufficient hardware, slowdown from sharding interdependent tables, and a plugin that overloads the database when it should serve historical comparisons. The talk discusses these concrete operational challenges and approaches to handle updates, scaling, sharding trade-offs, and query load in ClickHouse deployments.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 3:34Sharding and replication in ClickHouse
3. 8:29Distributed query optimization
4. 12:23Custom solutions and optimizations
5. 20:31Data and infrastructure
6. 27:57Heavy query optimization
7. 39:02Q&A

" related talks

• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018
• 53mClickHouse Is Slowing DownKirill Shvakov · HighLoad++ Moscow 2018
• 17mBuilding Real-Time Data Lake with ClickHouseAlexander Zaitsev · PG Armenia x Percona University – Yerevan, August 28, 2025
• 44mUnconventional Uses of ClickHouseAleksandr Zaytsev · HighLoad++ Moscow 2018
• 53mClickHouse: blitz meetup (questions and answers)Aleksey Milovidov · HighLoad++ Moscow 2018
• 30mReplicating Data from MySQL to ClickHouseVladislav Klimenko, Valeriy Panov · HighLoad++ Siberia 2018