CreateTransmissionTask--数据库传输服务-火山引擎

文档中心

立即注册

导航

CreateTransmissionTask

最近更新时间：2025.10.27 16:49:40首次发布时间：2023.03.29 20:39:53

调用 CreateTransmissionTask 接口创建数据库传输服务任务。

请求类型

同步请求。

请求参数

名称	类型	是否必选	示例值	描述
TaskName	String	是	Test****	任务名称。命名规则：以中文或字母开头且不能为空。长度需在 64 个字符内。只能包含中文、字母、数字、下划线（_）和中划线（-）。
TaskType	String	是	DataMigration	任务类型。取值如下： `DataMigration`：表示创建数据迁移任务。 `DataSubscription`：表示创建数据订阅任务。 `DataSynchronization`：表示创建数据同步任务。 `DataSynchronization`：表示创建数据同步任务。说明目前仅支持创建公网自建 MySQL/专有网络 MySQl 至火山引擎版 MySQL 的数据迁移评估任务。
SrcConfig	DataSource	是	请参见请求示例。	源库信息。详细信息，请参见 DataSource。
DestConfig	DataSource	是	请参见请求示例。	目标库信息。详细信息，请参见 DataSource。
SolutionSettings	SolutionSetting	是	请参见请求示例。	迁移、订阅、同步或评估任务对象的配置信息。详细信息，请参见 SolutionSetting。
TrafficSpec	String	否	Compact	任务链路规格。支持 `Compact` 和 `Standard` 取值。默认值为 `Compact`。关于链路规格的详细信息，请参见产品规格。
ChargeConfig	ChargeConfig	是	请参见请求示例。	计费配置。详细信息，请参见 ChargeConfig。
ProjectName	String	否	default	项目名称。说明您可以调用 GetProject 接口创建项目。
CreateBackwardSyncTask	Bool	否	false	是否创建反向同步任务。取值如下： `true`：表示创建反向同步任务。 `false`：表示不创建反向同步任务，默认值。说明数据同步功能支持多种同步拓扑，您可以根据业务需求选择合适的拓扑进行数据同步。更多信息，请参见同步拓扑。
Tags	Array of Tag	否	请参见请求示例。	标签信息。说明支持一次传入多组标签键值对像，多组标签键值对像间用英文逗号（,）分隔。最多同时传入 20 组标签键值对。单个任务最多可绑定 50 个键值。详细信息，请参见 Tag。

返回参数

名称	类型	示例值	描述
TaskId	String	af16a602e1134abdbb281864ca******	任务 ID。

请求示例

MySQL

Redis

PostgreSQL

MongoDB

POST /?Action=CreateTransmissionTask&Version=2022-10-01 HTTP/1.1
Content-Type: application/json
Host:dts.cn-beijing.volcengineapi.com
X-Date: 20221001T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20221001/cn-beijing/dts/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****

{
    "TaskName": "zaizaitest****1",
    "TaskType": "DataMigration",
    "SrcConfig": {
        "EndpointType": "Public_MySQL",
        "PublicMySQLSettings": {
            "Host": "192.168.***.***",
            "Port": 4,
            "Username": "test****",
            "Password": "Admin@****",
            "SSLSettings": {
                "EnableSSL": "true",
                "Cert": "-----BEGIN CERTIFICATE----- ...... -----END CERTIFICATE-----"
            },
            "RegionSettings": {
                "Region": "cn-shanghai"
            }
        }
    },
    "DestConfig": {
        "EndpointType": "Volc_MySQL",
        "VolcMySQLSettings": {
            "DBInstanceId": "mysql-7cd1dc4ab511",
            "DBInstanceName": "",
            "Password": "Admin@****",
            "RegionSettings": {
                "Region": "cn-guangzhou"
            },
            "Username": "test****"
        }
    },
    "TrafficSpec": "Compact",
    "ProjectName": "default",
    "SolutionSettings": {
        "MySQL2MySQLSettings": {
            "AccountTransmissionSettings": {
                "EnableAccount": true
            },
            "ETLSettings": {
                "Script": ""
            },
            "ErrorBehaviorSettings": {
                "MaxRetrySeconds": 7200
            },
            "FullTransmissionSettings": {
	              "FullSyncParalell": 8,
	   						"RPSLimit": 100000,
	   						"BPSLimit": 25000000,
	              "EnableFull": true
	          },
            "IncrTransmissionSettings": {
                "EnableIncr": true,
                "Statements": [
                    "StmtDDLAll",
                    "StmtDMLDelete",
                    "StmtDMLUpdate",
                    "StmtDMLInsert"
                ]
            },
            "MetaTransmissionSettings": {
                "EnableMeta": true
            },
            "EnableForeignKeyChecks": true, 
            "ObjectMappings": [
                {
                    "DestObjName": "huahua",
                    "MappingList": [
                        {
                            "DestObjName": "*",
                            "ObjectType": "Table",
                            "SrcObjName": "*"
                        }
                    ],
                    "ObjectType": "Database",
                    "SrcObjName": "huahua"
                }
            ],
            "PolicyForPrimaryKeyConflict": "Override",
            "AccountMapping": {
                "Account": "test****",
                "ResetPassword": "true",
                "Password": "*Test****"
            }
        },
        "SolutionType": "MySQL2MySQL"
    },
    "Tags": [
        {
            "Key": "key1",
            "Value": "value1"
        }
    ],
    "ChargeConfig": {
        "ChargeType": "PostPaid"
    }
}

POST /?Action=CreateTransmissionTask&Version=2022-10-01 HTTP/1.1
Content-Type: application/json
Host:dts.volcengineapi.com
X-Date: 20221001T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20221001/cn-beijing/dts/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****


{
    "TaskName": "rudonxxxxx-1", 
    "TaskType": "DataMigration",
    "TrafficSpec": "Compact",    
    "ProjectName": "default",  
    "Tags": [
               {
                   "Key": "key1",
                   "Value": "value1"
               }
           ],   
    "SrcConfig": {
        "EndpointType":"Public_Redis",
        "PublicRedisSettings":{
            "Host": "192.168.***.***",
            "Port": 4,
            "Username": "test****",
            "Password": "test****",
            "DBName": "test****",
            "RegionSettings": {
                "Region": "cn-beijing"
            }
        },       
    },  
     "DestConfig": {
        "EndpointType": "Volc_Redis", 
        "VolcRedisSettings": {
            "RegionSettings": {
                "Region": "cn-beijing"
            }, 
            "DBInstanceId": "redis-cnlfe66ipof9y86qz", 
            "Username": "default", 
            "Password": "ASDFasdf@2020"
        }
    }, 
    "SolutionSettings": {
        "SolutionType": "Redis2Redis",
        "Redis2RedisSettings": {
             "ObjectMappings": [
                        {
                         "ObjectType": "Database",
                         "SrcObjName": "0", 
                         "DestObjName": "0"
                         }, 
                         {
                         "ObjectType": "Database",
                         "SrcObjName": "1", 
                         "DestObjName": "1"
                         }, 
                         {
                         "ObjectType": "Database",
                         "SrcObjName": "2", 
                         "DestObjName": "2"
                         }
            ], 
            "ErrorBehaviorSettings": {
                "MaxRetrySeconds": 7200
            }, 
            "FullTransmissionSettings": {
                "EnableFull": true
            }, 
            "IncrTransmissionSettings": {
                "EnableIncr": false
            }
        }      
    } ,
     "ChargeConfig":{
        "ChargeType":"PostPaid"
    }         
}

POST /?Action=CreateTransmissionTask&Version=2022-10-01 HTTP/1.1
Content-Type: application/json
Host:dts.volcengineapi.com
X-Date: 20221001T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20221001/cn-beijing/dts/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****

{
    "TaskName": "rudonxxxxx-1", 
    "TaskType": "DataMigration",
    "TrafficSpec": "Compact",    
    "ProjectName": "default",  
    "Tags": [
               {
                   "Key": "key1",
                   "Value": "value1"
               }
           ],
     "SrcConfig": {
         "EndpointType": "Public_PostgreSQL",
         "PublicPostgreSQLSettings": {
             "Host": "192.168.***.***",
             "Port": 4,
             "Username": "test****",
             "Password": "Admin@****",
             "DBName": "test****",
             "RegionSettings": {
                "Region": "cn-beijing"
            }
         }       
     },
     "DestConfig": {
         "EndpointType": "Volc_PostgreSQL",
         "VolcPostgreSQLSettings": {
             "DBInstanceId": "postgres-h441603c68aaa****",
             "Username": "test****",
             "Password": "Admin@****",
             "DBName": "test****",
             "RegionSettings": {
                "Region": "cn-beijing"
            }
         },     
     },
    "SolutionSettings": {
        "SolutionType": "PG2PG",
        "PG2PGSettings": {
             "ObjectMappings": [
                 {
                    "ObjectType": "Database",
                    "SrcObjName": "0",                    
                    "DestObjName": "0"                
                  },
                {
                    "ObjectType": "Table",
                    "SrcObjName": "1",                   
                    "DestObjName": "1"                
                  },
                {
                    "ObjectType": "View",
                    "SrcObjName": "2",                    
                    "DestObjName": "2"               
                 },
                {
                    "ObjectType": "PostSequence",
                    "SrcObjName": "3",                     
                    "DestObjName": "3"
                }
            ], 
             "MetaTransmissionSettings": {
                 "EnableMeta": "true"
             },   
             "FullTransmissionSettings": {
                 "EnableMeta": "true"
             },
             "IncrTransmissionSettings": {
                 "EnableMeta": "true"
             },
              "ErrorBehaviorSettings": {
                "MaxRetrySeconds": 7200
            }
    } ,    
      "ChargeConfig":{
        "ChargeType":"PostPaid"
    } 
}

POST /?Action=CreateTransmissionTask&Version=2022-10-01 HTTP/1.1
Content-Type: application/json
Host:dts.volcengineapi.com
X-Date: 20221001T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20221001/cn-beijing/dts/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****

{
    "TaskName": "test",
    "TrafficSpec": "Standard",
    "ProjectName": "default",
    "Tags": [

    ],
    "CreateBackwardSyncTask": false,
    "ChargeConfig": {
        "ChargeType": "PostPaid",
        "Times": 1
    },
    "SrcConfig": {
        "EndpointType": "Public_Mongo",
        "PublicMongoSettings": {
            "RegionSettings": {
                "Region": "×××××××××"
            },
            "DeployType": "ShardedCluster",
            "PullMethod": "Oplog",
            "Endpoints": [
                "192.168..***.***:27***"
            ],
            "MongoAuthSourceDB": "admin",
            "Username": "root",
            "Password": "admin",
            "Shards": [
                {
                    "Username": "root",
                    "Password": "admin",
                    "Address": "192.168.***.***:27***,192.168.***.***:27***",
                    "AuthDb": "admin"
                },
                {
                    "Address": "192.168.***.***:27***,192.168.***.***:27***",
                    "AuthDb": "admin",
                    "Username": "root",
                    "Password": "admin"
                }
            ],
            "UseNewShardingDatasource": true
        }
    },
    "DestConfig": {
        "EndpointType": "Volc_Mongo",
        "VolcMongoSettings": {
            "RegionSettings": {
                "Region": "×××××××××"
            },
            "DeployType": "ShardedCluster",
            "PullMethod": "None",
            "DBInstanceId": "mongo-shard-××××××××",
            "Username": "root",
            "Password": "admin",
            "UseNewShardingDatasource": true
        }
    },
    "SolutionSettings": {
        "SolutionType": "Mongo2Mongo",
        "Mongo2MongoSettings": {
            "TaskRunType": [
                "Incr",
                "Full",
                "Meta"
            ],
            "PolicyForMongoPrimaryKeyConflict": "Override",
            "ObjectMappings": [
                {
                    "ObjectType": "Database",
                    "SrcObjName": "test",
                    "DestObjName": "test",
                    "MappingList": [
                        {
                            "ObjectType": "Table",
                            "SrcObjName": "*",
                            "DestObjName": "*"
                        }
                    ]
                }
            ],
            "ErrorBehaviorSettings": {
                "MaxRetrySeconds": 600
            },
            "FullTransmissionSettings": {
                "FullSyncParalell": 8,
                "EnableFull": true
            },
            "AccountTransmissionSettings": {
                "EnableAccount": false
            },
            "MetaTransmissionSettings": {
                "EnableMeta": true
            },
            "IncrTransmissionSettings": {
                "EnableIncr": true
            }
        }
    },
    "TaskType": "DataSynchronization"
}

返回示例

{
    "ResponseMetadata": {
        "RequestId": "2023032015110930FCAD0A8CC67B0EAB33",
        "Action": "CreateTransmissionTask",
        "Version": "2022-10-01",
        "Service": "dts",
        "Region": "cn-beijing"
    },
    "Result": {
        "TaskId": "af16a602e1134abdbb281864ca*****"
    }
}

错误码

更多详情，请参见错误码。