By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceAurora MySQLMySQL
Language
English
Jinlee
asked a month ago56 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.

profile picture
EXPERT
Riku_Kobayashi
answered a month ago
profile picture
EXPERT
Oleksii Bebych
reviewed a month ago
profile picture
EXPERT
NARRAVULA MUNISAI TEJA
reviewed a month 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.

Guidelines for Answering Questions

Relevant content