ApsaraDB for OceanBase:Set an incremental synchronization timestamp

Limitations

• When you create a data migration or synchronization project, you can set an incremental synchronization timestamp only if you select Incremental Synchronization for the migration or synchronization type and leave Full Migration/Full Synchronization unselected.

• The incremental synchronization timestamp must be the current time or a point in time earlier than the current time. It cannot be later than the expiration time of incremental logs in the source database.

Scenarios

You can set an incremental synchronization timestamp in the following scenarios:

• You have verified data consistency between the source and destination, and you want to create a data migration or synchronization project to obtain the incremental data generated after a specific point in time and synchronize the data to the destination database.

• You no longer need the historical data in the source database, but want to synchronize only the incremental data generated after a specific point in time to the destination database.

Procedure

1. Configure a data migration or synchronization project as prompted to the Select Migration Type or Select Synchronization Type step.

   For more information, see the topics about data migration or data synchronization projects of the corresponding data source types.

   

2. On the Select Migration Type or Select Synchronization Type page, select migration or synchronization types based on your business needs. You must select Incremental Synchronization and leave Full Migration/Full Synchronization unselected.

   

3. Configure other parameters as prompted and proceed to the Migration Options or Synchronization Options step. In the Incremental Synchronization Start Timestamp section, specify a point in time for synchronizing data. Data generated after this point in time will be synchronized. The default value is the current system time.

   

   Note

   The parameters on this page vary with the migration or synchronizing type that you selected. This topic describes how to configure the Incremental Synchronization Start Timestamp parameter. For information about other parameters, see the "Data migration" chapter.

   You can select a point in time or enter a timestamp. The timestamp is related to the retention period of incremental logs in the source database. Generally, you can start data synchronization from the current timestamp.

4. Click Precheck. After the precheck is passed, start the data migration project.