Managed Service for MySQL lets you use network and local storage for database clusters. Network storage is based on network blocks, which are virtual disks in the Yandex.Cloud infrastructure. Local storage is organized on disks that are physically located in the database host servers.
During cluster creation you can choose between the following storage types:
- Standard network storage (
network-hdd) — the cheapest option, for clusters with moderate requirements to IOPS.
- Fast network storage (
network-ssd) — a compromise option: slower than local storage, but, as opposed to local disks, guarantees data safety when Cloud servers are out of commission.
- Fast local storage (
local-ssd) — the fastest option. Local storage can only be increased in 100 GB intervals.
Local storage features
Local storage doesn't provide fault tolerance for data storage and affects the overall pricing for the cluster:
- Local storage doesn't provide fault tolerance for a single-host cluster: if a local disk fails, the data is permanently lost. Therefore, when creating a new Managed Service for MySQL cluster using local storage, a 3-host fail-safe configuration is automatically set up.
- You are charged for a cluster with local storage even if it's stopped. Read more in the pricing policy.