Skip to main content

ALTER-SYSTEM-DECOMMISSION-BACKEND

ALTER-SYSTEM-DECOMMISSION-BACKEND​

Name​

ALTER SYSTEM 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

Example​

  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​