Preparing for disaster recovery - Data360_DQ+ - 11.X

Data360 DQ+ Enterprise Installation

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
11.X
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Enterprise Installation
Copyright
2024
First publish date
2016
ft:lastEdition
2024-06-06
ft:lastPublication
2024-06-06T12:37:34.761477

Scheduling backups

  1. Manually add the backupApplicationDb and backupComputeDb tasks to the crontab file. Include the frequency at which you want to perform backups in the following format:

    <Minute> < Hour> <DayOfMonth> < Month> <DayOfWeek> < Command>

    For example, to run a full backup of the ApplicationDB and ComputeDB components every day at midnight, add the following:

    0 0 * * * /opt/infogix/dqplus/bin/backupApplicationDb

    0 0 * * * /opt/infogix/dqplus/bin/backupComputeDb

Restoring the system

  1. Backup the application database by executing the backupApplicationDb script from the <dqplus home>/bin directory:

    ./backupApplicationDb

  2. Clean-up the application database:
    1. Stop the application before erasing its database:

      <dqplus home>/bin /stopApplication

    2. Step into the ApplicationDb Docker Container:

      docker exec -it dqplusApplicationDb bash

    3. Obtain a connection to the PostgreSQL database, within the ApplicationDb Docker Container:

      psql -U postgres -d igxsagacity

    4. Drop the application schema:

      DROP SCHEMA sagacity CASCADE;

      Note: The application database backup is a full backup of the schema, therefore the schema will be created as a part of the restore process.
    5. Exit the PostgreSQL shell and the Docker container:
      • \q ends the current psql session
      • exit exits the current Docker session and returns you to the terminal
  3. Restore the application database:
    1. To list all available application database backups, run the following command:

      ./restore applicationdb list

    2. To restore to a backup, run the following command, pointing to the specific backup that you want to restore to:

      ./restore applicationdb 2017-08-09-11-21/igxsagacity_backup.sql.gz

  4. Restart the application after backup recovery:

    ./stop

    ./start

  5. Backup the Compute database:
    1. Run the backupComputeDb script from the <dqplus home>/bin directory:

      ./backupComputeDb

    2. To list all available compute database backups, run this command:

      ./restore computedb list

    3. Copy the sagacity_default_backup.ini file from the new backup location to the backup/configuration directory, for example, copy from:

      <backup location>/computeDb/full/20190613175428/configrations/sagacity_default_backup.ini

      to

      <backup location>/configrations/sagacity_default_backup.ini

    4. To restore to a backup, run the following command, pointing to the specific backup that you want to restore to:

      ./restore computedb 20170622220804

  6. Restart the application after backup recovery:

    ./stop

    ./start