ApsaraDB for ClickHouse allows you to use the command line tool of ClickHouse, Data Management (DMS), or other clients such as DataGrip or DBeaver to connect to an ApsaraDB for ClickHouse cluster. This topic describes how to use DMS to connect to an ApsaraDB for ClickHouse cluster.
Background information
DMS is a graphical data management tool provided by Alibaba Cloud. You can use DMS to manage relational databases and NoSQL databases. DMS provides features such as data management, SQL operations, data import and export, database cloning, database performance optimization, and security audit. You can use DMS to simplify database management, create databases and tables in ApsaraDB for ClickHouse online, and query data online. DMS can help you enhance data security, manage data more efficiently, and gain more value from your data.
Prerequisites
The following steps listed in Quick Start are complete:
- Note
When you create an ApsaraDB for ClickHouse cluster, the system automatically creates a whitelist group named ali_dms_group for the ApsaraDB for ClickHouse cluster and adds the IP address of the DMS server to the whitelist group. If the whitelist group fails to be added automatically, you must manually add the whitelist group. For more information about the IP addresses of DMS servers in different regions, see DMS IP addresses and CIDR blocks.
Procedure
Log on to the ApsaraDB for ClickHouse console.
In the top navigation bar, select the region where the cluster is deployed.
On the Default Instances tab of the Clusters page, click the ID of the cluster that you want to manage.
On the Cluster Information page, click Log On to Database.
Set the following parameters as prompted.
Parameter
Description
Example
Database Type
The type of the ApsaraDB for ClickHouse cluster. The default value is ClickHouse. You do not need to change this value.
ClickHouse
Instance Region
The region for the ApsaraDB for ClickHouse cluster. The default value is the region where the current ApsaraDB for ClickHouse cluster is deployed. You do not need to change this value.
NoteIf you want to log on to an ApsaraDB for ClickHouse cluster that is located in another region, select the region of the cluster from the drop-down list.
China (Hangzhou)
Instance ID
The ID of the ApsaraDB for ClickHouse cluster. The default value is the ID of the current ApsaraDB for ClickHouse cluster. You do not need to change this value.
NoteIf you want to log on to another ApsaraDB for ClickHouse cluster, select the ID of the cluster from the drop-down list.
cc-bp16qwvp7hy8i****
Database Account
The account that is used to log on to the database.
test
Database Password
The password of the database account.
123456Aa
Remember password
If you select Remember password, you do not need to enter the account and the password next time you log on to the ApsaraDB for ClickHouse cluster.
Select Remember password.
NoteIf you log on to the ApsaraDB for ClickHouse cluster by using DMS for the first time, the value of the Control Mode parameter is Flexible Management by default. After you log on to the cluster, you can change the control mode by modifying the information about the cluster. For more information, see Modify database instances and Control modes.
After the preceding parameters are set, click Test Connectivity in the lower-left corner of the Log on to Database Instance dialog box. If the connectivity test fails, check the parameter values that you specify based on the error message.
Click Login.
What to do next
References
If you want to connect to an ApsaraDB for ClickHouse cluster by using another method, see the following topics: