Data synchronization refers to the process where a migration or synchronization tool continuously reads upstream changes and writes the results to the target OceanBase Database (or other downstream systems), ensuring that the target database remains consistent with the source within an acceptable business delay. Compared to one-time data migration, it places greater emphasis on long-running data pipelines, latency monitoring, and consistency verification during playback.
In the OceanBase ecosystem, OceanBase Migration Service (OMS) is one of the primary solutions for migrating data from relational source databases to OceanBase. It typically covers schema, full data, and incremental data and supports switching orchestration.
Use OMS
Link |
Description |
|---|---|
| MySQL → OceanBase | OMS parses changes such as Binlogs and writes them to OceanBase. Example operation entry: Use OMS to migrate a MySQL database to OceanBase Database (MySQL-compatible mode tenant). |
| Oracle → OceanBase | Supports migration to MySQL-compatible or Oracle-compatible tenants: MySQL-compatible mode tenant, Oracle-compatible mode tenant. |
For more information about third-party synchronization tools (such as CloudCanal and scheduled DataX tasks), see Migrate data to OceanBase using ecosystem tools in Migrate data using tools.