Disk types in Managed Service for MySQL®

Managed Service for MySQL® allows you to use network and local storage drives for database clusters. Network drives are based on network blocks, which are virtual disks in the Yandex Cloud infrastructure. Local disks are physically located on the database host servers.

When creating a cluster, you can select the following disk types for data storage:

• Network HDD storage (network-hdd): Most cost-effective option for clusters that do not require high read/write performance.

• Network SSD storage (network-ssd): Balanced solution. Such disks are slower than local SSD storage, but, unlike local disks, they ensure data integrity if Yandex Cloud hardware fails.

• Non-replicated SSD storage (network-ssd-nonreplicated): Network SSD storage with enhanced performance but without redundancy.

  The storage size can only be increased in 93 GB increments.

• Local SSDs (local-ssd): Disks with the fastest performance.

  The size of such storage can be increased:

  • For Intel Broadwell and Intel Cascade Lake: In 100 GB increments only.
  • For Intel Ice Lake: In 368 GB increments only.

  Note

  For clusters with hosts residing in the ru-central1-d availability zone, local SSD storage is not available if using the Intel Cascade Lake platform.

Selecting disk type during cluster creationSelecting disk type during cluster creation

The number of hosts you can create together with a MySQL® cluster depends on the selected disk type:

• With local SSDs (local-ssd) or non-replicated SSDs (network-ssd-nonreplicated), you can create a cluster with three or more hosts.

  This cluster will be fault-tolerant.

  Local SSD storage has an effect on how much a cluster will cost: you pay for it even if it is stopped. For more information, refer to the pricing policy.

• With network HDD (network-hdd) or network SSD (network-ssd) storage, you can add any number of hosts within the current quota.

For more information about limits on the number of hosts per cluster, see Quotas and limits.