What You Need to Know About ClickHouse Architecture

on YouTube ↗51m

" summary

Overview of ClickHouse internals: how columnar on-disk storage and execution make analytical queries orders of magnitude faster while being unsuitable for OLTP or key-value workloads; replication and sharding design including how to achieve linear scaling and handle eventual consistency; and methods for diagnosing problems in production ClickHouse clusters.

AI-written summary · about

" chapters (11)

1. 0:00ClickHouse introduction
2. 1:31ClickHouse tasks and use
3. 3:41Query language and data storage
4. 7:01Data organization and indexing
5. 15:03Data sorting and insertion
6. 17:50Monitoring and merging parts
7. 19:17Data sharding
8. 24:27Data replication
9. 29:54ClickHouse cluster
10. 31:00Architecture summary
11. 32:22Q&A

" related talks

• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022
• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 45mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Devoxx Ukraine 2023: AI – Friend or Foe?
• 53mClickHouse Is Slowing DownKirill Shvakov · HighLoad++ Moscow 2018
• 44mUnconventional Uses of ClickHouseAleksandr Zaytsev · HighLoad++ Moscow 2018