查询DRDS下水平拆分数据库

调试

您可以在OpenAPI Explorer中直接运行该接口，免去您计算签名的困扰。运行成功后，OpenAPI Explorer可以自动生成SDK代码示例。

请求参数

名称 类型 是否必选 示例值 描述
Action String 是 DescribeDrdsShardingDbs

系统规定参数。取值：DescribeDrdsShardingDbs。
DbName String 是 drds_test

DRDS 实例的 DBName。
DrdsInstanceId String 是 drdshbgaf3c63qbo

DRDS 实例ID。
AccessKeyId String 否 test

AccessKey ID。
DbNamePattern String 否 test

DbName 匹配格式。

返回数据

名称 类型 示例值 描述
RequestId String 509BDE17-505A-4B3B-854D-30D3F092502F

请求ID。
ShardingDbs

返回结果。
ShardingDb

返回结果。
BlockingTimeout Integer 5000

控制事务为获取锁而需要等待的时长。
ConnectUrl String 100.100.64.100:11569

连接url。
ConnectionProperties String connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8

连接串属性。
DbInstanceId String rm-bp1hjzn0yv5j2sfpv

RDS实例ID。
DbStatus String running

数据库状态。
DbType String mysql

数据库类型。
GroupName String TEMP1_1568171495522SABE_KUP4_0000

物理分片名称。
IdleTimeOut Integer 30

空闲超时时间。
MaxPoolSize Integer 60

连接池最大个数。
MinPoolSize Integer 5

连接池最小个数。
PreparedStatementCacheSize Integer 0

结果缓存大小。
ShardingDbName String temp1_zhk1_0000

物理分库名。
UserName String pg284mi8

连RDS用户名。
Success Boolean true

是否成功。

示例

请求示例


http(s)://[Endpoint]/?Action=DescribeDrdsShardingDbs
&DbName=drds_test
&DrdsInstanceId=drdshbgaf3c63qbo
&<公共请求参数>

正常返回示例

XML 格式 

<DescribeDrdsShardingDbsResponse>
      <RequestId>509BDE17-505A-4B3B-854D-30D3F092502F</RequestId>
      <ShardingDbs>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0000</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0000</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0001</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0001</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0002</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0002</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0003</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0003</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0004</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0004</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0005</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0005</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0006</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0006</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
            <ShardingDb>
                  <ShardingDbName>temp1_zhk1_0007</ShardingDbName>
                  <GroupName>TEMP1_1568171495522SABE_KUP4_0007</GroupName>
                  <MinPoolSize>5</MinPoolSize>
                  <IdleTimeOut>30</IdleTimeOut>
                  <DbStatus>RW</DbStatus>
                  <MaxPoolSize>60</MaxPoolSize>
                  <UserName>pg284mi8</UserName>
                  <ConnectUrl>100.100.64.101:11569</ConnectUrl>
                  <DbType>mysql</DbType>
                  <DbInstanceId>rm-bp1hjzn0yv5j2sfpv</DbInstanceId>
                  <BlockingTimeout>5000</BlockingTimeout>
                  <PreparedStatementCacheSize>0</PreparedStatementCacheSize>
                  <ConnectionProperties>connectTimeout=3000;autoReconnect=true;failOverReadOnly=false;socketTimeout=900000;rewriteBatchedStatements=true;characterEncoding=utf8</ConnectionProperties>
            </ShardingDb>
      </ShardingDbs>
      <Success>true</Success>
</DescribeDrdsShardingDbsResponse>

错误码

HttpCode 错误码 错误信息 描述
400 ActionUnauthorized The specified action is not available for you 指定的action未授权，请您先做RAM授权再进行操作。

访问错误中心查看更多错误码。