cozystack/examples/backups/clickhouse

ClickHouse backup/restore example

This directory shows how to back up and restore a Cozystack-managed ClickHouse application using the cluster's Altinity backup strategy driver. The chart materialises an Altinity clickhouse-backup sidecar inside every chi-* Pod (when backup.enabled=true) that exposes the tool's HTTP API on port 7171 and shares /var/lib/clickhouse with clickhouse-server. The strategy Pod itself is a tiny curl + jq client that POSTs to the sidecar and polls the action log.

Step order

File	Role	Triggered by
00-helpers.sh	Shared bash helpers and env defaults; sourced by every step.	n/a
01-create-strategy.sh	Creates the cluster-scoped Altinity strategy that wraps clickhouse-backup.	admin
02-create-backupclass.sh	Maps apps.cozystack.io/ClickHouse to that strategy.	admin
03-create-bucket.sh	Provisions a Bucket and caches its S3 coordinates into .bucket-info.env (chmod 600; raw access keys). cleanup.sh removes this file.	tenant
04-create-clickhouse.sh	Provisions a ClickHouse instance with backup.enabled=true (chart emits the backup-s3 Secret + sidecar) and writes a sentinel row.	tenant
05-create-backupjob.sh	Submits a BackupJob and waits for Succeeded.	tenant
06-restore-in-place.sh	Drops the sentinel and restores into the same instance via RestoreJob.	tenant
07-restore-to-copy.sh	Provisions a second ClickHouse and restores into it via RestoreJob.spec.targetApplicationRef.	tenant
cleanup.sh	Removes everything created by the demo.	admin or tenant
run-all.sh	Convenience runner that executes 01..07 in order.	demo
90-scenario-admin-prepare.md	Narrative for the admin preparation steps.	docs
91-scenario-user-backup.md	Narrative for the user backup flow.	docs
92-scenario-user-restore.md	Narrative for the user restore flow (in-place and to-copy).	docs

Environment variables (overrides)

All variables come from 00-helpers.sh:

Variable	Default	Description
NAMESPACE	tenant-test	Tenant namespace for the demo.
CLICKHOUSE_NAME	clickhouse-test	Source ClickHouse application name.
CLICKHOUSE_RESTORE_NAME	clickhouse-restore	Target ClickHouse for the to-copy restore.
BUCKET_NAME	clickhouse-backups	Cozystack Bucket to provision.
BACKUPCLASS_NAME	clickhouse-backup	BackupClass name (cluster-scoped).
STRATEGY_NAME	altinity	Strategy name (cluster-scoped).
BACKUPJOB_NAME	clickhouse-backup-job	BackupJob name.
RESTOREJOB_INPLACE_NAME	clickhouse-restore-inplace	In-place RestoreJob name.
RESTOREJOB_TOCOPY_NAME	clickhouse-restore-to-copy	To-copy RestoreJob name.

Prerequisites

• Cozystack cluster with the backup-controller and backupstrategy-controller installed.
• kubectl, jq, and (for 04+) the ClickHouse operator deployed by the chart.