3 ms·
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 S
by zX41ZdbW 4y ago
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.
- 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...