Analytics
Vector and ClickHouse: An Observability Pipeline Worth the Effort
Vector ClickHouse pipeline: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
Blog
Observability & Monitoring
Detecting and Resolving Replication Lag in ClickHouse
ClickHouse replication lag: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
Mining the ClickHouse Query Log for Performance Insights
ClickHouse query log: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
Retention and TTL Policies for Telemetry on ClickHouse
ClickHouse telemetry retention: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
Disk and Memory Alerting for ClickHouse: Signals That Catch Outages Early
ClickHouse disk and memory alerting: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
ClickHouse
Capacity Planning for ClickHouse Observability Workloads
ClickHouse capacity planning: a practical look at how it works, what to tune, and the pitfalls that trip up production ClickHouse.
Real-Time Analytics
ClickHouse and Apache Kafka: Architecting Real-Time Streaming Analytics at Scale
Architect production-grade real-time streaming analytics with ClickHouse and Apache Kafka using the Kafka table engine, Materialized Views, and ReplicatedMergeTree.
Observability
ClickStack and HyperDX: Full-Stack Observability Built Natively on ClickHouse
Deploy ClickStack and HyperDX — the open-source full-stack observability platform built natively on ClickHouse for logs, metrics, traces, and session replay.
Observability
ClickHouse and Prometheus: Long-Term Metrics Storage with Remote Write at Scale
Solve the Prometheus retention problem with ClickHouse — remote_write, the native TimeSeries engine, downsampling Materialized Views, and tiered S3 storage.
ClickHouse
Materialized Views in ClickHouse
Materialized Views in ClickHouse for High-Performance Analytics Materialized views are the secret behind interactive dashboards that feel instant on billion-row tables. In this guide, ChistaDATA engineers detail both incremental and refreshable materialized view patterns in […]