通过DescribeSynchronizationJobs查询数据同步实例列表和各同步实例的详情。
调试
您可以在OpenAPI Explorer中直接运行该接口,免去您计算签名的困扰。运行成功后,OpenAPI Explorer可以自动生成SDK代码示例。
请求参数
名称 | 类型 | 是否必选 | 示例值 | 描述 |
---|
名称 | 类型 | 是否必选 | 示例值 | 描述 |
---|---|---|---|---|
Action | String | 是 | DescribeSynchronizationJobs |
系统规定参数,取值:DescribeSynchronizationJobs。 |
Tag.N.Key | String | 是 | testkey1 |
标签键,可以通过调用ListTagResources接口查询。
|
RegionId | String | 否 | cn-hangzhou |
数据同步实例所在地域的ID,详情请参见支持的地域列表。 |
PageSize | Integer | 否 | 30 |
每页记录数,取值: 30、50、100,默认值为30。 |
PageNum | Integer | 否 | 1 |
页码,取值为大于0且不超过Integer数据类型的最大值,默认值为1。 |
SynchronizationJobName | String | 否 | MySQL同步 |
同步实例名称。 支持模糊查询。
|
ClientToken | String | 否 | 0c593ea1-3bea-11e9-b96b-88e9fe63**** |
保证请求幂等性。从您的客户端生成一个参数值,确保不同请求间该参数值唯一。ClientToken只支持ASCII字符,且不能超过64个字符。 |
AccountId | String | 否 | 12323344**** |
阿里云主账号ID,无需设置,该参数即将下线。 |
Tag.N.Value | String | 否 | testvalue1 |
标签的值,可以通过调用ListTagResources接口查询。
|
返回数据
示例
请求示例
http(s)://dts.aliyuncs.com/?Action=DescribeSynchronizationJobs
&Tag.1.Key=testkey1
&<公共请求参数>
正常返回示例
XML
格式
<DescribeSynchronizationJobsResponse>
<TotalRecordCount>100</TotalRecordCount>
<SynchronizationInstances>
<Status>synchronizing</Status>
<SynchronizationObjects>
<SchemaName>dtstestdatabase</SchemaName>
<NewSchemaName>newdtstestdatabase</NewSchemaName>
</SynchronizationObjects>
<DataInitializationStatus>
<Status>Finished</Status>
<Progress>200001</Progress>
<Percent>100</Percent>
</DataInitializationStatus>
<SynchronizationJobName>MySQL同步</SynchronizationJobName>
<InstanceCreateTime>2021-06-28T09:36:32Z</InstanceCreateTime>
<CreateTime>2021-06-28 17:34:53.0</CreateTime>
<JobCreateTime>2021-06-28T09:34:53Z</JobCreateTime>
<PayType>PostPaid</PayType>
<Delay>0</Delay>
<PrecheckStatus>
<Status>Finished</Status>
<Percent>100</Percent>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_CONN_SRC</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_AUTH_SRC</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_CONN_DEST</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_AUTH_DEST</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_BINLOG_ON</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_BINLOG_MODE</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_BINLOG_ROW_IMAGE</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_SERVER_ID</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_BINLOG_EXIST</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_ENGINE</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_MYSQL_PASSOWRD_FORMAT</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_SRC</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_SAME_OBJ</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_SQL_MODE</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_SAME_USER</ItemName>
</Detail>
<Detail>
<CheckStatus>Success</CheckStatus>
<ItemName>CHECK_TOPOLOGY</ItemName>
</Detail>
</PrecheckStatus>
<SynchronizationJobId>dtsexjk1alb116lbf1</SynchronizationJobId>
<DataInitialization>true</DataInitialization>
<DestinationEndpoint>
<InstanceId>rm-bp162d4tp0500****</InstanceId>
<InstanceType>RDS</InstanceType>
<EngineName>MySQL</EngineName>
</DestinationEndpoint>
<SourceEndpoint>
<InstanceId>rm-bp1i99e8l7913****</InstanceId>
<InstanceType>RDS</InstanceType>
<EngineName>MySQL</EngineName>
</SourceEndpoint>
<StructureInitialization>true</StructureInitialization>
<ExpireTime>2021-07-07T16:00:00Z</ExpireTime>
<Performance>
<RPS>0</RPS>
<FLOW>0.00MB/s</FLOW>
</Performance>
<SynchronizationJobClass>large</SynchronizationJobClass>
<DataSynchronizationStatus></DataSynchronizationStatus>
<StructureInitializationStatus>
<Status>Finished</Status>
<Progress>1</Progress>
<Percent>100</Percent>
</StructureInitializationStatus>
</SynchronizationInstances>
<PageRecordCount>30</PageRecordCount>
<RequestId>92E1E99D-5224-4AD3-8C94-23A3516B****</RequestId>
<PageNumber>1</PageNumber>
</DescribeSynchronizationJobsResponse>
JSON
格式
{
"TotalRecordCount": 100,
"SynchronizationInstances": [
{
"Status": "synchronizing",
"SynchronizationObjects": [
{
"TableIncludes": [],
"TableExcludes": [],
"SchemaName": "dtstestdatabase",
"NewSchemaName": "newdtstestdatabase"
}
],
"DataInitializationStatus": {
"Status": "Finished",
"Progress": "200001",
"Percent": "100"
},
"SynchronizationJobName": "MySQL同步",
"InstanceCreateTime": "2021-06-28T09:36:32Z",
"CreateTime": "2021-06-28 17:34:53.0",
"JobCreateTime": "2021-06-28T09:34:53Z",
"PayType": "PostPaid",
"Delay": "0",
"PrecheckStatus": {
"Status": "Finished",
"Percent": "100",
"Detail": [
{
"CheckStatus": "Success",
"ItemName": "CHECK_CONN_SRC"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_AUTH_SRC"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_CONN_DEST"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_AUTH_DEST"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_BINLOG_ON"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_BINLOG_MODE"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_BINLOG_ROW_IMAGE"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_SERVER_ID"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_BINLOG_EXIST"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_ENGINE"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_MYSQL_PASSOWRD_FORMAT"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_SRC"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_SAME_OBJ"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_SQL_MODE"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_SAME_USER"
},
{
"CheckStatus": "Success",
"ItemName": "CHECK_TOPOLOGY"
}
]
},
"SynchronizationJobId": "dtsexjk1alb116lbf1",
"DataInitialization": true,
"DestinationEndpoint": {
"InstanceId": "rm-bp162d4tp0500****",
"InstanceType": "RDS",
"EngineName": "MySQL"
},
"SourceEndpoint": {
"InstanceId": "rm-bp1i99e8l7913****",
"InstanceType": "RDS",
"EngineName": "MySQL"
},
"StructureInitialization": true,
"ExpireTime": "2021-07-07T16:00:00Z",
"Performance": {
"RPS": "0",
"FLOW": "0.00MB/s"
},
"SynchronizationJobClass": "large",
"Tags": [],
"DataSynchronizationStatus": {},
"StructureInitializationStatus": {
"Status": "Finished",
"Progress": "1",
"Percent": "100"
}
}
],
"PageRecordCount": 30,
"RequestId": "92E1E99D-5224-4AD3-8C94-23A3516B****",
"PageNumber": 1
}
错误码
访问错误中心查看更多错误码。