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.
Tip
To calculate the cost of using the service, use our calculator on the Yandex Cloud website or check out the pricing below.
Prices for service products are also available in the price list.
Note
Currency of Service rates (prices) depends on the company you made a contract with:
- Prices in US dollars are applicable to customers of Iron Hive doo Beograd (Serbia) or Direct Cursus Technology L.L.C. (Dubai).
- Prices in Russian roubles are applicable to customers of Yandex.Cloud LLC.
Cluster status
Pricing is applied differently depending on the cluster status:
- For a
Runningcluster, you are charged both for the computing resources and the size of storage and backup. - For a
Stoppedcluster, you are only charged for the storage and backup size.
Alert
If a cluster uses local SSD storage (local-ssd), its computing resources are not released when it's stopped. This means that you are charged in full even for a stopped cluster.
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.
The incoming traffic and the number of requests to the hybrid storage are free-of-charge.
In all calculations: 1 GB = 230 bytes, 1 MB = 220 bytes.
DB 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 the 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).
Warning
In clusters with disabled ClickHouse® Keeper support and with two or more ClickHouse® hosts, 3 ZooKeeper hosts with the minimal class are automatically created to provide replication and fault tolerance.
The minimum billing unit is one minute (for example, 90 seconds of host operation cost is 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 usage
You are charged 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.
- You can only order local SSD storage (
-
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 backup but saves the DB changes since the previous one. It means the storage space used by automatic backups only increases in proportion to the amount of changed data.
-
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 backup but saves the DB changes since the previous one. It means the storage space used by automatic backups only increases in proportion to the amount of changed data.
-
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 90 seconds costs the same as storing 1 GB for two minutes).
Example of cluster cost calculation
This is an example of calculating the cost of using a cluster with the following properties for 30 days:
- ClickHouse® hosts: Three hosts of the
s3-c2-m8class: 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-m4hosts: 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 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:
- Go to Yandex Cloud Billing.
- Click on the desired billing account.
- Select Committed volume in the left-hand menu.
A CVoS guarantees a discount on consumption but does not guarantee the availability of the resources you order. 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.
Note
CVoS discount is only available for certain types of resources. A dash in the relevant CVoS columns under Prices for the Russia region means the resource is not supported. Currently, you cannot order storage or web traffic this way.
Prices for the Russia region
Note
Prices for Yandex Cloud resources vary based on the region. For more information about the available regions, see Regions.
The currency you can use to pay for the resources depends on which legal entity you entered into agreement with. For more information on creating an account, see Registering an account in Yandex Cloud.
All prices below do not include VAT.
The monthly usage rate is based on 720 hours a month.
ClickHouse® host computing resources
Note
Access to the Intel Ice Lake (Compute Optimized) platform is available upon request. Contact support or your account manager.
| Resource | Price per hour, without VAT |
With CVoS for 6 months, without VAT |
With CVoS for 1 year, without VAT |
|---|---|---|---|
| Intel Broadwell | |||
| 5% vCPU | $0.000258 | − | − |
| 20% vCPU | $0.003519 | − | − |
| 50% vCPU | $0.005837 | − | − |
| 100% vCPU | $0.019570 | − | − |
| RAM (for 1 GB) | $0.004463 | − | − |
| Intel Cascade Lake | |||
| 5% vCPU | $0.000270 | − | − |
| 20% vCPU | $0.003690 | − | − |
| 50% vCPU | $0.006120 | − | − |
| 100% vCPU | $0.017280 | $0.014688 (-15%) | $0.013478 (-22%) |
| RAM (for 1 GB) | $0.004680 | $0.003978 (-15%) | $0.003650 (-22%) |
| Intel Ice Lake | |||
| 50% vCPU | $0.005490 | − | − |
| 100% vCPU | $0.015480 | $0.013158 (-15%) | $0.012074 (-22%) |
| RAM (for 1 GB) | $0.004230 | $0.003595 (-15%) | $0.003299 (-22%) |
| Intel Ice Lake (Compute Optimized) | |||
| 100% vCPU | $0.024750 | − | − |
| RAM (for 1 GB) | $0.004860 | − | − |
| Resource | Price per month, without VAT |
With CVoS for 6 months, without VAT |
With CVoS for 1 year, without VAT |
|---|---|---|---|
| Intel Broadwell | |||
| 5% vCPU | $0.185400 | − | − |
| 20% vCPU | $2.533799 | − | − |
| 50% vCPU | $4.202398 | − | − |
| 100% vCPU | $14.090394 | − | − |
| RAM (for 1 GB) | $3.213599 | − | − |
| Intel Cascade Lake | |||
| 5% vCPU | $0.194400 | − | − |
| 20% vCPU | $2.656799 | − | − |
| 50% vCPU | $4.406399 | − | − |
| 100% vCPU | $12.441595 | $10.575356 (-15%) | $9.704444 (-22%) |
| RAM (for 1 GB) | $3.369599 | $2.864159 (-15%) | $2.628287 (-22%) |
| Intel Ice Lake | |||
| 50% vCPU | $3.952799 | − | − |
| 100% vCPU | $11.145596 | $9.473756 (-15%) | $8.693564 (-22%) |
| RAM (for 1 GB) | $3.045599 | $2.588759 (-15%) | $2.375567 (-22%) |
| Intel Ice Lake (Compute Optimized) | |||
| 100% vCPU | $17.819993 | − | − |
| RAM (for 1 GB) | $3.499199 | − | − |
ZooKeeper host computing resources
Note
Access to the Intel Ice Lake (Compute Optimized) platform is available upon request. Contact support or your account manager.
Note
You cannot order ZooKeeper host resources via CVoS.
| Resource | Price per hour, without VAT |
Price per month, without VAT |
|---|---|---|
| Intel Broadwell | ||
| 5% vCPU | $0.002060 | $1.483199 |
| 20% vCPU | $0.004807 | $3.460799 |
| 50% vCPU | $0.006695 | $4.820398 |
| 100% vCPU | $0.012188 | $8.775596 |
| RAM (for 1 GB) | $0.002747 | $1.977600 |
| Intel Cascade Lake | ||
| 5% vCPU | $0.002160 | $1.555199 |
| 20% vCPU | $0.005040 | $3.628799 |
| 50% vCPU | $0.007020 | $5.054398 |
| 100% vCPU | $0.010890 | $7.840797 |
| RAM (for 1 GB) | $0.002880 | $2.073599 |
| Intel Ice Lake | ||
| 50% vCPU | $0.006300 | $4.535998 |
| 100% vCPU | $0.009810 | $7.063197 |
| RAM (for 1 GB) | $0.002520 | $1.814399 |
| Intel Ice Lake (Compute Optimized) | ||
| 100% vCPU | $0.015660 | $11.275196 |
| RAM (for 1 GB) | $0.002880 | $2.073599 |
Storage and backups
Note
Access to the following storage types is provided on request:
- Ultra high-speed network storage with three replicas (SSD).
- Local SSD storage when using standard hosts based on Intel Ice Lake.
Contact support or your account manager.
| Service | Price of 1 GB per month, without VAT |
|---|---|
| Network HDD storage | $0.028800 |
| Non-replicated SSD storage | $0.079200 |
| Network SSD storage | $0.117090 |
| High-performance SSD storage | $0.196020 |
| Local SSD storage | $0.117090 |
| Hybrid cold data storage and backups | $0.018090 |
| Backups beyond the storage size | $0.017280 |
Outbound 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.
| Resource category | Price of 1 GB, without VAT |
|---|---|
| Outgoing traffic, 100 GB or less per month | Free |
| Outgoing traffic, over 100 GB per month | $0.013770 |