ALTER-SYSTEM-DROP-BACKEND

Name

ALTER SYSTEM DROP BACKEND

Description

This statement is used to delete the BACKEND node (administrator only!)

grammar:

  • Find backend through host and port
  1. ALTER SYSTEM DROP BACKEND "host:heartbeat_port"[,"host:heartbeat_port"...]
  • Find backend through backend_id
  1. ALTER SYSTEM DROP 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. Adding and deleting nodes is a synchronous operation. These two operations do not consider the existing data on the node, and the node is directly deleted from the metadata, please use it with caution.

Example

  1. Delete two nodes

    1. ALTER SYSTEM DROP BACKEND "host1:port", "host2:port";
    1. ALTER SYSTEM DROP BACKEND "ids1", "ids2";

Keywords

  1. ALTER, SYSTEM, DROP, BACKEND, ALTER SYSTEM

Best Practice