doris版本
apache-doris-2.0.12-bin-x64.tar.gz
计划是这样
我在A机通过BACKUP SNAPSHOT 数据库 To minio 备份至:本机的minio(模拟远程的3S)
然后在B机访问我本机的minio进行还原操作.
我在旧的(A)机子进行还原是可以
现在应该是备份文件没有在新的(B)机子上没有下载备份文件..导致的失败.!
图片.png
对应语句
创建库
CREATE REPOSITORY minio
WITH S3
ON LOCATION "s3://doris"
PROPERTIES
(
"AWS_ENDPOINT" = "http://192.168.XX.XX:9000",
"AWS_ACCESS_KEY" = "kizuLjXXXXXXXXX",
"AWS_SECRET_KEY"="5xmX2I6qjTVQxe9UuSxPuiXXXXXXXX",
"AWS_REGION" = "us-east-1",
"use_path_style" = "true"
)
备份表
BACKUP SNAPSHOT shujuku.biaoming To minio on(biaoming) PROPERTIES ("type"="full");
还原
RESTORE SNAPSHOT shujuku.biaoming
FROM minio
ON ( biaoming )
PROPERTIES
(
"backup_timestamp"="2024-10-08-16-06-41",
"replication_num" = "1"
);
