Resonant Backup and Recovery

Overview

Backups on the ILUS system should be performed on a regular basis. Critical business data is contained in two areas:

1. Database – contains all transactional data.

2. Document Management System – file storage, which is typically a mounted network folder.

Since ILUS has long running transactions, one of the following should be done when backing up the system.  Different backup systems have different requirements; use the procedure appropriate for your backup system.

Using a Live Backup System

If you use a live backup system that uses a shadow copy for open/active files (i.e. database files, outlook folders, etc.), backup and restore the live system as instructed by your backup software.

Cannot Backup Open/Active Files

If you use a backup system that will not work with open/active files you will need to take the following steps when backing up and recovering:

Backup

1. Stop the Resonant AP Hub service, as described in the section Startup and Shutdown.

2. Stop the MySQL service.

3. Perform the backup procedure. The database and ILUS folders must be backed up together.

Restore

1. Restore the system. ILUS and MySQL must be restored from the same backup.

2. Start the MySQL service.

3. Start the Resonant AP Hub service.

Manual Backup

If you back up the system manually or with a script, follow these steps.

Backup

1. Stop the Resonant AP Hub service.

2. Create a copy of the Resonant database (explained in the section, Dumping the ILUS Database).

3. Copy the entire %RESONANT_HOME%/APHub folder and the Resonant database file or files to a safe location. These files must be paired together in order to be able to restore correctly.

Restore

1. Perform a backup of the currently running system.

2. Stop the Resonant AP Hub service.

3. Import the Resonant database using the following syntax from command line (where %PASSWORD% is the database password and %BACKUP_FILE% is the location of the backed-up Resonant Life Solutions database):

mysql.exe –uresonant –p%PASSWORD% < %BACKUP_FILE

4. Copy the contents of the backed-up %RESONANT_HOME%/APHub directory back to its original location.

5. Start the Resonant AP Hub service.

Dumping the ILUS Database

Each database vendor provides unique dump/restore tools. For MySQL, perform the following steps:

1. Stop the Resonant AP Hub service.

2. Execute this statement from command line:

mysqldump –uroot –p%PASSWORD% life > %OUTPUT_FILE%

3. Restart the Resonant AP Hub service.

Log Files

ILUS maintains a detailed log file called server.log. Most system issues, such networking errors, may be quickly diagnosed by quickly reviewing the server.log file. The log files are located in:

%RESONANT_HOME%/APHub/processHub/standalone/log/

By default, each day at midnight all log files are started again.  When the log file is started again, the previous day’s log file is renamed and saved, appending a date stamp to the filename (e.g., resonant.log.2015-03-18). This default midnight rollover may be modified to satisfy other preferences, such as maximum log file size.