Nodegroup

A Nodegroup is a computing module that enables users to execute SQL commands such as DDL, DML, and DQL. Each Nodegroup consists of independent resources and supports dynamic scaling. Nodegroups are completely isolated and do not impact each other. Users can create one or more Nodegroups based on business requirements.

The Nodegroup uses units as its measurement metric. Users can dynamically adjust the number of units (expand or shrink) according to their business volume. More units equate to greater processing capacity. Users can also suspend the Nodegroup when not in use, reducing costs.

Nodegroup Creation

The Nodegroup is part of the Data Cloud, so it must be created within a Data Cloud. After creating a Data Cloud, navigate to the corresponding region's page and create a Nodegroup directly under the Data Cloud, as shown below:

After specifying the Nodegroup name (which must be unique within the same Data Cloud) and resource size, click "Confirm" to initiate the creation of the Nodegroup, as shown below:

Catalog is a collection of Databases. When a Nodegroup is linked to a Catalog, it gains access to all Databases within that Catalog. To learn more about Catalog, refer to Catalog.

When a Nodegroup is created, it is "initializing" and displays the creation status of its resources, as shown in the following figure. When it is "running," it indicates successful creation and readiness to provide external services.

Nodegroup Status

Nodegroup states include:

1. Initializing: The Nodegroup is being created and initialized.
2. Running: The Nodegroup is active, allowing users to perform SQL operations such as adding, deleting, modifying, and querying.
3. Pausing: The Nodegroup is in a pause state. Computing resources are halted, but user data remains stored.
4. Paused: The Nodegroup is paused, and SQL services are unavailable.
5. Recovering: The Nodegroup is transitioning back to a running state, automatically loading all data from before the pause.
6. Abnormal: The Nodegroup is in a temporary abnormal state.
7. Deleting: The Nodegroup is in the process of deletion until all resources are removed. User data remains intact unless the database data is deleted simultaneously.

Nodegroup Management

The figure below shows the page displaying the Nodegroup's utilization, QPS, latency, and other monitoring information. It also lists the operations available for the current Nodegroup.

Nodegroup Expansion and Reduction

Adjust the number of Nodegroup units in real time according to business volume requirements using "Resource Size." Size adjustments are independent of previous adjustments and can be modified anytime, with the system promptly responding to changes.

Nodegroup Connection

This section involves configuring public and VPC networks. In the VPC network, use the private link (PrivateLink) function provided by the cloud vendor. See Network Connection for details.

Nodegroup Pause/Resume

A running Nodegroup can be paused, and a paused Nodegroup can be restored to running.

Click the Nodegroup name in the upper left corner of the above picture to enter the Nodegroup details page, as shown below:

In addition to the above operations, you can also:

1. Rename: Change the Nodegroup name.
2. Attached Database: View the database attached to the Nodegroup.

Nodegroup Deletion

Users can delete Nodegroups that are no longer in use. Upon deletion, previously attached databases will be automatically detached, and the data will be retained. Users can reattach these databases by creating new Nodegroups, allowing continued data use.

When deleting, users can choose whether to delete the database simultaneously. Choose carefully, as database template0 and the Nodegroup are permanently deleted.

Note: Before deleting a Nodegroup, delete all VPC network endpoint connections under it.