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?