OceanBase Migration Service (OMS) is a comprehensive data transmission and synchronization tool provided by OceanBase. OMS supports data replication between OceanBase Database and multiple types of relational databases as well as message queue products. OMS is a data transmission service that integrates data migration, real-time data synchronization, and incremental data subscription. OMS can help you circulate data in OceanBase Database at low risks, high cost efficiency, and high efficiency, and build a secure, stable, and efficient data replication architecture.
Background
OMS provides a visualized and centralized management platform. Data can be migrated in real time after simple configurations. OMS aims to implement highly efficient real-time data migration and synchronization from homogeneous or heterogeneous databases to OceanBase Database with the lowest cost and risk. OMS supports data migration from various types of relational databases to OceanBase Database. The OMS features vary slightly with the source database.
In addition, OMS can migrate data to OceanBase Database seamlessly without service interruption. After writing has stopped on the source database, OMS can enable a reverse data synchronization link before business is switched to OceanBase Database, and then re-establish the primary/secondary relationship. Through the link, all data changes on OceanBase Database will be synchronized to the source database in real time, implementing data consistency during database switchback in case of an emergency. This feature greatly reduces business migration risks, helping enterprise users build a database architecture with high availability and high reliability.
In addition, OMS supports real-time replication between heterogeneous databases with second-level latency. Therefore, OMS can be applied to multiple scenarios, such as data migration, inter-city data backup for disaster recovery, emergency systems, real-time data synchronization, disaster recovery, and database upgrade and migration. OMS can migrate and synchronize data without affecting or interrupting your business applications. It also ensures data integrity and transaction consistency.
Migration process
To create and manage a data migration task, perform the following steps:
Prepare for data migration.
Before you migrate data by using OMS, create a user in the source or destination database and authorize the user.
Add data sources.
In the OMS console, add the source and destination databases as data sources. For more information, see Add a data source in User Guide of OceanBase Migration Service.
Create a data migration project.
Specify the source database, destination database, migration type, and tables to be migrated in the migration project. The data migration task involves the following steps:
Data migration
OMS automatically runs the data migration project without any human intervention in the interim. You do not need to start, suspend, or interrupt the process.
Data verification
After the data migration is completed, you can verify the data integrity and accuracy.
Forward switchover
Before your business is applied to the destination database, you can switch the synchronization link to create a synchronization link from the destination database to the source database.
Switch your business to the source database.
Create a rollback plan before you switch your business, to reduce the impact of data migration on your business.
Optional. View the status of the data migration project.
On the migration task monitoring page, you can view the link details to monitor the migration project status in real time. For more information, see View details of a data migration project in User Guide of OceanBase Migration Service.
(Optional) Stop and release the data migration task.
After the data migration task is completed and you confirm that your data no longer needs to be synchronized from the source database to the destination database, you can delete the current data migration project. For more information, see Delete a data migration project in User Guide of OceanBase Migration Service.
More information
For more information about OMS, see OceanBase Migration Service