Introduction
OceanBase Migration Service (OMS) Community Edition is a service that supports data interaction between OceanBase Community Edition and homogeneous or heterogeneous data sources. It supports online data migration and real-time synchronization of incremental data.
OMS Community Edition provides a visualized and centralized management platform. You can migrate data with simple configurations. OMS Community Edition aims to help you achieve real-time data migration and synchronization from homogeneous or heterogeneous data sources to OceanBase Community Edition at a low cost and low risk.
Features
OMS supports data migration and synchronization.
Data migration: Data migration is an one-off task. After the migration is completed, the project resources can be released. This feature is intended for full and incremental data migration between two relational data sources to ensure data consistency between the source and destination databases. With this feature, you can migrate inventory data from the source database to the destination database and maintain real-time synchronization of incremental data from the source database to the destination database.
Data migration projects are the basic unit of the data migration feature of OMS Community Edition. When you create a migration project, you can specify the migration level, which ranges from table to database. For more information about the project types and migration types supported in data migration, see Data migration.
Data synchronization: Data synchronization is a continuous operation. After a data synchronization project is created, data will be synchronized continuously to ensure consistency between the source and destination databases as well as the real-time flow of data of key business systems. With this feature, you can implement real-time data synchronization between OceanBase Community Edition and Kafka or RocketMQ instances. For more information, see Data synchronization.
Benefits
Support for multiple sources
OMS Community Edition supports real-time data transmission between OceanBase Community Edition and different types of data sources, such as MySQL, TiDB, Kafka, and RocketMQ, and supports data migration between MySQL tenants of OceanBase Community Edition. The features that OMS Community Edition provides vary with the types of source and destination data sources.
Real-time data migration without interrupting or affecting applications
You can use OMS Community Edition to seamlessly migrate data to OceanBase Community Edition without interrupting services. After you switch to OceanBase Community Edition, all changed data in OceanBase Community Edition will be synchronized to the original source database in real time.
OMS Community Edition minimizes the risks of business migration and helps enterprises build data architectures with high availability and reliability.
High-performance, secure, and reliable data migration
OMS Community Edition can replicate large amounts of data between IT infrastructures in real time with second-level latency. Therefore, OMS Community Edition can be applied in multiple scenarios, such as data migration, emergency systems, real-time data synchronization, and database upgrade.
OMS Community Edition can run data migration and synchronization tasks without affecting or interrupting your business applications, while ensuring data integrity and transaction consistency. OMS supports full migration at a speed of 100 MB/s and delivers a transaction processing performance of 200,000 transactions per second (TPS), and a data synchronization performance of 50,000 requests per second (RPS). OMS provides a high-availability deployment architecture as well as stable and reliable transmission channels for data migration and real-time synchronization.
One-stop interaction
OMS allows you to manage data migration throughout its whole lifecycle. You can create, configure, and monitor data migration projects on the visual management page.
Multiple data consistency checks
OMS provides multiple data consistency checks to ensure data quality. It displays differences in data to help you fix errors.
Easy data migration to OceanBase Community Edition
OMS Community Edition supports the features of every version of OceanBase Community Edition. It collects and converts database objects and supports data migration without interrupting the services of the source database.
Application scenarios
In-service data migration
In traditional database migration solutions, data is usually migrated during downtime to ensure the migration stability and data consistency. During the downtime, data writes to the source database must be temporarily stopped. The business database can be switched only after the migration is completed and the data consistency is verified.
The downtime duration varies according to the business data volume and network conditions. In case of a massive volume of business data, the downtime may last several days, greatly affecting the business.
OMS Community Edition supports in-service data migration, ensuring service continuity of the source database during the migration and minimizing the impact of data migration on the business. During schema migration, full data migration, and incremental data migration, the full data and incremental data in the source database are synchronized to the sink database in real time. After the data verification succeeds, the business can be handed over from the source database to the sink database.
Real-time data synchronization
OMS Community Edition can synchronize incremental data from OceanBase Community Edition and other databases to message queues of self-managed instances such as Kafka and RocketMQ instances in real time. This improves the message processing capability and extends the business application in monitoring data aggregation, streaming data processing, online/offline analysis, and other big data fields.
OMS Community Edition supports real-time data synchronization between OceanBase Community Edition and self-managed data sources such as Kafka instances. We recommend that you use OMS Community Edition in cloud business intelligence (BI), real-time data warehouse construction, data querying, report distribution, and other business scenarios.