The different storages are backed up every 24hrs, at 1am local time. Resulting files are stored in the folder root/backups. Details about what is backed up is detailed on the table below.
System | What is backup | Backup procedure |
|---|---|---|
VMMC DB | Mongo DB | Mongo dump → compress file |
Moodle | Postgres SQL database Files folders | SQL dump → compress .sql file files folder |
Superset Configuraiton (User, Dashboards, Connections, etc) | Dashbaord definitons | ./dasbharods/xxxxx.yaml API ? SQL backup ? Víctor Enrique Mendoza Yanes to update what file are we going to backup? |
Backup file naming conventions
We use the following convention:
YYYY-MM-DD - the date that the backup was completed, local time
HH-MM: the time that the backup was completed, local time
“MOH_ZWE”+system: the name of the system backed up
.X.X - The version of the associated product, to ensure “restorability”
.XXX the file extension
Resulting file names for MOH ZWE:
Moodle db: YYYY-MM-DD-HH-MM-MOH-ZWE-MOODLE-4.5.SQL.GIZ
VMMC db: YYYY-MM-DD-HH-MM-MOH-ZWE-MONGO.7.GIZ
Superset: YYYY-MM-DD-HH-MM-MOH-ZWE-SUPERSET.3.GIZ
Retention
In the absence of any mandate on backup frequency and retention, the following backup procedure was implemented for the various systems' databases, as of December 2024:
Daily backups, kept for 31 days
Weekly backups (Sunday), kept for 1 year
Monthly backups (last day of the month), kept for 7 years
For the Moodle folder, we implemented the following backup policy:
Daily backups, 31 days
Weekly backups, kept for 6 months
Monthly backups, kept for 7 years
The moodle files folder contains:
Language customizations
Files & images uploaded to Moodle
Cache storage
User session’s data
Storage needs
Total disk capacity required (cumulative)
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |
|---|---|---|---|---|---|---|---|
Total storage for backups mb |
Backup | Year-to-date | Year 2-7 |
|---|---|---|
Retention for databases | Last 30 days Last 52 weeks (Sunday) Last 12 month (Last day of month) = 94 backups | Last day of the month Year 2-7 = 72 backups |
Retention for Moodle files | Last 7 days | n/a |
Retention for Moodle files | Daily backups, 14 days Weekly backups, 6 months Monthly backup for 6 month | Monthly backups, kept for 7 years |
Moodle/ SQL | avg backup size: 1.0 Mb Transmission time: 5s | + 20% annual increase |
Moodle files | ||
VMMC Mongo | avg backup 1.0 Mb | |
Superset backup | avg backup 1.0 Mb |