ClickHouse-Backup的安装与部署

1、下载

方法一：直接下载预编译二进制文件（推荐）
bash
#确定最新版本（访问 https://github.com/AlexAkulov/clickhouse-backup/releases 查看）

LATEST_VERSION=$(curl -s https://api.github.com/repos/AlexAkulov/clickhouse-backup/releases/latest | grep -oP '"tag_name": "\K(.*)(?=")')

#下载对应版本（Linux x86_64 示例）

wget https://github.com/AlexAkulov/clickhouse-backup/releases/download/${LATEST_VERSION}/clickhouse-backup-linux-amd64.tar.gz

#解压
tar -xvf clickhouse-backup-linux-amd64.tar.gz

2、安装

#移动二进制文件到系统路径

mv clickhouse-backup /usr/local/bin/

#创建配置目录

mkdir -p /etc/clickhouse-backup

#生成默认配置文件

clickhouse-backup default-config > /etc/clickhouse-backup/config.yml

#检查版本

clickhouse-backup -version

#查看帮助

clickhouse-backup help

3、配置文件设置

编辑 /etc/clickhouse-backup/config.yml：
修改配置文件中的密码password

yaml
general:
  remote_storage: none  # 可选 s3, gcs, azblob 等
  disable_progress_bar: false
  backups_to_keep_local: 7
  backups_to_keep_remote: 0

clickhouse:
  username: "default"
  password: ""
  host: "localhost"
  port: 9000
  data_path: "/var/lib/clickhouse/"
  skip_tables:
    - "system.*"
    - "INFORMATION_SCHEMA.*"
    - "information_schema.*"

4、创建系统服务

创建 systemd 服务文件 /etc/systemd/system/clickhouse-backup.service：

ini
[Unit]
Description=ClickHouse Backup Service
After=network.target clickhouse-server.service

[Service]
User=clickhouse
Group=clickhouse
Type=simple
ExecStart=/usr/local/bin/clickhouse-backup server
Restart=always
RestartSec=3

[Install]
WantedBy=multi-user.target

启用并启动服务：

sudo systemctl daemon-reload
sudo systemctl enable clickhouse-backup
sudo systemctl start clickhouse-backup

5、基本使用命令

创建备份

clickhouse-backup create my_backup

列出备份

clickhouse-backup list

恢复备份

clickhouse-backup restore my_backup

上传到远程存储

clickhouse-backup upload my_backup

从远程下载

clickhouse-backup download my_backup

6、注意事项

确保 ClickHouse 服务正在运行

备份/恢复操作需要足够的磁盘空间

大型数据库备份可能需要较长时间

生产环境建议先在小规模测试环境验证

定期清理旧备份以节省空间