Get started
Yandex Managed Service for SQL Server™

Changing cluster settings

After creating a cluster, you can:

Change the host class

  1. Go to the folder page and select Managed Service for SQL Server.
  2. Select the cluster and click Edit cluster in the top panel.
  3. Select a new host class. When you change the host class for the cluster, the characteristics of all existing hosts change, too.
  4. Click Save changes.

To change the host class for the cluster, use the update method and pass the following in the request:

  • The cluster ID, in the clusterId parameter. To find out the cluster ID, get a list of clusters in the folder.
  • New host class, in the configSpec.resources.resourcePresetId parameter. To find out the list of supported values, use the list method for ResourcePreset.
  • List of cluster configuration fields to be changed (in this case, configSpec.resources.resourcePresetId), in the updateMask parameter.

Warning

This API method resets any cluster settings that aren't passed explicitly in the request to their defaults. To avoid this, in the updateMask parameter, list the settings you want to change (in a single line, separated by commas).

Increasing storage size

  1. Go to the folder page and select Managed Service for SQL Server.
  2. Select the cluster and click Edit cluster in the top panel.
  3. Under Storage size, specify the required value.
  4. Click Save changes.

To change the storage size for a cluster, use the update API method and pass the following in the request:

  • The cluster ID, in the clusterId parameter. To find out the cluster ID, get a list of clusters in the folder.
  • Required storage size (in bytes), in the configSpec.resources.diskSize parameter.
  • List of user configuration fields to be changed (in this case, configSpec.resources.diskSize), in the updateMask parameter.

Warning

This API method resets any cluster settings that aren't passed explicitly in the request to their defaults. To avoid this, in the updateMask parameter, list the settings you want to change (in a single line, separated by commas).

Changing SQL Server settings

  1. Go to the folder page and select Managed Service for SQL Server.
  2. Select the cluster and click Edit cluster in the top panel.
  3. Under DBMS settings, click Settings.
  4. Edit the settings and click Save.
  5. Click Save changes.

Use the update API method and pass the following in the request:

  • The cluster ID, in the clusterId parameter. To find out the cluster ID, get a list of clusters in the folder.
  • The relevant values in the configSpec.sqlserverConfig_2016sp2 parameter.
  • List of user configuration fields to be changed (in this case, configSpec.sqlserverConfig_2016sp2), in the updateMask parameter.

Warning

This API method resets any cluster settings that aren't passed explicitly in the request to their defaults. To avoid this, in the updateMask parameter, list the settings you want to change (in a single line, separated by commas).

Moving a cluster

To move a cluster to another folder:

  1. Go to the folder page and select Managed Service for SQL Server.
  2. Click to the right of the row of the cluster that you want to move.
  3. Click Move.
  4. Select the folder you want to move the cluster to.
  5. Click Move.

To move a cluster from the current folder to a different one, use the move API method and pass the following in the request:

  • The cluster ID, in the clusterId parameter. To find out the cluster ID, get a list of clusters in the folder.
  • The ID of the destination folder in the destinationFolderId parameter.
In this article: