clickhouse备份和恢复

1、编辑配置文件

[root@localhost ~]# vim config.xml
general:
  remote_storage: none   # 通过sftp，上传到远程服务器的话，需要这个参数,否则为none
  max_file_size: 1099511627776
  disable_progress_bar: false
  backups_to_keep_local: 2   # 本地备份的个数，大于2则自动删除旧的备份，默认为0，不删除备份
  backups_to_keep_remote: 2  # 远程备份的个数
  log_level: info
  allow_empty_backups: false
clickhouse:
  username: default    # 本地clickhouse的连接参数
  password: ""
  host: localhost
  port: 9000
  disk_mapping: {}
  skip_tables:
  - system.*
  - db.*
  - information_schema.*
  - INFORMATION_SCHEMA.*
  timeout: 5m
  freeze_by_part: false
  secure: false
  skip_verify: false
  sync_replicated_tables: true
  skip_sync_replica_timeouts: true
  log_sql_queries: false

2、编辑环境变量

CLICKHOUSE_PORT=9000

3、clickhouse查看备份列表

[root@localhost ~]# 客户端工具去到阿里云盘上下载
[root@localhost ~]# ./clickhouse-backup -c config.xml list

4、备份

[root@localhost ~]# clickhouse-backup create click_data_20240621

备份完之后的数据会在/var/lib/clickhouse下

5、恢复数据

[root@localhost ~]# ./clickhouse-backup restore (备份名)