About data migration and synchronization

As business grows and evolves, you may need to replace databases to meet changing requirements on database performance and features. During database replacement, carrying out data migration and synchronization becomes a necessity.

Data migration is a common database O&M operation essential for cluster load balancing and IDC relocation. You can use commands to perform operations such as data archiving for a cluster or for tables, disk-level load balancing, and resource unit migration in OceanBase Database. However, to perform operations such as data synchronization between heterogeneous data sources and between clusters, you need to use external tools.

This topic describes the following data migration methods and tools:

• Migrate data by using OMS

• Export and import data by using ODC

  • Overview

  • Data formats

  • Batch export and import

  • Single table export and import

• Migrate data by using SQL scripts

  • Common SQL scripts for data migration

  • Export data by using the OUTFILE statement

  • Import data by using the LOAD DATA statement

• Migrate data by using mysqldump

• Migrate data by using DataX

  • DataX

  • Examples of DataX reader and writer plug-ins for different data sources

• Migrate data by using OBLOADER and OBDUMPER

  • Import data by using OBLOADER

  • Export data by using OBDUMPER