Operation Type | SQL Operation Statements |
DML | INSERT, UPDATE, and DELETE |
DDL | CREATE DATABASE, DROP DATABASE, ALTER DATABASE, CREATE SCHEMA, DROP SCHEMA, CREATE TABLE,ALTER TABLE, DROP TABLE, CREATE VIEW, DROP VIEW, CREATE INDEX, DROP INDEX, CREATE SEQUENCE, and DROP SEQUENCE |
Type | Environment Requirements |
Source Database Requirements | The networks of source and target databases must be interconnected. The requirements for the source database parameters are as follows: Set the wal_level parameter to logical. The source database must meet the following requirement: number of databases to be synchronized + replication_slots <= max_replication_slots. The source database objects must be case-insensitive. Tables in the source database must have a primary key or a composite primary key. |
Target Database Requirements | The version of the target database must be no earlier than that of the source database. The target database must have sufficient storage space. If the Initialization Type is set to Full Data Initialization, the space of the target database must be at least 1.2 times the space occupied by the databases and tables to be synchronized. The target database cannot have tables, views, or other objects with the same names as those to be synchronized from the source database. |
Parameter | Description |
Billing Mode | Monthly subscription and pay-as-you-go billing are supported. |
Source Instance Type | Select PostgreSQL. It cannot be modified after purchase. |
Source Instance Region | Select the region where the source instance is located. It cannot be modified after purchase. |
Target Instance Type | Select PostgreSQL. It cannot be modified after purchase. |
Target Instance Region | Select the region where the target instance is located. It cannot be modified after purchase. |
Specification | Select a specification based on your business needs. The higher the specification, the better the performance. For more details, see Billing Overview. |
Configuration Item | Parameter | Description |
Task Configuration | Task Name | DTS automatically generates a task name. You can configure the name as needed. |
| Running Mode | Supports both immediate execution and scheduled execution. |
Source Instance Settings | Source Instance Type | The source instance type selected at the time of purchase. You cannot modify this parameter. |
| Source Instance Region | The source instance region selected at the time of purchase. You cannot modify this parameter. |
| Access Type | Select a type based on your scenario. In this scenario, select Direct Connect or VPN Access. This scenario requires you to select Direct Connect or VPN Access: Configuring VPN-IDC Interconnection. For the preparation required for other connection types, see Overview. Public Network: The source database can be accessed by using the public IP. Self-Build on CVM: The source database is deployed on Cloud Virtual Machine. Direct Connect: The source database can be connected to Tencent Cloud VPC by using Direct Connect. VPN: The source database can be connected to Tencent Cloud VPC through VPN Connections. TencentDB: The source database is a TencentDB instance. CCN: The source database can be connected to Tencent Cloud VPC through Cloud Connect Network. |
| VPC-based Direct Connect Gateway/VPN Gateway | If you use Direct Connect, only VPC-based Direct Connect Gateway/VPN Gateway is supported. Confirm the network type of the gateway. To use VPN Gateway, select a VPN Gateway instance. |
| VPC | Select a VPC and subnet associated with the VPC-based Direct Connect gateway or VPN gateway. |
| Host Address | The IP address or domain name for accessing the source MySQL instance. |
| Port | The port for accessing the source MySQL instance. |
| Account | The source instance account. It must have the required permissions. |
| Password | The password for the source instance account. |
Target Instance Settings | Target Instance Type | The target instance type selected at the time of purchase, which cannot be modified. |
| Target Instance Region | The target instance region selected at the time of purchase, which cannot be modified. |
| Access Type | Select a type based on your scenario. For this scenario, select Database. |
| Instance ID | Select the target instance ID. |
| Account | The target instance account, which must have the required permissions. |
| Password | The password for the target instance account. |
Configuration Item | Parameter | Description |
Task Configuration | Task Name | DTS automatically generates a task name. You can configure the name as needed. |
| Running Mode | Supports both immediate execution and scheduled execution. |
Source Instance Settings | Source Instance Type | The source instance type selected at the time of purchase, which cannot be modified. |
| Source Instance Region | The source instance region selected at the time of purchase, which cannot be modified. |
| Access Type | Select a type based on your scenario. For this scenario, select Database. For preparation required for different access types, see the preparation overview. Public Network: The source database can be accessed through the public IP. Self-Build on CVM: The source database is deployed on Cloud Virtual Machine. Direct Connect: The source database can be connected to Tencent Cloud VPC through [Direct Connect](https://www.tencentcloud.com/document/product/216!ac1fc9354c56b77f7143d2b6a7d185ad). VPN Access: The source database can be connected to Tencent Cloud VPC through [VPN Connections](https://www.tencentcloud.com/document/product/1037!a419dbfe8173788c2b5605b6583b70d9). TencentDB: The source database is a TencentDB instance. CCN: The source database can be connected to Tencent Cloud VPC through Cloud Connect Network. |
| Instance ID | |
| Account | The source instance account, which must have the required permissions. |
| Password | The password for the source instance account. |
Target Instance Settings | Target Instance Type | The target instance type selected at the time of purchase, which cannot be modified. |
| Target Instance Region | The target instance region selected at the time of purchase, which cannot be modified. |
| Access Type | Select a type based on your scenario. For this scenario, select Database. |
| Instance ID | Select the target instance ID. |
| Account | The target instance account, which must have the required permissions. |
| Password | The password for the target instance account. |
Configuration Item | Parameter | Description |
Task Configuration | Task Name | DTS automatically generates a task name. You can configure the name as needed. |
| Running Mode | Supports both immediate execution and scheduled execution. |
Source Instance Settings | Source Instance Type | The source instance type selected at the time of purchase, which cannot be modified. |
| Source Instance Region | The source instance region selected at the time of purchase, which cannot be modified. |
| Access Type | For databases from third-party cloud providers, Public Network is used in general cases. You can also choose VPN Access, Direct Connect, or CCN based on the actual network situation. In this scenario, select Public Network. For preparation required for different access types, see Overview. Public Network: The source database can be accessed through the public IP. Self-Build on CVM: The source database is deployed on Cloud Virtual Machine. Direct Connect: The source database can be connected to Tencent Cloud VPC through Direct Connect. VPN Access: The source database can be connected to Tencent Cloud VPC through VPN Connections. Database: The source database is a TencentDB instance. CCN: The source database can be connected to Tencent Cloud VPC through Cloud Connect Network. |
| Host Address | The IP address or domain name for accessing the source instance. |
| Port | The port for accessing the source instance. |
| Account | The source instance account, which must have the required permissions. |
| Password | The password for the source instance account. |
Target Instance Settings | Target Instance Type | The target instance type selected at the time of purchase, which cannot be modified. |
| Target Instance Region | The target instance region selected at the time of purchase, which cannot be modified. |
| Access Type | Select a type based on your scenario. For this scenario, select Database. |
| Instance ID | Select the target instance ID. |
| Account | The target instance account, which must have the required permissions. |
| Password | The password for the target instance account. |
Configuration Item | Parameter | Description |
Data Initialization Option | Initialization Type | Structure Initialization: When you run the sync task, the table structure in the source instance is initialized in the target instance first. Full data initialization: When you run the sync task, data in the source instance will be initialized in the target instance first. In scenarios where only Full data initialization is selected, you need to create the table structure in the target database in advance. By default, both are selected. You can cancel options based on the actual situation. |
| If Target Already Exists | Precheck and report error: If a table with the same name exists, an error is reported and the process is not continued. Ignore and execute: Directly synchronize both full and incremental data to the tables in the target instance. |
Data Sync Option | Conflict Resolution Method | Report: If a primary key conflict is detected during sync, an error is reported and the data sync task is paused. Ignore: If a primary key conflict is detected during sync, the primary key record in the target database is retained. Overwrite: If a primary key conflict is detected during sync, the primary key record in the source database overwrites that in the target database. |
| SQL Type | Supported operations: Insert, Update, Delete, and DDL. Currently, Custom DDL is not supported. |
Synchronize Object Option | Database and Table Objects of Source Instance | Select objects to be synchronized. The following objects are supported: databases, tables, and views. Only SEQUENCE is supported as advanced objects. |
Was this page helpful?