Clickhouse 的备份
Clickhouse 的备份有全库备份和单表备份
全库备份需借助第三方工具， clickhouse-backup
单表备份直接使用官方命令。
clickhouse-backup
1 install
可以直接下载安装包或者去 github 上下载
https://github.com/AlexAkulov/clickhouse-backup
2 修改配置文件
/etc/clickhouse-backup/config.yml
general:
remote_storage: none
max_file_size: 1073741824
disable_progress_bar: true
backups_to_keep_local: 7
backups_to_keep_remote: 0
log_level: debug
allow_empty_backups: false
download_concurrency: 1
upload_concurrency: 1
restore_schema_on_cluster: ""
upload_by_part: true
download_by_part: true
clickhouse:
username: chuser
password: "YouPassword"
host: 192.168.1.203
port: 9000
skip_tables:
- system.*
- INFORMATION_SCHEMA.*
- information_schema.*
timeout: 5m
freeze_by_part: false
secure: false
skip_verify: false
sync_replicated_tables: false
log_sql_queries: false
ignore_not_exists_error_during_freeze: true
debug: false
3 如果 clickhouse 是 docker 形式运行，需要创建一个 softlink ，否则备份时会报错
