Database backups
GovWifi databases are automatically backed up, a process covered by the govwifi-database-backup repo.
This repo contains scripts used to perform the automated data export of all GovWifi MySQL databases.
GovWifi databases are exported using mysqldump. The contents of the SQL dump are compressed and stored in Amazon S3.
Backups are scheduled to run nightly and target replica instances. This is in addition to automated RDS snapshots of primary servers.
The backup script runs as a scheduled container task using Amazon ECS which is configured in govwifi-terraform under database-backup-task.tf.
We need to rotate the IAM Access keys for IT periodically. Detailed instructions are kept in Google Docs (you will need to be a member of the GovWifi Team to access these).