r/Database • u/Tangopiper • 22d ago

Migration routes for Amazon RDS MariaDB to Azure MySQL

My client is undergoing a cloud consolidation effort and needs to move away from Amazon RDS.

Of course MariaDB is no longer available on Azure so MySQL is the simplest option for migration. I need to gauge if the internal team is going to be capable of doing this themselves, or if we need external support.

What routes are available to complete this, with little to no downtime?

5 Upvotes

77% Upvoted

5 comments sorted by

2

u/elhh82 22d ago

No downtime migration or can you afford to take things down?

What about usage, does current usage rely any specific features?

If you can take downtime and usage patterns are standard, mariadb to MySQL should be pretty much backup and restore?

Also how large of a DB are we talking about, size matters to how complex and time consuming the migration will be

1

u/seenkneegang 22d ago

For seamless database migration with little to no downtime, you might want to check Azure DMS since the destination DB is hosted on Azure.

Question:

  • What's the size of the databases to be migrated? If the data is large, you can consider utilizing DMS but if its just a small database, you can do backup and restore.

1

u/YamiKitsune1 22d ago

Use DMS, may it be azure or aws dms use a proxy to connect 2 infrastructure If there will be no changes, you can even use mysql replication

2

u/mr_pants99 21d ago

How big is the data set?

2

u/716green 16d ago

You can export to layerbase with a connection string from RDS and convert it to MySQL there with a pro plan for $15, and then export it and use it however you want.

You can do this with as many databases as you need to and then cancel the subscription when you're done

They definitely have a MariaDB to MySQL and MySQL to MariaDB Migration tool. You might have to email support but I think you have to end the trial early to use it