ADD OBSERVER

Description

This statement adds a node with the OBSERVER role to the FRONTEND node (only used by administrators!)

Syntax

ALTER SYSTEM ADD OBSERVER "<observer_host>:<edit_log_port>"

Required Parameters

1. <observer_host>

Can be the hostname or IP address of the FE node

2. <edit_log_port>

bdbje communication port of FE node, the default is 9010

Access Control Requirements

The user executing this SQL command must have at least the following permissions:

Privilege	Object	Notes
NODE_PRIV

Usage Notes

1. Before adding a new OBSERVER node, make sure the node is properly configured.
2. After adding the OBSERVER node, use the SHOW FRONTENDS command to verify that they have been added successfully and are in a normal state.

Examples

1. Add a OBSERVER node

   ALTER SYSTEM ADD OBSERVER "host_ip:9010"
   This command adds a OBSERVER node to the cluster (IP host_ip, port 9010)