[Yandex Cloud documentation](../../index.md) > [Yandex Managed Service for MySQL®](../index.md) > [Step-by-step guides](index.md) > Clusters > Information about existing clusters # Information about existing MySQL® clusters You can get detailed information about each Managed Service for MySQL® cluster you created. ## Getting a list of database clusters in your folder {#list-clusters} {% list tabs group=instructions %} - Management console {#console} Navigate to **Managed Service for MySQL**. - CLI {#cli} If you do not have the Yandex Cloud CLI yet, [install and initialize it](../../cli/quickstart.md#install). The folder used by default is the one specified when [creating](../../cli/operations/profile/profile-create.md) the CLI profile. To change the default folder, use the `yc config set folder-id ` command. You can also specify a different folder for any command using `--folder-name` or `--folder-id`. If you access a resource by its name, the search will be limited to the default folder. If you access a resource by its ID, the search will be global, i.e., through all folders based on access permissions. To get a list of MySQL® clusters in the default folder, run this command: ``` yc managed-mysql cluster list ``` Result: ``` +----------------------+--------------+---------------------+--------+---------+ | ID | NAME | CREATED AT | HEALTH | STATUS | +----------------------+--------------+---------------------+--------+---------+ | c9q5k4ve76js******** | mysql-test | 2019-07-09 11:05:25 | ALIVE | RUNNING | | ... | +----------------------+--------------+---------------------+--------+---------+ ``` - REST API {#api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Call the [Cluster.list](../api-ref/Cluster/list.md) method, e.g., via the following [cURL](https://curl.se/) request: ```bash curl \ --request GET \ --header "Authorization: Bearer $IAM_TOKEN" \ --url 'https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters' \ --url-query folderId= ``` You can get the folder ID with the [list of folders in the cloud](../../resource-manager/operations/folder/get-id.md). 1. Check the [server response](../api-ref/Cluster/list.md#yandex.cloud.mdb.mysql.v1.ListClustersResponse) to make sure your request was successful. - gRPC API {#grpc-api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Clone the [cloudapi](https://github.com/yandex-cloud/cloudapi) repository: ```bash cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi ``` Below, we assume that the repository contents reside in the `~/cloudapi/` directory. 1. Call the [ClusterService/List](../api-ref/grpc/Cluster/list.md) method, e.g., via the following [gRPCurl](https://github.com/fullstorydev/grpcurl) request: ```bash 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 '{ "folder_id": "" }' \ mdb.api.cloud.yandex.net:443 \ yandex.cloud.mdb.mysql.v1.ClusterService.List ``` You can get the folder ID with the [list of folders in the cloud](../../resource-manager/operations/folder/get-id.md). 1. Check the [server response](../api-ref/grpc/Cluster/list.md#yandex.cloud.mdb.mysql.v1.ListClustersResponse) to make sure your request was successful. {% endlist %} ## Getting detailed information about a cluster {#get-cluster} {% list tabs group=instructions %} - Management console {#console} 1. Navigate to **Managed Service for MySQL**. 1. Click the cluster name. - CLI {#cli} If you do not have the Yandex Cloud CLI yet, [install and initialize it](../../cli/quickstart.md#install). The folder used by default is the one specified when [creating](../../cli/operations/profile/profile-create.md) the CLI profile. To change the default folder, use the `yc config set folder-id ` command. You can also specify a different folder for any command using `--folder-name` or `--folder-id`. If you access a resource by its name, the search will be limited to the default folder. If you access a resource by its ID, the search will be global, i.e., through all folders based on access permissions. To get MySQL® cluster details, run the following command: ``` yc managed-mysql cluster get ``` You can get the cluster ID and name with the [list of clusters in the folder](#list-clusters). - REST API {#api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Call the [Cluster.get](../api-ref/Cluster/get.md) method, e.g., via the following [cURL](https://curl.se/) request: ```bash curl \ --request GET \ --header "Authorization: Bearer $IAM_TOKEN" \ --url 'https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters/' ``` You can get the cluster ID with the [list of clusters in the folder](#list-clusters). 1. Check the [server response](../api-ref/Cluster/get.md#yandex.cloud.mdb.mysql.v1.Cluster) to make sure your request was successful. - gRPC API {#grpc-api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Clone the [cloudapi](https://github.com/yandex-cloud/cloudapi) repository: ```bash cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi ``` Below, we assume that the repository contents reside in the `~/cloudapi/` directory. 1. Call the [ClusterService/Get](../api-ref/grpc/Cluster/get.md) method, e.g., via the following [gRPCurl](https://github.com/fullstorydev/grpcurl) request: ```bash 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": "" }' \ mdb.api.cloud.yandex.net:443 \ yandex.cloud.mdb.mysql.v1.ClusterService.Get ``` You can get the cluster ID with the [list of clusters in the folder](#list-clusters). 1. Check the [server response](../api-ref/grpc/Cluster/create.md#yandex.cloud.mdb.mysql.v1.Cluster) to make sure your request was successful. {% endlist %} ## Viewing operations with clusters {#list-operations} All actions with Managed Service for MySQL® clusters are logged as a list of operations. Each operation gets its own unique ID. ### Getting a list of operations {#get-operations} {% list tabs group=instructions %} - Management console {#console} To view operations with all Managed Service for MySQL® clusters, select ![image](../../_assets/console-icons/list-check.svg) **Operations** in the left-hand panel. In the list that opens, you will also see operations for the deleted resources. You can get a list of cluster operations as follows: 1. In the [management console](https://console.yandex.cloud), open the folder containing the cluster. 1. Navigate to **Managed Service for MySQL**. 1. In the left-hand panel, select ![image](../../_assets/console-icons/cubes-3.svg) **Clusters**. 1. Select the cluster and open the ![image](../../_assets/console-icons/list-check.svg) **Operations** tab. This will open the list of operations with the cluster. - CLI {#cli} If you do not have the Yandex Cloud CLI yet, [install and initialize it](../../cli/quickstart.md#install). The folder used by default is the one specified when [creating](../../cli/operations/profile/profile-create.md) the CLI profile. To change the default folder, use the `yc config set folder-id ` command. You can also specify a different folder for any command using `--folder-name` or `--folder-id`. If you access a resource by its name, the search will be limited to the default folder. If you access a resource by its ID, the search will be global, i.e., through all folders based on access permissions. To get a list of operations for a Managed Service for MySQL® cluster, run this command: ```bash yc managed-mysql cluster list-operations ``` Result: ```text +----------------------+---------------------+----------------------+---------------------+--------+----------------------+ | ID | CREATED AT | CREATED BY | MODIFIED AT | STATUS | DESCRIPTION | +----------------------+---------------------+----------------------+---------------------+--------+----------------------+ | c5m7ll6pq3j8******** | 2024-08-08 19:05:42 | mdb-maintainer | 2024-08-15 19:20:05 | DONE | Modify MySQL cluster | | c5mb0no66172******** | 2024-06-19 12:48:40 | mdb-maintainer | 2024-06-26 12:50:14 | DONE | Modify MySQL cluster | | c5m6of9he7op******** | 2023-11-13 19:25:21 | ajeef73j5iq9******** | 2023-11-13 19:32:00 | DONE | Create MySQL cluster | +----------------------+---------------------+----------------------+---------------------+---- ---+----------------------+ ``` You can get the cluster ID with the [list of clusters in the folder](cluster-list.md#list-clusters). By default, information about operations is output as text. To get more details, use `--format` to specify the `yaml` or `json` output format: ```bash yc managed-mysql cluster list-operations c9qk2926qqu9******** --format yaml ``` Result: ```text - id: c9ql6o8jm80n******** description: Create MySQL cluster created_at: "2024-08-06T05:47:26.423618Z" created_by: ajej2i98kcjd******** modified_at: "2024-08-06T05:58:36.571719Z" done: true metadata: '@type': type.googleapis.com/yandex.cloud.mdb.mysql.v1.CreateClusterMetadata cluster_id: c9qnfo2eh7js******** ... ``` - REST API {#api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Call the [Cluster.listOperations](../api-ref/Cluster/listOperations.md) method, e.g., via the following [cURL](https://curl.se/) request: ```bash curl \ --request GET \ --header "Authorization: Bearer $IAM_TOKEN" \ --url 'https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters//operations' ``` You can get the cluster ID with the [list of clusters in the folder](#list-clusters). 1. Check the [server response](../api-ref/Cluster/listOperations.md#yandex.cloud.mdb.mysql.v1.ListClusterOperationsResponse) to make sure your request was successful. - gRPC API {#grpc-api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Clone the [cloudapi](https://github.com/yandex-cloud/cloudapi) repository: ```bash cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi ``` Below, we assume that the repository contents reside in the `~/cloudapi/` directory. 1. Call the [ClusterService/ListOperations](../api-ref/grpc/Cluster/listOperations.md) method, e.g., via the following [gRPCurl](https://github.com/fullstorydev/grpcurl) request: ```bash 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": "" }' \ mdb.api.cloud.yandex.net:443 \ yandex.cloud.mdb.mysql.v1.ClusterService.ListOperations ``` You can get the cluster ID with the [list of clusters in the folder](#list-clusters). 1. Check the [server response](../api-ref/grpc/Cluster/listOperations.md#yandex.cloud.mdb.mysql.v1.ListClusterOperationsResponse) to make sure your request was successful. {% endlist %} ### Getting operation details {#get-operations-info} 1. [Get the list of operations](#get-operations) for the cluster. 1. Copy the ID of the operation you need. 1. Get the operation details: {% list tabs group=instructions %} - CLI {#cli} If you do not have the Yandex Cloud CLI yet, [install and initialize it](../../cli/quickstart.md#install). The folder used by default is the one specified when [creating](../../cli/operations/profile/profile-create.md) the CLI profile. To change the default folder, use the `yc config set folder-id ` command. You can also specify a different folder for any command using `--folder-name` or `--folder-id`. If you access a resource by its name, the search will be limited to the default folder. If you access a resource by its ID, the search will be global, i.e., through all folders based on access permissions. Run this command: ```bash yc operation get ``` Result: ```text id: c9ql6o8jm80n******** description: Create MySQL cluster created_at: "2024-08-06T05:47:26.423618Z" created_by: ajej2i98kcjd******** modified_at: "2024-08-06T05:58:36.571719Z" done: true metadata: '@type': type.googleapis.com/yandex.cloud.mdb.mysql.v1.CreateClusterMetadata cluster_id: c9qnfo2eh7js******** response: '@type': type.googleapis.com/yandex.cloud.mdb.mysql.v1.Cluster ... ``` - REST API {#api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Call the [Operation.get](../api-ref/Operation/get.md) method, e.g., via the following [cURL](https://curl.se/) request: ```bash curl \ --request GET \ --header "Authorization: Bearer $IAM_TOKEN" \ --url 'https://operation.api.cloud.yandex.net/operations/' ``` 1. Check the [server response](../api-ref/Operation/get.md#yandex.cloud.operation.Operation) to make sure your request was successful. - gRPC API {#grpc-api} 1. [Get an IAM token for API authentication](../api-ref/authentication.md) and put it into an environment variable: ```bash export IAM_TOKEN="" ``` 1. Clone the [cloudapi](https://github.com/yandex-cloud/cloudapi) repository: ```bash cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi ``` Below, we assume that the repository contents reside in the `~/cloudapi/` directory. 1. Call the [OperationService/Get](../api-ref/grpc/Operation/get.md) method, e.g., via the following [gRPCurl](https://github.com/fullstorydev/grpcurl) request: ```bash grpcurl \ -format json \ -import-path ~/cloudapi/ \ -import-path ~/cloudapi/third_party/googleapis/ \ -proto ~/cloudapi/yandex/cloud/operation/operation_service.proto \ -rpc-header "Authorization: Bearer $IAM_TOKEN" \ -d '{ "operation_id": "" }' \ operation.api.cloud.yandex.net:443 \ yandex.cloud.operation.OperationService.Get ``` 1. Check the [server response](../api-ref/grpc/Operation/get.md#yandex.cloud.operation.Operation) to make sure your request was successful. {% endlist %} #### Useful links {#see-also} * [Working with operations](../../api-design-guide/concepts/about-async.md)