All Products
Search
Document Center

ApsaraDB for ClickHouse:Create an ApsaraDB for ClickHouse cluster

Last Updated:Sep 19, 2024

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

Prerequisites

Usage notes

  • By default, a Classic Load Balancer (CLB) instance is mounted to an ApsaraDB for ClickHouse cluster created after December 1, 2021. You are charged for the CLB instance. For more information about the billing, see Billing details about relevant services. If you do not need a CLB instance, release the CLB instance. For more information, see Release and mount a CLB instance.

Procedure

Create an ApsaraDB for ClickHouse Community-compatible Edition cluster

  1. Log on to the ApsaraDB for ClickHouse console.

  2. On the Clusters page, click the Clusters of Community-compatible Edition tab, and then click Create Cluster.

  3. On the buy page, select a product type.

    Product Type

    Scenario

    Community-compatible Edition Subscription

    Create a Community-compatible Edition cluster that uses the subscription billing method.

    The subscription billing method allows you to use resources only after you pay for them. You complete the payment when you purchase a cluster. For long-term usage, this billing method is more cost-effective than the pay-as-you-go billing method. You are charged lower prices for longer subscription periods.

    Enterprise Edition Serverless & Community-compatible Edition Pay-as-you-go

    Create a Community-compatible Edition cluster or an Enterprise Edition cluster that uses the pay-as-you-go billing method.

    The pay-as-you-go billing method allows you to use resources before you pay for them. The system generates a bill per 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 a 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.

  4. Configure the following parameters as prompted.

    Note

    When you create an ApsaraDB for ClickHouse Community-compatible Edition 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.

    Parameter

    Description

    Example

    Region

    Select the region where you want to create a cluster.

    After the cluster is created, the region cannot be changed. To achieve fast access, we recommend that you select a region that is nearest to the location of your business.

    Asia Pacific, Singapore

    Cluster Type

    Select a cluster type.

    In this example, Community-compatible Edition is selected.

    Community-compatible Edition

    Deployment Method

    Single-zone: Disaster recovery across data centers is not supported.

    Multi-zone: Zone-disaster recovery is supported to implement high availability.

    Note
    • Community-compatible Edition integrates storage and computing. Multi-zone deployment requires two replicas. The computing and storage costs are twice that of a single replica.

    • Enterprise Edition uses the cloud-native architecture and decoupled computing and storage resources. Multi-zone deployment does not generate additional computing and storage costs.

    Single-zone

    Network Type

    Select a network type. Only the network type of virtual private cloud (VPC) is supported. A VPC is an isolated network environment that provides enhanced security.

    VPC

    Primary Zone

    Select a zone. A zone is a geographically isolated location within a region. Each zone has its own independent power supply and network. No substantive differences exist between zones in the same region.

    Note

    If you use the multi-zone deployment mode, you must configure the Secondary Zone and Secondary Zone 2 parameters. The secondary zones must be different from the primary zone.

    Hangzhou Zone H

    VPC

    Select the VPC in which you want to create the cluster. If no VPC is available, go to the VPC console to create a VPC.

    vpc-bp175iuvg8nxqraf2****

    vSwitch in Primary VPC

    Select a 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.

    23.8

    Edition

    • 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: 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. For more information, see Block storage performance.

    • Enterprise 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

    Specify 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.

    100 GB

    Subscription Period

    If the billing method is subscription, you must specify a subscription duration.

    1 Month

    Auto-renewal

    If the billing method is 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 Expenses and Costs console. For more information, see Renewal.

    Select Auto-renewal

    Resource Group

    Select the resource group to which the cluster belongs. You can use resource groups to manage resources within your Alibaba Cloud account by category and group. You can manage permissions, deploy resources, and monitor resources based on groups without the need to separately process each resource.

    Default Resource Group

  5. 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.

Create an ApsaraDB for ClickHouse Enterprise Edition cluster

  1. Log on to the ApsaraDB for ClickHouse console.

  2. On the Clusters page, click the Enterprise Edition Clusters tab, and then click Create Cluster.

  3. On the buy page, set Product Type to Enterprise Edition Serverless & Community-compatible Edition Pay-as-you-go.

  4. Configure the following parameters as prompted.

    Parameter

    Description

    Example

    Region

    Select the region where you want to create a cluster. After the cluster is created, the region cannot be changed. To achieve fast access, we recommend that you select a region that is nearest to the location of your business. For more information about the regions that support Enterprise Edition clusters, see Pay-as-you-go billing for ApsaraDB for ClickHouse Enterprise Edition.

    China, China (Hangzhou)

    Cluster Type

    Select a cluster type.

    In this example, Enterprise is selected.

    Important

    If the Enterprise option is not available in the console, you must submit a ticket to check whether the region where your enterprise resides supports ApsaraDB for ClickHouse Enterprise Edition.

    • If the region where your enterprise resides supports ApsaraDB for ClickHouse Enterprise Edition, we will add your user ID to the whitelist of Enterprise Edition to enable this option.

    • If the region where your enterprise resides does not support ApsaraDB for ClickHouse Enterprise Edition, you cannot create an Enterprise Edition cluster.

    Enterprise

    Deployment Method

    Single-zone: Disaster recovery across data centers is not supported.

    Multi-zone: Zone-disaster recovery is supported to implement high availability.

    Note
    • Community-compatible Edition integrates storage and computing. Multi-zone deployment requires two replicas. The computing and storage costs are twice that of a single replica.

    • Enterprise Edition uses the cloud-native architecture and decoupled computing and storage resources. Multi-zone deployment does not generate additional computing and storage costs.

    Single-zone

    Network Type

    Select a network type. Only the network type of VPC is supported. A VPC is an isolated network environment that provides enhanced security.

    VPC

    VPC

    Select the VPC in which you want to create the cluster. If no VPC is available, go to the VPC console to create a VPC.

    vpc-bp175iuvg8nxqraf2****

    Primary Zone

    Select a zone. A zone is a geographically isolated location within a region. Each zone has its own independent power supply and network. No substantive differences exist between zones in the same region.

    Note

    If you use the multi-zone deployment mode, you must configure the Secondary Zone and Secondary Zone 2 parameters. The secondary zones must be different from the primary zone.

    Hangzhou Zone H

    vSwitch in Primary VPC

    Select a vSwitch in the specified VPC. If no vSwitch is available, go to the VPC console to create a vSwitch.

    Note

    If you use the multi-zone deployment mode, you must configure the vSwitch for Secondary VPC and vSwitch for Secondary VPC 2 parameters. The vSwitches for secondary zones must be different from the vSwitch for the primary zone.

    vsw-bp1gzt31twhlo0sa5****

    Sample Test Data

    Select the sample test data that you want to import. Valid values: Do Not Import Sample Data, UK Prorperty Price Paid, NewYorkTaxi, and cell tower. By default, Do Not Import Sample Data is selected.

    Do Not Import Sample Data

    Maximum CCUs

    The maximum number of ClickHouse Compute Units (CCUs). 1 CCU is equal to 1 CPU core and 4 GiB of memory. The automatic scaling of computing resources is implemented by increasing or reducing the number of CCUs. The computing resources after scale-down cannot be smaller than the configured minimum number of CCUs.

    8

    Minimum CCUs

    The minimum number of CCUs.

    Note
    • If the value of Maximum CCUs is set to 8, the value of Minimum CCUs is fixed to 8.

    • If the value of Maximum CCUs is greater than 8, the value of Minimum CCUs ranges from 8 to the value specified by Maximum CCUs. You can select a value based on your business requirements.

    8

  5. 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:

  1. On the ApsaraDB for ClickHouse Subscription page, click the cart icon on the right side of the page.

  2. In the Cart panel, select the orders for which you want to pay and click Proceed to Checkout.

  3. On the Cart page, check whether the orders for which you want to pay are selected, and then click Buy Now.

    Note

    You can also specify Quantity and Subscription Cycle of the ApsaraDB for ClickHouse cluster.

  4. On the Confirm Order page, read and agree to Terms of Service and click Pay.

  5. On the Purchase page, click Subscribe.

FAQ

Q: Why am I unable to find the destination 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 incorrect.

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.

The clicked tab is incorrect.

The tab that you clicked in the ApsaraDB for ClickHouse console is not the tab to which your cluster belongs.

In the ApsaraDB for ClickHouse console, click the tab to which your cluster belongs.

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