Data Migration Overview

Data migration is a common O&M operation essential for cluster load balancing and IDC migration. 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 from MySQL to OceanBase

  • Use Canal to synchronize MySQL data to OceanBase Database in real time

  • Use DataX to migrate MySQL data to OceanBase Database

  • Use DBCAT to migrate MySQL table schemas to OceanBase Database

  • Migrate MySQL table schemas to OceanBase Database by using mysqldump

  • Migrate MySQL table data to OceanBase Database by using mysqldump

• Use OBDUMPER to export data from or OBLOADER to import data to OceanBase Database

• Migrate from csv files to OceanBase

  • Use DataX to load CSV data files to OceanBase Database

  • Use the LOAD DATA statement to load CSV data files to OceanBase Database

• Migrate data from SQL files to OceanBase Database

• Migrate data and resource units between tables

• Migrate from OceanBase to MySQL

  • Use Canal to synchronize OceanBase Database data to MySQL in real time