Deep Dive on ClickHouse: Sharding and Replication Webinar

Deep Dive on ClickHouse: Sharding and Replication Webinar

This talk walks you through sharding and replication, showing how Altinity experts enable clusters that deliver fast queries over petabytes of data. Starting with basic definitions of each, then moving to practical issues.

1 Trillion Rows in ClickHouse, Part 1: Altinity.Cloud Setup

1 Trillion Rows in ClickHouse, Part 1: Altinity.Cloud Setup

1 Trillion rows is a lot but ClickHouse can handle it and so can you. Our first article in a blog series shows how to set up a large dataset in Altinity.Cloud — using features like multi-volume storage, fast server rescaling, and scheduled operation — at a minimal cost.

ClickHouse Black Magic, Part 2: Bloom Filters

ClickHouse Black Magic, Part 2: Bloom Filters

Bloom filters are an important ClickHouse index type with mysterious parameters. Take a closer look at the theory behind bloom filters, parameter selection using queries on a test dataset, and effective tuning.

ClickHouse Black Magic: Skipping Indices

ClickHouse Black Magic: Skipping Indices

ClickHouse indices are different from traditional relational database management systems. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced ClickHouse users.

In this article we will dive into skipping indices and learn some of ClickHouse black magic.

A Day in the Life of a ClickHouse Query

A Day in the Life of a ClickHouse Query

This webinar is a gentle introduction to ClickHouse internals, focusing on topics that will help your applications run faster and more efficiently.