clickhouse-backup
clickhouse-backup copied to clipboard
Altinity
Tool for easy ClickHouse backup and restore using object storage for backup files.
node1: > clickhouse-backup create --table default.test1 backuptest1 > clickhouse-backup create --table default.test1 backuptest2 > clickhouse-backup upload backuptest1 > clickhouse-backup upload backuptest2 --diff-from backuptest1 node2: > clickhouse-backup download backuptest2 2022/07/29 18:14:57.065003...
Error info: Received exception from server (version 22.2.3): Code: 1000. DB::Exception: Received from chi-datalake-ck-cluster-0-0:9000. DB::Exception: Timeout. (POCO_EXCEPTION) (query: SELECT name FROM system.backup_list WHERE location='remote' AND name LIKE '20220722-%-shard_0-business-asset_log_local' ORDER BY...
I have two disks: one is default, another is s3, here is the storage configuration both in source clickhouse and target clickhouse: ```xml s3 https://s3.us-west-2.amazonaws.com/datavisor-access-logs/fedex/ false xxxxxx xxxxxx us-west-2 10000...
I've found one issue, if in backup i want to restore some dictionaries were renamed - then there will be error like: ``` 04:45:54 2022/06/18 02:45:54.080308 warn can't drop table...
When I used create_remote option to backup my data, I got an error: `400 EntityTooSmall(Message: Your proposed upload is smaller than the minimum allowed object size`.  Then I checked...
If I scan the latest version 1.4.3 with trivy, I get a security warning on github.com/dgrijalva/jwt-go: ``` # trivy image --severity HIGH,CRITICAL alexakulov/clickhouse-backup:1.4.3 bin/clickhouse-backup (gobinary) Total: 1 (HIGH: 1, CRITICAL:...
As I said in my previous post, I made a script which replaces the strings in backups by database and table name , you've said that I had made a...
I can create a backup in the folder(clickhouse-backup create "25042021_1115/clickhouse/" --table dbname.*), but I can't list it or restore it. when restore, I get an error: "error can't restore: backup...
- allow poll system.parts_log - upload new parts only - delete old parts via retention policy - allow data point in time recovery
We need to be sure we do UNFREEZE to release the files which were freezed.
