Migration Solution Overview

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

Data migration tools include Data Replication Service (DRS), Data Admin Service (DAS), 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 sources to destinations 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 to the destination database while minimizing service downtime.
Real-time synchronization: It refers to the real-time flow of workload data from sources to destinations 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?

During a DRS full migration, a large number of binlogs are generated in a short period of time and may be temporarily stored on your instance, which may cause the storage space to be used up. You are advised to enable autoscaling for your instance. To free up storage space, you can set an appropriate retention period for binlogs and clear the binlogs in a timely manner.

Migration Solutions

**Table 1** RDS for MySQL migration solutions
Source Database	Data Size	One-Time or Continuous Migration	Application Downtime	Solution	Document
RDS for MySQL	Small	One-time	Some time	Use mysqldump to copy data from the source to the destination RDS for MySQL instance.	Migrating Data to RDS for MySQL Using mysqldump
	Any	One-time or continuous	Minimal	Use DRS to migrate table, database, or instance data of the source to the destination RDS for MySQL instance. NOTE: For details about real-time migration billing, see DRS Migration Billing.	From MySQL to RDS for MySQL
	Medium	One-time	Some time	Use DAS to export data from the source and then import the data to the destination RDS for MySQL instance.	Migrating Data to RDS for MySQL Using the Export and Import Functions of DAS
	Any	One-time or continuous	Minimal	Use DRS to synchronize data from the source to the destination RDS for MySQL instance.	From MySQL to RDS for MySQL
	Any	Continuous	Minimal	Use DRS to synchronize data from the source to the DR RDS for MySQL instance. NOTE: If there is a regional failure, this solution can ensure service continuity by synchronizing data between databases.	Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS From MySQL to RDS for MySQL (Dual-Active DR)
DDM	Any	One-time or continuous	Minimal	Use DRS to synchronize data from DDM to RDS for MySQL.	From DDM to RDS for MySQL
GaussDB distributed	Any	One-time or continuous	Minimal	Use DRS to synchronize data from a GaussDB distributed instance to RDS for MySQL.	From GaussDB Distributed to RDS for MySQL
GaussDB primary/standby	Any	One-time or continuous	Minimal	Use DRS to synchronize data from a GaussDB primary/standby instance to RDS for MySQL.	From GaussDB Primary/Standby to RDS for MySQL
GaussDB(for MySQL)	Any	One-time or continuous	Minimal	Use DRS to synchronize data from GaussDB(for MySQL) to RDS for MySQL.	From GaussDB(for MySQL) to RDS for MySQL
On-premises MySQL databases MySQL databases on ECSs	Any	One-time or continuous	Minimal	Use DRS to migrate data from self-managed MySQL databases to RDS for MySQL. DRS supports incremental migration, so you can replicate ongoing data changes to keep sources and destinations in sync while minimizing the impact of service downtime and migration. NOTE: For details about real-time migration billing, see DRS Migration Billing.	Migrating Data from Self-Managed MySQL Databases to RDS for MySQL
	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed MySQL databases to RDS for MySQL. Real-time synchronization refers to the real-time flow of workload data from sources to destinations through a synchronization instance while consistency of data is ensured. It is suitable for real-time analysis, and data transfer in report systems and data warehouses.	From MySQL to RDS for MySQL
	Any	Continuous	Minimal	Use DRS to synchronize data from self-managed MySQL databases to the DR RDS for MySQL instance. NOTE: If there is a regional failure, this solution can ensure service continuity by synchronizing data between databases.	From MySQL to RDS for MySQL (Single-Active DR) From MySQL to RDS for MySQL (Dual-Active DR)
On-premises Oracle databases Oracle databases on ECSs	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed Oracle databases to RDS for MySQL.	From Oracle to RDS for MySQL
MySQL databases on other clouds	Any	One-time or continuous	Minimal	Use DRS to migrate data from MySQL databases on other clouds to RDS for MySQL. NOTE: For details about real-time migration billing, see DRS Migration Billing.	Migrating MySQL Databases from Other Clouds to RDS for MySQL
	Any	One-time or continuous	Minimal	Use DRS to synchronize data from MySQL databases on other clouds to RDS for MySQL.	From MySQL to RDS for MySQL
	Any	Continuous	Minimal	Use DRS to synchronize data from MySQL databases on other clouds to the DR RDS for MySQL instance. NOTE: If there is a regional failure, this solution can ensure service continuity by synchronizing data between databases.	From MySQL to RDS for MySQL (Single-Active DR) From MySQL to RDS for MySQL (Dual-Active DR)

DRS Migration Billing

Real-time migration supports only the pay-per-use billing mode.
Real-time migration tasks are free of configuration and traffic fees in the first seven days, lowering your costs for migrating data to the cloud.
Real-time synchronization and DR support pay-per-use and yearly/monthly billing modes.
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: Database Migration

Previous topic: Database Migration

Next topic: Migrating Data to RDS for MySQL Using mysqldump