Configuring for Database Backup - AWS Elemental Delta

This is version 2.3 of the AWS Elemental Delta documentation. This is the latest version. For prior versions, see the Previous Versions section of AWS Elemental Delta Documentation.

Configuring for Database Backup

The node is automatically configured to back up its database to /home/elemental/database_backups on the local disk.

Important

We strongly advise that you mount a remote folder as the location for backups. In that way, if the hardware unit fails, you can restore the database from that remote folder.

Perform the following procedure on each node.

To configure database backups

  1. Choose a remote server in your organization and designate a folder for backups. Mount that folder to the node as described in Adding Mount Points.

  2. On the web interface for the node, choose Settings > General.

  3. In Path to Store Backups, enter the path to the mount folder. The path always starts with /data/mnt/. For example, /data/mnt/delta01-backups

    Note

    Make sure you back up each node’s database to its own folder; do not back up the two nodes to the same folder.

  4. Change other fields as desired.

    Note that, when you reach the indicated number of backups to keep, AWS Elemental Delta deletes the oldest file before saving the next backup.

  5. If you changed the Minutes between backups, you must restart the node for the change to take effect. Run this command from the node:

    [elemental@hostname ~]$ sudo reboot

Backup files are named in this format: <yyyy-mm-dd_hh-mm-ss.tar.bz2>

To restore a database to a node

  1. At your workstation, start a remote terminal session to the hardware unit that is running AWS Elemental Delta. Log in with the user name elemental.

  2. Run the install script with the restore option:

    [elemental@hostname ~]$ sudo sh product --restore-db-backup pathbackup-file

    where:

    • product is the product installer. For example, elemental_production_delta.2.3.0.123456.run.

    • path is the path to the backup file. This path could simply be the remote folder where backups were originally stored.

    • backup-file is the file you want to restore. AWS Elemental Delta unzips the file and copies it to the appropriate folder. Do not unzip the file manually before restoring it!