【 使用环境 】生产环境
【 OB or 其他组件 】ocp
【 使用版本 】ocp 4.2.2
【问题描述】需要接管的集群,集群名称和集群id都相同,同时接管是否会出现冲突
需要新接入的集群,集群名:集群id也是 obcluster:1
【 使用环境 】生产环境
【 OB or 其他组件 】ocp
【 使用版本 】ocp 4.2.2
【问题描述】需要接管的集群,集群名称和集群id都相同,同时接管是否会出现冲突
根据OCP记录集群信息表结构来看是不行的,集群名和集群ID有唯一键
UNIQUE KEY uk_ob_cluster_name_ob_cluster_id
(name
, ob_cluster_id
)
CREATE TABLE ob_cluster
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘OCP???ID’,
create_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘???’,
update_time
datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘???’,
origin
varchar(64) NOT NULL DEFAULT ‘CREATED’ COMMENT ‘???’,
creator
varchar(64) DEFAULT NULL COMMENT ‘???’,
name
varchar(256) NOT NULL COMMENT ‘???’,
ob_version
varchar(32) NOT NULL COMMENT ‘OB??’,
vpc_id
bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘OB???VPC’,
ob_cluster_id
bigint(20) NOT NULL COMMENT ‘OB???id’,
type
varchar(16) NOT NULL DEFAULT ‘PRIMARY’ COMMENT ‘???, PRIMARY/STANDBY’,
architecture
varchar(128) DEFAULT NULL COMMENT ‘???’,
rootserver_json
varchar(65536) DEFAULT NULL COMMENT ‘rootserver?configurl??json??’,
rootserver_update_time
datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT ‘rootserver ???’,
status
varchar(64) NOT NULL DEFAULT ‘CREATING’ COMMENT ‘???CREATING/RUNNING/STOPPING/STOPPED/STARTING/DELETING/DELETED/STARTING_IN_READ_ONLY’,
sync_status
varchar(32) NOT NULL DEFAULT ‘VALID’ COMMENT ‘???VALID/DISABLE/UNKNOWN’,
operate_status
varchar(16) NOT NULL DEFAULT ‘NORMAL’ COMMENT ‘???, NORMAL/OPERATING’,
compaction_status
varchar(16) DEFAULT NULL COMMENT ‘???, IDLE/MERGING/INDEX/TIMEOUT/ERROR? ??? __all_zone merge_status ?’,
arbitration_service_id
bigint(20) DEFAULT NULL COMMENT ‘OB???ID’,
startup_parameters
varchar(2048) DEFAULT NULL COMMENT ‘???’,
attributes_json
varchar(2048) DEFAULT ‘{“DataDiskPath”:"/data/1",“InstallPath”:"/home/admin/oceanbase",“LogDiskPath”:"/data/log1",“OperatingSystemUser”:“admin”}’ COMMENT ‘???json???’,
start_time
datetime DEFAULT NULL COMMENT ‘???’,
stop_time
datetime DEFAULT NULL COMMENT ‘???’,
group_id
bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘???ID?FK refer to ob_cluster_group.id, 0 ???DEFAULT??’,
snapshot_id
bigint(20) DEFAULT ‘0’ COMMENT ‘???ID’,
PRIMARY KEY (id
),
UNIQUE KEY uk_ob_cluster_name_ob_cluster_id
(name
, ob_cluster_id
) BLOCK_SIZE 16384 GLOBAL
OCP中的集群名和集群ID是不可以修改的,所以不能接管已存在的集群名或者ID,OB的3段式用户名中包含了集群名或者ID,所以肯定是不行的哦