Sign inTry Free

ALTER NODE

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

On this page

While each node in a cluster resides on a specific host, the host itself can be part of multiple networks, both internal and external, and thus can be addressed by multiple hostnames and/or IP addresses. By extension, each node that resides on this type of host can also be addressed by multiple hostnames and/or IP addresses, both internal and external.

The ALTER NODE command can be used to set:

  • An external hostname or IP address with which to address a node.

  • An external port with which to connect to a node.

Syntax

ALTER NODE <host>:<port> SET EXTERNAL_HOST=<external_host>, EXTERNAL_PORT=<external_port>;

Arguments

  • <host>: The node’s host (hostname or IP address).

  • <port>: The node’s port on the host.

  • <external_host>: The external host (hostname or IP address) with which to address the node.

  • <external_port>: The external port with which to connect to the node.

Remarks

  • If only updating the host, <port> and <external_port> can be the same value.

  • If only updating the port, <host> and <external_host> can be the same value.

  • The ALTER NODE command is used when the secondary cluster connects to the primary cluster during disaster recovery (DR) replication.

    • DR connections are made from nodes on the secondary cluster to nodes on the primary cluster.

    • The nodes on the secondary cluster use the external host and external port to make these connections.

    • If the host and/or port are not specified, the host and/or port are used that were initially defined when the leaf node was added to the cluster.

  • The SingleStore database user must have the CLUSTERprivilege to run the ALTER NODE command.

  • The ALTER NODE command returns an error if the external host (hostname or IP address) and/or port are already in use.

Examples

ALTER NODE '127.0.0.1':3306 SET EXTERNAL_HOST='127.0.0.1', EXTERNAL_PORT=3316;
Query OK, 0 rows affected (7 ms)

Related Topics

REPLICATE DATABASE

Last modified: September 12, 2024

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK