I am working on an API layer which serves requests from a backend database. So the requirements are:
- Repopulate the whole table without downtime for API service: A main requirement for the API is that we should be able to re-populate the tables( 2to 3 tables, structured csv like data) in backend database periodically (bi-weekly or monthly), but the API service should not go down.
- low latency globally in the order of 100s of millisecond
- scalability with requests per second
- rate limit clients
- also switch to previous versions of the tables in the backend in case of issues.
My questions are about what kinds of AWS database that i can use and other AWS components which can achieve the above goals.