Linkedin

Migrate an on-premises MySQL database to Amazon EC2

Project Overview

Project Detail

Migrate an on-premises MySQL database to Amazon EC2

PDF

 

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

Summary

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 and limitations

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

Architecture

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 (mysqldbcopymysqldump)

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-mysql-database-to-amazon-ec2.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Migrate an on-premises MySQL database to Amazon EC2