Data Infrastructure & Analytics
ClickHouse Capacity Estimation Framework

ClickHouse Capacity Estimation Framework

11/5/2020 · Oxana Kharitonova

What this post added

Introduced a capacity estimation framework for ClickHouse clusters to automate disk space forecasting and proactive hardware procurement. This framework leverages historical metrics from system.parts, filters for unreplicated data to account for topology changes, and uses time-series forecasting models like Prophet for predictions. The results are visualized in Grafana, providing insights into real and predicted disk usage.

Read the original post ↗