You can call the DescribeDBInstanceAttribute operation to query details about an instance.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DescribeDBInstanceAttribute

The operation that you want to perform. Set the value to DescribeDBInstanceAttribute.

DBInstanceId String Yes rm-uf6wjk5*****

The ID of the instance. You can specify up to 30 instance IDs in a single request. If you specify multiple instance IDs, separate the instance IDs with commas (,).

Expired String No False

Specifies whether the instance expires. Valid values:

  • True: The instance expires.
  • False: The instance does not expire.

Response parameters

Parameter Type Example Description
RequestId String 1AD222E9-E606-4A42-BF6D-8A4442913CEF

The ID of the request.

Items Array of DBInstanceAttribute

An array that consists of the details about the instance.

DBInstanceAttribute
VpcId String vpc-*****

The ID of the virtual private cloud (VPC).

CreationTime String 2011-05-30T12:11:04Z

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

IncrementSourceDBInstanceId String rm-uf6wjk5*****

The ID of the instance from which incremental data comes. The incremental data of a disaster recovery instance or read-only instance comes from its primary instance. If this parameter is not returned, the instance is a primary instance.

MaintainTime String 00:00Z-02:00Z

The maintenance window of the instance. The time is displayed in UTC. Take note that the maintenance window displayed in the ApsaraDB RDS console is equal to the value of this parameter plus 8 hours.

PayType String Postpaid

The billing method of the instance. Valid values:

  • Postpaid: pay-as-you-go
  • Prepaid: subscription
AvailabilityValue String 100.0%

The availability status of the instance in percentage.

EngineVersion String 5.5

The database engine version of the instance.

DedicatedHostGroupId String dhg-7a9*****

The ID of the dedicated cluster to which the instance belongs.

ConnectionString String rm-uf6wjk5*****.mysql.rds.aliyuncs.com

The internal endpoint of the instance.

SuperPermissionMode String Disabled

Indicates whether the instance supports superuser accounts, such as the system administrator (SA) account, the Active Directory (AD) account, and the host account.

  • Enable: Superuser accounts are supported.
  • Disabled: Superuser accounts are not supported.
InstanceNetworkType String Classic

The network type of the instance. Valid values:

  • Classic: classic network
  • VPC: VPC
MasterInstanceId String rm-uf6wjk5*****

The ID of the primary instance.

Note If this parameter is not returned, the instance is the primary instance.
AutoUpgradeMinorVersion String Auto

The method that is used to update the minor engine version of the instance. Valid values:

  • Auto: automatic update.
  • Manual: manual update. ApsaraDB RDS automatically updates the current minor engine version of the instance only when the current minor engine version is phased out.
ExpireTime String 2019-03-27T16:00:00Z

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

Note Pay-as-you-go instances never expire.
AccountMaxQuantity Integer 50

The maximum number of accounts that can be created on the instance.

MasterZone String 5454284

The zone ID of the primary instance.

GuardDBInstanceId String rm-uf64zsu*****

The ID of the disaster recovery instance that is attached to the instance.

DBInstanceStorage Integer 10

The storage capacity of the instance. Unit: GB.

TimeZone String Central Standard Time

The time zone of the instance.

LatestKernelVersion String rds_20201031

The latest minor engine version that is supported by the instance.

TipsLevel Integer 1

The severity level of the exception that is detected on the instance. This parameter is returned only when the instance is created in an ApsaraDB MyBase cluster that runs MySQL on Standard Edition. Valid values:

  • 1: The instance is normal.
  • 2: The specifications of the read-only instances do not match the specifications of the primary instance. You must adjust the specifications of these instances based on your business requirements.
ZoneId String cn-hangzhou-a

The zone ID of the instance.

MaxConnections Integer 60

The maximum number of concurrent connections that are allowed by the instance.

DBInstanceId String rm-uf6wjk5*****

The ID of the instance.

TempDBInstanceId String rm-uf64zsu*****

The ID of the temporary instance that is attached to the instance.

AdvancedFeatures String LinkedServer

The advanced features that are enabled for the instance. If multiple advanced features are enabled, the advanced features are separated by commas (,). This parameter is available only to instances that run SQL Server. Valid values:

  • LinkedServer
  • DistributeTransaction
DBInstanceStorageType String local_ssd

The storage type of the instance. Valid values:

  • local_ssd and ephemeral_ssd: local SSD
  • cloud_ssd: standard SSD
  • cloud_essd: enhanced SSD
DBInstanceMemory Long 4096

The memory capacity of the instance. Unit: MB.

IPType String IPv4

The type of the IP address. Only IPv4 addresses are supported.

ConsoleVersion String 2

The type of the proxy that is used by the instance. Valid values:

  • 1: shared proxy
  • 2: dedicated proxy
Note We recommend that you use the ProxyType parameter instead of this parameter.
ConnectionMode String Standard

The connection mode of the instance. Valid values:

  • Standard: standard mode
  • Safe: proxy mode
Port String 3306

The internal port number that is used to connect to the instance.

LockMode String Unlock

The lock mode of the instance. Valid values:

  • Unlock: The instance is not locked.
  • ManualLock: The instance is manually locked.
  • LockByExpiration: The instance is automatically locked due to instance expiration.
  • LockByRestoration: The instance is automatically locked due to instance restoration.
  • LockByDiskQuota: The instance is automatically locked due to exhausted storage.
  • LockReadInstanceByDiskQuota: The instance is a read-only instance that is automatically locked when the disk space is full.
GeneralGroupName String TestGroup

The name of the dedicated cluster to which the instance belongs. This parameter is returned only when the instance is created in an ApsaraDB MyBase cluster that runs MySQL on Standard Edition.

VpcCloudInstanceId String vpc-23rsxdf*****

The VPC ID of the instance. This parameter is returned only when the instance resides in a VPC.

Collation String Chinese_PRC_CI_AS

The character set collation of the instance.

MaxIOPS Integer 150

The maximum number of I/O requests that can be processed by the instance per second.

MaxIOMBPS Integer 0MB/s

The maximum I/O throughput. Unit: MB/s.

Tips String Everything is fine.

The information about the exception that is detected on the instance. This parameter is returned only when the instance is created in an ApsaraDB MyBase cluster that runs MySQL on Standard Edition.

SecurityIPList String 192.168.XX.XX/24

The IP addresses in the IP address whitelist.

SecurityIPMode String normal

The whitelist mode of the instance. Valid values:

  • normal: standard whitelist mode
  • safety: enhanced whitelist mode
DBInstanceClassType String s

The instance family to which the instance belongs. Valid values:

  • s: shared instance family
  • x: general-purpose instance family
  • d: dedicated instance family
  • h: dedicated host instance family
ProxyType Integer 1

The type of the proxy that is supported by the instance. Valid values:

  • 0: The instance does not support database proxies.
  • 1: The instance supports shared proxies, with which the instance runs in multi-tenant mode.
  • 2: The instance supports dedicated proxies, with which the instance runs in single-tenant mode.
CurrentKernelVersion String rds_20181010

The minor engine version of the instance.

DBInstanceDescription String Test database

The description of the instance.

DBInstanceCPU String 2

The number of cores that are configured for the instance.

DBInstanceNetType String Internet

The type of the network over which the instance is connected. Valid values:

  • Internet: Internet
  • Intranet: internal network
DBInstanceType String Primary

The type of the instance. Valid values:

  • Primary: primary instance
  • Readonly: read-only instance
  • Guard: disaster recovery instance
  • Temp: temporary instance
LockReason String instance_expired

The reason why the instance is locked.

DBInstanceStatus String Running

The status of the instance. For more information, see Instance state table.

DBMaxQuantity Integer 200

The maximum number of databases that can be created on the instance.

RegionId String cn-hangzhou

The region ID of the instance.

ReadonlyInstanceSQLDelayedTime String 30

The latency at which the system replicates data to read-only instances. The system replicates data from the primary instance to the read-only instances at the latency that is specified by the ReadonlyInstanceSQLDelayedTime parameter. Unit: seconds.

VSwitchId String vsw-*****

The ID of the vSwitch.

ResourceGroupId String rg-acfmy*****

The ID of the resource group.

Category String Basic

The RDS edition of the instance. Valid values:

  • Basic: RDS Basic Edition
  • HighAvailability: RDS High-availability Edition

  • AlwaysOn: RDS Cluster Edition for SQL Server
  • Finance: RDS Enterprise Edition
  • Serverless_basic: RDS Serverless Basic Edition
DBInstanceClass String rds.mys2.small

The instance type of the instance. For more information, see Primary ApsaraDB RDS instance types.

Engine String MySQL

The database engine of the instance. Valid values:

  • MySQL
  • PostgreSQL
  • SQLServer
  • MariaDB
SlaveZones Array of SlaveZone

An array that consists of the details about the secondary zones.

SlaveZone
ZoneId String cn-hangzhou-a

The ID of the zone.

ReadOnlyDBInstanceIds Array of ReadOnlyDBInstanceId

An array that consists of the IDs of the read-only instances attached to the primary instance.

ReadOnlyDBInstanceId
DBInstanceId String rm-bp*****

The ID of the read-only RDS instance.

Extra Object

The extended information of the instance.

DBInstanceIds Array of String rm-uf6wjk5*****

The ID of the instance.

DeletionProtection Boolean true

Indicates whether the release protection feature is enabled. Valid values:

  • true: The feature is enabled.
  • false: The feature is disabled.
ServerlessConfig Object

The settings of the serverless instance.

ScaleMin double 0.5

The minimum number of RDS Capacity Units (RCUs).

ScaleMax double 8

The maximum number of RCUs.

AutoPause Boolean true

Indicates whether the automatic start and stop feature is enabled for the serverless instance. Valid values:

  • true: The feature is enabled.
  • false: The feature is disabled. This is the default value.
Note After the start and stop feature is enabled, if no connections to the instance are established within 10 minutes, the instance is suspended. After a connection is established to the instance, the instance is automatically resumed.
SwitchForce Boolean false

Indicates whether the forced scaling feature is enabled for the serverless instance.

  • true: The feature is enabled.
  • false: The feature is disabled. This is the default value.
Note In most cases, ApsaraDB RDS automatically scales in or out the RCUs of a serverless instance based on business requirements in real time. In some cases, the scaling does not take effect in real time. You can enable the forced scaling feature to forcefully scales in or out the RCUs of the instance.
BabelfishConfig Object

The configuration of Babelfish for the instance.

Note This parameter is suitable only for ApsaraDB RDS for PostgreSQL instances for which Babelfish is enabled. For more information, see Introduction to Babelfish.
BabelfishEnabled String true

The switch to enable or disable Babelfish.

Note If Babelfish is enabled when you purchase an ApsaraDB RDS for PostgreSQL instance, this parameter is fixed as true.
MigrationMode String single-db

The migration mode for Babelfish. Valid values:

  • single-db
  • multi-db
Note For more information about migration modes for Babelfish, see Migration modes.
kindCode String None

An internal parameter. This operation does not return a value for this parameter.

InstructionSetArch String x86

The architecture type of the instance. Valid values:

  • x86
  • arm
DBClusterNodes Array of DBClusterNode

The information about the node in the cluster.

DBClusterNode
NodeRegionId String cn-beijing

The ID of the region.

NodeZoneId String cn-beijing-h

The zone ID of the instance.

NodeId String rn-****

The ID of the node.

NodeRole String primary

The role of the node. Valid values:

  • primary: primary node
  • secondary: secondary node
ClassCode String mysql.n2.medium.xc

The node type of the node.

Examples

Sample requests

http(s)://rds.aliyuncs.com/?Action=DescribeDBInstanceAttribute
&DBInstanceId=rm-uf6wjk5*****
&Expired=False
&Common request parameters

Sample success responses

XML format

HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeDBInstanceAttributeResponse>
    <RequestId>1AD222E9-E606-4A42-BF6D-8A4442913CEF</RequestId>
    <Items>
        <VpcId>vpc-*****</VpcId>
        <CreationTime>2011-05-30T12:11:04Z</CreationTime>
        <IncrementSourceDBInstanceId>rm-uf6wjk5*****</IncrementSourceDBInstanceId>
        <MaintainTime>00:00Z-02:00Z</MaintainTime>
        <PayType>Postpaid</PayType>
        <AvailabilityValue>100.0%</AvailabilityValue>
        <EngineVersion>5.5</EngineVersion>
        <DedicatedHostGroupId>dhg-7a9*****</DedicatedHostGroupId>
        <ConnectionString>rm-uf6wjk5*****.mysql.rds.aliyuncs.com</ConnectionString>
        <SuperPermissionMode>Disabled</SuperPermissionMode>
        <InstanceNetworkType>Classic</InstanceNetworkType>
        <MasterInstanceId>rm-uf6wjk5*****</MasterInstanceId>
        <AutoUpgradeMinorVersion>Auto</AutoUpgradeMinorVersion>
        <ExpireTime>2019-03-27T16:00:00Z</ExpireTime>
        <AccountMaxQuantity>50</AccountMaxQuantity>
        <MasterZone>5454284</MasterZone>
        <GuardDBInstanceId>rm-uf64zsu*****</GuardDBInstanceId>
        <DBInstanceStorage>10</DBInstanceStorage>
        <TimeZone>Central Standard Time</TimeZone>
        <LatestKernelVersion>rds_20201031</LatestKernelVersion>
        <TipsLevel>1</TipsLevel>
        <ZoneId>cn-hangzhou-a</ZoneId>
        <MaxConnections>60</MaxConnections>
        <DBInstanceId>rm-uf6wjk5*****</DBInstanceId>
        <TempDBInstanceId>rm-uf64zsu*****</TempDBInstanceId>
        <AdvancedFeatures>LinkedServer</AdvancedFeatures>
        <DBInstanceStorageType>local_ssd</DBInstanceStorageType>
        <DBInstanceMemory>4096</DBInstanceMemory>
        <IPType>IPv4</IPType>
        <ConsoleVersion>2</ConsoleVersion>
        <ConnectionMode>Standard</ConnectionMode>
        <Port>3306</Port>
        <LockMode>Unlock</LockMode>
        <GeneralGroupName>TestGroup</GeneralGroupName>
        <VpcCloudInstanceId>vpc-23rsxdf*****</VpcCloudInstanceId>
        <Collation>Chinese_PRC_CI_AS</Collation>
        <MaxIOPS>150</MaxIOPS>
        <Tips>Run as normal</Tips>
        <SecurityIPList>192.168.XX.XX/24</SecurityIPList>
        <SecurityIPMode>normal</SecurityIPMode>
        <DBInstanceClassType>s</DBInstanceClassType>
        <ProxyType>1</ProxyType>
        <CurrentKernelVersion>rds_20181010</CurrentKernelVersion>
        <DBInstanceDescription>Test database</DBInstanceDescription>
        <DBInstanceCPU>2</DBInstanceCPU>
        <DBInstanceNetType>Internet</DBInstanceNetType>
        <DBInstanceType>Primary</DBInstanceType>
        <LockReason>instance_expired</LockReason>
        <DBInstanceStatus>Running</DBInstanceStatus>
        <DBMaxQuantity>200</DBMaxQuantity>
        <RegionId>cn-hangzhou </RegionId>
        <ReadonlyInstanceSQLDelayedTime>30</ReadonlyInstanceSQLDelayedTime>
        <VSwitchId>vsw-*****</VSwitchId>
        <ResourceGroupId>rg-acfmy*****</ResourceGroupId>
        <Category>Basic</Category>
        <DBInstanceClass>rds.mys2.small</DBInstanceClass>
        <Engine>MySQL</Engine>
        <SlaveZones>
            <ZoneId>cn-hangzhou-a</ZoneId>
        </SlaveZones>
        <ReadOnlyDBInstanceIds>
            <DBInstanceId>rm-bp*****</DBInstanceId>
        </ReadOnlyDBInstanceIds>
        <Extra>
            <DBInstanceIds>rm-uf6wjk5*****</DBInstanceIds>
        </Extra>
        <DeletionProtection>true</DeletionProtection>
        <ServerlessConfig>
            <ScaleMin>0.5</ScaleMin>
            <ScaleMax>8</ScaleMax>
            <AutoPause>true</AutoPause>
            <SwitchForce>false</SwitchForce>
        </ServerlessConfig>
        <BabelfishConfig>
            <BabelfishEnabled>true</BabelfishEnabled>
            <MigrationMode>single-db</MigrationMode>
        </BabelfishConfig>
        <kindCode>None</kindCode>
        <InstructionSetArch>x86</InstructionSetArch>
        <DBClusterNodes>
            <NodeRegionId>cn-beijing</NodeRegionId>
            <NodeZoneId>cn-beijing-h</NodeZoneId>
            <NodeId>rn-****</NodeId>
            <NodeRole>primary</NodeRole>
            <ClassCode>mysql.n2.medium.xc</ClassCode>
        </DBClusterNodes>
    </Items>
</DescribeDBInstanceAttributeResponse>

JSON format

HTTP/1.1 200 OK
Content-Type:application/json

{
  "RequestId" : "1AD222E9-E606-4A42-BF6D-8A4442913CEF",
  "Items" : [ {
    "VpcId" : "vpc-*****",
    "CreationTime" : "2011-05-30T12:11:04Z",
    "IncrementSourceDBInstanceId" : "rm-uf6wjk5*****",
    "MaintainTime" : "00:00Z-02:00Z",
    "PayType" : "Postpaid",
    "AvailabilityValue" : "100.0%",
    "EngineVersion" : "5.5",
    "DedicatedHostGroupId" : "dhg-7a9*****",
    "ConnectionString" : "rm-uf6wjk5*****.mysql.rds.aliyuncs.com",
    "SuperPermissionMode" : "Disabled",
    "InstanceNetworkType" : "Classic",
    "MasterInstanceId" : "rm-uf6wjk5*****",
    "AutoUpgradeMinorVersion" : "Auto",
    "ExpireTime" : "2019-03-27T16:00:00Z",
    "AccountMaxQuantity" : 50,
    "MasterZone" : "5454284",
    "GuardDBInstanceId" : "rm-uf64zsu*****",
    "DBInstanceStorage" : 10,
    "TimeZone" : "Central Standard Time",
    "LatestKernelVersion" : "rds_20201031",
    "TipsLevel" : 1,
    "ZoneId" : "cn-hangzhou-a",
    "MaxConnections" : 60,
    "DBInstanceId" : "rm-uf6wjk5*****",
    "TempDBInstanceId" : "rm-uf64zsu*****",
    "AdvancedFeatures" : "LinkedServer",
    "DBInstanceStorageType" : "local_ssd",
    "DBInstanceMemory" : 4096,
    "IPType" : "IPv4",
    "ConsoleVersion" : "2",
    "ConnectionMode" : "Standard",
    "Port" : "3306",
    "LockMode" : "Unlock",
    "GeneralGroupName" : "TestGroup",
    "VpcCloudInstanceId" : "vpc-23rsxdf*****",
    "Collation" : "Chinese_PRC_CI_AS",
    "MaxIOPS" : 150,
    "Tips" : "Run as normal",
    "SecurityIPList" : "192.168.XX.XX/24",
    "SecurityIPMode" : "normal",
    "DBInstanceClassType" : "s",
    "ProxyType" : 1,
    "CurrentKernelVersion" : "rds_20181010",
    "DBInstanceDescription": "Test database",
    "DBInstanceCPU" : "2",
    "DBInstanceNetType" : "Internet",
    "DBInstanceType" : "Primary",
    "LockReason" : "instance_expired",
    "DBInstanceStatus" : "Running",
    "DBMaxQuantity" : 200,
    "RegionId" : "cn-hangzhou ",
    "ReadonlyInstanceSQLDelayedTime" : "30",
    "VSwitchId" : "vsw-*****",
    "ResourceGroupId" : "rg-acfmy*****",
    "Category" : "Basic",
    "DBInstanceClass" : "rds.mys2.small",
    "Engine" : "MySQL",
    "SlaveZones" : [ {
      "ZoneId" : "cn-hangzhou-a"
    } ],
    "ReadOnlyDBInstanceIds" : [ {
      "DBInstanceId" : "rm-bp*****"
    } ],
    "Extra" : {
      "DBInstanceIds" : [ "rm-uf6wjk5*****" ]
    },
    "DeletionProtection" : true,
    "ServerlessConfig" : {
      "ScaleMin" : 0.5,
      "ScaleMax" : 8,
      "AutoPause" : true,
      "SwitchForce" : false
    },
    "BabelfishConfig" : {
      "BabelfishEnabled" : "true",
      "MigrationMode" : "single-db"
    },
    "kindCode" : "None",
    "InstructionSetArch" : "x86",
    "DBClusterNodes" : [ {
      "NodeRegionId" : "cn-beijing",
      "NodeZoneId" : "cn-beijing-h",
      "NodeId" : "rn-****",
      "NodeRole" : "primary",
      "ClassCode" : "mysql.n2.medium.xc"
    } ]
  } ]
}

Error codes

HTTP status code Error code Error message Description
400 ConnectTimeoutRetryLater Connect timeout retry later. The error message returned because the connection to the instance timed out. Try again later.
400 DataNotExist Data not exist. The error message returned because no data is available.

For a list of error codes, see Service error codes.