Get started
Yandex Managed Service for SQL Server™

Creating clusters SQL Server

A SQL Server cluster is one or more database hosts that replication can be configured between. Replication is enabled by default in any cluster consisting of more than one host: the master host accepts write requests, synchronously duplicates changes in the primary replica, and does it asynchronously in all the others.

Note

If database storage is 95% full, the cluster switches to read-only mode. Plan and increase the required storage size in advance.

How to create a cluster SQL Server

  1. In the management console, select the folder where you want to create a database cluster.

  2. Select Managed Service for SQL Server.

  3. Click Create cluster.

  4. Enter the cluster name in the Cluster name field. The cluster name must be unique within the folder.

  5. Select the environment where you want to create the cluster (you can't change the environment once the cluster is created):

    • PRODUCTION: For stable versions of your apps.
    • PRESTABLE: For testing, including the Managed Service for SQL Server service itself. The Prestable environment is first updated with new features, improvements, and bug fixes. However, not every update ensures backward compatibility.

  6. Select the DBMS version. The currently supported version is 2016 ServicePack 2.

  7. Select the host class to define the technical specifications of the VMs where the database hosts will be deployed. All available options are listed in Host classes. When you change the host class for the cluster, the characteristics of all existing hosts change, too.

  8. Under Storage size:

    Select the type of storage, either a more flexible network storage (network-hdd or network-ssd) or faster local SSD storage (local-ssd). The size of the local storage can only be changed in 100 GB increments.

    • Select the size to be used for data and backups. For more information about how backups take up storage space, see Backups.

  9. Under Database, specify the database attributes:

    • Database name. This name must be unique within the folder and contain only Latin letters, numbers, and underscores.
    • Username of the database owner. This name may only contain Latin letters, numbers, and underscores. By default, the new user is assigned 50 connections to each host in the cluster.
    • User password (from 8 to 128 characters).

  10. Under Hosts, select the parameters for the database hosts created with the cluster. You can add either one, three, or more hosts. By default, each host is created in a separate subnet. To select a specific subnet for the host, click in the row of the host and select the desired availability zone and subnet.

  11. Click Create cluster.

To create a cluster, use the API create method and pass the following in the request:

  • In the folderId parameter, the ID of the folder where the cluster should be placed.
  • The cluster name, in the name parameter.
  • Cluster configuration, in the configSpec parameter.
  • Configuration of the cluster hosts, in one or more hostSpecs parameters.
  • Cluster database configuration, in one or more databaseSpecs parameters.
  • Configuration of the accounts in the cluster database, in one or more userSpecs parameters.
  • Network ID, in the networkId parameter.