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 Amazon Web Services. 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 Amazon 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 Amazon Web Services commercial regions for databases using MySQL versions 5.6, 5.7, and 8.0, including Amazon Web Services China (Beijing) region, operated by Sinnet and Amazon Web Services China (Ningxia) region, operated by NWCD. 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.