VK Cloud logo

MySQL

Starting, restarting, and stopping a DB instance or its hosts

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. Perform the desired operation:

    • To start a DB instance entirely, with all of its hosts, perform one of the following actions:

      • Select one or more DB instances using the checkboxes, then click Start.
      • Click MySQL for the DB instance host with the Master role and select Start.
    • To start a separate replica of a DB instance, click MySQL for the desired host with the Replica role and select Start.

Getting information about a DB instance and its hosts

Different information is available for active and stopped DB instances.

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. Perform the desired operation:

    • To view information about a DB instance, click its name.

    • To view information about an individual host of a DB instance, click the host name.

    A page with the information will open.

Managing an external IP address

You can assign an external IP address or unbind it at the level of an individual host that is part of a DB instance:

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. Perform the desired operation:

    1. Click MySQL for the desired host and select Assign external IP.
    2. Select an existing IP address or the Add new IP option from the drop-down list.
    3. Click Confirm.

Creating a backup

The operation is described in detail in the section Manually creating a backup.

Expanding a DB instance

To expand an instance, add a replica to it. The operation is described in detail in the section Replication.

Vertical scaling

You can change the virtual machine type used by the hosts of a DB instance:

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. To perform vertical scaling:

    1. Click MySQL for the DB instance host with the Master role and select Vertical scaling.
    2. Select the desired virtual machine category and type.
    3. Click Save size.

Promoting a replica to master

For DB instances in the Master-Replica configuration, a replica can be separated into a standalone DB instance.

  1. Go to the VK Cloud management console.
  2. Select the project where the desired DB instance is located.
  3. Go to Databases → Database instances.
  4. Click MySQL for the desired DB instance host with the Replica role and select Promote to master.
  5. Read the warning and click Confirm.

Switching the master

For DB instances in the Cluster configuration, you can switch the Master role from the current host to a host with the Sync replica role:

  1. Go to the VK Cloud management console.
  2. Select the project where the desired DB instance is located.
  3. Go to Databases → Database instances.
  4. Click MySQL for the DB instance host with the Sync replica role and select Assign as master.
  5. Read the warning and click Assign.

Configuring disk size autoscaling

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. Configure autoscaling for the disk where data is stored:

    1. Perform one of the following actions:

      • Click MySQL for the desired DB instance and select Change disk autoscaling.
      • Click MySQL for the DB instance host with the Master role and select Change disk autoscaling.
    2. Enable or disable the disk autoscaling option.

    3. If the autoscaling option is enabled, set the maximum disk size.

    4. Click Confirm.

Deleting a DB instance or its hosts

  1. Go to the VK Cloud management console.

  2. Select the project where the desired DB instance is located.

  3. Go to Databases → Database instances.

  4. Depending on the configuration, you can delete either the entire instance or its individual replicas:

    1. Click MySQL for the desired DB instance and select Delete.
    2. Click Confirm.
Was this article helpful?