Managed Service for ClickHouse® pricing
In this section, you can find Managed Service for ClickHouse® pricing rules and effective prices for the service's resources.
To calculate the cost of using the service, use the calculator on the Yandex Cloud website or see the prices in this section.
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).
- 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
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.
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 is included in the Managed Service for ClickHouse® cost
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 = 230 bytes.
DB host usage
The cost is calculated for each hour of operation of the host in accordance with the allocated computing resources. Supported resource configurations are shown in the Host classes section, while prices for using vCPUs and RAM are quoted in the Prices section.
You can choose 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 a minute (for example, 1.5 minutes of host usage cost the same as 2 minutes). You are not charged 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. -
The size of local and network storage used for data backups:
-
Backups are stored free of charge as long as the combined size of the database and all 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.
-
During an automatic backup, Managed Service for ClickHouse® does not create a new copy but saves changes to the database compared to the previous copy. This means that storage used by automatic backups increases only in proportion to the volume of changes that are made.
-
The number of hosts in the cluster does not affect the size of the storage and, consequently, 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.
-
-
The storage size used by cold data backups of a hybrid storage:
-
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.
-
During an automatic backup, Managed Service for ClickHouse® does not create a new copy but saves changes to the database compared to the previous copy. This means that storage used by automatic backups increases only in proportion to the volume of changes that are made.
-
The cost is specified for one month of use and is 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 calculation
The cost of using a cluster with the following parameters for 30 days:
- ClickHouse® hosts: 3
s3-c2-m8
hosts: Intel Ice Lake, 2 × 100% vCPU, 8 GB RAM. - ZooKeeper hosts (created automatically): 3
b3-c1-m4
hosts: Intel Ice Lake, 2 × 50% vCPU, 4 GB RAM. - Storage: 100 GB of HDD network storage.
Cost calculation for ClickHouse® hosts:
3 × (2 × $0.013760 + 8 × $0.003760) = $0.172800
Total: $0.172800 is the cost per hour of ClickHouse® host operation.
Where:
- 3 is the number of ClickHouse® hosts.
- 2 is the number of vCPUs.
- $0.013760 is the cost per hour of 100% vCPU utilization.
- 8 is the amount of RAM per ClickHouse® host (in GB).
- $0.003760 is the cost per hour of 1 GB RAM utilization on 100% vCPU.
Cost calculation for ZooKeeper hosts:
3 × (2 × $0.005600 + 4 × $0.002240) = $0.060480
Total: $0.060480 is the cost per hour of ZooKeeper host operation.
Where:
- 3 is the number of ZooKeeper hosts.
- 2 is the number of vCPUs.
- $0.005600 is the cost per hour of 50% vCPU utilization.
- 4 is the amount of RAM per ZooKeeper host (in GB).
- $0.002240 is the cost per hour of 1 GB RAM utilization on 50% vCPU.
Calculation for the storage cost and total cost:
720 × ($0.172800 + $0.060480) + 100 × $0.025600 = $170.521600
Total: $170.521600 is the cost of using the cluster for 30 days.
Where:
- 720: Number of hours in 30 days.
- $0.172800: Cost per hour of ClickHouse® host operation.
- $0.060480: Cost per hour of ZooKeeper host operation.
- 100: Amount of HDD network storage (in GB).
- $0.025600: Cost of using 1 GB of network HDD storage per month.
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 Billing
. - Click on the desired billing account.
- Choose Committed volume of services 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 kinds of CVoS: on vCPUs and RAM on the hosts you plan to use in DB clusters. In the management console, you can see potential savings from using a CVoS at the current resource usage. You can also forecast your monthly payments for the desired number of vCPUs and RAM.
Note
You can use a CVoS to order certain types of resources. For non-supported resources, CVoS columns feature dashes under Prices. Currently, you cannot order storage or web traffic this way.
Pricing
All prices are shown without VAT.
The monthly usage rate is based on 720 hours a month.
ClickHouse® host computing resources
Resource | Cost per hour | With CVoS for 6 months |
With CVoS for 1 year |
---|---|---|---|
Intel Broadwell | |||
5% vCPU | $0.000240 | − | − |
20% vCPU | $0.003280 | − | − |
50% vCPU | $0.005440 | − | − |
100% vCPU | $0.018240 | − | − |
RAM (for 1 GB) | $0.004160 | − | − |
Intel Cascade Lake | |||
5% vCPU | $0.000240 | − | − |
20% vCPU | $0.003280 | − | − |
50% vCPU | $0.005440 | − | − |
100% vCPU | $0.015360 | $0.013056 (-15%) | $0.011981 (-22%) |
RAM (for 1 GB) | $0.004160 | $0.003536 (-15%) | $0.003245 (-22%) |
Intel Ice Lake | |||
50% vCPU | $0.004880 | − | − |
100% vCPU | $0.013760 | $0.011696 (-15%) | $0.010733 (-22%) |
RAM (for 1 GB) | $0.003760 | $0.003196 (-15%) | $0.002933 (-22%) |
Resource | Cost per month | With CVoS for 6 months |
With CVoS for 1 year |
---|---|---|---|
Intel Broadwell | |||
5% vCPU | $0.172800 | − | − |
20% vCPU | $2.361600 | − | − |
50% vCPU | $3.916800 | − | − |
100% vCPU | $13.132800 | − | − |
RAM (for 1 GB) | $2.995200 | − | − |
Intel Cascade Lake | |||
5% vCPU | $0.172800 | − | − |
20% vCPU | $2.361600 | − | − |
50% vCPU | $3.916800 | − | − |
100% vCPU | $11.059200 | $9.400320 (-15%) | $8.626176 (-22%) |
RAM (for 1 GB) | $2.995200 | $2.545920 (-15%) | $2.336256 (-22%) |
Intel Ice Lake | |||
50% vCPU | $3.513600 | − | − |
100% vCPU | $9.907200 | $8.421120 (-15%) | $7.727616 (-22%) |
RAM (for 1 GB) | $2.707200 | $2.301120 (-15%) | $2.111616 (-22%) |
ZooKeeper host computing resources
Note
You can't order ZooKeeper host resources using a CVoS.
Resource | Cost per hour | Cost 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 |
Storage and backups
Note
When using standard hosts on Intel Ice Lake, access to local SSD storage (local-ssd
) is provided on request. Contact technical support
Service | Cost of 1 GB per month |
---|---|
Standard network storage | $0.025600 |
Non-replicated network storage | $0.070400 |
Fast network storage | $0.104080 |
Fast local storage | $0.104080 |
Hybrid cold data storage and backups | $0.016080 |
Local and network storage backups | $0.032594 |
Egress traffic
When using the service, you pay for traffic from Yandex Cloud to the internet. Traffic between Yandex Cloud services and incoming internet traffic are free of charge.
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 via NAT gateway, first 10 GB per month | Free |
Outgoing traffic via NAT gateway, over 10 GB per month | $0.012240 |
ClickHouse® is a registered trademark of ClickHouse, Inc