Restoring a database cluster from a snapshot in AWS Backup

• Amazon Web Services (AWS)

  • Requires: access to medicineone_clinicalbrain-prod account with the role Disaster_Recovery_Permissions

eNGINEERING

TODO

1. Navigate to Amazon Web Services (AWS)

2. Log in to the medicineone_clinicalbrain-prod account, utilizing the Disaster_Recovery_Permissions role

3. Select the Ireland region from the region selection menu

4. Navigate to RDS service

5. Select Snapshots from the navigation panel

6. Select the Backup service tab

7. Identify and select the latest snapshot based on the date and time it was created

8. Click on Actions → Restore snapshot

9. Enter a descriptive DB instance identifier (e.g. clinical-brain-dr)

10. In the Connectivity section, select cb-vpc from the DB subnet group dropdown menu and for the Existing VPC security groups choose allow-postgresql

11. Click on Restore DB cluster to initiate the restore process

12. Monitor the restore progress and wait for it to be completed

TODO

TODO

TODO

TODO

TODO

TODO

Connecting to and testing the restored database cluster

• Amazon Web Services (AWS)

  • Requires: access to medicineone_clinicalbrain-prod account with the role Disaster_Recovery_Permissions

• pgAdmin software

eNGINEERING

TODO

1. Navigate to Amazon Web Services (AWS)

2. Log in to the medicineone_clinicalbrain-prod account, utilizing the Disaster_Recovery_Permissions role

3. Select the Ireland region from the region selection menu

4. Navigate to RDS service

5. Select Databases in the navigation panel

6. Click on the database name that corresponds to your restored cluster

7. Navigate to the Connectivity & Security tab within your database's detail page

8. In the Endpoint section, identify and record the value of the Writer endpoint, as it is essential for establishing a connection to the disaster recovery database.

9. Navigate to Parameter Store service

10. Locate and open the parameter /databases_connection_strings/master_user

11. Click on Show decrypted value and note the displayed Credentials, needed for authenticating against the disaster recovery database

    Open

    

12. Open pgAdmin software

13. Launch the pgAdmin software

14. Right click on Servers and navigate to Register → Server

    • In the General tab, enter clinical-brain-dr in the Name field

    • Switch to the Connection tab

    • In the Host name/address field, input the RDS Writer endpoint you noted earlier

    • Use the Credentials from the Parameter Store for the Username and Password fields

    • Click on Save

15. Expand the clinical-brain-dr server

16. Right click on clinical_brain database and select Query Tool

17. Run some SQL queries to test data integrity

TODO

TODO

TODO

TODO

TODO

TODO

Removing any temporary resources created during the testing process to avoid unnecessary charges

• Amazon Web Services (AWS)

  • Requires: access to medicineone_clinicalbrain-prod account with the role Disaster_Recovery_Permissions

eNGINEERING

TODO

1. Navigate to Amazon Web Services (AWS)

2. Log in to the medicineone_clinicalbrain-prod account, utilizing the Disaster_Recovery_Permissions role

3. Select the Ireland region from the region selection menu

4. Navigate to RDS service

5. Select Databases in the navigation panel

6. Click on the database name that corresponds to your restored cluster

7. Click on Actions → Delete

8. Monitor the delete progress and wait for it to be completed

TODO

TODO

TODO

TODO

TODO

TODO