ClickHouse / ClickHouse/ClickHouse

How To Backup/Restore While Preserving Disk For Partition

Open
#66,882 1 comment 0 reactions 0 assignees View on GitHub
comp-backup external question
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
20h 33m
Merged PRs (30d)
501

Description

### Company or project name

_No response_

### Question

Hi,

I'm using the builtin BACKUP and RESTORE commands. I've found that during a restore that the data partitions are not being sent onto the same disk as they were on the original backed up database. My setup has some small local disk with the majority of data being stored on S3. This means that the restore always runs out of local disk and fails. I have tried to write some script that runs during the restore to move partitions onto S3 while the restore is running but it seems like it can't keep up and eventually it still runs out of disk.

My question is, is there some parameter I'm missing when using the backup/restore commands to preserve some metadata about the partition disk?

Thanks,
Ricky

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.