Easy Backup of MySQL for Harvester and Console in NFA

Products

• Network Observability

Issue/Introduction

What's the best method to backup MySQL database for my Harvester and my Console?

Environment

Network Flow Analysis version 23.3+ 

Resolution

1.  Before performing any backups or restoration, its important to stop the following services:

Console:

CA NFA OData Service
CA NFA RibSource
NetQos Reporter Manager Service
NetQos Reporter / Analyser General Service
NetQos Reporter / Analyser Pump Service
NetQos Reporter / Analyser Query Service
NetQos Reporter / Analyser Watchdog
NetQos Reporter / Analyser Report Services
Performance Center SSO

Harvester:

CA NFA Collection and Poller Webservices
CA NFA Data Retentions
CA NFA DNS/SNMP Proxies
CA NFA File Server
CA NFA Harvester
CA NFA Poller
CA NFA Reaper
NetQoS NQMySql

*For Harvesters running Linux, you can run the script to stop services in /opt/CA/NFA/Tools/:

Linux Harvester:

cd /opt/CA/NFA/Tools/
./harvester-services.sh stop

 

2.  For the Console, use the following to backup:

mysqldump -uroot -proot@123 reporter > reporterbackup.sql

3.  For the Harvester, use the following to backup:

mysqldump -uroot -proot@123 harvester > harvesterbackup.sql

 

Replace root@123 with the MySQL password if its been changed.

Keep in mind that the output folders can also be specified, based upon OS:

> C:\harvesterbackup.sql
> /tmp/harvesterbackup.sql

4.  Restart services when complete.

Additional Information

Restoration of these files is equally easy, beging by stopping the services listed above:

For the Console:

mysql -uroot -proot@123 reporter < reporterbackup.sql

For the Harvester:

mysql -uroot -proot@123 harvester < harvesterbackup.sql

Then Restart Services when Complete