9.1

Edit

Cold backup and restore

Currently, the backup and restore process cannot be used as a part of migration process, if DNS names are changed, due to VAULT DB component containing records with old DNS names from the previous installation.

This backup script can back up and restore only SPA data components.

From SPA 9.0.0, TLS certificates, config.yml and secrets.yml can be found in the distr archive in the backup directory once the backup is performed. You can use them in the restore process.

important

In SPA 8.5.X, backup scripts were incorporated in the Ansible installer.

Since SPA 9.0, backup scripts are a part of the product and located in

{{ install_dir }}/tools/cold-backup.

General information

The ansible installation comes with the script that implements the following cold backup solution design:

Backup script

The backup script syntax is as follows: wf-backup.sh { OPERATION } { COMPONENT } { ROLE }

$ ./wf-backup.sh
Usage:
 ./wf-backup.sh {prepare,backup,restore} 
{all,mysql,postgresql,riak,minio,mongodb,vault,nexus,rpa-manager,distr} {apm,db,app} [EXTRA_VARS...]
Examples:
./wf-backup.sh prepare all db
./wf-backup.sh backup all db
./wf-backup.sh restore all db
./wf-backup.sh backup rpa-manager app
./wf-backup.sh restore rpa-manager app
./wf-backup.sh backup mongodb apm
./wf-backup.sh restore mongodb apm

Available procedures

Backup script supports three possible operation:

  1. Prepare (optional) hot-sync data. It is part of Backup operation, but can be launched separately before the main backup process to achieve minimal downtime.
  2. Back up. All SPA services are turned off, components are archived. Once completed, the services are restarted.
  3. Restore. The script searches for backup archives in the backup directory and performs the restore process.

Components for backup

Depending on Server ROLE (APM, DB, APP), the script supports backup and restore of the next components:

DB ROLE:

  • mysql
  • postgres
  • minio
  • mongodb
  • vault
  • nexus

APM ROLE:

  • mongodb

APP ROLE:

  • rpa-manager

Variables used in backup script

$ cat secrets.yml

mysql_admin_user : mysql

mysql_admin_pass: mysql

postgresql_admin_user: postgres

$ cat config.yml

install_dir: /opt/workfusion

backup_directory: '{{ install_dir }}/backup'

Backup procedure

DB Server

  1. Run a preparation step (hot-sync step).

    Command

    $ ./wf-backup.sh prepare all db

    The script copies (hot-sync) all DB components to {{ backup_directory }}.

    Result

    $ ls -1 /opt/workfusion/backup/

mongodb_db

mysql

nexus

postgres

riak

rpa-manager

vault

  2. Shut down APP services. This step should be executed not on DB Server but run manually on APP Server.

    $ wfmanager stop all

  3. Run the main backup step.

    ./wf-backup.sh backup all db

    The script checks if there are no external connections to WF databases, shuts WF services down, then performs cold-sync of database components files. In your {{ backup directory }}, you will find the archives with backups of components' content :

    $ ls -1 /opt/workfusion/backup/

...

mongodb_db-1516797995.tar.gz

mysql-1516797995.tar.gz

nexus-1516797995.tar.gz

postgres-1516797995.tar.gz

riak-1516797995.tar.gz

vault-1516797995.tar.gz

  4. Move these archives to the backup storage.

APP Server

  1. Run a main backup step.

    Command

    $ ./wf-backup.sh backup all app

    Result

    $ ls -1 /opt/workfusion/backup/
rpa-manager-1516800559.tar.gz

  2. Move this archive to the backup storage.

PM Server

  1. Run the main backup step.

    Command

    $ ./wf-backup.sh backup all apm

    Result

    $ ls -1 /opt/workfusion/backup/

mongodb_apm

mongodb_apm-1516865538.tar.gz

  2. Move this archive to the backup storage.

Restore procedure

DB server

  1. Run the installation (as root).

    $ ./install.sh precheck db && ./install.sh preinstall db 
$ su - wfuser
$ ./install.sh install db && ./install.sh check db

  2. Put backup archives with DB components into the backup directory.

  3. Run the restore command. All services on APP Server should be stopped.

    ./wf-backup.sh restore all db

  4. Verify that services started successfully.

    $ wfmanager status

PM Server

  1. Run the installation (as root).

    $ ./install.sh precheck apm && ./install.sh preinstall apm 
$ su - wfuser
$ ./install.sh install apm && ./install.sh check apm

  2. Put backup archives with APM components into the backup directory.

  3. Run the restore command.

    $ ./wf-backup.sh restore all apm

  4. Verify that services started successfully.

    $ ./wfmanager status

APP Server

  1. Run the installation (as root).

    $ ./install.sh precheck app && ./install.sh preinstall app 
$ su - wfuser
$ ./install.sh install app && ./install.sh check app

  2. Put backup archives with APP components into the backup directory.

  3. Run the restore command.

    $ ./wf-backup.sh restore all app

  4. Verify that services started successfully.

    $ ./wfmanager status
← PreviousNext →