23 lines
700 B
Plaintext
23 lines
700 B
Plaintext
# 51. SQL backups to S3
|
|
|
|
Date: 2021-01-22
|
|
|
|
## Status
|
|
|
|
Accepted
|
|
|
|
## Context
|
|
|
|
We need to take SQL dumps as backups, so that in case of disaster, we can import an SQL backup.
|
|
We currently take RDS snapshots, but these can only be restored to an RDS - which can lengthen the time it takes to restore a database
|
|
|
|
## Decision
|
|
|
|
We will create a scheduled task for each RDS launched, that will take an SQL dump of each database created on it.
|
|
These will be stored in S3, with Standard-IA (infequent access) to reduce cost of storing the backups.
|
|
The backups will be deleted after 90 days.
|
|
|
|
## Consequences
|
|
|
|
If AWS does completely go down, these will be unavailable, so offsite backups should be kept aswell.
|