The design specifies that the Info services is using AWS RDS Aurora PostgreSQL as the backend. What about the backup on Jetstream? It would need to be independent of AWS, right? Is it running regular PostgresSQL and somehow mirroring Aurora data?
© ACCESS All Rights Reserved.
ACCESS is an advanced computing and data resource supported by the
National Science Foundation
and made possible through these lead institutions and their partners:
Carnegie Mellon University,
University of Colorado Boulder,
University of Illinois at Urbana-Champaign, and
State University of New York at Buffalo .
We'll keep a database backup on Jetstream.
Live backup or periodic snapshots?
AWS doesn't support live transaction shipping to an external standby database, so we'll need to either snapshot periodically, or run it in parallel. Because of the higher-availability of AWS RDS, I think a weekly backup should be good enough for disaster recovery purposes.