查询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授权再进行操作。

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

     </article>
  </main>