Managed Service for Greenplum® pricing
In this section, you can find Managed Service for Greenplum® 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 Managed Service for Greenplum® cost
The Managed Service for Greenplum® usage cost is based on:
- Disk type and storage size.
- Computing resources allocated to cluster hosts and host type.
- Settings and number of backups.
- Egress traffic from Yandex Cloud.
In all calculations, 1 GB = 230 bytes.
Using cluster hosts
There are different ways to calculate the cost depending on the host type:
-
Standard hosts
The cost is calculated for each hour of operation of the host in accordance with the allocated computing resources.
-
Dedicated hosts
The usage cost includes two components: the cost of Yandex Compute Cloud computing resources and Managed Service for Greenplum® markup for using these resources.
You can check the supported resource configurations in Greenplum® host classes and see prices for using vCPUs and RAM in the Prices section.
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 Greenplum® host is not performing its main functions.
Disk space usage
You are charged for the following:
-
Storage allocated for clusters.
- You can only order local SSD storage (
local-ssd
) for clusters with two master hosts:- For Intel Cascade Lake: In 100 GB increments.
- For Intel Ice Lake: In increments of 368 GB.
- You can only order storage on non-replicated SSDs (
network-ssd-nonreplicated
) in 93 GB increments for clusters with two master hosts.
To pay less for storage, export AO and AOCO tables from disks within the Managed Service for Greenplum® cluster to cold storage in Yandex Object Storage. The data will be stored in a service bucket in a compressed and encrypted form, which is more cost-efficient. The cost of such storage is calculated based on the Object Storage pricing policy.
- You can only order local SSD storage (
-
Space used by DB backups in excess of the storage amount specified for the cluster.
-
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.
-
During an automatic backup, Managed Service for Greenplum® 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 or free backups.
-
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:
- Standard hosts: 3
s3-c8-m32
hosts: Intel Ice Lake, 8 × 100% vCPU, 32 GB RAM. - Storage for standard hosts: 100 GB of HDD network storage.
- Dedicated hosts: 3
s2.medium
hosts: Intel Cascade Lake, 8 × 100% vCPU, 32 GB RAM. - Storage for dedicated hosts: 50 GB of local SSD storage.
Cost calculation for standard hosts:
3 × (8 × ₽2.1500 + 32 × ₽0.5700) = ₽106.3200
Total: ₽106.3200 is the cost per hour of standard host operation.
Where:
- 3: Number of standard hosts.
- 8: Number of vCPUs.
- ₽2.1500: Cost of using 100% vCPU per hour.
- 32: Amount of RAM per standard host (in GB).
- ₽0.5700: Cost of using 1GB of RAM on 100% vCPU per hour.
Cost calculation for dedicated hosts:
3 × (8 × ₽1.2000 + 32 × ₽0.3100) = ₽58.5600
Total: ₽58.5600 is the cost per hour of dedicated host operation.
Where:
- 3: Number of dedicated hosts.
- 8: Number of vCPUs.
- ₽1.2000: Cost of using 100% vCPU per hour.
- 32: Amount of RAM per dedicated host (in GB).
- ₽0.3100: Cost of using 1GB of RAM on 100% vCPU per hour.
Calculation for the storage cost and total cost:
(720 × ₽106.3200 + 100 × ₽3.2000) + (720 × ₽58.5600 + 50 × ₽13.0100) = ₽119684.1000
Total: ₽119684.1000 is the cost of using the cluster for 30 days.
Where:
- 720: Number of hours in 30 days.
- ₽106.3200: Cost per hour of standard host operation.
- 100: Amount of HDD network storage (in GB) for standard hosts.
- ₽3.2000: Cost of using 1 GB of network HDD storage per month.
- ₽58.5600: Cost per hour of dedicated host operation.
- 50: Amount of local SSD storage (in GB) for dedicated hosts.
- ₽13.0100: Cost of using 1 GB of local SSD 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 Greenplum® provides two types 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, web traffic, and computing resources for dedicated hosts this way.
Pricing
All prices are shown with VAT.
Prices for hosts are calculated in different ways depending on the selected host type.
The cost of storage on local SSDs (local-ssd
) also depends on the host type.
The monthly usage rate is based on 720 hours a month.
Host computing resources
Standard hosts
The cost calculation will be different depending on the host configuration:
-
For hosts i2 and i3 (
io-optimized
), the cost is made up of the price for Managed Service for Greenplum® host computing resources (see the table below) and the price for software-accelerated network use. -
For hosts with other configurations, you only pay for their computing resources:
Costs per hourCosts per monthResource Cost per hour Cost with CVoS for 6 months Cost with CVoS for 1 year Intel Cascade Lake 100% vCPU ₽2.39 — — RAM (for 1 GB) ₽0.63 — — Intel Ice Lake 100% vCPU ₽2.15 ₽1.8275 (-15%) ₽1.6770 (-22%) RAM (for 1 GB) ₽0.57 ₽0.4845 (-15%) ₽0.4446 (-22%) Resource Cost per month Cost with CVoS for 6 months Cost with CVoS for 1 year Intel Cascade Lake 100% vCPU ₽1720.80 — — RAM (for 1 GB) ₽453.60 — — Intel Ice Lake 100% vCPU ₽1548.00 ₽1315.80 (-15%) ₽1207.44 (-22%) RAM (for 1 GB) ₽410.40 ₽348.84 (-15%) ₽320.1120 (-22%)
Dedicated hosts
The usage cost includes two components: the cost of Yandex Compute Cloud computing resources and Managed Service for Greenplum® markup for using these resources.
Resource | Managed Service for Greenplum® markup for 1 hour |
---|---|
Intel Cascade Lake | |
100% vCPU | ₽1.20 |
RAM (for 1 GB) | ₽0.31 |
Intel Ice Lake | |
100% vCPU | ₽1.08 |
RAM (for 1 GB) | ₽0.28 |
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 |
---|---|
HDD network storage | ₽3.20 |
Non-replicated SSD storage | ₽8.80 |
Network SSD storage | ₽13.01 |
Local SSD storage | ₽13.01 |
Backups beyond the storage size | ₽1.92 |
The cost is made up of two components: the Yandex Compute Cloud storage cost and the Managed Service for Greenplum® price for it. All prices are shown per 1 GB per month.
Service | Cost Compute Cloud | MDB cost | Total cost |
---|---|---|---|
HDD network storage | - | ₽3.20 | ₽3.20 |
Non-replicated SSD storage | - | ₽8.80 | ₽8.80 |
Network SSD storage | - | ₽13.01 | ₽13.01 |
Local SSD storage | ₽8.80 | ₽4.21 | ₽13.01 |
Backups beyond the storage size | - | ₽1.9200 | ₽1.92 |
The cost of cold storage in Yandex Object Storage is calculated based on the Object Storage pricing policy.
Pricing for backup storage has the following specifics:
-
Backups are stored free of charge as long as the combined size of the database and all backups is less than the total storage size.
-
Adding a segment host increases the total cost per cluster. However, expenses for storing backups beyond the storage size will decrease because the total storage will expand.
-
The total backup size is a whole of data copy and WAL sizes. The backup size does not include the amount of deduplicated append-optimized table data. The size of WAL data depends on the amount of made changes and is comparable to the backup size. You can get both values with a list of backups.
Egress traffic
When using the service, you pay for traffic from Yandex Cloud to the internet. Traffic between internal IPs 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 | ₽1.53 |
Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.