Is it possible to migrate back from Amazon Aurora to native MySQL in Amazon RDS?

mysql amazon-web-services amazon-rds amazon-rds-aurora
Dror picture Dror · Sep 26, 2015 · Viewed 10.9k times · Source

I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL.

Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?

Answer

ydaetskcoR picture ydaetskcoR · Sep 26, 2015

Amazon's Aurora is MySQL wire compatible so you can always use tools such as mysqldump to get your data back out into a form that you could use to import back into a regular MySQL instance running in RDS, an EC2 instance or anywhere else for that matter.

Since posting this answer Amazon has also released the Database Migration Service which can be used to do zero downtime migrations between MySQL -> Aurora MySQL (Aurora also now supports PostgreSQL) and back. It also supports heterogeneous migrations such as from Oracle to Aurora MySQL or a number of other sources and targets.

Related questions

Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?

I've been looking around for best practices when setting up your database on the cloud but it still isn't clear to me which of the following solutions should we be going for? Amazon RDS Aurora Amazon RDS MySQL MySQL on …

Read More
MySQL: How long are binlogs retained?

I have a mysql slave which I am attempting to replicate a master mysql instance. I migrated the data a week or so from the production master instance. At the time I invoked SHOW MASTER STATUS on the master and …

Read More
Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More