thanking you for your responses. I have one "rds proxy" connected to "aurora rds primary" in one region and another "rds proxy" connected to the other "aurora rds stanby or secondary" but in a different region.
Here comes the challenge: If the first "rds proxy" goes down
- How to manage so that the "secondary rds proxy becomes active" and is transparent to applications?
- Is there some architectural pattern to have "rds proxy" in high availability across two different regions.