We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours.
And I am looking for strategies in which this could work effectively? Our RDS has both innodb and myisam tables. How possible is this to do while live without corrupting data and what kind of time do you think it would take to migrate a 21 Gb db? Would it be wise to migrate first to a ec2 server so we would have more capabilities? Can you create a read-only replication of the main RDS and clone that to the EC2 for more protection? Thoughts?
SUPER
privilege on the new host?) Also, please explain what you are thinking as far as a benefit to doing an interim migration to EC2? – Michael - sqlbot Sep 25 '13 at 16:22