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 22 days ago53 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 22 days ago
profile picture
EXPERT
Oleksii Bebych
reviewed 22 days ago
profile picture
EXPERT
NARRAVULA MUNISAI TEJA
reviewed 22 days 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