I have the task of migrating an RDS database to an on-prem PXC.
What I would like is to set the PXC as a replication slave to the RDS until I am ready to failover to having all sources writing to PXC only.
The process can be async, meaning the PXC while a slave can be behind RDS.
Could someone help with the high level steps involved to do this. I was thinking something along the line of:
- Creating an rds replication slave to master rds
- Create an on prem slave to the PXC
- make the on-prem slave a ‘slave’ to the rds slave?