配置同步任务

1. 接口描述

接口请求域名： dts.tencentcloudapi.com 。

配置一个同步任务

默认接口请求频率限制：20次/秒。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数，完整公共参数列表见 公共请求参数。

3. 输出参数

4. 示例

示例1 配置同步任务

配置一个同步整库的同步任务

输入示例

POST / HTTP/1.1
Host: dts.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: ConfigureSyncJob
<公共请求参数>

{
    "DstInfo": {
        "Ip": "9.123.210.46",
        "Password": "Test1234",
        "User": "root",
        "Port": 30654
    },
    "SrcInfo": {
        "Ip": "9.123.211.23",
        "Password": "Test1234",
        "User": "root",
        "Port": "30645"
    },
    "ExpectRunTime": "0000-00-00 00:00:01",
    "DstAccessType": "noProxy",
    "JobName": "truexu-api",
    "RunMode": "Immediate",
    "Objects": {
        "Mode": "Partial",
        "Databases": [
            {
                "DbName": "db1",
                "DbMode": "All",
                "TableMode": "All",
                "Tables": null,
                "ViewMode": "All",
                "Views": null,
                "FunctionMode": "All",
                "TriggerMode": "",
                "EventMode": "",
                "ProcedureMode": "All",
                "Functions": null,
                "Procedures": null,
                "Events": null,
                "Triggers": null
            }
        ]
    },
    "JobId": "sync-7r1cz016",
    "Options": {
        "DealOfExistSameTable": "ExecuteAfterIgnore",
        "OpTypes": [
            "Update"
        ],
        "DdlOptions": [
            {
                "DdlObject": "Database",
                "DdlValue": [
                    "Create",
                    "Alter"
                ]
            }
        ],
        "InitType": "Full",
        "ConflictHandleOption": {
            "ConditionColumn": "ts",
            "ConditionOperator": ">",
            "ConditionOrderInSrcAndDst": "<"
        }
    },
    "SrcAccessType": "noProxy"
}

输出示例

{
    "Response": {
        "RequestId": "8d495a08-5f8f-411b-ae4d-cc6da2475b9c"
    }
}

示例2 配置同步任务2

配置一个同步包含条件覆盖的任务

输入示例

POST / HTTP/1.1
Host: dts.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: ConfigureSyncJob
<公共请求参数>

{
    "DstInfo": {
        "Ip": "100.88.178.199",
        "Password": "Test1234",
        "User": "root",
        "Port": 20152
    },
    "SrcInfo": {
        "Ip": "100.88.166.23",
        "Password": "Test1234",
        "User": "root",
        "Port": "20126"
    },
    "ExpectRunTime": "2021-12-08 11:59:05",
    "DstAccessType": "noProxy",
    "JobName": "truex",
    "RunMode": "Immediate",
    "Objects": {
        "Mode": "Partial",
        "Databases": [
            {
                "Tables": [
                    {
                        "FilterCondition": "id>1",
                        "TableName": "tb1",
                        "NewTableName": "tb2"
                    }
                ],
                "Views": [
                    {
                        "ViewName": "vw1",
                        "NewViewName": "vw2"
                    }
                ],
                "DbName": "db1",
                "ViewMode": "Partial",
                "TableMode": "Partial",
                "DbMode": "Partial"
            }
        ]
    },
    "JobId": "sync-31t047r6",
    "Options": {
        "DdlOptions": [
            {
                "DdlObject": "Database",
                "DdlValue": [
                    "Drop"
                ]
            }
        ],
        "ConflictHandleType": "ReportError",
        "DealOfExistSameTable": "ReportErrorAfterCheck",
        "ConflictHandleOption": {
            "ConditionColumn": "ts",
            "ConditionOperator": ">",
            "ConditionOrderInSrcAndDst": ">"
        },
        "InitType": "Full",
        "OpTypes": [
            "Insert",
            "Update"
        ],
        "AddAdditionalColumn": "false"
    },
    "SrcAccessType": "noProxy"
}

输出示例

{
    "Response": {
        "RequestId": "59dd9972-00e7-4ce3-8f33-72d13bc64400"
    }
}

5. 开发者资源

腾讯云 API 平台

腾讯云 API 平台 是综合 API 文档、错误码、API Explorer 及 SDK 等资源的统一查询平台，方便您从同一入口查询及使用腾讯云提供的所有 API 服务。

API Inspector

用户可通过 API Inspector 查看控制台每一步操作关联的 API 调用情况，并自动生成各语言版本的 API 代码，也可前往 API Explorer 进行在线调试。

SDK

云 API 3.0 提供了配套的开发工具集（SDK），支持多种编程语言，能更方便的调用 API。

• Tencent Cloud SDK 3.0 for Python: GitHub Gitee
• Tencent Cloud SDK 3.0 for Java: GitHub Gitee
• Tencent Cloud SDK 3.0 for PHP: GitHub Gitee
• Tencent Cloud SDK 3.0 for Go: GitHub Gitee
• Tencent Cloud SDK 3.0 for Node.js: GitHub Gitee
• Tencent Cloud SDK 3.0 for .NET: GitHub Gitee
• Tencent Cloud SDK 3.0 for C++: GitHub Gitee
• Tencent Cloud SDK 3.0 for Ruby: GitHub Gitee

命令行工具

• Tencent Cloud CLI 3.0

6. 错误码

以下仅列出了接口业务逻辑相关的错误码，其他错误码详见 公共错误码。