一、删除BE节点命令
ALTER SYSTEM DROP BACKEND "node1:9050";
ALTER SYSTEM DROP BACKEND "node2:9050";
ALTER SYSTEM DROP BACKEND "node3:9050";
如果报如下错误:
ERROR 1105 (HY000): errCode = 2, detailMessage = It is highly NOT RECOMMENDED to use DROP BACKEND stmt.It is not safe to directly drop a backend. All data on this backend will be discarded permanently. If you insist, use DROPP instead of DROP
请使用如下命令进行删除
ALTER SYSTEM DROPP BACKEND "node1:9050";
ALTER SYSTEM DROPP BACKEND "node2:9050";
ALTER SYSTEM DROPP BACKEND "node3:9050";
二、增加BE节点
ALTER SYSTEM ADD BACKEND "node1:9050";
ALTER SYSTEM ADD BACKEND "node2:9050";
ALTER SYSTEM ADD BACKEND "node3:9050";