Skip to main content
Skip to main content

ALTER-SYSTEM-ADD-BACKEND

ALTER-SYSTEM-ADD-BACKEND​

Name​

ALTER SYSTEM ADD BACKEND

Description​

This statement is used to manipulate nodes within a system. (Administrator only!)

grammar:

-- Add nodes (add this method if you do not use the multi-tenancy function)
ALTER SYSTEM ADD BACKEND "host:heartbeat_port"[,"host:heartbeat_port"...];

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. Add a node

    ALTER SYSTEM ADD BACKEND "host:port";

Keywords​

ALTER, SYSTEM, ADD, BACKEND, ALTER SYSTEM

Best Practice​