The different storages databases/files for the e-Learning and VMMC systems 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 compressed file |
Moodle | Postgres SQL database Files folders | SQL dump → compress compressed .sql file files folder XXX |
Superset Configuraiton (User, Dashboards, Connections, etc) | Dashbaord definitons | ./dasbharods/xxxxx.yaml API ? SQL backup ? Víctor Enrique Mendoza Yanes |
...
Resulting file names for MOH ZWE:
Moodle db: YYYYyyyy-MMmm-DDdd-HHhh-MMmm-MOHmoh-ZWEzwe-MOODLEmoodle-4.5.SQL.GIZsql.giz
Moodle files: yyyy-mm-dd-hh-mm-moh-zwe-moodle-files.giz
VMMC db: YYYYyyyy-MMmm-DDdd-HHhh-MMmm-MOHmoh-ZWEzwe-MONGOmongo.7.GIZgiz
Superset: YYYYyyyy-MMmm-DDdd-HHhh-MMmm-MOHmoh-ZWEzwe-SUPERSETsuperset.3.GIZgiz
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:
...
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
...
Average backup size & transmisison time
Mooodle DB
Moodle files
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 |