9.0

Edit

Cold backup and restore

Currently, the cold backup and restore process cannot be used as a part of the 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 or restore only SPA data components.

From SPA 9.0.0 on, TLS certificates, config.yml and secrets.yml can be found in the distr archive in backup directory once the backup has been performed. You can use them in 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.

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

The backup script supports three possible operation:

  1. Prepare (optional) hot-sync data. It is a 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
  • s3_backend ( minio or riak )
  • 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 prepare (hot-sync step).

    Command:

    $ ./wf-backup.sh prepare all db

    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. Execute the step not only on DB Server but run manually on APP Server.

    $ wfmanager stop all

  3. Run the main backup step.

    ./wf-backup backup all db

    The script checks if there are no external connections to WF databases, shuts WF services down, and performs cold-sync of database components files. After all, the files are archived.

    As result in your {{ backup directory }}, you 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 backup storage.

APP Server

  1. Run the 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 installation first (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.

    caution

    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 installation first (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 are started successfully.

    $ ./wfmanager status

APP Server

  1. Run installation first (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 are started successfully.

    $ ./wfmanager status
← PreviousNext →