Contact UsGet started
© 2024 Iron Hive LLC Belgrade

Stopping and starting an MySQL® cluster

Written by
Updated at November 18, 2024

You can stop and restart an MySQL® cluster as needed. There is no charge while your cluster is idle: you continue to pay only for the storage size and backups based on the pricing policy.

Alert

If a cluster uses local SSD storage (local-ssd), its computing resources are not released when it's stopped. This means that you are charged in full even for a stopped cluster.

Stopping a cluster

You can stop the cluster if you're not going to use the DBMS you launched for a while.

  1. Go to the folder page and select Managed Service for MySQL.
  2. Select the cluster you need in the list, click , and select Stop.
  3. Confirm that you want to stop the cluster and click Stop.

If you do not have the Yandex Cloud command line interface yet, install and initialize 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.

  1. See the description of the CLI cluster stop command:

    yc managed-mysql cluster stop --help

  2. To get a cluster ID and name, request the list of clusters in the folder:

    yc managed-mysql cluster list

  3. To stop a cluster, run the command:

    yc managed-mysql cluster stop <cluster_name_or_ID>

  1. Get an IAM token for API authentication and put it into the environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Use the Cluster.stop method to make a request, e.g., via cURL:

    curl \
    --request POST \
    --header "Authorization: Bearer $IAM_TOKEN" \
    --header "Content-Type: application/json" \
    --url 'https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters/<cluster_ID>:stop'

    You can get the cluster ID with a list of clusters in the folder.

  3. View the server response to make sure the request was successful.

  1. Get an IAM token for API authentication and put it into the environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Clone the cloudapi repository:

    cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi

    Below, we assume the repository contents are stored in the ~/cloudapi/ directory.

  3. Use the ClusterService/Stop call to make a request, e.g., via gRPCurl:

    grpcurl \
    -format json \
    -import-path ~/cloudapi/ \
    -import-path ~/cloudapi/third_party/googleapis/ \
    -proto ~/cloudapi/yandex/cloud/mdb/mysql/v1/cluster_service.proto \
    -rpc-header "Authorization: Bearer $IAM_TOKEN" \
    -d '{
          "cluster_id": "<cluster_ID>"
        }' \
    mdb.api.cloud.yandex.net:443 \
    yandex.cloud.mdb.mysql.v1.ClusterService.Stop

    You can get the cluster ID with a list of clusters in the folder.

  4. View the server response to make sure the request was successful.

Starting a cluster

You can restart STOPPED clusters.

  1. Go to the folder page and select Managed Service for MySQL.
  2. Select the stopped cluster you need in the list, click , and select Start.
  3. Confirm that you want to start the cluster: click Start in the dialog box that opens.

If you do not have the Yandex Cloud command line interface yet, install and initialize 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.

  1. See the description of the CLI cluster start command:

    yc managed-mysql cluster start --help

  2. To get a cluster ID and name, request the list of clusters in the folder:

    yc managed-mysql cluster list

  3. To start a cluster, run the command:

    yc managed-mysql cluster start <cluster_name_or_ID>

  1. Get an IAM token for API authentication and put it into the environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Use the Cluster.start method to make a request, e.g., via cURL:

    curl \
    --request POST \
    --header "Authorization: Bearer $IAM_TOKEN" \
    --header "Content-Type: application/json" \
    --url 'https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters/<cluster_ID>:start'

    You can get the cluster ID with a list of clusters in the folder.

  3. View the server response to make sure the request was successful.

  1. Get an IAM token for API authentication and put it into the environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Clone the cloudapi repository:

    cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi

    Below, we assume the repository contents are stored in the ~/cloudapi/ directory.

  3. Use the ClusterService/Start call to make a request, e.g., via gRPCurl:

    grpcurl \
    -format json \
    -import-path ~/cloudapi/ \
    -import-path ~/cloudapi/third_party/googleapis/ \
    -proto ~/cloudapi/yandex/cloud/mdb/mysql/v1/cluster_service.proto \
    -rpc-header "Authorization: Bearer $IAM_TOKEN" \
    -d '{
          "cluster_id": "<cluster_ID>"
        }' \
    mdb.api.cloud.yandex.net:443 \
    yandex.cloud.mdb.mysql.v1.ClusterService.Start

    You can get the cluster ID with a list of clusters in the folder.

  4. View the server response to make sure the request was successful.

Previous
Updating a cluster
Next
Managing cluster hosts