Yandex MPP Analytics for PostgreSQL host classes

The host class determines the computing power allocated for each host in a cluster. In a Yandex MPP Analytics for PostgreSQL cluster, the classes of master hosts and segment hosts may differ. For information on how to select host classes, see Calculating the cluster configuration.

For master hosts, the host class determines the available disk types:

• s2, i2: local-ssd, network-ssd-nonreplicated.
• s3, i3: network-ssd, local-ssd, network-ssd-nonreplicated, network-ssd-io-m3.

For segment hosts, the following disk types are available:

• local-ssd
• network-ssd-nonreplicated
• network-ssd-io-m3

The network-ssd-nonreplicated type is available for clusters with up to four segment hosts.

The available storage size does not depend on the host class. For storage limitations, see Quotas and limits.

Available host classesAvailable host classes

Yandex MPP Analytics for PostgreSQL cluster hosts are deployed on Yandex Compute Cloud virtual machines on Intel Cascade Lake and Intel Ice Lake platforms with a guaranteed vCPU share of 100%. The full list of possible host configurations is provided below.

The available host configurations for each of the platforms depend on the following factors:

• Database management system.
• Processor type.
• Allocated quota.
• Availability zone.

For example, ru-central1-d does not support Intel Broadwell and local SSD storage if Intel Cascade Lake is used.

Configuration types:

• s2, s3: Standard configurations with 4 GB:1 RAM-to-vCPU ratio.
• i2, i3: Configurations with 8 GB:1 RAM-to-vCPU ratio. These configurations are well suited for clusters with high cache requirements. Hosts with this configuration run in a software-accelerated network, which substantially affects cluster costs.

Using dedicated hostsUsing dedicated hosts

You can use dedicated hosts for your master hosts, segment hosts, or all your cluster's hosts at the same time. In which case the cluster's hosts will reside on dedicated hosts from the group you select.

A cluster on dedicated hosts will have the following available to it:

• Configurations of the platform the group's dedicated hosts were created on.
• The whole local disk (local-ssd) volume of the dedicated host. The maximum storage size per host is greater than if standard VMs are used.

Network drives are also available on dedicated hosts.