Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

July 9, 2020
with Marcel Birkner, Yoann Buch and Robert Hodges

Instana automated APM provides complete visibility into complex systems, including ClickHouse servers. Hear how their team uses ClickHouse to power their solution and how they've integrated them back into their own ClickHouse monitoring features.

Read More
Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

June 23, 2020
with Adam Brown and Robert Hodges

Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We close with discussion around the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.

Read More
Big Data in Real-Time: How ClickHouse powers Admiral’s visitor relationships for publishers

June 16, 2020
James Hartig and Robert Hodges

Advertising is dying in the wake of privacy and adblockers. Join us for a conversation with James Hartig, a Co-Founder at Admiral (getadmiral.com), who helps publishers diversify their revenue and build more meaningful relationships with users. Discussion includes how Admiral migrated from MongoDB and how ClickHouse drives cutting edge real-time applications.

Read More
Using Joins in ClickHouse Materialized Views

ClickHouse materialized views provide a powerful way to restructure data in ClickHouse. We have discussed their capabilities many times in webinars, blog articles, and conference talks. One of the most common follow-on questions we receive is whether materialized views can support joins. The answer is emphatically yes.

Read More
Webinar Slides. MORE secrets of ClickHouse Query Performance

By Robert Hodges and Alexander Zaitsev
Slides for the Webinar, presented on May 27, 2020
Webinar recording is available here

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Sign up now to polish your ClickHouse performance skills!

Read More
ClickHouse Kafka Engine Tutorial

Our colleague Mikhail Filimonov just published an excellent ClickHouse Kafka Engine FAQ. It provides users with answers to common questions about using stable versions, configuration parameters, standard SQL definitions, and many other topics. Even experienced users are likely to learn something new.
But what if you are getting started and need help setting up Kafka and ClickHouse for the first time? Good news! This article is for you.

Read More
MORE secrets of ClickHouse Query Performance

May 27, 2020
with Robert Hodges

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Sign up now to polish your ClickHouse performance skills!

Read More
Monitoring ClickHouse on Kubernetes with Prometheus and Grafana


The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!
In this article we’ll explore how to configure two popular tools for building monitoring systems: Prometheus and Grafana. The ClickHouse Kubernetes operator includes scripts to set these up quickly and add a basic dashboard for clusters.

Read More
Webinar Slides. Strength in Numbers: Introduction to ClickHouse Cluster Performance

By Robert Hodges and Alexander Zaitsev
Slides for the Webinar, presented on Apr 29, 2020
Webinar recording is available here

ClickHouse clusters apply the power of dozens or even hundreds of nodes to vast datasets. In this webinar we'll show you how to use the basic tools of replication and sharding to create high performance ClickHouse clusters. We'll study the plumbing of inserts into sharded datasets and how to determine the correct number of shards for your desired writes. We'll similarly look at distributed queries and show how to scale read capacity to desired levels using replicas. Finally, we'll look at techniques for scaling up both shards and replicas to accommodate growth in your dataset.

Read More
Strength in Numbers. Introduction to ClickHouse Cluster Performance

April 29, 2020
with Robert Hodges

ClickHouse clusters apply the power of dozens or even hundreds of nodes to vast datasets. In this webinar we'll show you how to use the basic tools of replication and sharding to create high performance ClickHouse clusters. We'll study the plumbing of inserts into sharded datasets and how to determine the correct number of shards for your desired writes. We'll similarly look at distributed queries and show how to scale read capacity to desired levels using replicas. Finally, we'll look at techniques for scaling up both shards and replicas to accommodate growth in your dataset.

Read More
Webinar Slides. ClickHouse Monitoring 101: What to monitor and how

By Robert Hodges and Ned McClain
Slides for the Webinar, presented on Apr 1, 2020
Webinar recording is available here

You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We'll describe available monitoring data, how to collect and store measurements, and graphical display using Grafana. We'll demo techniques and share sample Grafana dashboards that you can use for your own clusters.

Read More
Webinar: ClickHouse Monitoring 101. What to monitor and how

April 1, 2020
with Robert Hodges and Ned McClain

You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We'll describe available monitoring data, how to collect and store measurements, and graphical display using Grafana. We'll demo techniques and share sample Grafana dashboards that you can use for your own clusters.

Read More