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.  

5. Store .sql files in safe location.

Additional Information

Restoration of these files is equally easy.

 

1.  Begin by stopping the services listed depending on which server you're addressing:

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

2.  You will need to ensure that the following service remains running:

CA MySql

3.  Find and locate the backed up .sql files

4.  Perform the restoration: 

For the Console:

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

For the Harvester:

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

5.  Then Restart the remaining services when complete