ClickHouse Cluster
ClickHouse is an open-source columnar database management system built for real-time analytical queries over large volumes of data using SQL. It was originally developed at Yandex to power its web analytics product before being released as open source and later spun out into an independent company.
Baseline topologies
| Topology | Minimum nodes | Roles |
|---|---|---|
| single-shard-replicated | 2 | clickhouse, clickhouse |
| multi-shard-replicated | 4 | clickhouse, clickhouse-keeper |
What drives the cost
- Data shards
- Number of data shards in the cluster.
- Replicas per shard
- Number of replicas configured for each shard.
- Compressed dataset size (GB)
- Estimated compressed data footprint under steady-state retention.
- Peak concurrent queries
- Expected peak number of simultaneous analytical queries. Drives CPU and memory working-set sizing.
Where it runs
bare_metal, dedicated, cloud_vm
Size ClickHouse Cluster and get a cost estimate