How do I migrate MySQL data to an Aurora MySQL DB cluster using Amazon S3?
3 minute read
I want to migrate data from MySQL to an Amazon Aurora MySQL DB cluster. How do I restore MySQL data to an Aurora MySQL DB cluster using Amazon Simple Storage Service (Amazon S3)?
Amazon Aurora MySQL is compatible with MySQL 5.6 and MySQL 5.7 versions. To restore a MySQL innobackupex backup, first go to the Percona website and install Percona Xtrabackup (version 2.3 or later) to your Amazon Elastic Compute Cloud (Amazon EC2) instance:
After installing Percona Xtrabackup, back up the data that you want to migrate to Aurora MySQL. Then, upload the backup to Amazon S3 to perform the restoration. For more information see the Percona documentation for The Backup Cycle.
Connect to an EC2 instance and back up your MySQL database
3. Enter the Source Engine Version that you noted earlier.
4. From the S3 Backup Location dropdown menu, select the S3 bucket that you created. Enter your S3 Bucket Prefix. Note: Don't use leading or trailing slashes ("/") when entering the bucket name in the S3 Bucket Prefix field.