I have a 300GB MySQL DB that’s running in a data center. I am planning to migrate to AWS RDS MySQL, and was wondering what the best way to sync that data over was, in order to avoid a 2-3 hour backup window on the night of go-live.
so what i’m thinking of was:
#1 Take a backup of the DB
#2 Restore that backup on to AWS RDS MySQL
#3 Setup replication between the local DB and RDS to start from a specific master_log_pos value
Is this scenario something that XtraBackup can help with (assuming it’s even doable) ? and if so, how do I do it ?
Thanks in advance.