ClickHouse Billing Examples

Updated on 2024-05-13 GMT+08:00

View PDF

A user purchased a pay-per-use ClickHouse cluster on March 18, 2023, 15:00:00 and used the cluster for one hour. After 0.5 hour, the user changed the specifications of the ClickHouse node from 4 vCPUs and 16 GB memory to 8 vCPUs and 32 GB memory. The user changed the cluster to yearly/monthly on March 18, 2023, 15:59:59 for a long-term use. The validity period was one month, and the cluster expired at 23:59:59 on April 18, 2023. This section shows how to count the total fee for using this cluster. Suppose the cluster specifications are as follows:

Compute node specifications
- Compute: 8U32G
- Storage: High I/O and 500 GB/Node
- Nodes: 2
ZooKeeper node specifications
- Compute: 4U16G
- Storage: Ultra-high I/O and 100 GB/Node
- Nodes: 3 (This is a default value and cannot be changed.)

Billing Analysis

Based on this example, you can calculate the consumption before and after the specification change.

**Table 1** Billing change details
Billing Mode	Formula	Billing Cycle	Price
Pay-per-use billing (before specification change)	Compute unit fee: Unit price of a compute unit x Number of nodes	Hourly fee	Compute nodes: 0.7072 (Unit price of a compute unit: USD/hour) x 2 (Node quantity) x 1 (Usage duration: hour) = $1.4144 USD ZooKeeper nodes: 0.3536 (Unit price of a compute unit: USD/hour) x 3 (Node quantity) x 1 (Usage duration: hour) = $1.0608 USD
	Disk fee: Disk unit price x Capacity x Number of nodes		Compute nodes: 0.0001 (Unit price of a disk: USD/hour) x 500 (Disk capacity: GB) x 2 (Node quantity) x 0.5 (Usage duration: hour) = $0.05 USD ZooKeeper node disk fee: 0
	Disk fee: Disk unit price x Capacity x Number of nodes		Total fee: $2.5252 USD
Pay-per-use billing (after specification change)	Compute unit fee: Unit price of a compute unit x Number of nodes	Hourly fee	Compute nodes: 0.7072 (Unit price of a compute unit: USD/hour) x 2 (Node quantity) x 1 (Usage duration: hour) = $1.4144 USD ZooKeeper nodes: 0.7072 (Unit price of a compute unit: USD/hour) x 3 (Node quantity) x 1 (Usage duration: hour) = $2.1216 USD
	Disk fee: Disk unit price x Capacity x Number of nodes		Compute nodes: 0.0001 (Unit price of a disk: USD/hour) x 500 (Disk capacity: GB) x 2 (Node quantity) x 1 (Usage duration: hour) = $0.10 USD ZooKeeper node disk fee: 0
	Disk fee: Disk unit price x Capacity x Number of nodes		Total price: $3.636 USD
Yearly/Monthly billing	Compute unit fee: Unit price of a compute unit x Number of nodes	Monthly fee	Compute nodes: $336.32 (Unit price of a compute unit: USD/month) x 2 (Node quantity) = $672.64 USD ZooKeeper nodes: 336.32 (CU unit price: ¥/month) x 3 (nodes) = $1008.96 USD
	Disk fee: Disk unit price x Capacity x Number of nodes		Compute nodes: 0.05 (Unit price of a disk: USD/hour) x 500 (Disk capacity: GB) x 2 (Node quantity) = $50 USD ZooKeeper node disk fee: 0
	Total		Total fee: $1731.60 USD

NOTE:

ClickHouse clusters are charged by hour. The smallest billing unit for compute unit usage is one hour, and partial hours are counted as full hours.
Periodic Settlement of Pay-per-Use Products:
- Settlement by hour: Huawei Cloud calculates the fee based on your usage every hour and deducts the fee from your account. For example, fees incurred from 8:00 to 9:00 are usually deducted before 10:00.
- Settlement by month: Huawei Cloud calculates the fee based on your usage and deducts the fee of the month at the beginning of the next month. For example, fees incurred from 00:00:00 on April 1, 2019 to 23:59:59 on April 30, 2019 are usually deducted at about 01:00:00 on May 1, 2019.

From March to April, the total fee of the ClickHouse cluster is $1735.236 USD (3.636+17.31.60).

Parent topic: Billing Examples

Previous topic: HBase Billing Examples

Next topic: Billing Mode Change