Skip to main content

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:

PrivilegeObjectNotes
NODE_PRIV

Usage Notes

  1. Before adding a new OBSERVER node, make sure the node is properly configured.
  2. After adding the OBSERVER node, useSHOW FRONTENDScommand 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)