【详述】集群备份和恢复功能
1、使用backup、restore功能
在restore时,报错
Table sl_dws_xxxxx_fht already exist but with different schema]
MySQL [sl_dw]> show restore from sl_dw\G
*************************** 1. row ***************************
JobId: 2681062
Label: sl_dws_xxxxx_fht_20221109_04
Timestamp: 2022-12-14-16-11-21-994
DbName: default_cluster:sl_dw
State: CANCELLED
AllowLoad: false
ReplicationNum: 3
RestoreObjs: sl_dws_xxxxx_fht PARTITIONS [p20221109]
CreateTime: 2022-12-14 16:16:07
MetaPreparedTime: NULL
SnapshotFinishedTime: NULL
DownloadFinishedTime: NULL
FinishedTime: 2022-12-14 16:16:10
UnfinishedTasks:
Progress:
TaskErrMsg:
Status: [COMMON_ERROR, msg: Table sl_dws_xxxxx_fht already exist but with different schema]
Timeout: 86400
1 row in set (0.00 sec)
- 表结构差异
backup的表是2.2.1的,相比restore的表(2.3.4),少了一个属性
“enable_persistent_index” = “false”
【背景】做过哪些操作?
【业务影响】
【StarRocks版本】
broker版本:2.3.4
SR版本:
backup机器:2.2.1
restore机器:2.3.4
【集群规模】 3fe+5be+1broker
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【附件】