Introduction to ClickHouse Backups and clickhouse-backup

Introduction to ClickHouse Backups and clickhouse-backup

Data backups are an inglorious but vital part of IT operations. They are most challenging in “big data” deployments, such as analytics databases. This article will explore the plumbing involved in backing up ClickHouse and introduce the clickhouse-backup tool for…

ClickHouse Materialized Views Illuminated, Part 1

ClickHouse Materialized Views Illuminated, Part 1

Readers of the Altinity blog know we love ClickHouse materialized views. Materialized views can compute aggregates, read data from Kafka, implement last point queries, and reorganize table primary indexes and sort order. Beyond these functional capabilities, materialized views scale well…