1 clickhouse备份恢复
1.1 clickhouse-backup备份恢复工具安装
安装命令:
rpm -ivh clickhouse-backup-1.0.0-1.x86_64.rpm
1.2 备份clickhouse数据
1.2.1执行备份命令
备份命令:
export CLICKHOUSE_PORT=9091 BACKUP_NAME=backup_clickhouse_$(date "+%Y-%m-%d-%H-%M-%S") clickhouse-backup create $BACKUP_NAME
列出所有备份文件命令:
clickhouse-backup list
[root@localhost backup]# clickhouse-backup list backup_clickhouse_2021-09-01-14-54-25 22.02KiB 01/09/2021 06:54:26 local backup_clickhouse_2021-09-01-14-56-56 22.02KiB 01/09/2021 06:56:57 local 2021/09/01 14:57:54 error InvalidParameter: 1 validation error(s) found. - minimum field size of 1, ListObjectsV2Input.Bucket. [root@localhost backup]#
备份文件默认保存在/opt/hyperion/clickhouse/backup目录,将备份的文件导出即可
[root@localhost backup]# ll /opt/hyperion/clickhouse/backup 总用量 0 drwxr-x--- 4 clickhouse clickhouse 57 2021-09-01 14:54:26 backup_clickhouse_2021-09-01-14-54-25 drwxr-x--- 4 clickhouse clickhouse 57 2021-09-01 14:56:57 backup_clickhouse_2021-09-01-14-56-56 [root@localhost backup]#
1.3 恢复clickhouse数据
2 postgresql备份
PGPASSWORD='123456' pg_dump -p 5432 -d pylon -U QAX -Fc -f pylonbackup.dump PGPASSWORD='123456' pg_restore -p 5432 -d pylon -U QAX -c -Fc pylonbackup.dump PGPASSWORD='123456' pg_dump -p 5432 -d zeus_pylon -U postgres -Fc -f zeus_pylon_backup.dump PGPASSWORD='123456' pg_restore -p 5432 -d zeus_pylon -U postgres -c -Fc zeus_pylon_backup.dump PGPASSWORD='123456' pg_dump -p 5432 -d HYPER -U postgres -Fc -f HYPER_backup.dump PGPASSWORD='123456' pg_restore -p 5432 -d HYPER -U postgres -c -Fc HYPER_backup.dump grant all on database zeus_pylon to public; grant all on schema public to public; pg_restore -p 5432 -d pylon -U postgres -c pylon_backup.dump pg_dumpall -p 5432 -U postgres -c > all_backup.out
3 redis备份
4 其他命令
列出 clickhouse-backup该包中有哪些文件
rpm -ql clickhouse-backup