Unlock this content

Enter your email to unlock this content for free

By continuing, you agree to our Terms of Service and Privacy Notice, and to receive occasional marketing emails.

Scaling Reads

TL;DR

ClickHouse handles dramatically different query patterns, each requiring different scaling strategies. Understanding your workload type determines whether you need more replicas, dedicated machines, or separate compute resources. Load balancers need cluster health awareness to route queries effectively.

Three Query Workload Types

ClickHouse handles dramatically different query patterns, each requiring different scaling strategies. Understanding your workload type determines whether you need more replicas, dedicated machines, or separate compute resources.

When scaling reads, you'll typically encounter three distinct query workload patterns, each with different performance characteristics and scaling requirements:

PreviousScaling Strategies
NextScaling Ingestion

Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.

Scaling Reads | ClickHouse for Developers