Cut Compute Costs by Scaling ClickHouse Servers to Zero on Kubernetes

Cut Compute Costs by Scaling ClickHouse Servers to Zero on Kubernetes

Learn how to significantly reduce compute costs for ClickHouse servers on Kubernetes by leveraging the Altinity Kubernetes Operator. Discover the ‘stop: yes’ property to turn off ClickHouse pods, preserve storage, and save money on business-hours-only clusters.

Fixing the Dreaded ClickHouse Crash Loop on Kubernetes

Fixing the Dreaded ClickHouse Crash Loop on Kubernetes

As countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. But there’s still the occasional dark cloud. One of these is pod crash loops, which arise when a ClickHouse pod crashes on startup. This article shows how to diagnose and fix them.

Webinar Slides: ClickHouse and the Magic of Materialized Views

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on June 26, 2019 
Webinar recording is available here

Materialized views are a killer feature of ClickHouse that can speed up queries 200X or more. Our webinar will teach you how to use this potent tool starting with how to create materialized views and load data. We’ll then walk through cookbook examples to solve practical problems like deriving aggregates that outlive base data, answering last point queries, and using AggregateFunctions to handle problems like counting unique values, which is a special ClickHouse feature. There will be time for Q&A at the end. At that point you’ll be a wizard of ClickHouse materialized views and able to cast spells of your own.

Webinar: Analyzing Billion Row Datasets with ClickHouse

Webinar: Analyzing Billion Row Datasets with ClickHouse

This talk shows how to get a sub-second response from datasets containing a billion rows or more. We’ll start with defining schema and loading quickly data in parallel. We will then introduce tricks like LowCardinality datatype, ASOF joins, and materialized views that can reduce query response to thousandths of seconds. Finally, we’ll show you metrics and logging to analyze query performance. After this talk you’ll be ready for your first billion rows and many more afterwards