One-Click Resynchronization of Database Tables
NineData’s data replication feature supports one-click resynchronization of specified tables during the incremental data synchronization phase.
Prerequisites
The target task must be an incremental replication task, and its status must be .
Steps
You need to add the sharded databases and tables from the source data source into NineData’s database table group to enable their migration. If your replication target also involves sharded databases and tables, follow this step to create a target database table group as well.
Log in to the NineData Console.
In the left navigation pane, click > .
On the page, click on the of the target synchronization task.
On the page, navigate to the tab, where you will find that one table shows a significant number of inconsistencies in the comparison results. Manually fixing these discrepancies with SQL statements would require extensive effort and time.
Click on the tab, select the inconsistent table, and then click on the page.
In the pop-up window, configure the following parameters and click . The system will automatically start resynchronizing the target data.
Parameter Description Name of the resynchronization task. Choose the resynchronization policy: - : Delete all data in the target table and rewrite it.
- : Ignore the existing data in the target and append only the data that is present in the source but not in the target.
- : Delete the target table, rebuild it based on the structure of the source table, and then write the data.
Once resynchronization is complete, go back to the tab and click . Wait for the comparison results to show that the data is consistent.
