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


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

## Summary by CodeRabbit

## Release Notes for Cozystack v0.23.0

- **Image Updates**
  - Upgraded core Cozystack components to version v0.23.0
- Updated multiple system and application images across various packages
- Refreshed image digests for components like Kubernetes, backup, and
infrastructure tools

- **Version Bump**
  - Incremented overall system version from v0.22.0 to v0.23.0
  - Updated configuration and deployment manifests accordingly

- **System Components**
  - Updated Cozystack API, Controller, and Dashboard configurations
- Refreshed image references for Kamaji, KubeOVN, and other system
services

<!-- end of auto-generated comment: release notes by coderabbit.ai -->

Signed-off-by: Andrei Kvapil <kvapss@gmail.com>
2025-01-17 18:23:53 +01:00
..
2025-01-17 18:23:53 +01:00
2024-08-12 14:47:11 +02:00
2024-07-16 17:31:52 +02:00
2024-11-21 15:35:10 +01: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