Backing Up Product Data
To make a consistent backup of your Paragon Active Assurance data, you need to stop all services accessing the database before starting the backup procedure. It is possible to make backups of a live system, but data consistency cannot then be guaranteed.
Proceed as follows:
-
Stop Paragon Active Assurance services:
sudo systemctl stop "netrounds-*" apache2 kafka openvpn@netrounds
-
Make backups according to the subsections below.
-
Start Paragon Active Assurance services:
sudo systemctl start --all "netrounds-*" apache2 kafka openvpn@netrounds
Backing Up the PostgreSQL Database
Run this command:
pg_dump -h localhost -U netrounds netrounds > ncc_postgres.sql
The pg_dump command will ask for a password which can be found in
/etc/netrounds/netrounds.conf under "postgres database". The default
password is "netrounds".
To learn about advanced options of pg_dump, such as compression, type
pg_dump --help
Netrounds versions before 2.29 used a MySQL database. If you are still using an old version, or if you are about to upgrade, use this command to back up a MySQL database:
mysqldump --user=root --password netrounds > ncc_mysql.sql
Alternatively, you may want to back up the database in binary format. If so, use this command:
pg_dump -h localhost -U netrounds -Fc netrounds > ncc_postgres.binary
Backing Up the OpenVPN Keys
Use this command:
sudo tar -czf ncc_openvpn.tar.gz /var/lib/netrounds/openvpn
Backing Up the Configuration Files
Make copies of the following files:
/etc/apache2/sites-available/netrounds-ssl.conf/etc/apache2/sites-available/netrounds.conf/etc/netrounds/netrounds.conf/etc/netrounds/probe-connect.conf/etc/netrounds/restol.conf/etc/netrounds/secret_key/etc/netrounds/test-agent-gateway.yaml/etc/openvpn/netrounds.conf
For example:
cp /etc/apache2/sites-available/netrounds-ssl.conf /etc/apache2/sites-available/netrounds-ssl.conf.old
Backing Up the RRD Files
The RRD (round-robin database) files contain the Paragon Active Assurance measurement data.
-
For a small-scale setup (< 50 GB), use this backup command:
sudo tar -czf ncc_rrd.tar.gz /var/lib/netrounds/rrd
-
For a large-scale setup (> 50 GB), making a tarball of the RRD files might take too long, and taking a snapshot of the volume can be a better idea. Possible solutions for doing this include: using a file system that supports snapshots, or taking a snapshot of the virtual volume if the server is running in a virtual environment.