Not the answer you need?
Register and ask your own question!

Restoring backup to AWS RDS and setting replication from a specific master_log_pos

revhrevh EntrantInactive User Role Beginner
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.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.