MGR集群将ARBITRATOR节点变SECONDARY节点
我创建一个3节点的MGR（如下），请我现在怎么才可以把ARBITRATOR节点变成有数据的SECONDARY节点？{
"clusterName": "GreatSQLMGR",
"defaultReplicaSet": {
"name": "default",
"primary": "10.186.132.44:3306",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"10.186.132.44:3306": {
"address": "10.186.132.44:3306",
"instanceErrors": [
"WARNING: Detected an unused recovery account: mysql_innodb_cluster_47. Use Cluster.rescan() to clean up."
],
"memberRole": "PRIMARY",
"mode": "R/W",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
},
"10.186.132.45:3306": {
"address": "10.186.132.45:3306",
"memberRole": "SECONDARY",
"mode": "R/O",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
},
"10.186.132.47:3306": {
"address": "10.186.132.47:3306",
"instanceErrors": [
"WARNING: The replication recovery account in use by the instance is not stored in the metadata. Use Cluster.rescan() to update the metadata."
],
"memberRole": "ARBITRATOR",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "10.186.132.44:3306"
}
需要手动操作，大概过程
1. 修改 group_replication_arbitrator = OFF，关闭仲裁节点模式
2. 利用GreatSQL Shell，执行 removeInstance() 删除该节点
3. 利用GreatSQL Shell，执行 addInstance() 重新加回该节点，会提示要用Clone全量复制一份数据 yejr 发表于 2024-5-22 17:53
需要手动操作，大概过程
1. 修改 group_replication_arbitrator = OFF，关闭仲裁节点模式
2. 利用GreatSQL...
仲裁节点既然是Greasql独有节点特性，能否在以后Greasql MYSQL SHELL版本中直接进行仲裁、主节点、从节点的切换，不用再退出添加节点。 15167759230 发表于 2024-5-31 16:13
仲裁节点既然是Greasql独有节点特性，能否在以后Greasql MYSQL SHELL版本中直接进行仲裁、主节点、从节点 ...
暂不支持，原因详见 https://greatsql.cn/thread-771-1-1.html 这里的回复
页:
[1]