Resources

AWS Prescriptive Guidance

• Portfolio playbook for AWS large migrations

• Migration strategy for relational databases

• Migrate an on-premises MySQL database to Amazon RDS for MySQL

• Set up data replication between Amazon RDS for MySQL and MySQL on Amazon EC2 using GTID

• Migrate an on-premises MariaDB database to Amazon RDS for MariaDB using native tools

AWS blog posts

• Security best practices for Amazon RDS for MySQL and MariaDB instances

• Migrate self-managed MariaDB to Amazon Aurora MySQL

Resources for restoring the backup

• Creating a bucket (Amazon S3 documentation)

• Connecting to your Linux instance using SSH (Amazon EC2 documentation)

• Configuring the AWS CLI (AWS CLI documentation)

• sync command (AWS CLI Command Reference)

• Creating an IAM policy to access Amazon S3 resources (Aurora documentation)

• DB cluster prerequisites (Aurora documentation)

• Working with DB subnet groups (Aurora documentation)

• Creating a VPC security group for a private DB cluster (Aurora documentation)

• Restoring an Aurora MySQL DB cluster from an Amazon S3 bucket (Aurora documentation)

• Setting up replication with MySQL or another Aurora DB cluster (Aurora documentation)

• rds_set_external_master procedure (Amazon RDS documentation)

• rds_start_replication procedure (Amazon RDS documentation)

AWS marketing

• Amazon Aurora

• Amazon RDS for MariaDB

• Amazon RDS for MySQL

• Amazon S3 File Gateway

Other resources

• Percona XtraBackup

• MyDumper

• mysqldump

• mysqlpump