Hyperic Database Backup and Recovery

The Hyperic database contains most of the data necessary to recreate your Hyperic Server environment after a failure, or to move the database to a different host. In addition to historical metrics, the database contains configuration settings, such as Hyperic Agent connection information, collection intervals, portlet configurations, groups, roles, and users. Some server configuration data, such as database connection information, the mail server for alerts, and Java arguments used at server startup, is stored in external files.

Like any other database, your Hyperic database should be backed up on a regular basis, so that you can restore the data in the event of a failure that corrupts or destroys the database. It is also good practice to backup the database prior to upgrading Hyperic, your database server, or other software that resides on the server machine.

You should define Hyperic backup procedures and incorporate them into your overall backup processes. Your local requirements and practices will dictate backup frequency, timing, naming conventions, and retention policies. A daily backup is sufficient for most environments.

Shut down Hyperic Server if backup makes database unavailable

If your database backup process makes the Hyperic database unavailable, shut down the Hyperic Server before running the backup.

Backing up Built-In PostgreSQL Database

If you use Hyperic's built-in PostgreSQL database, back it up with the PostreSQL pg_dump command:

pg_dump hqdb | gzip > hqdb-MM.DD.YY.dump.gz

Copy the dump file to your backup location.

Always use this method to back up the built-in database; do not simply copy the contents of the database's data directory.

Backup and Recovery of MySQL and Oracle Databases

If you use MySQL or Oracle for your Hyperic database, extend your existing database backup and recovery procedures to the Hyperic database. Perform a full database backup on a scheduled basis.

Hyperic Files to Backup

In addition to the Hyperic database, you may want to create a backup of the following directories and files in your server directory:

conf/
bin/hq-server.sh
hqdb/data/postgresql.conf

You can back up these files while Hyperic Server is running.

The contents of these files are stable. Changes are infrequent once your Hyperic Server is installed at configured. Back them up at that time and after making changes to the sever configuration.