I wanted to transfer my mysql databaes from us-east-1 (virginia) to eu-east-1 (ireland) without loosing any data. Also, I want to stop virginia after transfering database from one region to other region.
I have read about read replicas. I have tried once to make one read replica to another region with public access available. Once replica was ready I have promoted it and tried to access publicly . But I was not able to access the database with same credentials .
Also, I have seen blogs related to cloud formation.