Skip to content

Technical docs

Amanda Ho-Lyn edited this page Jun 13, 2024 · 1 revision

Backing up and Restoring DB

From #7:

For an emergency backup and restore, we can ask ISD. Both production and pre-production VMs (frra-app01.ad.ucl.ac.uk and frra-app01p.ad.ucl.ac.uk) are backed up daily at night, and they keep these backups for 30 days. We can request a snapshot to be taken at a certain time when we are about to do a major update or something that is risky and we may need to revert. Restoring to a previous backup needs to be requested to HIS, who will perform the restore.

They suggest I test the restore process once we have had pre-prod running with the web application:

  • Shutdown frra-app01p
  • Restore the VM to VM name frra-app01p-restore
  • Power on frra-app01p-restore and test to confirm everything works as you expect
  • Shutdown VM frra-app01p-restore and delete it from VMWare
  • Power on VM frra-app01p
  • Restore test will then be complete

So we don't need to worry about puppet, restore happens from a snapshot and not the puppet configuration.