Managed Clickhouse Service

find snapshot:

restic -r s3:s3.example.org/clickhouse-backups/table_name snapshots

restore:

restic -r s3:s3.example.org/clickhouse-backups/table_name restore latest --target /tmp/

more details:

Parameters

Name	Description	Value
`size`	Persistent Volume size	`10Gi`
`logStorageSize`	Persistent Volume for logs size	`2Gi`
`shards`	Number of Clickhouse replicas	`1`
`replicas`	Number of Clickhouse shards	`2`
`storageClass`	StorageClass used to store the data	`""`
`logTTL`	for query_log and query_thread_log	`15`

Name	Description	Value
`users`	Users configuration	`{}`

Name	Description	Value
`backup.enabled`	Enable pereiodic backups	`false`
`backup.s3Region`	The AWS S3 region where backups are stored	`us-east-1`
`backup.s3Bucket`	The S3 bucket used for storing backups	`s3.example.org/clickhouse-backups`
`backup.schedule`	Cron schedule for automated backups	`0 2 * * *`
`backup.cleanupStrategy`	The strategy for cleaning up old backups	`--keep-last=3 --keep-daily=3 --keep-within-weekly=1m`
`backup.s3AccessKey`	The access key for S3, used for authentication	`oobaiRus9pah8PhohL1ThaeTa4UVa7gu`
`backup.s3SecretKey`	The secret key for S3, used for authentication	`ju3eum4dekeich9ahM1te8waeGai0oog`
`backup.resticPassword`	The password for Restic backup encryption	`ChaXoveekoh6eigh4siesheeda2quai0`
`resources`	Resources	`{}`
`resourcesPreset`	Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if resources is set (resources is recommended for production).	`nano`