Updated on 2022-12-07 GMT+08:00

Quickly Buying a ClickHouse Cluster

This section describes how to quickly buy a ClickHouse cluster. ClickHouse is a columnar database management system used for online analysis. It features ultimate compression rate and fast query performance. It is widely used in Internet advertisement, app and web traffic analysis, telecom, finance, and IoT fields.

The ClickHouse cluster consists of the following components:

  • MRS 3.1.0: ClickHouse 21.3.4.25 and ZooKeeper 3.5.6.
  • MRS 3.1.2-LTS.3: ClickHouse 21.3.4.25 and ZooKeeper 3.6.3.

The ClickHouse cluster table engine that uses Kunpeng as the CPU architecture does not support HDFS and Kafka.

Quickly Buying a ClickHouse Cluster

  1. Log in to the MRS console.
  2. Click Buy Cluster. The page for buying a cluster is dispalyed.
  3. On the page for buying a cluster, click the Quick Config tab.
  4. Configure basic cluster information. For details about the parameters, see Buying a Custom Cluster.

    • Region: Use the default value.
    • Billing Mode: Select Pay-per-use.
    • Cluster Name: You can use the default name. However, you are advised to include a project name abbreviation or date for consolidated memory and easy distinguishing, Example: mrs_20201121.
    • Version Type: Normal is selected by default. (Components vary depending on the version type. Select a version type as needed.)
    • Cluster Version: Select the latest version, which is the default value. (The components provided by a cluster vary according to the cluster version. Select a cluster version based on site requirements.)
    • Component: Select ClickHouse cluster.
    • AZ: Use the default value.
    • Enterprise Project: Retain the default value.
    • VPC: Use the default value. If there is no available VPC, click View VPC to access the VPC console and create a new VPC.
    • Subnet: Use the default value.
    • Cluster Node: Select the number of cluster nodes and node specifications based on site requirements. For MRS 3.x or later, the memory of the master node must be greater than 64 GB.
    • Kerberos Authentication: Whether to enable Kerberos authentication. The slider status cannot be changed once the cluster is bought.
    • Username: The default value is root/admin. User root is used to remotely log in to ECSs, and user admin is used to access the cluster management page.
    • Password: Set a password for user root/admin.
    • Confirm Password: Enter the password of user root/admin again.
    Figure 1 ClickHouse Cluster
    Figure 2 Cluster node configurations

  5. Select Enable to enable secure communications. For details, see Communication Security Authorization.
  6. Click Buy Now.

    If Kerberos authentication is enabled, check whether this function is required. If it is, click Continue. If not, click Back to disable it and then proceed with the subsequent step. The slider status cannot be changed once the cluster is bought.

    For any doubt about the pricing, click Pricing details in the lower left corner.

  7. Click Back to Cluster List to view the cluster status. Click Access Cluster to view cluster details.

    For details about cluster status during creation, see the description of the status parameters in Table 1.

    It takes some time to create a cluster. The initial status of the cluster is Starting. After the cluster has been created successfully, the cluster status becomes Running.

    On the MRS management console, a maximum of 10 clusters can be concurrently created, and a maximum of 100 clusters can be managed.