Backup and Restoration Process

Index

• Overview
• Virtual Machine Snapshots
• Backing up your current Statseeker Installation
  • Configuring an SSH Backup
  • Configuring an SFTP Backup
  • Destination Server Host Key Changes
• Stopping a Running Backup Process
• Scheduling Automated Backups
• Restoring Statseeker from a Backup

Overview

Statseeker supports local and remote backup regimes and backups may be both scheduled and initiated manually.

[top]

Virtual Machine Snapshots

If you are running Statseeker on an VM, it is strongly advised that you do not use VM snapshots as an alternative to creating Statseeker backups.

If you must rely on a snapshot for backup and restoration purposes, then it is imperative that you DO NOT snapshot a live (running) Statseeker server, instead cleanly shutdown the server prior to creating the snapshot. Failure to do so can result in database corruption leading to everything from data loss to a dead server.

To shut down the server correctly:

• Log in to your Statseeker server via ssh or directly
• From the command prompt enter ssadmin and enter the root user password if prompted

This will display the ssadmin menu, offering access to the different areas of functionality.

• Select 8. Operating System
• Select 3. Shutdown Server
• Monitor the Statseeker server state in the VM host, and once it has shutdown create the snapshot

[top]

Backing up your current Statseeker Installation

To backup your current Statseeker installation:

• From the Administration Tool, select Statseeker Administration > Backup/Restore
• Click Edit (top-right)
• Select the Method
  • local - the backup will be saved to a specified local directory on the Statseeker server
  • ftp - Statseeker will open an ftp connection and write the backup file directly to the specified directory on the destination server
  • ssh - Statseeker will open an ssh connection and write the backup file directly to the specified directory on the destination server
  • sftp - Statseeker will open a secure ftp connection and write the backup file directly to the specified directory on the destination server
  Note: prior to using ssh to connect to the destination server, the destination server will need to be configured to accept a password-less ssh connection from the Statseeker server.
• Specify the backup destination path and any credentials required to access that path as required by the selected Method
• Specify the Cycle Count (the number of backups to keep) and Start Time

• Click Save



The backup configuration will be saved, and the form returned to the non-editable Display mode.

• You can test the configuration to ensure that the credentials supplied are valid and will provide write access to the specified destination directory (local backups use the statseeker user account).
  • Click Test
  • Select a size for the test backup and click Test

  The backup configuration will be tested, and the results displayed.

  

Once you are satisfied with the configuration:

• Click Edit
• Click Manual Backup

A confirmation dialog will be displayed.

• Click Yes

The backup will begin, and the progress will be displayed. Once the backup is complete you can Verify the resulting backup file.

[top]

Configuring an SSH Backup

SSH and SFTP backups allow you configure a secure backup process to a remote server on your network. Both methods require the destination server to have a copy of the public key to the SSH certificate that the Statseeker server is using.

To configure the backup:

• Create a backup directory on the destination server
• Configure the directory write permissions as needed

• Ensure the destination server has an /.ssh/authorized_keys file, if not create it

• Configure the backup in Statseeker, specifying the server, backup directory and a destination server user that has write permission to that directory

You will be prompted to generate an SSH key (unless there is already a key configured on your Statseeker server)

Clicking Yes will generate and display the key

• Copy the key and append it to the authorized_keys file

• Save the backup configuration in Statseeker

Statseeker will test the connection using the saved configuration.

[top]

Configuring an SFTP Backup

SFTP backups allow you configure a secure backup process to a remote server on your network. This method requires that:

• The destination server has a copy of the public key to the SSH certificate being used by the Statseeker server
• The destination server is configured to allow SFTP connections

To configure the backup:

• Create a backup directory on the destination server
• Configure the directory owner and write permissions as needed, the backup configuration will specify a user which will be used to log in to the destination server and write the backup file to the backup directory.

• Ensure the destination server has an /.ssh/authorized_keys file, if not create it

• Configure the backup in Statseeker, specifying the server, backup directory, and a destination server user that has write permission to that directory

You will be prompted to generate an SSH key (unless there is already a key configured on your Statseeker server)

Clicking Yes will generate and display the key

• Copy the key and append it to the authorized_keys file

• Save the backup configuration in Statseeker

Statseeker will test the connection using the saved configuration.

[top]

Destination Server Host Key Changes

When configuring secure backup using SSH/SFTP, Statseeker adds a host 'fingerprint' for the backup destination server to a 'known hosts' file. This fingerprint is used to verify the server's identity during future connections, ensuring that Statseeker connects to the same server as before.

• Upgrading the destination server's operating system often results in the locally stored host key fingerprint in Statseeker no longer matching the destination server's key
• As a result, Statseeker's backup process will fail when attempting to connect to a destination that fails this fingerprint check

To resolve this issue, please refer to the Managing SSH Host Key Changes guide.

[top]

Stopping a Running Backup Process

The Administration Tool offers the ability to stop a running Backup process.

• From the Administration Tool, select Statseeker Administration > Backup/Restore
• Click Edit (top-right)

Progress through the currently running backup process will be displayed along with the option to stop this process. The process cannot be resumed once halted but can be restarted manually or according to the configured backup schedule.

• Click Stop Backup to halt the backup process.

[top]

Scheduling Automated Backups

To schedule the backup process:

• From the Administration Tool, select Statseeker Administration > Backup/Restore
• Click Edit (top-right)
• Use the checkboxes to specify on which days the backup should be performed

Clicking in the Start Time field will display a time-selector

• Specify a Start Time using the selector or manually enter a time
• Optionally enter an email address to receive notifications resulting from the automated backup process.
Note: you will need to configure Statseeker to be able to send email notifications, this is managed from Administration Tool > Statseeker Administration > Email Configuration
• Click Save

[top]

Restoring Statseeker from a Backup

To restore Statseeker from a previously created backup:

• From the Administration Tool, select Statseeker Administration > Backup/Restore

The Backups section lists the existing backup files.

• Click Edit (top-right)
• Select one of the stored backups and click Verify - this will allow you to confirm that the backup is valid prior to attempting to restore from the backup data

• Once the backup data has been verified click Restore

A confirmation dialog will be displayed detailing the backup data selected for the restore process.

• Click OK to begin the restore process

A dialog will be displayed when the restoration process has completed.

• Click OK to close the dialog

[top]