Business Function
The RDS instances store the following information
- Rave EHR Data Map
- Rave Site Subject
- Rave Study Site
- Rave User Role
- Rave Visit
- Load Subject queue
There are four environments:
- dev
- demo
- uat
- prod
Scope
The scope of this document is all four RDS environments (dev, qa, uat, prod) running in the DDC AWS Account.
The regional scope of this RC is the eu-west-1 region of AWS.
Key Information
- Latest RDS snapshots are needed
- KMS key used to encrypt the database that needs to be restored
Recovery Checklist & Dependencies
The following tables provide the step-by-step recovery checklist that the ACE Infra team can use to guide them through the recovery steps for the ETL RDS instances.
| Status | Task Summary | Task Details |
|---|---|---|
| ☐ | Log into AWS | Log into the AWS Console using this link |
| ☐ | Restore RDS from Snapshot | Select the latest snapshot for the RDS environment that is being restored. Use the steps in this guide from AWS to restore the snapshot |
| ☐ | Select DB Engine | Production DB Engine is 5.7.mysql_aurora |
| ☐ | Add the DB instance identifier | Type a name for your DB instance. The name must be unique across all DB instances in the current AWS Region. |
| ☐ | Do not create standby instance | Do not create a standby instance undser Availability and durability |
| ☐ | Select VPC | Use the following VPC: vpc |
| ☐ | Select Subnet Group | Use the following subnet group: “ |
| ☐ | Public access | Publicly accessible should be set to no |
| ☐ | Security Group | Use the following security group: “ |
| ☐ | Select AZ | Select the AZ that is available and working |
| ☐ | Instance Configuration | 1. For prod / uat: Under instance configuration, select Memory optimized classes, db.r5.2xlarge 2. For dev /qa: Under instance configuration, select Memory optimized classes, db.r5.large or similar |
| ☐ | Storage type | Use the following storage type: Provisioned IOPS SSD (io1), 1000 IOPS |
| ☐ | Database authentication | For DB authentication select Password authentication |
| ☐ | Enable Encryption | Enable encryption using the following AWS managed kms keys: “ |
| ☐ | Initial Database Name | Input a database name. The name must be unique for the region. |
| ☐ | DB parameter group | Use the following parameter group: “ |
| ☐ | Option group | Use the following option group: “ |
| ☐ | Copy tags to snapshots | Check the box to copy tags to snapshots |
| ☐ | Maintenance | Disable auto upgrades for minor versions |
| ☐ | Log Exports | Enable log exports for Alert and Audit logs. |
| ☐ | Delete protection | Enable deletion protection |
| ☐ | Restore from snapshot | At the bottom right click Restore DB Instance |
| ☐ | Enable automated backups | 1. Wait for the database to created and is in the Available status. 2. Select the newly created database and click the modify button at the top right. 3. Scroll down to the Backup section and check Enable automated backups. 4. Next select the following options: Backup retention of 30 days for prod and uat, 14 days for dev and qa. E sure copy tags to snapshots is checked 5. Start time is 19:00 UTC and Duration is 0.5 hours. 6. Click continue to save |