Storage types
Managed Service for SQL Server 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.
When creating a cluster, you can choose between the following storage types:
- Standard network storage (
network-hdd): The cheapest option for servers with relaxed read/write performance requirements. - Fast network storage (
network-ssd): A middle-ground solution. It's slower than local storage, but unlike local disks, it ensures data integrity if Yandex.Cloud hardware goes down. - Fast local storage (
local-ssd): The fastest disks. The size of local storage can only be incremented by 100 GB.
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 SQL Server 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.