|
I have a Clickhouse cluster with 3 replicas for Langfuse where all tables are created with I'd like to use S3 as default storage for these tables and I wonder if there's a way to set the |
Replies: 1 comment 2 replies
|
You can change tables' policy using The problem with merge_tree/XML that all MergeTree tables will be placed to S3 including internal _log telemetry tables, sometimes this is unwanted because S3 is expensive. See my example https://kb.altinity.com/altinity-kb-setup-and-maintenance/altinity-kb-s3-object-storage/s3_cache_example/ |
|
Thanks @den-crane, When changing the storage policy, will existing data of the changed table automatically synched to S3? Or manual copy is required? |
|
you can use |
You can change tables' policy using
ALTER:alter table mydata modify setting storage_policy = 's3tiered';The problem with merge_tree/XML that all MergeTree tables will be placed to S3 including internal _log telemetry tables, sometimes this is unwanted because S3 is expensive.
But of course you can add one more disk policy and define merge_tree/storage_policy = your_s3_policy if you need.
See my example https://kb.altinity.com/altinity-kb-setup-and-maintenance/altinity-kb-s3-object-storage/s3_cache_example/