Posted On: Nov 17, 2017

Starting today you can easily restore a new Amazon RDS for MySQL database instance from a backup of your existing MySQL database, including MySQL databases running on Amazon EC2 or outside of AWS. This is done by creating a backup using the Percona XtraBackup tool and uploading the resulting files to an Amazon S3 bucket. You then create a new Amazon RDS DB Instance from the backup files in Amazon S3, directly through the RDS Console or AWS Command Line Interface. 

This feature makes it considerably easier and faster to migrate large MySQL databases with complex schemas to Amazon RDS. It has no performance impact on your source database and you can keep writing to your database during the backup process, minimizing downtime during migration. You can make use of Amazon S3 file transfer optimizations including Multipart Upload and Transfer Acceleration for quickly uploading large backup files. Once created, you can use MySQL replication to catch your Amazon RDS database up to changes in the source database.

This feature is available in all AWS Commercial regions for databases using MySQL version 5.6. Please refer to Amazon RDS documentation to learn more about this feature.