Pricing for Managed Service for ClickHouse

Note

Currency of Service rates (prices) depends on the company you made a contract with:

  • prices in US dollars are applicable to customers of Yandex Services AG,
  • 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 a local 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 cost of Managed Service for ClickHouse usage is based on:

  • Storage type and size (disk space).

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

  • Settings and number of backups.

  • Volume of outgoing traffic from Yandex.Cloud to the internet.

In all calculations, 1 GB = 230 bytes.

Use of DB hosts

The cost is calculated for each hour of operation of the host in accordance with the allocated computing resources. Supported resource configurations are listed in the Host classes section, prices for using vCPU and RAM — in the Prices section.

You can choose the host class for ClickHouse and ZooKeeper hosts (as appropriate for the expected replication load).

Warning

When you create a cluster with 2 or more ClickHouse hosts, 3 ZooKeeper hosts with the minimal host class are created automatically to provide replication and fault tolerance for the cluster.

The minimum billing unit is one hour (for example, the cost of 1.5 hours of operation is the same as the cost of 2 hours of operation). You aren't charged for time when the DBMS or ZooKeeper host isn't performing its main functions.

Disk space usage

The following is charged:

  • Storage allocated for DB clusters.

    • Storage on fast local disks (local-ssd) can only be ordered for clusters with more than 2 hosts in 100 GB increments.
  • Space used by DB backups in excess of the storage specified for the cluster.

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

    • During an automatic backup, Managed Service for ClickHouse doesn't 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, that of free backups.

The cost is specified for one month of use. The minimum billing unit is 1 GB per hour (for example, the cost of storing 1 GB for 1.5 hours is equal to the cost of storage for 2 hours).

Example of cluster cost calculation

For example, you created a cluster:

  • with 3 ClickHouse hosts with the host class s1.micro (2 vCPU, 8 GB RAM),
  • with 3 automatically created ZooKeeper hosts with the class s1.nano (1 vCPU, 4 GB RAM),
  • with 100 GB of standard network storage.

Cost per hour for all hosts: 3 × (2 × ₽1.43 + 8 × ₽0.33) + 3 × (1 × ₽0.89 + 4 × ₽0,2) = ₽21.57

The total cost of the cluster in the month (hosts and storage): 720 × ₽21.57 + 100 × ₽2.2881 = ₽15,759.21

Discount for committed volumes of services (CVoS)

You can get a guaranteed discount on Yandex.Cloud resource usage when you plan for one or three years ahead. To see the resources you can get a discount on:

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

A CVoS guarantees a discount on usage, but doesn't guarantee the availability of the resources ordered. Read more about CVoS in the 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 pre-estimate 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 contain dashes under Prices. You currently can't order storage or web traffic this way.

Pricing

Host computing resources ClickHouse

Resource Rate for 1 hour With CVoS for 1 year With CVoS for 3 years
Intel Broadwell
5% vCPU $0.000256 - -
20% vCPU $0.003333 - -
50% vCPU $0.005513 - -
100% vCPU $0.018333 - -
RAM (for 1 GB) $0.004231 - -
Intel Cascade Lake
5% vCPU $0.000256 - -
20% vCPU $0.003333 - -
50% vCPU $0.005513 - -
100% vCPU $0.015385 $0.011282 $0.008718
RAM (for 1 GB) $0.004231 $0.002692 $0.002051
Resource Rate for 1 hour With CVoS for 1 year With CVoS for 3 years
Intel Broadwell
5% vCPU ₽0.02 - -
20% vCPU ₽0.26 - -
50% vCPU ₽0.43 - -
100% vCPU ₽1.43 - -
RAM (for 1 GB) ₽0.33 - -
Intel Cascade Lake
5% vCPU ₽0.02 - -
20% vCPU ₽0.26 - -
50% vCPU ₽0.43 - -
100% vCPU ₽1.20 ₽0.88 ₽0.68
RAM (for 1 GB) ₽0.33 ₽0.21 ₽0.16

Host computing resources ZooKeeper

Note

You can't order ZooKeeper resources with CVoS discounts.

Resource Rate for 1 hour
Intel Broadwell
5% vCPU $0.001923
20% vCPU $0.004487
50% vCPU $0.006282
100% vCPU $0.011410
RAM (for 1 GB) $0.002564
Intel Cascade Lake
5% vCPU $0.001923
20% vCPU $0.004487
50% vCPU $0.006282
100% vCPU $0.009744
RAM (for 1 GB) $0.002564
Resource Rate for 1 hour
Intel Broadwell
5% vCPU ₽0.15
20% vCPU ₽0.35
50% vCPU ₽0.49
100% vCPU ₽0.89
RAM (for 1 GB) ₽0.20
Intel Cascade Lake
5% vCPU ₽0.15
20% vCPU ₽0.35
50% vCPU ₽0.49
100% vCPU ₽0.76
RAM (for 1 GB) ₽0.20

Storage and backups

Service Rate for 1 GB per month
Fast network storage $0.104302
Backup over storage size $0.032594
Service Rate for 1 GB per month
Fast network storage ₽8.1356
Backup over storage size ₽2.5424

Outgoing traffic

When using the service, you pay for the traffic from Yandex.Cloud to the internet. Traffic between Yandex.Cloud services and incoming internet traffic are free.

The minimum charging unit is 1 MB.

Resource category Cost of 1 GB, without VAT
Outgoing traffic, <10 GB $0
Outgoing traffic, >10 GB $0.012307
Resource category Cost of 1 GB, with VAT
Outgoing traffic, <10 GB ₽0
Outgoing traffic, >10 GB ₽0.9600

Estimated prices for host classes

Prices for the time of host uptime are calculated based on host classes and the above prices for using vCPU and RAM for the corresponding platform. To accurately calculate the cost of the desired cluster, use the calculator.

Alert

Yandex.Cloud billing detailization shows the consumption of vCPU and RAM corresponding to the configuration and number of hosts in your clusters.

ClickHouse hosts

Host class Rate for 1 hour With CVoS for 1 year With CVoS for 3 years
Intel Broadwell
b1.nano (2 vCPU × 5%, 2 GB) $0.008974 - -
b1.micro (2 vCPU × 20%, 2 GB) $0.015128 - -
b1.medium (2 vCPU × 50%, 4 GB) $0.027949 - -
s1.nano (1 vCPU, 4 GB) $0.035256 - -
s1.micro (2 vCPU, 8 GB) $0.070513 - -
s1.small (4 vCPU, 16 GB) $0.141026 - -
s1.medium (8 vCPU, 32 GB) $0.282051 - -
s1.large (16 vCPU, 64 GB) $0.564103 - -
s1.xlarge (32 vCPU, 128 GB) $1.128205 - -
Intel Cascade Lake
b2.nano (2 vCPU × 5%, 2 GB) $0.008974 - -
b2.micro (2 vCPU × 20%, 2 GB) $0.015128 - -
b2.medium (2 vCPU × 50%, 4 GB) $0.027949 - -
m2.micro (2 vCPU, 16 GB) $0.098462 $0.065641 $0.050256
m2.small (4 vCPU, 32 GB) $0.196923 $0.131282 $0.100513
m2.medium (6 vCPU, 48 GB) $0.295385 $0.196923 $0.150769
m2.large (8 vCPU, 64 GB) $0.393846 $0.262564 $0.201026
m2.xlarge (12 vCPU, 96 GB) $0.590769 $0.393846 $0.301538
m2.2xlarge (16 vCPU, 128 GB) $0.787692 $0.525128 $0.402051
m2.3xlarge (24 vCPU, 192 GB) $1.181538 $0.787692 $0.603077
m2.4xlarge (32 vCPU, 256 GB) $1.575385 $1.050256 $0.804103
m2.5xlarge (40 vCPU, 320 GB) $1.969231 $1.312821 $1.005128
m2.6xlarge (48 vCPU, 384 GB) $2.363077 $1.575385 $1.206154
s2.micro (2 vCPU, 8 GB) $0.064615 $0.044103 $0.033846
s2.small (4 vCPU, 16 GB) $0.129231 $0.088205 $0.067692
s2.medium (8 vCPU, 32 GB) $0.258462 $0.176410 $0.135385
s2.large (12 vCPU, 48 GB) $0.387692 $0.264615 $0.203077
s2.xlarge (16 vCPU, 64 GB) $0.516923 $0.352821 $0.270769
s2.2xlarge (24 vCPU, 96 GB) $0.775385 $0.529231 $0.406154
s2.3xlarge (32 vCPU, 128 GB) $1.033846 $0.705641 $0.541538
s2.4xlarge (40 vCPU, 160 GB) $1.292308 $0.882051 $0.676923
s2.5xlarge (48 vCPU, 192 GB) $1.550769 $1.058462 $0.812308
s2.6xlarge (64 vCPU, 256 GB) $2.067692 $1.411282 $1.083077
Host class Rate for 1 hour With CVoS for 1 year With CVoS for 3 years
Intel Broadwell
b1.nano (2 vCPU × 5%, 2 GB) ₽0.70
b1.micro (2 vCPU × 20%, 2 GB) ₽1.18
b1.medium (2 vCPU × 50%, 4 GB) ₽2.18
s1.nano (1 vCPU, 4 GB) ₽2.75
s1.micro (2 vCPU, 8 GB) ₽5.50
s1.small (4 vCPU, 16 GB) ₽11.00
s1.medium (8 vCPU, 32 GB) ₽22.00
s1.large (16 vCPU, 64 GB) ₽44.00
s1.xlarge (32 vCPU, 128 GB) ₽88.00
Intel Cascade Lake
b2.nano (2 vCPU × 5%, 2 GB) ₽0.70
b2.micro (2 vCPU × 20%, 2 GB) ₽1.18
b2.medium (2 vCPU × 50%, 4 GB) ₽2.18
m2.micro (2 vCPU, 16 GB) ₽7.68 ₽5.12 ₽3.92
m2.small (4 vCPU, 32 GB) ₽15.36 ₽10.24 ₽7.84
m2.medium (6 vCPU, 48 GB) ₽23.04 ₽15.36 ₽11.76
m2.large (8 vCPU, 64 GB) ₽30.72 ₽20.48 ₽15.68
m2.xlarge (12 vCPU, 96 GB) ₽46.08 ₽30.72 ₽23.52
m2.2xlarge (16 vCPU, 128 GB) ₽61.44 ₽40.96 ₽31.36
m2.3xlarge (24 vCPU, 192 GB) ₽92.16 ₽61.44 ₽47.04
m2.4xlarge (32 vCPU, 256 GB) ₽122.88 ₽81.92 ₽62.72
m2.5xlarge (40 vCPU, 320 GB) ₽153.60 ₽102.40 ₽78.40
m2.6xlarge (48 vCPU, 384 GB) ₽184.32 ₽122.88 ₽94.08
s2.micro (2 vCPU, 8 GB) ₽5.04 ₽3.44 ₽2.64
s2.small (4 vCPU, 16 GB) ₽10.08 ₽6.88 ₽5.28
s2.medium (8 vCPU, 32 GB) ₽20.16 ₽13.76 ₽10.56
s2.large (12 vCPU, 48 GB) ₽30.24 ₽20.64 ₽15.84
s2.xlarge (16 vCPU, 64 GB) ₽40.32 ₽27.52 ₽21.12
s2.2xlarge (24 vCPU, 96 GB) ₽60.48 ₽41.28 ₽31.68
s2.3xlarge (32 vCPU, 128 GB) ₽80.64 ₽55.04 ₽42.24
s2.4xlarge (40 vCPU, 160 GB) ₽100.80 ₽68.80 ₽52.80
s2.5xlarge (48 vCPU, 192 GB) ₽120.96 ₽82.56 ₽63.36
s2.6xlarge (64 vCPU, 256 GB) ₽161.28 ₽110.08 ₽84.48

ZooKeeper hosts

Host class Rate for 1 hour
Intel Broadwell
b1.nano (2 vCPU × 5%, 2 GB) $0.008974
b1.micro (2 vCPU × 20%, 2 GB) $0.014103
b1.medium (2 vCPU × 50%, 4 GB) $0.022821
s1.nano (1 vCPU, 4 GB) $0.021667
s1.micro (2 vCPU, 8 GB) $0.043333
s1.small (4 vCPU, 16 GB) $0.086667
s1.medium (8 vCPU, 32 GB) $0.173333
s1.large (16 vCPU, 64 GB) $0.346667
s1.xlarge (32 vCPU, 128 GB) $0.693333
Intel Cascade Lake
b2.nano (2 vCPU × 5%, 2 GB) $0.008974
b2.micro (2 vCPU × 20%, 2 GB) $0.014103
b2.medium (2 vCPU × 50%, 4 GB) $0.022821
m2.micro (2 vCPU, 16 GB) $0.060513
m2.small (4 vCPU, 32 GB) $0.121026
m2.medium (6 vCPU, 48 GB) $0.181538
m2.large (8 vCPU, 64 GB) $0.242051
m2.xlarge (12 vCPU, 96 GB) $0.363077
m2.2xlarge (16 vCPU, 128 GB) $0.484103
m2.3xlarge (24 vCPU, 192 GB) $0.726154
m2.4xlarge (32 vCPU, 256 GB) $0.968205
m2.5xlarge (40 vCPU, 320 GB) $1.210256
m2.6xlarge (48 vCPU, 384 GB) $1.452308
s2.micro (2 vCPU, 8 GB) $0.040000
s2.small (4 vCPU, 16 GB) $0.080000
s2.medium (8 vCPU, 32 GB) $0.160000
s2.large (12 vCPU, 48 GB) $0.240000
s2.xlarge (16 vCPU, 64 GB) $0.320000
s2.2xlarge (24 vCPU, 96 GB) $0.480000
s2.3xlarge (32 vCPU, 128 GB) $0.640000
s2.4xlarge (40 vCPU, 160 GB) $0.800000
s2.5xlarge (48 vCPU, 192 GB) $0.960000
s2.6xlarge (64 vCPU, 256 GB) $1.280000
Host class Rate for 1 hour
Intel Broadwell
b1.nano (2 vCPU × 5%, 2 GB) ₽0.70
b1.micro (2 vCPU × 20%, 2 GB) ₽1.10
b1.medium (2 vCPU × 50%, 4 GB) ₽1.78
s1.nano (1 vCPU, 4 GB) ₽1.69
s1.micro (2 vCPU, 8 GB) ₽3.38
s1.small (4 vCPU, 16 GB) ₽6.76
s1.medium (8 vCPU, 32 GB) ₽13.52
s1.large (16 vCPU, 64 GB) ₽27.04
s1.xlarge (32 vCPU, 128 GB) ₽54.08
Intel Cascade Lake
b2.nano (2 vCPU × 5%, 2 GB) ₽0.70
b2.micro (2 vCPU × 20%, 2 GB) ₽1.10
b2.medium (2 vCPU × 50%, 4 GB) ₽1.78
m2.micro (2 vCPU, 16 GB) ₽4.72
m2.small (4 vCPU, 32 GB) ₽9.44
m2.medium (6 vCPU, 48 GB) ₽14.16
m2.large (8 vCPU, 64 GB) ₽18.88
m2.xlarge (12 vCPU, 96 GB) ₽28.32
m2.2xlarge (16 vCPU, 128 GB) ₽37.76
m2.3xlarge (24 vCPU, 192 GB) ₽56.64
m2.4xlarge (32 vCPU, 256 GB) ₽75.52
m2.5xlarge (40 vCPU, 320 GB) ₽94.40
m2.6xlarge (48 vCPU, 384 GB) ₽113.28
s2.micro (2 vCPU, 8 GB) ₽3.12
s2.small (4 vCPU, 16 GB) ₽6.24
s2.medium (8 vCPU, 32 GB) ₽12.48
s2.large (12 vCPU, 48 GB) ₽18.72
s2.xlarge (16 vCPU, 64 GB) ₽24.96
s2.2xlarge (24 vCPU, 96 GB) ₽37.44
s2.3xlarge (32 vCPU, 128 GB) ₽49.92
s2.4xlarge (40 vCPU, 160 GB) ₽62.40
s2.5xlarge (48 vCPU, 192 GB) ₽74.88
s2.6xlarge (64 vCPU, 256 GB) ₽99.84