clickhouse-s3-config.yaml (1460B)
1 apiVersion: v1 2 kind: ConfigMap 3 metadata: 4 name: clickhouse-s3-config 5 namespace: blog 6 data: 7 s3-storage.xml: | 8 <clickhouse> 9 <listen_host>0.0.0.0</listen_host> 10 <listen_host>::</listen_host> 11 <listen_try>1</listen_try> 12 <storage_configuration> 13 <disks> 14 <s3_disk> 15 <type>s3</type> 16 <endpoint>https://hel1.your-objectstorage.com/midnightthoughts-clickhouse/</endpoint> 17 <access_key_id from_env="CH_S3_ACCESS_KEY"/> 18 <secret_access_key from_env="CH_S3_SECRET_KEY"/> 19 <skip_access_check>true</skip_access_check> 20 </s3_disk> 21 </disks> 22 <policies> 23 <s3_only> 24 <volumes> 25 <default> 26 <disk>default</disk> 27 </default> 28 <remote> 29 <disk>s3_disk</disk> 30 </remote> 31 </volumes> 32 <move_factor>0.2</move_factor> 33 </s3_only> 34 </policies> 35 </storage_configuration> 36 <default_storage_policy>s3_only</default_storage_policy> 37 38 <!-- Disable system log tables that accumulate on local disk --> 39 <text_log remove="remove"/> 40 <trace_log remove="remove"/> 41 <metric_log remove="remove"/> 42 <asynchronous_metric_log remove="remove"/> 43 <processors_profile_log remove="remove"/> 44 <asynchronous_insert_log remove="remove"/> 45 <blob_storage_log remove="remove"/> 46 </clickhouse>