Is it possible to deploy ClickHouse with separate storage and compute?

The short answer is "yes".

Object storage (S3, GCS) can be used as the elastic primary storage backend for data in ClickHouse tables. S3-backed MergeTree and GCS-backed MergeTree guides are published. Only metadata is stored locally on compute nodes in this configuration. You can easily upscale and downscale compute resources in this setup as additional nodes only need to replicate metadata.

Was this page helpful?

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free