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.

At present, OceanBase Database Enterprise Edition supports the Change Data Capture (CDC) tool. The obcdc component of this tool provides real-time incremental (transaction) data of OceanBase Database as dynamic libraries that can be synchronized and subscribed to.

This topic describes the following data migration methods and tools:

• Migrate data by using 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 mysqldump

• Migrate data by using DataX

• Migrate data by using OUTFILE statements