Data synchronization process

OceanBase Migration Service (OMS) supports the real-time synchronization between a MySQL or Oracle tenant of OceanBase Database and a Kafka, RocketMQ, or DataHub data source. OMS can synchronize logical tables from a DataBase Proxy (DBP) data source to the physical tables in a MySQL tenant of OceanBase Database. OMS provides a scalable message processing capability, which is useful for real-time data warehousing, data query, report distribution, and other services. This topic describes the data synchronization process.

To create and manage a data synchronization task, perform the following steps:

1. Prepare for data synchronization.

   Before you use OMS to synchronize data, we recommend that you create a dedicated database user for the data synchronization task and grant the required data operation privileges to the user. For more information, see Create and authorize a database user.

2. Add source and destination data sources. For more information, see Create a data source.

3. Create a data synchronization task.

   Log on to the OMS console and complete the required configurations. For more information, see Data synchronization.

4. Optional. View the status, objects, and component monitoring metrics of the data synchronization task. For more information, see View details of a data synchronization task.

   • View details about the data synchronization task.

     You can learn about the status of the data synchronization task based on its synchronization timestamp and latency, which provides reference information for monitoring the synchronization performance.

   • View the component monitoring metrics.

     You can view the Store Log Pulling Component and Connector Synchronous Write Component on the View Component Monitoring page.

   • View the synchronization objects.

     You can view the synchronization objects during data synchronization.

5. Optional. Stop and release the data synchronization task.

   If data synchronization is no longer required, you can stop the data synchronization task and release the resources. For more information, see Release and delete a data synchronization task.