Migrate an on-premises MySQL database to Aurora MySQL - AWS Prescriptive Guidance

Migrate an on-premises MySQL database to Aurora MySQL

R Type: Re-architect

Source: Databases: Relational

Target: Amazon Aurora MySQL

Created by: AWS

Environment: Production

Technology: Databases

Workload: Oracle

Summary

This pattern explains how to migrate an on-premises MySQL source database to Amazon Aurora MySQL. It describes two options for migration: using AWS Database Migration Service (AWS DMS) or using native MySQL tools such as mysqldbcopy and mysqldump.

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • A source MySQL database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Product versions

Architecture

Source technology stack

  • An on-premises MySQL database

  • Amazon Aurora MySQL 

Data migration architecture

Using AWS DMS:

Using native MySQL tools:

Tools

  • AWS DMS - AWS Database Migration Service (AWS DMS) supports several source and target databases. For information about MySQL source and target databases supported by AWS DMS, see Migrating MySQL-Compatible Databases to AWS. We recommend that you use the latest version of AWS DMS for the most comprehensive version and feature support.

  • Native MySQL tools - mysqldbcopy and mysqldump.

Epics

Task Description Skills required
Validate the source and target database version and engine. DBA
Identify hardware requirements for the target server instance. DBA, SysAdmin
Identify storage requirements (storage type and capacity). DBA, SysAdmin
Choose proper instance type based on capacity, storage features, and network features. DBA, SysAdmin
Identify the network access security requirements for source and target databases. DBA, SysAdmin
Identify the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Create a virtual private cloud (VPC). SysAdmin
Create security groups. SysAdmin
Configure and start an Amazon RDS for MySQL DB instance. SysAdmin
Task Description Skills required
Use native MySQL tools or third-party tools to migrate database objects and data. For instructions, see the documentation for MySQL tools such as mysqldbcopy and mysqldump. DBA
Task Description Skills required
Migrate data with AWS DMS. DBA
Task Description Skills required
Follow the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Switch the application clients over to the new infrastructure. DBA, SysAdmin, AppOwner
Task Description Skills required
Shut down temporary AWS resources. DBA, SysAdmin
Review and validate the project documents. DBA, SysAdmin, AppOwner
Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc. DBA, SysAdmin, AppOwner
Close out the project and provide feedback.

References

Tutorials and videos