Posted On: Nov 17, 2017
Starting today you can easily restore a new HAQM RDS for MySQL database instance from a backup of your existing MySQL database, including MySQL databases running on HAQM EC2 or outside of AWS. This is done by creating a backup using the Percona XtraBackup tool and uploading the resulting files to an HAQM S3 bucket. You then create a new HAQM RDS DB Instance from the backup files in HAQM 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 HAQM 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 HAQM 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 HAQM 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 HAQM RDS documentation to learn more about this feature.