Is the clickhouse-copier support backup incremental data in each day to DR env?

[taotaizhu-pw]

We would build the Disaster Rcovery Environment. Our prod clickhouse cluster env has 3 nodes. Is it possible to run clickhouse-copier in each day once at 5:00AM to backup the incremental data to DR servers?

If it is not a good solution, is there any suggestion? thanks!

[Alex-Cheng]

I am also interested in the topic.

[hyj629222521]

me too

[hkrutzer]

I don't know about clickhouse-copier but maybe https://kb.altinity.com/altinity-kb-setup-and-maintenance/clickhouse-backup-diff/ can be of help.

[taotaizhu-pw]

we already used clickhouse-backup to backup the whole data in each day. But, we have not found how to backup the incremental data. ***@***.*** From: Hans Krutzer Date: 2023-03-13 21:21 To: ClickHouse/ClickHouse CC: taotaizhu-pw; Author Subject: Re: [ClickHouse/ClickHouse] Is the clickhouse-copier support backup incremental data in each day to DR env? (Issue #47517) I don't know about clickhouse-copier but maybe https://kb.altinity.com/altinity-kb-setup-and-maintenance/clickhouse-backup-diff/ can be of help. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[hkrutzer]

The page I linked makes a full backup on mondays and differential/incremental backups every hour.

[taotaizhu-pw]

The page I linked makes a full backup on mondays and differential/incremental backups every hour.

Thanks! Does this solution need mid storage for transition, such as s3 ? Any point to point solution?

[taotaizhu-pw]

any reply from clickhouse?

[taotaizhu-pw]

hello?