Overview of data migration or synchronization solutions

Solution

Data volume

Full migration

Incremental migration

DTS

• Synchronize data between PolarDB-X instances

• Synchronize data from a PolarDB-X 1.0 instance to an ApsaraDB RDS for MySQL instance

Large

√

√

Large

×

√

Large

√

√

Large

√

√

Assess data import and export.

Migrate data from an ApsaraDB RDS instance to a PolarDB-X 1.0 instance

Large

√

√

Large

√

√

MySQL native commands

• Run the source command to import an SQL text file into PolarDB-X 1.0.

• Run the mysqldump command to export an SQL text file from PolarDB-X 1.0.

For more information about the detailed steps, see Import and export data by using mysqldump.

Small (less than 20 million records)

√

×

Programming methods

• Import data from a database or a text file to PolarDB-X 1.0.

• Export data from PolarDB-X 1.0 to a database or a text file.

For more information about the detailed steps, see Import big data through a program.

Large

√

×

Data Integration

• Import data from MaxCompute (formerly known as ODPS) to PolarDB-X 1.0.

• Export data from PolarDB-X 1.0 to MaxCompute (formerly known as ODPS).

For more information about the detailed steps, see Overview.

Large

√

×