Migrations is an OceanBase Database service that integrates data migration and incremental data synchronization. The service provides a visualized and centralized management console. You can migrate data between a MySQL or Oracle database and OceanBase Database in real time by making some simple settings.
Migrations aims to help you achieve secure, stable, and efficient real-time data migration between a MySQL or Oracle database and OceanBase Database at low costs and risks. Project members are categorized into the roles of Project Owner, Project Admin, Instance Admin, Project Member, Data Read/Write, and Data Services Admin. Project Admin and Data Services Admin have read-write access to the menus and data resources within the project's data services modules. Members with other roles only have read-only access to the menus and all data within the project's data services modules. You can set project roles on the Manage Organization page. For more information, see Manage organization and project access.
Features and benefits
Real-time data migration without interrupting or affecting applications
You can use Migrations to seamlessly migrate data to OceanBase Database without interrupting your applications. Migrations minimizes the risks of business migration and helps enterprises build business with high availability and reliability.
High-performance, secure, and reliable data migration
Migrations can replicate large amounts of data in real time with seconds-level latency. It allows you to migrate data without affecting or interrupting your business applications, ensuring data integrity and transaction consistency.
All-in-one interaction
Migrations allows you to manage data migration throughout its whole lifecycle. You can create, configure, and monitor data migration tasks in the console.
Easy data migration to OceanBase Database
Migrations supports the features of every version of OceanBase Database. It collects and converts database objects and supports data migration without interrupting the services of the source database.
Data migration process
To create and manage a data migration task, perform the following steps:
Prepare for data migration to make sure that the following conditions are met:
Create a MySQL or Oracle database instance.
Create an OceanBase instance and a tenant. For more information, see Create an instance and Create a tenant.
For data migration between a MySQL or Oracle database and OceanBase Database:
If you want to select Public IP as the connection type when you create the data migration task, you need to first add the data source IP address displayed on the page to the whitelist of the MySQL/Oracle database instance to ensure connectivity. For more information, see Add an IP address to an allowlist.
If you want to select Endpoint as the connection type when you create a data migration task, you need to first add the account ID displayed on the page to the whitelist of your endpoint service, to allow the endpoint of the account to connect to the endpoint service.
For more information, see Configure PrivateLink/Private Service Connect.
Create dedicated database users for data migration in the source and target, and grant required privileges to the users. For more information, see User privileges.
Create a data migration task.
Configure the source, target, migration type, and objects to migrate for the data migration task based on your business needs. For more information, see the topic about creating a data migration task between the corresponding data sources.
View details of the data migration task.
After the data migration task is started, it will be executed based on the selected migration types. For more information, see View details of a data migration task.
Optional. Delete the data migration task.
After the data migration task is completed, if data no longer needs to be synchronized from the source database to the target database, you can release the current data migration task. For more information, see Delete a data migration task.