3 ms·
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
by didip 4y ago
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.
- zX41ZdbW 4y agoClickHouse 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.
- didip 4y agoAh this must be a new feature? If you could share the docs related to this, I'd really appreciate it.
- pandemicsyn 4y agoNot 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/#storage-tiers https://clickhouse.com/docs/en/integrations/s3/s3-merge-tree...