Migration Solution Overview

You can migrate data from on-premises MySQL databases, on-premises Oracle databases, Huawei Cloud RDS for MySQL databases, MySQL databases built on other clouds to GaussDB(for MySQL) instances, or from a GaussDB(for MySQL) instance to another GaussDB(for MySQL) instance.

Data migration tools include Data Replication Service (DRS) and mysqldump. You are advised to use DRS because 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.

DRS provides real-time migration and synchronization.

Real-time migration: With DRS, you can migrate data from the source to the destination in real time. You just need to create a replication instance to connect to both the source and destination and configure objects to be migrated. DRS will help you compare metrics and data between the source and destination, so you can determine the best time to switch services to the destination while minimizing service downtime.
Real-time synchronization: It refers to the real-time flow of workload data from the source to the destination through a synchronization instance while consistency of data is ensured. It is different from migration. Migration means moving entire data of a database to another. Synchronization refers to the continuous flow of data between different applications.

For more information, see What Is DRS?

Migration Solutions

**Table 1** Migration solutions
Source Database	Solution	Documentation
RDS for MySQL	Use DRS to migrate table, database, or instance data.	From MySQL to GaussDB(for MySQL)
GaussDB(for MySQL)	Use mysqldump to copy data.	Migrating Data to GaussDB(for MySQL) Using mysqldump
On-premises MySQL databases ECS-hosted MySQL databases	Use DRS to migrate data.	From ECS-hosted MySQL to GaussDB(for MySQL)
MySQL databases on other clouds	Use DRS to migrate data.	From MySQL on Other Clouds to GaussDB(for MySQL)

**Table 2** Synchronization solution
Source Database	Solution	Documentation
GaussDB(for MySQL)	Use DRS to synchronize data.	From GaussDB(for MySQL) to GaussDB(for MySQL)
On-premises MySQL databases ECS-hosted MySQL databases MySQL databases on other clouds RDS for MySQL	Use DRS to synchronize data.	From MySQL to GaussDB(for MySQL)
On-premises Oracle databases ECS-hosted Oracle databases	Use DRS to synchronize data.	From Oracle to GaussDB(for MySQL)

DRS Billing

Real-time migration tasks are only billed based on a pay-per-use basis.
Their configuration and traffic fees are free in the first seven days, lowering your costs for migrating data to the cloud.
Real-time synchronization and DR tasks are billed based on a pay-per-use or yearly/monthly basis.
Real-time migration and synchronization will provide long-term discounts, lowering your costs for data transfers.

For more information, see Pay-Per-Use.

Parent topic: Data Migration

Previous topic: Data Migration

Next topic: Migrating Data to GaussDB(for MySQL) Using DRS