Create an ApsaraDB for ClickHouse cluster - ApsaraDB for ClickHouse

This topic describes how to create an ApsaraDB for ClickHouse cluster.

Prerequisites

An Alibaba Cloud account is created. If no Alibaba Cloud account is created, create one.
The AliyunClickHouseFullAccess permission is granted to the Resource Access Management (RAM) user that you use to create an ApsaraDB for ClickHouse cluster. For more information about how to grant permissions, see Grant permissions to RAM users.
Application Real-Time Monitoring Service (ARMS) is activated before you create an ApsaraDB for ClickHouse cluster. For more information, see Activate ARMS.

Procedure

Log on to the ApsaraDB for ClickHouse console.
On the Clusters page, click the Default Instances tab and click Create Cluster.

On the buy page, specify Billing Method.

Billing method	Use scenario
Subscription	The subscription billing method is a payment plan in which you pay a subscription fee when you purchase an ApsaraDB for ClickHouse cluster. For long-term usage, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You are charged lower prices for longer subscription durations.
Pay-as-you-go	The pay-as-you-go billing method is a payment plan in which the system generates a bill each hour and deducts the fee from the balance of your Alibaba Cloud account based on the cluster specifications. This billing method is cost-effective for business scenarios that require access to resources for short periods of time, such as testing. You can release an ApsaraDB for ClickHouse cluster based on your business requirements to save costs. When you can estimate the amount of resources that you need each month or each year, you can change the billing method from pay-as-you-go to subscription.

Set the following parameters of an ApsaraDB for ClickHouse cluster as prompted.

Parameter	Description	Example
Region and Zone	The region and zone where you want to create an ApsaraDB for ClickHouse cluster. After the cluster is created, the region and zone cannot be changed. To achieve fast access, we recommend that you select a region and zone that are nearest to the location of your business.	Asia Pacific, Singapore, Singapore Zone C
Network Type	Only a virtual private cloud (VPC) is supported. A VPC is an isolated network environment that provides enhanced security.	VPC
VPC	The VPC in which you want to create an ApsaraDB for ClickHouse cluster. If no VPC is available, go to the VPC console to create a VPC.	vpc-bp175iuvg8nxqraf2****
VSwitch	The vSwitch in the specified VPC. If no vSwitch is available, go to the VPC console to create a vSwitch.	vsw-bp1gzt31twhlo0sa5****
Kernel Version	The version released by the open source community.	21.8
Edition	Single-replica Edition: For ApsaraDB for ClickHouse Single-replica Edition, a shard has only one replica. If the replica fails, the entire cluster becomes unavailable. The cluster can provide stable services only after the replica is recovered. Double-replica Edition: For ApsaraDB for ClickHouse Double-replica Edition, a shard has two replicas. If a replica in the shard fails, the other replica in the shard can take over services from the failed replica. Note The number of resources that are required by an ApsaraDB for ClickHouse cluster of Double-replica Edition is twice the number of resources that are required by an ApsaraDB for ClickHouse cluster of Single-replica Edition. An ApsaraDB for ClickHouse cluster of Double-replica Edition costs twice as much as an ApsaraDB for ClickHouse cluster of Single-replica Edition. With highly reliable disks, even ApsaraDB for ClickHouse clusters of Single-replica Edition can help prevent data loss.	Double-replica Edition
Specification	The CPU and memory of a single node.	8 Cores, 32 GB
Nodes	The number of nodes.	1
Storage Type	The type of disks. You can select the following types based on the use scenarios: Enhanced SSD (ESSD) Large online transaction processing (OLTP) databases: relational databases, such as MySQL, PostgreSQL, Oracle, and SQL Server databases NoSQL databases: non-relational databases, such as MongoDB, HBase, and Cassandra databases Elasticsearch distributed logs: Elasticsearch, Logstash, and Kibana (ELK) log analysis Ultra disk Development and testing System disk	ESSD PL1 (Recommended)
Encryption Type	Specifies whether to enable disk encryption. After disk encryption is enabled, data disks are encrypted based on block storage, and cannot be decrypted even if backup data is leaked. For more information, see Disk encryption.	Disk Encryption
Service-linked Role	If you set Encryption Type to Disk Encryption, you must assign a service-linked role to the service. This way, the service can access other cloud services.	Created
Encryption Key	If you set Encryption Type to Disk Encryption, you must configure an encryption key. If no Key Management Service (KMS) key is available in the current region, go to the KMS console to create a KMS key.	0d2470df-da7b-4786-b981-9a164dae****
Storage Capacity	The storage capacity of a single node. Total storage capacity = Number of nodes × Storage capacity of a single node If the storage type is disk and the storage capacity is greater than 2,000 GB, the disk is divided into four disks, disk 0 to disk 3.	100GB
Subscription Period	If Billing Method is set to Subscription, you must specify the Subscription Period parameter.	1 Month
Auto-renewal	If Billing Method is set to Subscription, you can determine whether to select auto-renewal based on your business requirements. If you did not select Auto-renewal when you created the cluster, you can perform automatic or manual renewal in the Billing Management console. For more information, see Renewal.	Select Auto-renewal.

Note

When you create an ApsaraDB for ClickHouse cluster, you do not need to configure ZooKeeper specifications. After the cluster is created, 4 cores and 8 GB memory of ZooKeeper specifications are provided for free by default.

After the configuration is complete, click Buy Now and complete the payment as prompted.
Note
It takes 1 to 10 minutes to create an ApsaraDB for ClickHouse cluster. Refresh the page to view the cluster state. If the cluster state changes from Creating to Running, the cluster is created.

Pay for the orders in the cart

If you want to purchase a subscription cluster, you can also click Add to Cart to pay for the orders in the cart in a lump sum after you complete the parameter settings. You can perform the following steps to pay for the orders in the cart:

On the ApsaraDB for ClickHouse (Subscription) page, click the cart icon on the right side of the page.
In the Cart panel, select the orders for which you want to pay and click Proceed to Checkout.
On the Cart page, check whether the orders for which you want to pay are selected. If they are selected, click Buy Now.
Note
You can also specify Quantity and Subscription Cycle of ApsaraDB for ClickHouse.
On the Confirm Order page, read and agree to the Terms of Service and click Pay.
On the Purchase page, click Subscribe.

FAQ

Q: Why cannot I find the cluster after I create an ApsaraDB for ClickHouse cluster?

A: The following table describes the possible causes and solutions for the failure to find the cluster.

Possible cause	Description	Solution
The selected region is invalid.	The region that you selected in the ApsaraDB for ClickHouse console is not the region in which your cluster is deployed.	In the top navigation bar of the ApsaraDB for ClickHouse console, select the region in which your cluster is deployed.
Resources are insufficient in the zone that you selected.	The system may fail to create your cluster due to insufficient resources. In this case, your payment is refunded. You can check the refund on the Orders page.	After you confirm that the payment is refunded, you can try to create an ApsaraDB for ClickHouse cluster in another zone.

What to do next

Create an account