How can I read from different Amazon RDS instances using one endpoint?

238 views Asked by Andrew At 14 March 2022 at 20:56

I’m gonna implement the following pattern using RDS Aurora instances:

I have to import into my DB large amount of data (about 30 millions of records) two times a day
Gonna create 2 instances: A and B
While data is being imported into the Instance A (it is about 30 minutes), user can read from the Instance B. And after successful data import he/she starts to read from the Instance A.
As far as I understand, I can use Route53 or CloudMap to map some URL to the specific endpoints of my Instances A and B, and I’m gonna swap instances by Cron.

Is it technically possible to implement such pattern in AWS or should I use some another approach for solving the problem?

TechQA.