You can call the DescribeDBInstanceAttribute operation to query details about an instance.
Debugging
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:
|
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:
|
| 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.
|
| InstanceNetworkType | String | Classic | The network type of the instance. Valid values:
|
| 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:
|
| 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:
|
| 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:
|
| DBInstanceStorageType | String | local_ssd | The storage type of the instance. Valid values:
|
| 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:
Note We recommend that you use the ProxyType parameter instead of this parameter. |
| ConnectionMode | String | Standard | The connection mode of the instance. Valid values:
|
| 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:
|
| 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:
|
| DBInstanceClassType | String | s | The instance family to which the instance belongs. Valid values:
|
| ProxyType | Integer | 1 | The type of the proxy that is supported by the instance. Valid values:
|
| 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:
|
| DBInstanceType | String | Primary | The type of the instance. Valid values:
|
| 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:
|
| 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:
|
| 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:
|
| 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:
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.
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:
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:
|
| 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:
|
| 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.