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.

To calculate the cost of using the service, use the calculator on the Yandex Cloud website or see the pricing in this section.

Cluster statusCluster status

Pricing is applied differently depending on the cluster status:

• For a Running cluster, you are charged both for the computing resources and the size of storage and backup.
• For a Stopped cluster, you are only charged for the storage and backup size.

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 is based on:

• Disk type and storage size.

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

• Settings and number of backups.

• Egress traffic from Yandex Cloud.

The incoming traffic and the number of requests to the hybrid storage are free-of-charge.

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

DB host usageDB host usage

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 vCPU and RAM prices, see Prices for the Russia region.

You can choose a host class both for ClickHouse® and ZooKeeper hosts (according to the expected replication load).

The minimum billing unit is one minute (for example, 1.5 minutes of host operation cost the same as 2 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 DB 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 (network-ssd-nonreplicated) storage can only be ordered for clusters with three or more hosts, in increments of 93 GB.

• Size of local and network storage data backups:

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

  • If the combined size of the database and all 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 copy but saves the data changed from the previous backup. It means the storage space used by automatic backups only increases in proportion to the volume of changes.

  • The number of hosts in a cluster does not affect the storage size and, consequently, the free volume of 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 hybrid storage cold data backups:

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

  • The cost of using Object Storage considers 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 copy but saves the data changed from the previous backup. It means the storage space used by automatic backups only increases in proportion to the volume of changes.

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

Example of cluster cost calculationExample of cluster cost calculation

The cost of using a cluster with the following parameters for 30 days:

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

Cost calculation for ClickHouse® hosts:

3 × (2 × $0.013760 + 8 × $0.003760) = $0.172800

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

Where:

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

Cost calculation for ZooKeeper hosts:

3 × (2 × $0.005600 + 4 × $0.002240) = 0.06048

Total: 0.06048, cost of operation of ZooKeeper hosts per hour.

Where:

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

Calculation for the storage cost and total cost:

720 × ($0.172800 + ₽0.0605) + 100 × $0.025600 = $170.521600

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

Where:

• 720: Number of hours in 30 days.
• $0.172800: Cost of operation of ClickHouse® hosts per hour.
• $0.060480: Cost of operation of ZooKeeper hosts per hour.
• 100: Amount of network HDD storage (in GB).
• $0.025600: Cost of using 1 GB of network HDD storage per month.

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

You can get a guaranteed discount on service resource usage when you plan for six months or one year ahead. To see the resources you can get a discount on:

1. Go to Billing.
2. Click on the desired billing account.
3. Choose Committed volume in the left-hand menu.

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

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

Prices for the Russia regionPrices for the Russia region

All prices below do not include VAT.

The monthly usage rate is based on 720 hours a month.

Computing resources of ClickHouse® hostsComputing resources of ClickHouse® hosts

Computing resources of ZooKeeper hostsComputing resources of ZooKeeper hosts

Resource	Price per hour	Price per month
Intel Broadwell
5% vCPU	$0.001920	$1.382400
20% vCPU	$0.004480	$3.225600
50% vCPU	$0.006240	$4.492800
100% vCPU	$0.011360	$8.179200
RAM (for 1 GB)	$0.002560	$1.843200
Intel Cascade Lake
5% vCPU	$0.001920	$1.382400
20% vCPU	$0.004480	$3.225600
50% vCPU	$0.006240	$4.492800
100% vCPU	$0.009680	$6.969600
RAM (for 1 GB)	$0.002560	$1.843200
Intel Ice Lake
50% vCPU	$0.005600	$4.032000
100% vCPU	$0.008720	$6.278400
RAM (for 1 GB)	$0.002240	$1.612800
Intel Ice Lake (Compute Optimized)
100% vCPU	$0.013920	$10.022400
RAM (for 1 GB)	$0.002560	$1.843200

Storage and backupsStorage and backups

Service	Price of 1 GB per month
Network HDD storage	$0.025600
Non-replicated SSD storage	$0.070400
Network SSD storage	$0.104080
High-performance SSD storage	$0.174240
Local SSD storage	$0.104080
Hybrid cold data storage and backups	$0.016080
Backups beyond the storage size	$0.015360

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 are provided free of charge every month.

The minimum billing unit is 1 MB.

Resource category	Cost of 1 GB
Outgoing traffic, 100 GB or less per month	Free
Outgoing traffic, over 100 GB per month	$0.012240