Overview
Data migration is a common operation in database O&M and is typical in the following scenarios:
- Cluster load adjustment and IDC relocation
- Data export to files and data import from files to databases
- Database replacement
- Logical database replication, including read/write splitting, database disaster recovery, and multi-site high availability for business
- Data replication for business
Migration plans
OceanBase Database provides various data migration and replication methods, including:
- Migrate data by using OceanBase Migration Service (OMS) (recommended)
- Migrate data by using OBLOADER and OBDUMPER
- Import data by using OBLOADER
- Export data by using OBDUMPER
- Migrate data by using SQL scripts
- Migrate data by using MyDumper
- Migrate data by using DataX
- Migrate data by using an OUTFILE statement
- Migrate data by using DBCAT
| Migration plan | Schema migration | Full data migration | Incremental data migration | Data verification | Supported data sources |
|---|---|---|---|---|---|
| OMS | Supported | Supported | Supported | Supported | MySQL PostgreSQL Oracle DB2 TiDB OceanBase Database Kafka RocketMQ DataHub ADB |
| OBLOADER and OBDUMPER | Not supported | Supported | Not supported | Not supported | OceanBase Database |
| SQL scripts | Supported | Supported | Not supported | Not supported | Mainstream databases. Data migration across instances is not supported. |
| MyDumper | Supported | Supported | Not supported | Not supported | Data sources compatible with MySQL |
| DataX | Not supported | Supported | Not supported | Not supported | See the official documents for details. |
| OUTFILE statements | Not supported | Supported | Not supported | Not supported | MySQL OceanBase Database |
| DBCAT | Supported | Not supported | Not supported | Not supported | See the official documents for details. |
