Versions Compared

Version Old Version 5 New Version 6
Changes made by

Rodolfo Melia

Ricardo Gomez

Saved on

Key

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

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

Each server contains their own backups stored in the following folder:

Code Block
/opt/backups/

The process to backup files are triggered by multiple bash files inside the /opt/backups/ path of each app/service. The following table details the order that each script file is triggered in order to be backed up:

System

What is backup

Backup procedure

VMMC DB

Mongo DB

Mongo dump → compressed fileMoodle

eLearning

Resource files

Status
colourRed
titleMISSING

Postgres SQL database

Files folders

SQL dump → compressed .sql file

files folder XXX

Superset Configuraiton (User, Dashboards, Connections, etc)

Dashbaord definitons

SQL backup

Configuration files (.yaml)

Dashboards (.yaml → .zip)

  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.

Backup file naming conventions

...