Improve DB backups (retention rates & manual backup plan) #4281
Description
Issue description
We want to create a more robust system of DB backups (especially for stable, staging, and test data). To do this, accomplish the following 2 tasks:
1 - Increase db backup retention period for stable, staging, and test to 35 days IF this does not incur additional cost. Cloud.gov automatically creates backups of our DBs. The default retention time period for these backups is 14 days. Their documentation states we can increase backup retention up to 35 days ~ but it is unclear whether this will incur additional cost. Research (and/or contact [email protected]) to gain clarity on cost impact of increasing DB retention periods for our stable, staging, and test resources. If there is additional cost, coordinate with leads on whether to proceed.
2 - Research and propose a manual backup plan for our test DB that will allow us to conduct our own backups for that database. The plan should include proposals for where to store the DB backup and the method for creation (see https://docs.cloud.gov/platform/services/relational-database/#backups-and-recovery for reference) -- relates to #3908
Acceptance criteria
- DB retention time frames for stable, staging, and test are increased to 35 days (cost allowing)
- Propose plan for manual test DB backups to leads
Additional context
No response