Changing cluster settings

After creating a cluster, you can:

Changing the host class

If you don't have the Yandex.Cloud command line interface yet, install it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To change the host class for the cluster:

  1. View the description of the CLI's update cluster command:

    $ yc managed-mysql cluster update --help
    
  2. Request a list of available host classes (the ZONES column specifies the availability zones where you can select the appropriate class):

    $ yc managed-mysql resource-preset list
    
    +-----------+--------------------------------+-------+----------+
    |    ID     |            ZONE IDS            | CORES |  MEMORY  |
    +-----------+--------------------------------+-------+----------+
    | s1.nano   | ru-central1-a, ru-central1-b,  |     1 | 4.0 GB   |
    |           | ru-central1-c                  |       |          |
    | s1.micro  | ru-central1-a, ru-central1-b,  |     2 | 8.0 GB   |
    |           | ru-central1-c                  |       |          |
    | ...                                                           |
    +-----------+--------------------------------+-------+----------+
    
  3. Specify the class in the update cluster command:

    $ yc managed-mysql cluster update <cluster name>
         --resource-preset <class ID>
    

    Managed Service for MySQL will run the update host class command for the cluster.

You can change the host class using the API update method: pass the necessary value in the request parameter configSpec.clickhouse.resources.resourcePresetId.

To request a list of supported values, use the list method for the ResourcePreset resources.

Increasing storage size

If you don't have the Yandex.Cloud command line interface yet, install it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To increase the storage size for a cluster:

  1. View the description of the CLI's update cluster command:

    $ yc managed-mysql cluster update --help
    
  2. Make sure the cloud's quota is sufficient to increase the storage size: open the Квоты page for your cloud and check that the Yandex Managed Service for MySQL section still has space available in the space line.

  3. Make sure the required cluster is using network storage (it is not yet possible to increase the size of local storage). To do this, request information about the cluster and find the disk_type_id field: it should be set to network-hdd or network-ssd:

    $ yc managed-mysql cluster get <cluster name>
    
    id: c7qkvr3u78qiopj3u4k2
    folder_id: b1g0ftj57rrjk9thribv
    ...
    config:
      ...
      resources:
        resource_preset_id: s1.nano
        disk_size: "10737418240"
        disk_type_id: network-ssd
    ...
    
  4. Specify the required amount of storage in the update cluster command (it must be at least as large as disk_size in the cluster properties):

    $ yc managed-mysql cluster update <cluster name>
         --disk-size <storage size in GB>
    

    If all these conditions are met, Managed Service for MySQL launches the operation to increase storage space.

You can change the storage size for a cluster using the API update method: pass the appropriate values in the request parameter configSpec.resources.diskSize.

Make sure the cloud's quota is sufficient to increase the storage size: open the Квоты page for your cloud and check that the Yandex Managed Service for MySQL section still has space available in the space line.

Changing settings MySQL

You can change the DBMS settings of the hosts in your cluster. All supported settings are described in the API reference.

If you don't have the Yandex.Cloud command line interface yet, install it.

The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name or --folder-id parameter.

To change MySQL server settings:

  1. View the description of the CLI's update cluster configuration command:

    $ yc managed-mysql cluster update-config --help
    
  2. Set the required parameter values.

    All supported parameters are listed in the request format for the update method, in the mysql_config_5_7 field. To specify the parameter name in the CLI's call, convert the name from lowerCamelCase to snake_case. For example, the logMinDurationStatement parameter from an API request should be converted to log_min_duration_statement for the CLI command:

    $ yc managed-mysql cluster update-config <cluster name>
         --set log_min_duration_statement=100,<parameter name>=<value>,...
    

    Managed Service for MySQL will run the operation for changing the cluster settings.

You can change the DBMS settings for a cluster using the API update method: pass the appropriate values in the request parameter configSpec.mysql_config_5_7.