mirror of
https://github.com/outbackdingo/cozystack.git
synced 2026-02-06 01:06:27 +00:00
18bbdb675f
<!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit - **New Features** - Introduced a local hook to generate a versions map and check for changes. - Added new configuration options for ClickHouse, including enhanced logging, user management, and structured templates. - New parameters for persistent volume size and Docker image specifications in ClickHouse configuration. - Added hostname matching capabilities in ClickHouse operator configuration. - **Bug Fixes** - Updated exclusion patterns for YAML files in pre-commit hooks. - **Version Updates** - Incremented ClickHouse chart version from 0.5.0 to 0.6.0. - Updated versioning for several packages, including `clickhouse` and `tenant`. <!-- end of auto-generated comment: release notes by coderabbit.ai --> --------- Co-authored-by: Andrei Kvapil <kvapss@gmail.com>
2.4 KiB
2.4 KiB
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 |