I'm using AWS RDS, with 1 master & 1 slave.

Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem.

Let say I wanted to instantiate a new RDS instance and migrate the whole DB over (around 1TB++), how can I fully migrate, because every seconds got new data comes in.

The problem now is because if want to copy the DB over, estimated around 30 minutes. What about the data in this 30 minutes during the migration?

Any idea?


Take the slave offline and clone it.

Replication will be backed up, and will catch up after bring brought back online.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.