Migration options for large MySQL and MariaDB databases
You can choose from an extensive range of options to migrate from on-premises MySQL or MariaDB databases to Amazon Relational Database Service (Amazon RDS) or Amazon Aurora MySQL-Compatible Edition databases instances. Choosing the right migration approach and tool is essential for a successful migration, and in this guide, you evaluate the options based on your usability, data size, and downtime requirements.
The following table summarizes the common migration approaches that are available to migrate multi-terabyte MySQL or MariaDB databases efficiently to Amazon RDS, Aurora MySQL-Compatible, or Amazon Elastic Compute Cloud (Amazon EC2) database instances.
Source |
Target |
Migration tool |
Approach |
---|---|---|---|
Self-managed MySQL |
Amazon RDS, MySQL or MariaDB on Amazon EC2, or Aurora |
Physical |
|
Logical |
|||
Logical |
|||
Physical, logical, or both |
|||
MySQL-compatible (such as MariaDB) |
Amazon RDS, MySQL or MariaDB on Amazon EC2, or Aurora |
Logical |
|
Logical |
|||
Physical, logical, or both |
For each migration tool, there are several approaches you can use to transfer the large database backup file to the AWS Cloud. Options are provided for each tool, and you can also use Amazon S3 File Gateway. For more information, see Using Amazon S3 File Gateway to transfer backup files in this guide.