Disk types in Managed Service for MySQL®
Managed Service for MySQL® allows you to use network and local storage drives for database clusters. Network storage drives are based on network blocks, which are virtual disks in the Yandex Cloud infrastructure. Local disks are physically located in 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-davailability zone, local SSD storage is not available if using the Intel Cascade Lake platform.
Selecting 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 impacts the cost of a cluster: you are charged for it even if it is not running. 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.