Migration Solution Overview
You can migrate data from self-managed MySQL 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.
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.
Note
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. | |
RDS for MySQL | 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. | |
RDS for MySQL | Any | One-time or continuous | Minimal | Use DRS to synchronize data from the source to the destination RDS for MySQL instance. |
Parent topic: Database Migration
- Migration Solutions