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

Hi revh;

That’s the basic idea, though you’ll probably have to use mysqldump vs. xtrabackup. There are a lot of good guides out there on this (it’s a fairly common activity), so I would start with the below and then do some extra Googling if you need some additional information:

[url]http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html[/url]

[url]https://www.percona.com/blog/2014/07/28/what-i-learned-while-migrating-a-customer-mysql-installation-to-amazon-rds/[/url]

[url]https://engineering.gosquared.com/migrating-mysql-to-amazon-rds[/url]

-Scott