OceanBase Migration Service (OMS) supports data interaction between OceanBase Database and homogeneous or heterogeneous Relational Database Management Systems (RDBMSs). It provides online data migration and real-time synchronization of incremental data.
OMS provides a visualized and centralized management platform. Data can be migrated in real time after simple configurations, and the resource usage and performance impact on the source database and business systems are slight. 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. OMS can enable a reverse data synchronization link before business applications are 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 an emergency. This feature greatly reduces business migration risks, helping enterprise users build a database architecture with high availability and high reliability.
OMS also allows you to perform millisecond-level real-time mass data replication between heterogeneous IT infrastructures. 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. For more information, see Create and authorize a database user in OMS User Guide.
Add a data source.
In the OMS console, add the source and destination databases as data sources. For more information, see Add a data source in OMS User Guide.
Create a data migration task.
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.
Synchronization link switching
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 task.
On the migration task monitoring page, you can view the link details to monitor the migration task status in real time. For more information, see View the status of a data migration task in OMS User Guide.
(Optional) Stop and release the data migration task.
After the data migration task is completed and data no longer needs to be synchronized from the source database to the destination database, you can clear the current data migration task. For more information, see Delete a data migration task in OMS User Guide.
More information
For more information about the OMS usage, see the OMS documentation