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	Percona XtraBackup	Physical
		MyDumper	Logical
		mysqldump and mysqlpump	Logical
		Split backup	Physical, logical, or both
MySQL-compatible (such as MariaDB)	Amazon RDS, MySQL or MariaDB on Amazon EC2, or Aurora	MyDumper	Logical
		mysqldump and mysqlpump	Logical
		Split backup	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.