The Change Tracking feature of Data Transmission Service (DTS) subscribes to incremental data in real time, enabling lightweight cache updates, asynchronous business decoupling, and real-time data synchronization with ETL processes.
If you are new to Change Tracking, read the Change Tracking operations guide to learn how to create, monitor, and manage tasks and consume tracked data.
Notes
The specific steps may vary depending on the source instance. For detailed examples, see Overview of change tracking scenarios.
Procedure
-
Purchase a change tracking task based on the database type and region of the source instance. For more information, see Purchase a change tracking task.
-
Log in to the DTS console.
NoteIf you are automatically redirected to the Data Management (DMS) console, you can click the
icon in the lower-right corner and then click
to return to the classic DTS console. -
In the left-side navigation pane, click Change Tracking.
-
At the top of the Change Tracking Tasks page, select the region of your change tracking task.
-
Find the change tracking task that you purchased and click Configure Channel for that task.
-
Configure the connection settings for the source instance. On the Configure Channel page, set the Subscription Name. In the source database information section, set Instance Type to RDS Instance, confirm the Database Type and Instance Region, and then select the RDS Instance ID. Note that DTS does not support Change Tracking for read-only or temporary instances. Then, enter the Database Account and Database Password. The specified account requires the Replication slave, Replication client, and SHOW VIEW permissions, and the SELECT permission on the objects to be tracked. In the network type section, set Network Type to VPC, and select the corresponding VPC and vSwitch.
-
Click Set Whitelist and Next.
NoteIf the source instance is an Alibaba Cloud instance, this step automatically adds the IP addresses of DTS servers to the whitelist of the source instance, allowing DTS servers to connect to the instance.
-
Configure the data types and objects to track. Select the data types to track, and then select Data Update and Structure Update. In the Subscribed Objects section, move the database objects that you want to track from the left pane to the Selected Objects pane by using the right arrow.
-
Click Save and Precheck in the lower-right corner of the page.
Note-
DTS performs a precheck before the task starts. The task can begin only after it passes this precheck.
-
If the precheck fails, click the
icon next to the failed check item to view details. Fix the issue as prompted and then run the precheck again.
-
-
When the Precheck dialog box shows Precheck Passed, close the Precheck dialog box.
After configuration, the change tracking task enters initialization, which typically takes about one minute.