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
- Before adding a new OBSERVER node, make sure the node is properly configured.
- After adding the OBSERVER node, use
SHOW FRONTENDS
command to verify that they have been added successfully and are in a normal state.
Examples
- Add a OBSERVER node
This command adds a OBSERVER node to the cluster (IP host_ip, port 9010)
ALTER SYSTEM ADD OBSERVER "host_ip:9010"