DocsICP FilingConsole
官方文档
首页

Connect to a cluster

更新时间：
复制 MD 格式
产品详情
我的收藏

You can connect to an ApsaraDB for ClickHouse cluster by using DMS, the ClickHouse command-line tool, or other clients such as DataGrip and DBeaver. This topic walks you through connecting by using DMS.

Background information

DMS (Data Management Service) is an Alibaba Cloud graphical tool for managing relational and NoSQL databases. It supports data management, SQL operations, data import/export, database cloning, performance optimization, and security audits. You can use DMS to manage databases and tables and run online queries in ApsaraDB for ClickHouse.

Prerequisites

You have completed the following steps in the quick start guide:

  • Create a cluster

  • Create an account

  • Configure a whitelist

    Note

    When you create an ApsaraDB for ClickHouse cluster, the system automatically adds a whitelist group named ali_dms_group to the ApsaraDB for ClickHouse cluster and adds the IP addresses of DMS servers to this group. If this process fails, you must add the IP addresses manually. For the IP addresses of DMS servers in different regions, see DMS IP Address Ranges.

Procedure

  1. Log on to the ApsaraDB for ClickHouse console.

  2. In the upper-left corner of the page, select the region where your cluster resides.

  3. On the Clusters page, find the Instance list for your cluster type, and then click the ID of your target cluster.

  4. On the Cluster Information page, click Log On to Database.

  5. Configure the following parameters.

    Parameter

    Description

    Example

    The database type

    The type of the ApsaraDB for ClickHouse cluster. The value is set to ClickHouse by default. You do not need to change this setting.

    ClickHouse

    Region

    The region where the current ApsaraDB for ClickHouse cluster resides. The value is set by default. You do not need to change this setting.

    Note

    If you need to log on to an ApsaraDB for ClickHouse cluster in a different region, select the target region from the drop-down list.

    China (Hangzhou)

    Instance ID

    The ID of the current ApsaraDB for ClickHouse cluster. The value is set by default. You do not need to change this setting.

    Note

    If you need to log on to another ApsaraDB for ClickHouse cluster, select the ID of the target cluster from the drop-down list.

    cc-bp16qwvp7hy8i****

    Database Account

    The account that you want to use to log on to the database.

    test

    Database Password

    The password that corresponds to the database account.

    123456Aa

    Remember password

    Select Remember password to automatically log on to the ApsaraDB for ClickHouse cluster next time without the need to re-enter your credentials.

    Select Remember password.
    Note

    • When you log on to an ApsaraDB for ClickHouse cluster through DMS for the first time, the control mode is set to Flexible Management by default. After you successfully log on, you can modify the control mode by editing the instance. For more information, see and .

    • After you configure the logon parameters, you can click Test Connection in the lower-left corner of the page to check whether the cluster can be connected. If the connection test fails, check the cluster information that you entered based on the error message that appears.

  6. Click Log On.

Next steps

Create a database

Related documents

Previous：Configure a whitelistNext：Create a database