Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Migrating on prm MySql to Aurora MySql on AWS

0

I am planning to migrate my on-prem MySQL database to Aurora MySQL in AWS. For conducting a POC what are the various options available for the migration. What's the best practice to do this migration quickly and without losing data or having downtime?

Topics
Database
Tags
Aurora MySQLMySQLAmazon Relational Database Service
Language
English

asked 2 years ago331 views

1 Answer
3

Hello.

If you want to reduce downtime, I think you should migrate using replication using AWS DMS.
https://repost.aws/knowledge-center/migrate-mysql-rds-dms
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-mysql-database-to-amazon-rds-for-mysql.html

If you can tolerate some downtime, the lowest cost is to create a dump file with mysqldump and import it to RDS.

EXPERT

answered 2 years ago

EXPERT

reviewed 2 years ago

EXPERT

reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content