Versions Compared

Version Old Version 6 New Version 7
Changes made by

Ricardo Gomez

Ricardo Gomez

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following page details the process and files stored for ZWE MOH machines:

Table of Contents
stylenone

...

Backup Files and Process

The different databases/files for the e-Learning, VMMC and Analytic 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 → compressed file

eLearning

Resource files

Status
colourRed
titleMISSING

Postgres SQL database

  1. Dump postgres database.

  2. Extract database dumped from docker container.

  3. Transfer dump file to backup machine.

Superset

Config files

  1. Extract configuration file from docker container.

  2. Transfer configuration file to backup machine.

Dashboard

  1. Rename existing backup files

  2. Remove previous backup files.

  3. Create new dashboards backup.

  4. Extract dashboards backup.

  5. Transfer dashboard to backup machine.

Database

  1. Dump postgres database.

  2. Extract database dumped from docker container.

  3. Transfer dump file to backup machine.

NiFi

Configuration folder (includes nifi flows, user credentials, etc)

  1. Compress configuration directory.

  2. Extract configuration directory from docker container.

  3. Transfer configuration directory to backup machine.

Datawarehouse

Postgres SQL Database

  1. Dump postgres database.

  2. Extract database dumped from docker container.

  3. Transfer dump file to backup machine.

Docker analytics volume

Volumes folder

  1. Compress volume directory

  2. Transfer compressed directory to backup machine.

Docker elearning volume

Volumes folder

  1. Compress volume directory

  2. Transfer compressed directory to backup machine.

...

File Naming Conventions

We use the following convention:

...

  • Moodle db: yyyy-mm-dd-hh-mm-moh-zwe-moodle-4.5.sql.giz

  • Moodle files: yyyy-mm-dd-hh-mm-moh-zwe-moodle-files.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 Policies

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:

...