Parameter | Description |
Billing Mode | Pay-as-you-go billing and monthly subscription are supported. |
Source Instance Type | Select "TDSQL-C for MySQL", which cannot be changed after purchase. |
Source Instance Region | Select the source instance region, which cannot be changed after purchase. |
Target Instance Type | Select "TDSQL-C for MySQL", which cannot be changed after purchase. |
Target Instance Region | Select the target instance region, which cannot be changed after purchase. |
Specification | Select a specification based on your business needs. The higher the specification, the higher the performance. For more information, see Billing Overview. |
Category | Parameter | Description |
Task Settings | Task Name | DTS will automatically generate a task name, which is customizable. |
| Running Mode | Immediate execution and scheduled execution are supported. |
Source Instance Settings | Source Instance Type | Select the source instance type selected during purchase, which cannot be changed once configured. |
| Source Instance Region | Select the source instance region selected during purchase, which cannot be changed once configured. |
| Service Provider | For a self-built database (such as a CVM-based one) or TencentDB database, select "Others". For a third-party cloud database, select the corresponding service provider.In this scenario, select "Others". |
| Access Type | Select a type based on your scenario. In this scenario, select "Database". For the preparations for different access types, see Overview. Public Network: The source database can be accessed through a public IP. Self-Build on CVM: The source database is deployed on a CVM instance. Direct Connect: The source database can be interconnected with VPCs through Direct Connect. VPN Access: The source database can be interconnected with VPCs through VPN Connections. Database: The source database is a TencentDB database. CCN: The source database can be interconnected with VPCs through CCN. VPC: The source and target databases are both deployed in Tencent Cloud VPCs. To use the VPC access type, submit a ticket for application. |
| Instance ID | |
| Account | Account of the source instance, which must have the required permissions. |
| Password | Password of the source instance account. |
Target Instance Settings | Target Instance Type | The target instance type selected during purchase, which cannot be changed. |
| Target Instance Region | The target instance region selected during purchase, which cannot be changed. |
| Access Type | Select a type based on your scenario. In this scenario, select "Database". |
| Instance ID | Target instance ID. |
| Account | Account of the target instance, which must have the required permissions. |
| Password | Password of the target instance account. |
Category | Parameter | Description |
Data Initialization Option | Initialization Type | Structure initialization: Table structures in the source database will be initialized into the target database before the sync task runs. Full data initialization: Data in the source database will be initialized into the target database before the sync task runs. If you only select Full data initialization, you need to create the table structure in the target database in advance. Both options are selected by default, and you can deselect them as needed.
|
| If Target Already Exists | Precheck and report error: If a table with the same name exists in both the source and target databases, an error will be reported, and the task will stop. Ignore and execute: Full and incremental data will be directly added to tables in the target instance. |
Data Sync Option | Conflict Resolution Method | Report: If a primary key conflict is found during data sync, an error will be reported, and the data sync task will be paused. Ignore: If a primary key conflict is found during data sync, the primary key record in the target database will be retained. Overwrite: If a primary key conflict is found during data sync, the primary key record in the source database will overwrite that in the target database. |
| SQL Type | Supported operations include INSERT, UPDATE, DELETE, and DDL. If you select "Custom DDL“, you can select different DDL statement sync policies as needed. For more information, see
Setting SQL Filter Policy. |
Sync Object Option | Database and Table Objects of Source Instance | Select the objects to be synced. You can select basic databases, tables, views, procedures, and functions.
The sync of advanced objects is a one-time operation: only advanced objects already in the source database before the task start can be synced, while those added to the source database after the task start will not be synced to the target database. For more information, see Syncing Advanced Object. |
| Selected Object | Database/Table mapping (renaming) is supported. Hover over a database or table name, click the displayed ”Edit“ icon, and enter a new name in the pop-up window. When advanced objects are selected for sync, we do not recommend that you rename databases/tables. If you do so, sync of the advanced objects may fail. |
|
Sync Online DDL Temp Table
| If you use the "gh-ost" or "pt-osc" tool to perform online DDL operations on source database tables, DTS supports migrating the generated temp tables to the target database. If you select `gh-ost`, DTS will migrate the temp tables named `_Table name_ghc`, `_Table name_gho`, and `_Table name_del` to the target database. If you select "pt-osc", DTS will migrate the temp tables named `_Table name_new` and `_Table name_old` to the target database. For more information, see Syncing Online DDL Temp Table. |
Was this page helpful?