CREATE NODE

Function

CREATE NODE creates a cluster node.

Precautions

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

Syntax

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

CREATE NODE nodename WITH
  (
    [ TYPE = nodetype,]
    [ HOST = hostname,]
    [ PORT = portnum,]
    [ HOST1 = 'hostname',]
    [ PORT1 = portnum,]
    [ HOSTPRIMARY [ = boolean ],]
    [ PRIMARY [ = boolean ],]
    [ PREFERRED [ = boolean ],]
    [ SCTP_PORT = portnum,]
    [ CONTROL_PORT = portnum,]
    [ SCTP_PORT1 = portnum,]
    [ CONTROL_PORT1 = portnum ]
  );

Parameter Description

• nodename

  Specifies the node name.

  Value range: a string. It must comply with the naming convention.

• TYPE = nodetype

  Specifies the type of a node.

  Value range:

  • 'coordinator'
  • 'datanode'
• HOST = hostname

  Specifies the primary server name or IP address of a node.

• PORT = portnum

  Specifies the primary server port to which a node is bound.

• HOST1 = hostname

  Specifies the name or IP address of the standby server of a node.

• PORT1 = portnum

  Specifies the port number of the standby server to which a node is bound.

• HOSTPRIMARY
• PRIMARY = boolean

  Specifies whether the node is a primary node or not. A primary node allows read/write operations. A non-primary node allows only read operations.

  Value range:

  • true
  • false (default value)
• PREFERRED = boolean

  Specifies whether the node is a preferred node for read operations.

  Value range:

  • true
  • false (default value)
• SCTP_PORT = portnum

  Specifies the port used by the TCP proxy communication library or SCTP communication library (Due to specification changes, the current version no longer supports the current feature. Do not use this feature.) of the primary node to listen on the data transmission channel. The TCP protocol is used to listen on connections.

Helpful Links

ALTER NODE and DROP NODE