Managed Service for ClickHouse® pricing policy

In this section, you can find the Managed Service for ClickHouse® pricing policy and effective prices for its resources.

The prices for service products are also available in the price list.

All prices below do not include VAT.

Cluster statusCluster status

The prices apply differently depending on the cluster status:

• For a Running cluster, you pay for both the computing resources and the size of your storage and backups.
• For a Stopped cluster, you only pay for the size of your storage and backups.

What goes into the cost of using Managed Service for ClickHouse®What goes into the cost of using Managed Service for ClickHouse®

The Managed Service for ClickHouse® usage cost includes:

• Disk type and storage size.

• Computing resources allocated to cluster hosts (including ZooKeeper hosts).

• Settings and number of backups.

• Egress traffic from Yandex Cloud to the internet.

You are not charged for ingress traffic and requests to the hybrid storage.

In all calculations: 1 GB = 2³⁰ bytes, 1 MB = 2²⁰ bytes.

Database host usageDatabase host usage

The host operation cost is charged per hour based on what computing resources you allocate for it. You can find the supported resource configurations in the Host classes section. For the vCPU and RAM prices, see Prices for the Russia region.

You can choose a host class both for ClickHouse® and ZooKeeper hosts based on the expected replication load.

The minimum billing unit is one minute, e.g., 1.5 minutes of host operation cost the same as two minutes. You do not pay for the time when the DBMS or ZooKeeper host is unable to perform its main functions.

Disk space usageDisk space usage

You pay for the following:

• Storage allocated for database clusters.

  • You can only order local SSD storage (local-ssd) for clusters with three or more hosts:
    • For Intel Broadwell and Intel Cascade Lake: In increments of 100 GB.
    • For Intel Ice Lake: In increments of 368 GB.
  • Non-replicated SSD storage (network-ssd-nonreplicated) can only be ordered for clusters with three or more hosts, in increments of 93 GB.

• Size of data backups in local and network storage:

  • Backups are stored free of charge as long as the combined size of the database and all its backups is smaller than the selected storage size.

  • If the combined size of the database and all its backups exceeds the cluster storage size, you only pay for the portion in excess of the storage size.

  • When performing automatic backups, Managed Service for ClickHouse® does not create a new backup but saves the database changes introduced since the previous one. This means the storage space used by automatic backups increases only in proportion to the amount of changes.

  • The number of hosts in a cluster does not affect the storage size and, consequently, the amount of free backups.

  For example, if there are N free GB of space in the cluster, the first N GB of backups are stored free of charge.

• Size of cold data backups in a hybrid storage:

  • Cold data backups are stored in the same Object Storage bucket as the data itself.

  • The cost of using Object Storage includes both the space used by the backups and the space used by the data itself.

  • When performing automatic backups, Managed Service for ClickHouse® does not create a new backup but saves the database changes introduced since the previous one. This means the storage space used by automatic backups increases only in proportion to the amount of changes.

The price covers one month of use based on 720 hours per month. The minimum billing unit is 1 GB per minute; e.g., storing 1 GB for 1.5 minutes costs the same as for 2 minutes.

Example of cluster cost calculationExample of cluster cost calculation

Let's calculate the cost of using a cluster with the following properties for 30 days:

• ClickHouse® hosts: Three s3-c2-m8 hosts, Intel Ice Lake, 2 × 100% vCPU, 8 GB RAM.
• Storage for ClickHouse® hosts: 100 GB of network HDD storage per host.
• ZooKeeper hosts (created automatically): Three b3-c1-m4 hosts, Intel Ice Lake, 2 × 50% vCPU, 4 GB RAM.
• Storage for ZooKeeper hosts: 10 GB of network SSD storage per host.

Cost calculation for ClickHouse® hosts:

3 × (2 × $0.015480 + 8 × $0.004230) = $0.194400

Total: $0.194400, cost of operation of ClickHouse® hosts per hour.

Where:

• 3: Number of ClickHouse® hosts.
• 2: Number of vCPUs.
• $0.015480: Cost of using 100% vCPU per hour.
• 8: Amount of RAM per ClickHouse® host (in GB).
• $0.004230: Cost of using 1 GB of RAM at 100% vCPU per hour.

Calculating the cost of storage for ClickHouse® hosts:

3 × 100 × $0.028800 = $8.640000

Total: $8.640000, cost of using the cluster for 30 days.

Where:

• 3: Number of ClickHouse® hosts.
• 100: Amount of network HDD storage (in GB).
• $0.028800: Cost of using 1 GB of network HDD storage per month.

Cost calculation for ZooKeeper hosts:

3 × (2 × $0.006300 + 4 × $0.002520) = $0.068040

Total: $0.068040, cost of operation of ZooKeeper hosts per hour.

Where:

• 3: Number of ZooKeeper hosts.
• 2: Number of vCPUs.
• $0.006300: Cost of using 50% vCPU per hour.
• 4: Amount of RAM per ZooKeeper host (in GB).
• $0.002520: Cost of using 1 GB of RAM at 50% vCPU per hour.

Calculating the cost of storage for ZooKeeper hosts:

3 × 10 × $0.117090 = $3.512700

Total: $3.512700, cost of storage for ZooKeeper hosts.

Where:

• 3: Number of ZooKeeper hosts.
• 10: Amount of SSD network storage (in GB).
• $0.117090: Cost of using 1 GB of network SSD storage per month.

Total cost calculation:

720 × ($0.194400 + $0.068040) + $8.640000 + $3.512700 = $201.109500

Total: $201.109500, cost of using the cluster for 30 days.

Where:

• 720: Number of hours in 30 days.
• $0.194400, cost of operation of ClickHouse® hosts per hour.
• $0.068040, cost of operation of ZooKeeper hosts per hour.
• $8.640000, cost of storage for ClickHouse® hosts.
• $3.512700: Cost of storage for ZooKeeper hosts.

Discount for committed volume of services (CVoS)Discount for committed volume of services (CVoS)

You can get a guaranteed discount on service resource usage when you plan for 6 or 12 months ahead. To view the resources eligible for this discount:

1. Navigate to Yandex Cloud Billing.
2. Click the billing account.
3. Select Committed volume in the left-hand menu.

A CVoS guarantees a discount on usage, but does not guarantee the availability of the resources you order. You can read more about CVoS in the relevant Yandex Cloud Billing article.

Managed Service for ClickHouse® provides two types of CVoS: on vCPUs and on RAM for the hosts you are going to use in your database clusters. In the management console, you can see how much you can potentially save with CVoS at the current consumption level. You can also estimate your monthly payments for the required number of vCPUs and RAM.

Prices for the Russia regionPrices for the Russia region

The monthly prices are based on 720 hours per month.

You cannot order ZooKeeper host resources via CVoS.

Outgoing trafficOutgoing traffic

When using the service, you pay for traffic from Yandex Cloud to the internet. Traffic between internal IP addresses of Yandex Cloud services and incoming internet traffic is free.

The first 100 GB of outgoing traffic per month are free of charge.

The minimum billing unit is 1 MB.