Easily restore an Amazon RDS for MySQL database from your MySQL 8.0 backup

Posted on: Oct 9, 2020

Starting today, you can use easily restore a new Amazon RDS for MySQL database instance from a backup of your existing MySQL 8.0 database, whether it’s running on Amazon EC2 or outside of AWS. This is done by using Percona XtraBackup to create a backup of your existing MySQL database, uploading the resulting files to an Amazon S3 bucket, and then creating a new Amazon RDS DB instance through the RDS Console or AWS Command Line Interface (CLI).

This improvement allows faster migrations and minimal performance impact on your source database, and you can also make use of the Amazon S3 file transfer optimization like Multipart Upload and Transfer Acceleration to speed up the upload of large backup files. Once the backup is finished, you can use MySQL replication to catch up your Amazon RDS database to the latest changes in your source database. 

This feature is now available in all AWS commercial regions for databases using MySQL versions 5.6, 5.7, and 8.0. Please refer to Amazon RDS documentation to learn more about this feature.

Amazon RDS for MySQL makes it easy to set up, operate, and scale MySQL deployments in the cloud.