My question is about migrating large amounts of MySQL data with as little downtime as possible.
I have 3 MySQL databases that need to be moved from one RDS instance inside a VPC into a brand new AWS account into a new RDS instance.
Each database is around 200GB.
I'd like to minimise downtime as much as possible on the 3 sites these databases support.
- The sites are very read and write intensive, so unfortunately I can't go into a read-only mode for a few hours while I migrate.
- I cannot SSH into and copy the data files for the mysql instances because this is RDS.
- It takes around 4-5 hours to run
mysqldumpfor the entire database to my local machine.
What options do I have to be able to do this and how much downtime would you estimate for any ideas?