DROP NODE

Description

Drops nodes from a cluster.

Precautions

DROP NODE is an API of the cluster management tool. You are advised not to use this API, because doing so affects the cluster. Only the administrator has the permission to use this API.

Syntax

    
         DROP NODE [ IF EXISTS ] nodename [WITH ( cnnodename [, ... ] )];

Click to enlarge

Parameters

IF EXISTS
Reports a notice instead of an error if the specified node does not exist.

nodename
Specifies the name of the node to be dropped.

Value range: an existing node name.

cnnodename
Specifies the CN name. If this parameter is defined, the cluster nodes under the currently connected CN and the defined CN are dropped.

Value range: an existing CN name

If there are multiple CNs, cluster nodes are created only on the currently connected CNs and will not be synchronized to other CNs. You need to create cluster nodes on all CNs. To drop a cluster node, you only need to connect to one CN. If cluster nodes are created on only one CN, you need to define the current CN name and drop the cluster node on the CN.

Examples

-- Create cluster nodes on all CNs.
gaussdb=# CREATE NODE datanode1 WITH(
   TYPE = datanode,
   PREFERRED = false
);

-- Drop cluster nodes and connect to only one CN.
gaussdb=# DROP NODE datanode1;