老黄 Journal

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 ，否则备份时会报错