Use DMS to connect to a StarRocks instance - E-MapReduce

Data Management (DMS) is a one-stop data management platform that allows you to manage data throughout its lifecycle. DMS provides a web UI that helps you efficiently manage an E-MapReduce (EMR) Serverless StarRocks instance and perform in-depth O&M on the instance after you add the information about the StarRocks instance in the DMS console. This greatly improves data management experience and operation efficiency. This topic describes how to use DMS to connect to a StarRocks instance.

Background information

DMS is a web terminal provided by Alibaba Cloud to help manage databases that run Windows or Linux. After you add information about a StarRocks instance in the DMS console, you can use data management features such as database and table creation. For more information, see What is DMS?

Prerequisites

A Serverless StarRocks instance is created. For more information, see Create an instance.
The VPC CIDR blocks of DMS in the corresponding region are added to the private IP address whitelist of the Serverless StarRocks instance. For more information, see Network access and security configuration.

Procedure

Log on to the DMS console V5.0.
Click the icon in the upper-left corner and choose Data Assets > Instances.
Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Data Assets > Instances.
On the Instance List tab, click + New.

In the Add Instance dialog box, configure the parameters.

The following table describes the parameters that you must configure. Use the default values for the remaining parameters.

Section	Parameter	Description
Data Source	-	Select StarRocks for Big data on the Alibaba Cloud tab.
Basic Information	Database Type	Select StarRocks from the drop-down list.
	Instance Region	Select the region in which the StarRocks instance resides.
	Other primary accounts	The Alibaba Cloud account to which the StarRocks instance belongs. This parameter is available only if you click Cross-Alibaba Cloud account instances Note If the Alibaba Cloud account is not in the list, you can click Add User to add the Alibaba Cloud account that is used to purchase the StarRocks instance to DMS. For more information, see Add a user.
	Connection Method	The method that you use to specify the information about the StarRocks instance. Valid values: Instance ID and Connection String Address.
	Instance ID	Select the ID of the StarRocks instance from the drop-down list.
	Connection String Address	Enter the internal endpoint and internal port of the frontend node (FE) of the StarRocks instance. You can view the internal endpoint and internal port of the FE node in the FE Details section of the Instance Details tab in the EMR console. Note The connection string is in the following format: Internal endpoint of the FE:9030. Example: `fe-c-f24348802cd4****-internal.starrocks.aliyuncs.com:9030`.
	Access mode	The access mode. Valid values: Security Hosting - Manual: After security hosting is enabled, you must specify an account and its password. This option is recommended. Disable Security Hosting: Security hosting is disabled.
	Database Account	Enter the admin user of the StarRocks instance or the name of the user that you created for the instance in the EMR console. For information about how to create a user, see User management and data authorization.
	Database Password	The password of the username for the StarRocks instance.

Click Test Connection.
Note
If the connection test fails, check the instance information based on the error message.
If the test is successful, click Submit.
After you perform the preceding steps, the StarRocks instance is registered with DMS. You can view and manage your StarRocks instance in the left-side database instance list of the DMS console.
Optional. In the top navigation bar, click SQL Console. In the dialog box that appears, select the connected StarRocks instance. In the left-side navigation pane, find and double-click information_schema. On the SQLConsole tab, perform SQL operations.
Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > SQL Console > SQL Console.
For example, you can query the available databases.
```
SHOW DATABASES;
```

References

For more information about how to add an instance in the DMS console, see Register an Alibaba Cloud database instance.