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 convertions
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 procedures was implemented as of December 2024:
Daily backups, kept for 30 days
Weekly backups, kept for 1 year
Monthly backups, kept for 7 years
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 |
Backup | Year-to-date | Year 2-7 |
|---|---|---|
Retention | Last 30 days Last 52 weeks Last 12 month = 94 backups | Last day of the month Year 2-7 = 72 backups |
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 |