NFA 22.2.6 Upgrade Path Requirements

Products

• CA Network Flow Analysis (NetQos / NFA)
• DX NetOps

Issue/Introduction

If you plan to upgrade to Network Flow Analysis 22.2.6, PLEASE read this document. 

The upgrade consists of a major MySQL upgrade from version 5.7.x to 8.0.31.

Environment

Release : NFA

Resolution

The ONLY supported upgrade path from NFA 9.x and up is to FIRST upgrade to NFA 22.2.5. Once you are on 22.2.5, you can upgrade to 22.2.6. However we highly recommend going right to NFA 22.2.7 where you can upgrade from any version and only step 1 from this document is needed (backups). 

1. Backup the MySQL databases (substitute 'root@123' for your own root password if changed on versions 21.2.8 or higher):

NFA Console 21.2.6 or lower: mysqldump reporter -uroot --routines --events > x:\reporter_backup.sql

NFA Harvester 21.2.6 or lower: mysqldump harvester -uroot --routines --events > x:\harvester_backup.sql

NFA Console 21.2.8 or higher: mysqldump reporter -uroot -proot@123 --routines --events > x:\reporter_backup.sql

NFA Harvester 21.2.8 or higher: mysqldump harvester -uroot -proot@123 --routines --events > x:\harvester_backup.sql

2. Upgrade to Network Flow Analysis 22.2.5.

3. Check if the "backup" database exists on the NFA Console reporter database. From an open command prompt, issue the following commands as administrator. Please substitute your own password if you changed the default password for the root user:

     mysql -uroot -proot@123
     show databases;
     exit

4. If the "backup" database is not listed on the console, issue the following commands as administrator:

    mysql -uroot -proot@123
    create database backup;
    exit

5. Run the Pre-Upgrade commands for each Harvester: NFA 22.2.6 Pre-Upgrade Script

6. Backup the MySQL databases (substitute 'root@123' for your own root password if changed):

NFA Console: mysqldump reporter -uroot -proot@123 --routines --events > x:\reporter_backup2225.sql

NFA Harvester: mysqldump harvester -uroot -proot@123 --routines --events > x:\harvester_backup2225.sql

7. At this point you can safely upgrade to Network Flow Analysis 22.2.6. If there are any issue, please contact Broadcom Support.