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

  1. Find the snapshot:

    restic -r s3:s3.example.org/clickhouse-backups/table_name snapshots
    
  2. 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

NameDescriptionValue
sizeSize of Persistent Volume for data10Gi
logStorageSizeSize of Persistent Volume for logs2Gi
shardsNumber of Clickhouse shards1
replicasNumber of Clickhouse replicas2
storageClassStorageClass used to store the data""
logTTLTTL (expiration time) for query_log and query_thread_log15

Configuration parameters

NameDescriptionValue
usersUsers configuration{}

Backup parameters

NameDescriptionValue
backup.enabledEnable periodic backupsfalse
backup.s3RegionAWS S3 region where backups are storedus-east-1
backup.s3BucketS3 bucket used for storing backupss3.example.org/clickhouse-backups
backup.scheduleCron schedule for automated backups0 2 * * *
backup.cleanupStrategyRetention strategy for cleaning up old backups--keep-last=3 --keep-daily=3 --keep-within-weekly=1m
backup.s3AccessKeyAccess key for S3, used for authenticationoobaiRus9pah8PhohL1ThaeTa4UVa7gu
backup.s3SecretKeySecret key for S3, used for authenticationju3eum4dekeich9ahM1te8waeGai0oog
backup.resticPasswordPassword for Restic backup encryptionChaXoveekoh6eigh4siesheeda2quai0
resourcesExplicit CPU and memory configuration for each ClickHouse replica. When left empty, the preset defined in resourcesPreset is applied.{}
resourcesPresetDefault 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 nameCPUmemory
nano100m128Mi
micro250m256Mi
small500m512Mi
medium500m1Gi
large12Gi
xlarge24Gi
2xlarge48Gi