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.

This page was last reviewed on 7 September 2022. It needs to be reviewed again on 7 March 2023 by the page owner #govwifi .

This page was set to be reviewed before 7 March 2023 by the page owner #govwifi. This might mean the content is out of date.