DECOMMISSION BACKEND

Description

The node offline operation is used to safely log off the node. The operation is asynchronous. If successful, the node is eventually removed from the metadata. If it fails, the logout will not be done (only for admins!)

grammar:

• Find backend through host and port

ALTER SYSTEM DECOMMISSION BACKEND "host:heartbeat_port"[,"host:heartbeat_port"...];

• Find backend through backend_id

ALTER SYSTEM DECOMMISSION BACKEND "id1","id2"...;

illustrate:

1. host can be a hostname or an ip address
2. heartbeat_port is the heartbeat port of the node
3. The node offline operation is used to safely log off the node. The operation is asynchronous. If successful, the node is eventually removed from the metadata. If it fails, the logout will not be completed.
4. You can manually cancel the node offline operation. See CANCEL DECOMMISSION

Examples

1. Offline two nodes

   ALTER SYSTEM DECOMMISSION BACKEND "host1:port", "host2:port";

   ALTER SYSTEM DECOMMISSION BACKEND "id1", "id2";

Keywords

ALTER, SYSTEM, DECOMMISSION, BACKEND, ALTER SYSTEM

Best Practice