DescribeDrdsShardingDbs
查询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授权再进行操作。 |
访问错误中心查看更多错误码。
版权声明
本文仅代表作者观点,不代表本站立场。
本文系作者授权发表,未经许可,不得转载。
评论