Files
cozystack/packages/apps/clickhouse
Nick Volynkin c795e4fb68 Prepare release v0.29.0 (#740)
<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

- **Chores**
- Streamlined the asset release process to automatically replace
existing files during uploads.
  
- **Container Image Updates**
- Upgraded versions across multiple components—including backup,
caching, autoscaling, API, dashboard, monitoring, and more—to align with
the latest release (e.g., updating from v0.28.0 to v0.29.0 and other
minor version increments).
- Updated specific images for Grafana, PostgreSQL, MariaDB, ClickHouse,
and others to their latest versions.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->

---------

Signed-off-by: Nick Volynkin <nick.volynkin@gmail.com>
Signed-off-by: Andrei Kvapil <kvapss@gmail.com>
2025-04-02 23:45:25 +02:00
..
2025-04-02 23:45:25 +02:00
2024-08-12 14:47:11 +02:00
2025-03-13 17:03:00 +03:00
2024-07-16 17:31:52 +02:00
2025-03-13 17:03:00 +03:00
2025-03-13 17:03:00 +03:00
2025-03-13 17:03:00 +03:00
2025-03-13 17:03:00 +03: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
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