Question 1

What does ClickHouse consulting include?

Accepted Answer

ClickHouse consulting covers MergeTree-family selection (MergeTree vs ReplicatedMergeTree vs ReplacingMergeTree vs CollapsingMergeTree vs SummingMergeTree vs AggregatingMergeTree), projection vs materialized-view decisions, sharding and replication strategy, ClickHouse Keeper vs ZooKeeper topology, ingestion pipeline design (Kafka engine, S3 engine, RabbitMQ, native HTTP), and the ClickHouse-Cloud-vs-self-managed-on-K8s-or-EC2 economics. Deliverables are written recommendations and topology proposals.

Question 2

ClickHouse Cloud vs self-managed - what's the right answer?

Accepted Answer

ClickHouse Cloud wins when: you want elastic compute decoupled from storage, your team is small, and the per-second billing model fits your spiky workload. Self-managed wins when: you're at sustained 50+ node-hours/day, you have an ops team comfortable with replication and Keeper, or you need on-prem / regulatory placement. We model your actual usage - query concurrency, peak vs idle hours, data growth rate - and surface the break-even point with real numbers.

Question 3

Which MergeTree variant should I pick?

Accepted Answer

ReplicatedMergeTree for any production deployment - replication is non-negotiable. Within the family: plain MergeTree for append-only events; ReplacingMergeTree for upserts where you can tolerate eventual dedup (final SELECT pays the cost); CollapsingMergeTree for fact-table updates with explicit sign columns; SummingMergeTree for pre-aggregated counters; AggregatingMergeTree for stateful aggregations (uniqState, quantilesState). The wrong choice creates compaction storms or query-time correctness traps - we audit the write pattern before recommending.

Question 4

Projections, materialized views, or both?

Accepted Answer

Projections are stored alongside the base table - they trigger automatically when the optimizer detects a match, and they share the lifecycle of the base partition. Materialized views are separate tables fed by INSERT triggers - they decouple from the base, can target different MergeTree variants, and don't slow down the base SELECT path. Projections fit ad-hoc query acceleration on the same table; MVs fit fan-out to differently-shaped target tables. Most production ClickHouse uses both. We map your slow-query log to the right tool for each pattern.

Question 5

ClickHouse Keeper vs ZooKeeper - what should I run?

Accepted Answer

ClickHouse Keeper is the right answer for new deployments. It's a drop-in replacement implemented in C++ inside ClickHouse, removes the Java ZooKeeper operational burden, and is now the default in current releases. Migrate existing ZooKeeper deployments only if you're touching the topology anyway - there's no urgency for stable fleets. We size Keeper based on replication-task QPS, not on node count.

Question 6

How do I shard ClickHouse and pick the sharding key?

Accepted Answer

Sharding key is the single hardest decision in ClickHouse - it's nearly irreversible without a full data rewrite. Pick a high-cardinality column that distributes write load evenly (hash-bucketed customer_id, request_id, or sipHash64(user_id) for skewed populations). Avoid sharding by time - that creates hot shards at the head and dead shards at the tail. Distributed-table layer over local replicated tables is the standard pattern. We model your query pattern (does it filter by the shard key?) and your write pattern (does it skew?) before recommending.

Question 7

Does ClickHouse consulting include migration execution?

Accepted Answer

No - execution is a separate engagement shape. Consulting is the decision phase: pick the topology, pick the MergeTree variants, design the projections and MVs, decide Cloud vs self-managed, model the costs. Execution covers PostgreSQL → ClickHouse, Snowflake → ClickHouse, the ZooKeeper → Keeper migration, or ClickHouse Cloud onboarding. The split keeps consulting deliverables crisp.

Engine	Fits when	Avoid when
ReplicatedMergeTree	Append-only events, log analytics, immutable historical data - the production default.	You need upserts - pick ReplacingMergeTree or CollapsingMergeTree.
ReplacingMergeTree	Idempotent upserts where eventual dedup is acceptable; final-modifier SELECT pays the cost.	Need strong real-time dedup - final SELECT cost grows with table size.
CollapsingMergeTree	Fact-table updates with explicit sign columns; your pipeline can emit corrections.	Source can't produce sign rows - ReplacingMergeTree is simpler.
SummingMergeTree	Pre-aggregated counters where rows merge by sum; saves both storage and query cost.	Need raw rows back - aggregation is destructive.
AggregatingMergeTree	Stateful aggregations (uniqState, quantilesState) feeding materialized views.	Simple sums - SummingMergeTree is lighter.

ClickHouse Consulting Services

What our ClickHouse consulting covers

How a ClickHouse consulting engagement is shaped

MergeTree-variant matrix - when each one fits

ClickHouse consulting - common questions

Ready to make the call on ClickHouse?

Related ClickHouse Services