Hacker News Reader

The 2 things that makes me hesitant about ClickHouse is that:

1. Data rebalancing is not automatic.

2. It doesn't really have a concept of cold-tier pushed to S3 directly, so cluster management is not simple for a small team.

Other than that, ClickHouse looks super amazing.

View on HN

ClickHouse can push cold data directly to S3, so S3 will be used as cold storage and the local filesystem as hot storage.

Another approach is to store all in S3 with local caching, it is much more easy and somewhat more efficient.

ClickHouse Cloud covers these concerns.

Ah this must be a new feature? If you could share the docs related to this, I'd really appreciate it.

Not affiliated with Clickhouse, but fwiw they've been working on this for a while (I recall coming across it like +2 years ago in an old Altinity blog post):

https://clickhouse.com/docs/en/integrations/s3/s3-merge-tree...

Reply on news.ycombinator.com