CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-rdsamazon-aurora
WK123
WK123

Reputation: 630

Migrating MySQL 8.0.20 database to AWS Aurora

I was trying to use the AWS RDS Proxy service and realized that the only compatible versions with the service are AWS Aurora.

The current database I have is a MySQL database using MySQL version 8.0.20. AWS Aurora is MySQL compatible but only with version 5.6 and 5.7. I am not overly familiar with these versions and how different it would be to version 8.0.20.

Has anyone gone through the process of converting a MySQL database to Aurora? I know there are docs on the subject out there but they deal with version 5.6 or 5.7, has anyone done it for later versions?

I have all the MySQL code in SQL files along with the stored procedures so the database creation can be automated to an extent, it would just be if anyone has ran into issues doing it/found a better way than running multiple SQL files to transfer over data.

If you have gone through the process are there major differences between MySQL and Aurora in terms of running stored procedures etc?

Upvotes: 2

Views: 2932

Answers (2)

Ronald Bradford
Ronald Bradford

Reputation: 1

Aurora 3.01.00 is the first public GA version of Aurora MySQL 8 released 2021-11-18 -- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.3010.html

I've written a full tutorial of the upgrade process including the multiple options for pre-checks to ensure maximum compatibility at https://github.com/ronaldbradford/aws-tutorial/blob/main/rds/mysql-aurora-major-upgrade.md

Upvotes: 0

Anil Vaitla
Anil Vaitla

Reputation: 2978

MySQL 8 is now supported in AWS Aurora: https://aws.amazon.com/blogs/database/amazon-aurora-mysql-3-with-mysql-8-0-compatibility-is-now-generally-available/

They include the migration path in particular through a read replica promotion or full snapshot restore from rds into aurora.

Upvotes: 1

Related Questions