Road to Percona Live 2022 - Robert Hodges

on YouTube ↗04m

" summary

Claims that ClickHouse is fast because it is a column store with high compression that aggressively parallelizes work, and the session shows the actual query execution flow: how queries split, how aggregation is implemented, how results reassemble, and how IO CPU and memory affect performance. It demonstrates tools like system.query_log and builds a streaming pipeline for MySQL binlog data using Debezium → Kafka/Red Panda → ClickHouse on Kubernetes so transactional workloads (hundreds of thousands TPS) keep analytics in sync.

AI-written summary · about

" chapters (4)

1. 0:00Introduction
2. 0:51Quickcast Architecture
3. 1:45Clickhouse Analytics
4. 2:49Recap

" related talks

• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022
• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 28mColumnstore RevolutionPeter Zaitsev, Hannes Mühleisen, Alexy Milovidov · Percona Live Amsterdam 2026
• 17mBuilding Real-Time Data Lake with ClickHouseAlexander Zaitsev · PG Armenia x Percona University – Yerevan, August 28, 2025
• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 30mBuilding For FastDale McDiarmid, Ryadh Dahimene · Big Data LDN 2022
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 26mO11y in One: Exploring ClickHouse as a Unified Telemetry DatabaseJosh Lee · SREday London 2025 Q3