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?