Synchronize the addition or deletion of tables for PolarDB-X 1.0 instances
When a data synchronization task uses database-level granularity with a PolarDB-X 1.0 source, you can add or remove tables from the synchronized set without recreating the task. This page explains the behavior for each operation and walks you through the steps.
Prerequisites
Before you begin, make sure you have:
A data synchronization instance running with a PolarDB-X 1.0 instance as the source, with synchronization granularity set to database level
Met all prerequisites listed in Modify the objects to be synchronized, as this operation uses that feature
Limitations
This operation is supported only for data synchronization instances. Migration instances do not support it.
If you need to both add and remove tables, perform the operations in two separate steps. For example, first remove the tables and submit the change, then add new tables and submit again. Doing both at once may cause synchronization errors.
Go to the Data Synchronization page
Use one of the following methods to open the Data Synchronization page, then select the region where your synchronization instance resides.
DTS console
Log on to the DTS console.
In the left-side navigation pane, click Data Synchronization.
In the upper-left corner, select the region where the synchronization instance resides.
DMS console
Steps may vary depending on your DMS console mode and layout. For details, see Simple mode and Customize the layout and style of the DMS console.
Log on to the DMS console.
In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.
From the drop-down list to the right of Data Synchronization Tasks, select the region where the synchronization instance resides.
Source database adds tables
Adding a table requires two rounds of object reselection. In the first round, you switch the synchronization granularity from database to table level while excluding the newly added tables. In the second round, you add the new tables.
Phase 1: Switch granularity to table level
In the Actions column of the target synchronization instance, click Reselect Objects.
In the Selected Objects section, select the database that contains the newly added tables, then click
to move it to the Source Objects section.In the Source Objects section, select the tables to synchronize at the table level, excluding the newly added tables, then click
to move them to the Selected Objects section.At the bottom of the page, click Next: Advanced Settings, then click Next: Precheck and Start Task.
When Success Rate shows 100%, click Changed. Return.
Wait until the Status of the synchronization instance changes to Running.
If Auto Refresh is not enabled, click above the Actions column to manually refresh the status.
Phase 2: Add the newly added tables
In the Actions column, click Reselect Objects again.
In the Source Objects section, select the newly added tables, then click
to move them to the Selected Objects section.At the bottom of the page, click Next: Advanced Settings, then click Next: Precheck and Start Task.
When Success Rate shows 100%, click Changed. Return.
Wait until the Status of the synchronization instance changes to Running.
If Auto Refresh is not enabled, click above the Actions column to manually refresh the status.
Source database deletes tables
In the Actions column of the target synchronization instance, click Reselect Objects.
In the Selected Objects section, select the database that contains the deleted tables, then click
to move it to the Source Objects section.In the Source Objects section, select the tables to synchronize at the table level, excluding the deleted tables, then click
to move them to the Selected Objects section.At the bottom of the page, click Next: Advanced Settings, then click Next: Precheck and Start Task.
When Success Rate shows 100%, click Changed. Return.
Wait until the Status of the synchronization instance changes to Running.
If Auto Refresh is not enabled, click above the Actions column to manually refresh the status.