The change tracking feature of Data Transmission Service (DTS) captures real-time incremental data from databases. You can consume this data and write it to a destination as needed. This feature supports various scenarios, such as cache updates, asynchronous service decoupling, real-time data synchronization between disparate data sources, and complex extract, transform, and load (ETL) operations.
Source database limits
Limit | Description |
Network requirements |
|
Service requirements |
|
Change tracking solutions
Whether you can create a change tracking task across Alibaba Cloud accounts depends on the database type and connection type. To create a cross-account task, set the Replicate Data Across Alibaba Cloud Accounts parameter to Yes for the source database instance. For more information, see Configure a task across Alibaba Cloud accounts.
Source database | Supported data change types | Configuration document |
|
| Create a change tracking task for an ApsaraDB RDS for MySQL instance |
PolarDB for MySQL All versions |
| Create a change tracking task for a PolarDB for MySQL cluster |
PolarDB-X 1.0 Important Databases in a PolarDB-X instance must be created from ApsaraDB RDS for MySQL instances. DTS does not support PolarDB-X databases that are created from PolarDB for MySQL clusters. |
| |
PolarDB-X 2.0 Important Databases in a PolarDB-X instance must be created from ApsaraDB RDS for MySQL instances. DTS does not support databases that are created from PolarDB for MySQL clusters. |
| |
PolarDB for PostgreSQL (Compatible with Oracle) All versions | Data updates | Create a change tracking task for a PolarDB for PostgreSQL (Compatible with Oracle) cluster |
Self-managed Oracle database (non-RAC) Versions: 9i, 10g, and 11g |
| |
| Data updates | Create a change tracking task for an ApsaraDB RDS for PostgreSQL instance |
Data Management (DMS) logical database Important A logical database must be created from the database shards of multiple PolarDB for MySQL clusters. | Data updates | |
PolarDB for PostgreSQL Versions: 11, 14, 15, and 16 |
| Create a change tracking task for a PolarDB for PostgreSQL cluster |