Help Center/ GaussDB(for MySQL)/ User Guide/ Data Migration/ Data Migration Schemes
Updated on 2024-11-06 GMT+08:00
View PDF
Share

Data Migration Schemes

You can migrate data from RDS for MySQL, self-managed MySQL, other cloud MySQL, and self-managed Oracle databases to GaussDB(for MySQL), or from one GaussDB(for MySQL) instance to another GaussDB(for MySQL) instance.

Migration Tools

Table 1 Migration tools

Tool

Description

Billing

Reference

DRS (recommended)

Data Replication Service (DRS) provides real-time data migration and synchronization between databases in various scenarios. It is easy to use and can complete a migration task in minutes. DRS facilitates data transfer between databases, helping you reduce DBA labor costs and hardware costs.

Pay-per-use

For details, see Billing.

What Is DRS?

mysqldump

mysqldump is a command-line tool that comes with MySQL. It is used to back up and restore MySQL databases.

Free of charge

What Is mysqldump?

DAS

During data backup or migration, Data Admin Service (DAS) can help you export data to a local PC or OBS bucket, and import the data to the target data table.

Free of charge

What Is DAS?

Migration Schemes

Table 2 Migration schemes

Source Database

Migration Tool

Characteristic

Operation Guide

RDS for MySQL

DRS
  • Migration of all data, database-level data, or table-level data
  • Full and incremental data migration
  • Minimal downtime
  • Applicable to any data volume

From MySQL to GaussDB(for MySQL)

GaussDB(for MySQL)

mysqldump
  • Full data migration
  • Long downtime
  • Applicable to small amounts of data

Migrating Data to GaussDB(for MySQL) Using mysqldump

DAS
  • Full data migration
  • Long downtime
  • Applicable to moderate amounts of data

Migrating Data to GaussDB(for MySQL) Using the Export and Import Functions of DAS
  • On-premises MySQL databases
  • ECS-hosted MySQL databases

DRS
  • Migration of all data, database-level data, or table-level data
  • Full and incremental data migration
  • Minimal downtime
  • Applicable to any data volume

From ECS-hosted MySQL to GaussDB(for MySQL)

Other cloud MySQL databases

DRS
  • Migration of all data, database-level data, or table-level data
  • Full and incremental data migration
  • Minimal downtime
  • Applicable to any data volume

From Other Cloud MySQL to GaussDB(for MySQL)
Parent Topic: Data Migration