All Products
Search
Document Center

AnalyticDB:DescribeDBClusters

Last Updated:Mar 10, 2025

Queries the information about AnalyticDB for MySQL Data Lakehouse Edition clusters within a region.

Operation description

For information about the endpoints of AnalyticDB for MySQL, see Endpoints .

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Authorization information

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

  • Operation: the value that you can use in the Action element to specify the operation on a resource.
  • Access level: the access level of each operation. The levels are read, write, and list.
  • Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
    • For mandatory resource types, indicate with a prefix of * .
    • If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
  • Condition Key: the condition key that is defined by the cloud service.
  • Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.
OperationAccess levelResource typeCondition keyAssociated operation
adb:DescribeDBClusterslist
*DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
    none
none

Request parameters

ParameterTypeRequiredDescriptionExample
RegionIdstringYes

The region ID of the cluster.

Note You can call the DescribeRegions operation to query the most recent region list.
cn-hangzhou
DBClusterIdsstringNo

The ID of the AnalyticDB for MySQL Data Lakehouse Edition cluster.

If you do not specify this parameter, the information about all clusters that reside in the region is returned.

amv-bp1r053byu48p****
DBClusterDescriptionstringNo

The description of the cluster.

  • The description cannot start with http:// or https://.
  • The description must be 2 to 256 characters in length
test
DBClusterStatusstringNo

The state of the cluster. Valid values:

  • Preparing
  • Creating
  • Running
  • Deleting
  • Restoring
  • ClassChanging
  • NetAddressCreating
  • NetAddressDeleting
  • NetAddressModifying
Running
PageSizeintegerNo

The number of entries per page. Valid values:

  • 30 (default)
  • 50
  • 100
30
PageNumberintegerNo

The page number. Pages start from page 1. Default value: 1.

1
ResourceGroupIdstringNo

The resource group ID. If you do not specify this parameter, the information about all resource groups in the cluster is returned.

rg-4690g37929****
Tagarray<object>No

The tags that are added to the cluster.

objectNo

The tag that is added to the cluster.

KeystringNo

The tag key.

tag1
ValuestringNo

The tag value.

test1
ProductVersionstringNo

The edition of the cluster. Valid values:

  • EnterpriseVersion: Enterprise Edition.
  • BasicVersion: Basic Edition.

If you leave this parameter empty, the information about clusters of all editions is returned.

BasicVersion
DBClusterVersionstringNo

The database engine version of the cluster. Valid values:

  • 3.0: Data Warehouse Edition.
  • 5.0 (default): Data Lakehouse Edition, Enterprise Edition, and Basic Edition.
  • All: Data Warehouse Edition, Data Lakehouse Edition, Enterprise Edition, and Basic Edition.
5.0

Response parameters

ParameterTypeDescriptionExample
object
TotalCountinteger

The total number of entries returned.

1
PageSizeinteger

The number of entries per page.

30
RequestIdstring

The request ID.

A5EDBA27-AF3E-5966-9503-FD1557E19167
PageNumberinteger

The page number.

1
Itemsarray<object>

The queried clusters.

DBClusterobject

The queried cluster.

Expiredstring

Indicates whether the subscription cluster has expired. Valid values:

  • true
  • false
Note
  • If the cluster has expired, the system locks or releases the cluster within a period of time. We recommend that you renew the expired cluster. For more information, see Renewal policy.

  • This parameter is not returned for pay-as-you-go clusters.

false
CreateTimestring

The time when the cluster was created. The time follows the ISO 8601 standard in the yyyy-mm-ddThh:mm:ssZ format. The time is displayed in UTC.

2022-04-01T09:50:18Z
PayTypestring

The billing method of the cluster. Valid values:

  • Postpaid: pay-as-you-go.
  • Prepaid: subscription.
Prepaid
Modestring

The mode of the cluster. By default, flexible is returned, which indicates that the cluster is in elastic mode.

flexible
Portstring

The port number that is used to connect to the cluster.

3306
LockModestring

The lock status of the cluster. Valid values:

  • Unlock: The cluster is not locked.
  • ManualLock: The cluster is manually locked.
  • LockByExpiration: The cluster is automatically locked due to cluster expiration.
Unlock
StorageResourcestring

The specifications of reserved storage resources. Each AnalyticDB compute unit (ACU) is approximately equal to 1 core and 4 GB memory. Storage resources are used to read and write data. The increase in the storage resources can improve the read and write performance of the cluster.

24ACU
DBClusterIdstring

The ID of the AnalyticDB for MySQL Data Lakehouse Edition cluster.

amv-bp163885f8q21****
ConnectionStringstring

The public endpoint that is used to connect to the cluster.

amv-bp163885f8q21****.ads.aliyuncs.com
DBClusterTypestring

The type of the cluster. By default, Common is returned, which indicates a common cluster.

Common
CommodityCodestring

The billing method of the cluster. Valid values:

  • ads: pay-as-you-go.
  • ads_pre: subscription.
ads_pre
ExpireTimestring

The time when the cluster expires. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

Note
  • If the billing method of the cluster is subscription, the actual expiration time is returned.

  • If the billing method of the cluster is pay-as-you-go, null is returned.

2022-07-01T09:50:18Z
LockReasonstring

The reason why the cluster is locked.

Note This parameter is returned only when the cluster was locked. instance_expire is returned.
instance_expire
VPCIdstring

The virtual private cloud (VPC) ID of the cluster.

vpc-bp13h7uzhulpuxvnp****
RegionIdstring

The region ID of the cluster.

cn-hangzhou
ComputeResourcestring

The specifications of reserved computing resources. Each ACU is approximately equal to 1 core and 4 GB memory. Computing resources are used to compute data. The increase in the computing resources can accelerate queries. You can scale computing resources based on your business requirements.

16ACU
VSwitchIdstring

The vSwitch ID of the cluster.

vsw-bp1syh8vvw8yech7n****
DBVersionstring

The engine version of the AnalyticDB for MySQL Data Lakehouse Edition cluster. 5.0 is returned.

5.0
DBClusterStatusstring

The status of the cluster. Valid values:

  • Preparing
  • Creating
  • Running
  • Deleting
  • Restoring
  • ClassChanging
  • NetAddressCreating
  • NetAddressDeleting
  • NetAddressModifying
Running
ResourceGroupIdstring

The resource group ID.

rg-acfmyiu4ekp****
DBClusterNetworkTypestring

The network type of the cluster. VPC is returned.

VPC
DBClusterDescriptionstring

The description of the cluster.

adb_test
ZoneIdstring

The zone ID of the cluster.

cn-hangzhou-h
Enginestring

The engine of the cluster. AnalyticDB is returned.

AnalyticDB
ReservedACUstring

The remaining reserved computing resources that are available in the cluster. Each ACU is approximately equal to 1 core and 4 GB memory.

32ACU
Tagsarray<object>

The tags that are added to the cluster.

Tagobject

The tag that is added to the cluster.

Keystring

The tag key.

Note You can call the TagResources operation to add tags to a cluster.
tag1
Valuestring

The tag value.

test1
Categorystring

The mode of the cluster. This parameter is returned only for Data Warehouse Edition clusters. Valid values:

  • BASIC: reserved mode for Basic Edition.
  • CLUSTER: reserved mode for Cluster Edition.
  • MIXED_STORAGE: elastic mode for Cluster Edition.
Note For more information about cluster editions, see Editions .
MIXED_STORAGE
InnerPortstring

The internal port of the cluster.

3306
VPCCloudInstanceIdstring

The ID of the cluster that resides in the VPC.

am-bp163885f8q21****-controller
InnerIpstring

The internal IP address of the cluster.

10.1.xx.xx
DtsJobIdstring

The ID of the Data Transmission Service (DTS) synchronization job This parameter is returned only for MySQL analytic instances.

dtsb1578j90XXXX
ElasticIOResourceinteger

The number of elastic I/O units (EIUs). For more information, see the " EIUs " section of the Scale out elastic I/O resources topic.

Note This parameter is returned only for clusters in elastic mode.
2
RdsInstanceIdstring

The ID of the ApsaraDB RDS instance from which data is synchronized to the cluster. This parameter is returned only for MySQL analytic instances.

rm-bp11q28kvl688****
ExecutorCountstring

The number of compute nodes that are used by the cluster in elastic mode.

1
DBNodeClassstring

The node specifications of the cluster. This parameter is returned only for Data Warehouse Edition clusters.

E8
DiskTypestring

The disk type of the cluster. Valid values:

  • local_ssd: local disk.
  • cloud: basic disk.
  • cloud_ssd: standard SSD.
  • cloud_efficiency: ultra disk.
  • cloud_essd: PL1 Enterprise SSD (ESSD).
  • cloud_essd2: PL2 ESSD.
  • cloud_essd3: PL3 ESSD.
Note For more information about ESSDs, see ESSDs .
cloud_essd
DBNodeStoragelong

The storage capacity of the cluster. Unit: GB.

300
DBNodeCountlong

The number of node groups.

2
TaskInfoobject

The job progress.

Namestring

The name of the job.

analyticDBFlexibleScaleOut
Statusstring

The status of the job. Valid values:

  • NOT_RUN
  • RUNNING
  • SUCCEED
RUNNING
Progressstring

The progress of the job. Unit: %.

10
StepListarray<object>

The job steps.

StepListobject

The job step.

StepNamestring

The name of the job step.

ApplyResource
StepDescstring

The description of the job step.

Apply resource
StepStatusstring

The status of the job step. Valid values:

  • NOT_RUN
  • RUNNING
  • SUCCEED
SUCCEED
StepProgressstring

The progress of the job step. Unit: %.

50
StartTimestring

The start time of the job step. The time follows the ISO 8601 standard in the YYYY-MM-DDThh:mm:ssZ format. The time is displayed in UTC.

2024-03-10T09:28:34Z
EndTimestring

The end time of the job step. The time follows the ISO 8601 standard in the YYYY-MM-DDThh:mm:ssZ format. The time is displayed in UTC.

2024-03-10T10:28:34Z
ProductFormstring

The service type of the cluster. Valid values:

  • LegacyForm
  • IntegrationForm
IntegrationForm
ProductVersionstring

The edition of the cluster. Valid values:

  • BasicVersion: Basic Edition.
  • EnterpriseVersion: Enterprise Edition.
EnterpriseVersion
ReservedNodeSizestring

The single-node specifications of reserved resources.

8ACU
ReservedNodeCountinteger

The number of reserved resource nodes.

1

Examples

Sample success responses

JSONformat

{
  "TotalCount": 1,
  "PageSize": 30,
  "RequestId": "A5EDBA27-AF3E-5966-9503-FD1557E19167",
  "PageNumber": 1,
  "Items": {
    "DBCluster": [
      {
        "Expired": "false",
        "CreateTime": "2022-04-01T09:50:18Z",
        "PayType": "Prepaid",
        "Mode": "flexible",
        "Port": "3306",
        "LockMode": "Unlock",
        "StorageResource": "24ACU",
        "DBClusterId": "amv-bp163885f8q21****",
        "ConnectionString": "amv-bp163885f8q21****.ads.aliyuncs.com",
        "DBClusterType": "Common",
        "CommodityCode": "ads_pre",
        "ExpireTime": "2022-07-01T09:50:18Z",
        "LockReason": "instance_expire",
        "VPCId": "vpc-bp13h7uzhulpuxvnp****",
        "RegionId": "cn-hangzhou",
        "ComputeResource": "16ACU",
        "VSwitchId": "vsw-bp1syh8vvw8yech7n****",
        "DBVersion": "5.0",
        "DBClusterStatus": "Running",
        "ResourceGroupId": "rg-acfmyiu4ekp****",
        "DBClusterNetworkType": "VPC",
        "DBClusterDescription": "adb_test",
        "ZoneId": "cn-hangzhou-h",
        "Engine": "AnalyticDB",
        "ReservedACU": "32ACU",
        "Tags": {
          "Tag": [
            {
              "Key": "tag1",
              "Value": "test1"
            }
          ]
        },
        "Category": "MIXED_STORAGE",
        "InnerPort": "3306",
        "VPCCloudInstanceId": "am-bp163885f8q21****-controller",
        "InnerIp": "10.1.xx.xx",
        "DtsJobId": "dtsb1578j90XXXX",
        "ElasticIOResource": 2,
        "RdsInstanceId": "rm-bp11q28kvl688****",
        "ExecutorCount": "1",
        "DBNodeClass": "E8",
        "DiskType": "cloud_essd",
        "DBNodeStorage": 300,
        "DBNodeCount": 2,
        "TaskInfo": {
          "Name": "analyticDBFlexibleScaleOut",
          "Status": "RUNNING",
          "Progress": "10",
          "StepList": {
            "StepList": [
              {
                "StepName": "ApplyResource",
                "StepDesc": "Apply resource",
                "StepStatus": "SUCCEED",
                "StepProgress": "50",
                "StartTime": "2024-03-10T09:28:34Z",
                "EndTime": "2024-03-10T10:28:34Z"
              }
            ]
          }
        },
        "ProductForm": "IntegrationForm",
        "ProductVersion": "EnterpriseVersion",
        "ReservedNodeSize": "8ACU",
        "ReservedNodeCount": 1
      }
    ]
  }
}

Error codes

HTTP status codeError codeError messageDescription
500InternalErrorAn error occurred while processing your request.An internal error occurred. Please try again later.
503ServiceUnavailableAn error occurred while processing your request.The system is unavailable. Please try again later.

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
2024-05-28The Error code has changed. The response structure of the API has changedView Change Details
2024-05-09The Error code has changed. The request parameters of the API has changed. The response structure of the API has changedView Change Details
2023-07-27The Error code has changed. The request parameters of the API has changed. The response structure of the API has changedView Change Details