Created by Sergey Dmitriev (AWS) and Lorenzo Mota (AWS)
R Type: Rehost |
Source: Databases: Relational |
Target: MySQL on Amazon EC2 |
Created by: AWS |
Environment: PoC or pilot |
Technologies: Databases; Migration |
Workload: Open-source |
This pattern provides guidance for migrating an on-premises MySQL database to a MySQL database on an Amazon Elastic Compute Cloud (Amazon EC2) instance. The pattern discusses the use of AWS Database Migration Service (AWS DMS) or native MySQL tools such as mysqldbcopy and mysqldump for the migration.
Prerequisites
An active AWS account
A MySQL source database in an on-premises data center
Product versions
MySQL versions 5.5, 5.6, and 5.7
For a list of target operating systems supported by Amazon EC2, see Amazon EC2 FAQs
Source technology stack
An on-premises MySQL database
Target technology stack
A MySQL database instance on Amazon EC2
AWS data migration methods
AWS DMS
Native MySQL tools (mysqldbcopy, mysqldump)