Quick Creation of a ClickHouse Cluster

Updated on 2024-10-11 GMT+08:00

View PDF

This section describes how to quickly create a ClickHouse cluster. ClickHouse is a columnar database management system used for online analysis. It features the 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.2.0-LTS.1: ClickHouse 22.3.2.2 and ZooKeeper 3.6.3.

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

Quick Creation of a ClickHouse Cluster

Log in to the MRS console.
Click Create Cluster. The page for creating a cluster is displayed.
Click the Quick Config tab.
Configure basic cluster information. For details about the parameters, see Creating a Custom Cluster.
- Region: Use the default value.
- 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.
- 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.
- 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.
- CPU Architecture: Use the default value. This parameter is available in MRS 3.2.0-LTS.1 or later.
- 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.
- Cluster HA: Use the default value. This parameter is not available in MRS 3.x.
- Kerberos Authentication: Select whether to enable Kerberos authentication.
- 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. User root is supported in MRS 3.2.0-LTS.1 or later.
- Password: Set a password for user root/admin.
- Confirm Password: Enter the password of user root/admin again.
- Key Pair: Select a key pair from the drop-down list to log in to an ECS. Select "I acknowledge that I have obtained private key file SSHkey-xxx and that without this file I will not be able to log in to my ECS." If you have never created a key pair, click View Key Pair to create or import a key pair. And then, obtain a private key file. This parameter is available in MRS 3.1.2-LTS.3 orearlier.
Select Enable to enable secure communications. For details, see Communication Security Authorization.
Click Apply Now.

If Kerberos authentication is enabled for a cluster, check whether Kerberos authentication is required. If yes, click Continue. If no, click Back to disable Kerberos authentication and then create a cluster.
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.