Files
cozystack/packages/apps/clickhouse
Andrei Kvapil d8a92aa3ff Prepare release v0.17.0 (#444)
Signed-off-by: Andrei Kvapil <kvapss@gmail.com>


<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

## Release Notes

- **New Features**
- Updated various container images to newer versions, enhancing
performance and security.

- **Bug Fixes**
- Resolved issues by updating image tags and digests for several
components, ensuring consistency and stability.

- **Documentation**
- Incremented version numbers in configuration files for clarity and
tracking.

- **Chores**
- Updated image tags and digests across multiple services to maintain
up-to-date deployments.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->

Signed-off-by: Andrei Kvapil <kvapss@gmail.com>
2024-10-21 16:02:11 +02:00
..
2024-10-21 16:02:11 +02:00
2024-08-12 14:47:11 +02:00
2024-10-21 12:18:39 +02:00
2024-07-16 17:31:52 +02:00
2024-10-21 12:18:39 +02:00
2024-09-15 06:52:21 +02:00

Managed Clickhouse Service

How to restore backup:

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

Common 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

Configuration parameters

Name Description Value
users Users configuration {}

Backup parameters

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