DescribeDBClusters

Updated at:

Queries the list of PolarDB clusters or the details of clusters with RAM authorization.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

  • Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.

  • API: The API that you can call to perform the action.

  • Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.

  • Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.

    • For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.

    • For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.

  • Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.

  • Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

Action

Access level

Resource type

Condition key

Dependent action

polardb:DescribeDBClusters

list

*DBCluster

acs:polardb:{#regionId}:{#accountId}:dbcluster/{#DbClusterId}

None None

Request parameters

Parameter

Type

Required

Description

Example

RegionId

string

Yes

The region ID.

Note

You can call the DescribeRegions operation to query available regions.

cn-hangzhou

DBClusterIds

string

No

The cluster IDs. Separate multiple cluster IDs with commas (,).

pc-****************

DBClusterDescription

string

No

The cluster description. Fuzzy match is supported.

pc-****************

ConnectionString

string

No

The database endpoint.

********.rwlb.polardb-pg-public.rds.aliyuncs.com

DBClusterStatus

string

No

The cluster status. For valid values, see Cluster status table.

Running

DBType

string

No

The database type. Valid values:

  • MySQL

  • PostgreSQL

  • Oracle

MySQL

DescribeType

string

No

The query mode for the list. A value of Simple indicates the brief mode, in which only the basic metadata of the clusters is returned.

Note

If this parameter is not specified, the detailed mode is used by default, and the detailed information of the clusters is returned.

Simple

DBVersion

string

No

The database version.

5.6

RecentCreationInterval

integer

No

Filters the clusters created in the last N days. Valid values: 0 to 15.

7

RecentExpirationInterval

integer

No

Filters the clusters that expire in N days. Valid values: 0 to 15.

6

Expired

boolean

No

Specifies whether the cluster has expired. Valid values:

  • true

  • false

true

PageSize

integer

No

The number of entries per page. Valid values: 30, 50, and 100.

Default value: 30.

30

PageNumber

integer

No

The page number. The value must be a positive integer that does not exceed the maximum value of the Integer data type. Default value: 1.

10

ResourceGroupId

string

No

The resource group ID.

rg-**********

Tag

array<object>

No

The list of tags.

object

No

Key

string

No

The tag key. You can filter the cluster list based on tags. You can specify up to 20 tag key-value pairs. The number n in each tag key-value pair must be unique and must be a consecutive integer starting from 1. The value of Tag.n.Key is Tag.n.Value.

Note

The tag key can be up to 64 characters in length and cannot start with aliyun, acs:, http://, or https://.

MySQL

Value

string

No

The tag value that corresponds to the tag key.

Note

The tag value can be up to 64 characters in length and cannot start with aliyun, acs:, http://, or https://.

5.6

PayType

string

No

The billing method. Valid values:

  • Postpaid: pay-as-you-go

  • Prepaid: subscription

Postpaid

DBNodeIds

string

No

The node IDs. You can specify multiple node IDs and separate them with commas (,).

pi-***************

Response elements

Element

Type

Description

Example

object

TotalRecordCount

integer

The total number of entries.

16

PageRecordCount

integer

The number of clusters returned on the current page.

5

RequestId

string

The request ID.

9B7BFB11-C077-4FE3-B051-F69CEB******

PageNumber

integer

The page number.

12

Items

object

DBCluster

array<object>

The list of clusters.

array<object>

VpcId

string

The VPC ID.

vpc-****************

VswitchId

string

The vSwitch ID.

vsw-***************

ExpireTime

string

The expiration time of the cluster.

Note

A specific value is returned only for Prepaid (subscription) clusters. For Postpaid (pay-as-you-go) clusters, an empty value is returned. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

2020-11-14T16:00:00Z

Expired

string

Indicates whether the cluster has expired. Valid values:

  • true

  • false

Note

This parameter is returned only for Prepaid (subscription) clusters.

false

DBNodeNumber

integer

The number of nodes.

2

CreateTime

string

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

2020-08-14T05:58:42Z

PayType

string

The billing method. Valid values:

  • Postpaid: pay-as-you-go.

  • Prepaid: subscription.

Prepaid

StoragePayType

string

The storage billing method. Valid values:

  • Postpaid: pay-as-you-go billing method based on capacity.

  • Prepaid: subscription based on storage space.

Prepaid

ServerlessType

string

The Serverless type. A value of AgileServerless indicates that the cluster is a Serverless cluster. An empty value indicates common clusters.

AgileServerless

StrictConsistency

string

Indicates whether cross-zone strong data consistency is enabled for the cluster. Valid values:

  • ON: Cross-zone strong data consistency is enabled. This applies to the Standard Edition in a three-zone deployment scenario.

  • OFF: Cross-zone strong data consistency is disabled.

ON

DBNodeClass

string

The node specifications.

polar.mysql.x4.large

Tags

object

Tag

array<object>

The list of tags.

object

Key

string

The tag key.

MySQL

Value

string

The tag value.

5.6

DBType

string

The database type.

MySQL

LockMode

string

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 expiration.

Unlock

DBNodes

object

DBNode

array<object>

The list of nodes.

object

DBNodeClass

string

The node specifications.

polar.mysql.x4.large

ZoneId

string

The zone ID.

cn-hangzhou-i

DBNodeRole

string

The node role. Valid values:

  • Writer: The primary node.

  • Reader: The read-only node.

  • ColumnReader: The column store read-only node.

  • AI: The AI node.

Reader

DBNodeId

string

The node ID.

pi-****************

RegionId

string

The region ID.

cn-hangzhou

Serverless

string

Indicates whether the Serverless feature is enabled for the current node.

  • A value of ON indicates that the Serverless feature is enabled.

  • An empty value indicates that the Serverless feature is disabled.

ON

ImciSwitch

string

Indicates whether IMCI is enabled. Valid values:

  • ON: Enabled.

  • OFF: Disabled.

Valid values:

  • OFF :

    Disabled.

  • ON :

    Enabled.

OFF

HotReplicaMode

string

Indicates whether hot standby is enabled. Valid values:

  • ON: Enabled

  • OFF: Disabled

OFF

RegionId

string

The region ID.

cn-hangzhou

DeletionLock

integer

The deletion protection status of the cluster. Valid values:

  • 0: Unlocked.

  • 1: Locked.

Note

You cannot delete a cluster that is in the Locked state.

0

DBVersion

string

The database version.

5.6

DBClusterId

string

The cluster ID.

pc-****************

DBClusterStatus

string

The cluster status.

Running

ResourceGroupId

string

The resource group ID.

rg-************

SearchStorageUsed

integer

The storage usage of the Search node.

89227945573

StorageSpace

integer

The storage space for subscription clusters billed by space. Unit: bytes.

50

DBClusterNetworkType

string

The network type of the cluster.

VPC

DBClusterDescription

string

The cluster description.

GDN-1

ZoneId

string

The zone ID.

cn-hangzhou-i

Engine

string

The cluster engine.

POLARDB

Category

string

The cluster edition. Valid values:

  • Normal: Cluster Edition

  • Basic: Single Node Edition

  • Archive: PolarDB X-Engine Edition

  • NormalMultimaster: Multi-master Cluster (Database/Table)

Normal

AiType

string

The status of the AI node information. Valid values:

  • SearchNode: Search node

  • DLNode: AI node

Valid values:

  • SearchNode|DLNode :

    Both

  • DLNode :

    DLNode

  • SearchNode :

    SearchNode

SearchNode

CpuCores

string

The number of CPU cores.

1

MemorySize

string

The memory size of the node. Unit: MB.

2048

StorageType

string

The storage type. Valid values for Enterprise Edition:

  • HighPerformance: PSL5

  • Standard: PSL4

Valid values for Standard Edition:

  • essdpl0

  • essdpl1

  • essdpl2

  • essdpl3

  • essdautopl

essdautopl

HotStandbyCluster

string

The hot standby storage cluster. Valid values:

  • ON: Enabled.

  • OFF: Disabled.

OFF

SubCategory

string

The specification type of the compute node. Valid values:

  • Exclusive: Dedicated

  • General: General-purpose

Exclusive

StorageUsed

integer

The storage space used by the cluster. Unit: bytes.

3009413120

RemoteMemorySize

string

The size of the remote memory. Unit: MB.

3612

ConnectionResourceQuota

integer

ConnectionResourceUsed

integer

The connection resources used by AgenticDB.

Examples

Success response

JSON format

{
  "TotalRecordCount": 16,
  "PageRecordCount": 5,
  "RequestId": "9B7BFB11-C077-4FE3-B051-F69CEB******",
  "PageNumber": 12,
  "Items": {
    "DBCluster": [
      {
        "VpcId": "vpc-****************",
        "VswitchId": "vsw-***************",
        "ExpireTime": "2020-11-14T16:00:00Z",
        "Expired": "false",
        "DBNodeNumber": 2,
        "CreateTime": "2020-08-14T05:58:42Z",
        "PayType": "Prepaid",
        "StoragePayType": "Prepaid",
        "ServerlessType": "AgileServerless",
        "StrictConsistency": "ON",
        "DBNodeClass": "polar.mysql.x4.large",
        "Tags": {
          "Tag": [
            {
              "Key": "MySQL",
              "Value": "5.6"
            }
          ]
        },
        "DBType": "MySQL",
        "LockMode": "Unlock",
        "DBNodes": {
          "DBNode": [
            {
              "DBNodeClass": "polar.mysql.x4.large",
              "ZoneId": "cn-hangzhou-i",
              "DBNodeRole": "Reader",
              "DBNodeId": "pi-****************",
              "RegionId": "cn-hangzhou",
              "Serverless": "ON",
              "ImciSwitch": "OFF",
              "HotReplicaMode": "OFF"
            }
          ]
        },
        "RegionId": "cn-hangzhou",
        "DeletionLock": 0,
        "DBVersion": "5.6",
        "DBClusterId": "pc-****************",
        "DBClusterStatus": "Running",
        "ResourceGroupId": "rg-************",
        "SearchStorageUsed": 89227945573,
        "StorageSpace": 50,
        "DBClusterNetworkType": "VPC",
        "DBClusterDescription": "GDN-1",
        "ZoneId": "cn-hangzhou-i",
        "Engine": "POLARDB",
        "Category": "Normal",
        "AiType": "SearchNode",
        "CpuCores": "1",
        "MemorySize": "2048",
        "StorageType": "essdautopl",
        "HotStandbyCluster": "OFF",
        "SubCategory": "Exclusive",
        "StorageUsed": 3009413120,
        "RemoteMemorySize": "3612",
        "ConnectionResourceQuota": 0,
        "ConnectionResourceUsed": 0
      }
    ]
  }
}

Error codes

HTTP status code

Error code

Error message

Description

400 InvalidRegionId.Malformed The specified parameter RegionId is not valid. The specified RegionId parameter is invalid.
400 NumberExceed.Tags The Tags parameter's number is exceed. The number of tags specified in the tags parameter exceeds the limit.
400 InvalidPageSize.Malformed The specified parameter PageSize is not valid. The specified PageSize parameter is invalid.
400 InvalidPageNumber.Malformed The specified parameter PageNumber is not valid. The specified PageNumber parameter is invalid.
400 InvalidRecentCreationInterval.Malformed The specified parameter RecentCreationInterval is not valid. The specified RecentCreationInterval parameter is invalid.
400 InvalidRecentExpirationInterval.Malformed The specified parameter RecentExpirationInterval is not valid. The specified RecentExpirationInterval parameter is invalid.
500 InternalError The request processing has failed due to some unknown error, exception or failure. The request failed to be processed because unknown errors, exceptions, or failures have occurred.
404 DBTypeOrDBVersion.Malformed The specified DBType does not match DBVersion. The specified values of DBType and DBVersion do not match.
503 ServiceUnavailable The request has failed due to a temporary failure of the server. A temporary server error occurred.

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.