Managed Clickhouse Service
ClickHouse is an open source high-performance and column-oriented SQL database management system (DBMS). It is used for online analytical processing (OLAP).
How to restore backup from S3
Find the snapshot:
restic -r s3:s3.example.org/clickhouse-backups/table_name snapshots
Restore it:
restic -r s3:s3.example.org/clickhouse-backups/table_name restore latest --target /tmp/
For more details, read Restic: Effective Backup from Stdin.
Parameters
Common parameters
Name | Description | Value |
---|---|---|
size | Size of Persistent Volume for data | 10Gi |
logStorageSize | Size of Persistent Volume for logs | 2Gi |
shards | Number of Clickhouse shards | 1 |
replicas | Number of Clickhouse replicas | 2 |
storageClass | StorageClass used to store the data | "" |
logTTL | TTL (expiration time) for query_log and query_thread_log | 15 |
Configuration parameters
Name | Description | Value |
---|---|---|
users | Users configuration | {} |
Backup parameters
Name | Description | Value |
---|---|---|
backup.enabled | Enable periodic backups | false |
backup.s3Region | AWS S3 region where backups are stored | us-east-1 |
backup.s3Bucket | S3 bucket used for storing backups | s3.example.org/clickhouse-backups |
backup.schedule | Cron schedule for automated backups | 0 2 * * * |
backup.cleanupStrategy | Retention strategy for cleaning up old backups | --keep-last=3 --keep-daily=3 --keep-within-weekly=1m |
backup.s3AccessKey | Access key for S3, used for authentication | oobaiRus9pah8PhohL1ThaeTa4UVa7gu |
backup.s3SecretKey | Secret key for S3, used for authentication | ju3eum4dekeich9ahM1te8waeGai0oog |
backup.resticPassword | Password for Restic backup encryption | ChaXoveekoh6eigh4siesheeda2quai0 |
resources | Explicit CPU and memory configuration for each ClickHouse replica. When left empty, the preset defined in resourcesPreset is applied. | {} |
resourcesPreset | Default sizing preset used when resources is omitted. Allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge. | small |
Parameter examples and reference
resources and resourcesPreset
resources
sets explicit CPU and memory configurations for each replica.
When left empty, the preset defined in resourcesPreset
is applied.
resources:
cpu: 4000m
memory: 4Gi
resourcesPreset
sets named CPU and memory configurations for each replica.
This setting is ignored if the corresponding resources
value is set.
Preset name | CPU | memory |
---|---|---|
nano | 100m | 128Mi |
micro | 250m | 256Mi |
small | 500m | 512Mi |
medium | 500m | 1Gi |
large | 1 | 2Gi |
xlarge | 2 | 4Gi |
2xlarge | 4 | 8Gi |
Last modified 2025-07-01: [docs] Update managed apps reference (cada010)