How do I migrate my NFA server to Windows 2012R2?

Document ID : KB000013740
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Beginning with NFA 9.3.6, you can no longer install or upgrade NFA if you are running on Windows 2008 R2.

Question:

How do I migrate my NFA server to Windows 2012R2?

Environment:
NFA on Windows 2008R2
Answer:

Follow the steps listed in the NFA 9.3.6 upgrade documentation or the NFA 9.3.7 upgrade documentation.

 

Two-Tier Deployment

Follow these steps:

  1. Install Windows Server 2012 R2 Standard Edition on new servers.
  2. (WS2012) Do a clean install of CA NFA 9.3.3 on the new servers.
  3. For each Windows Harvester:
    1. (WS2008) Stop the following services and disable them:
      • CA NFA Collection and Poller Webservices
      • CA NFA Data Retention
      • CA NFA DNS/SNMP Proxies
      • CA NFA File Server
      • CA NFA Harvester
      • CA NFA Poller
      • CA NFA Reaper
      • CA NFA Flow Cloner (if Flow Cloner is installed)
    2. (WS2008) Create the directory install_path\MySql_Backups.
    3. (WS2008) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysqldump --routines --events -u root -P 3308 harvester > install_path\MySql_Backups\harvester_backup.sql

      mysqldump --routines --events -u root -P 3308 mysql proc > install_path\MySql_Backups\proc_backup.sql

      mysqldump --routines --events -u root -P 3308 poller > install_path\MySql_Backups\poller_backup.sql

      mysqldump --routines --events -u root -P 3308 data_retention > install_path\MySql_Backups\data_retention_backup.sql

    4. (WS2008 and WS2012) Copy the install_path\MySql_Backups directory to the Windows Server 2012 system.
    5. (WS2008 and WS2012) Copy the install_path\Netflow\datafiles directory to the Windows Server 2012 system.
    6. (WS2008) Shutdown the Windows Server 2008 system.
    7. (WS2012) Stop the following services:
      • CA NFA Collection and Poller Webservices
      • CA NFA Data Retention
      • CA NFA DNS/SNMP Proxies
      • CA NFA File Server
      • CA NFA Harvester
      • CA NFA Poller
      • CA NFA Reaper
    8. (WS2012) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysql -P 3308 -u root -e "drop database harvester"

      mysql -P 3308 -u root -e "create database harvester"

      mysql -P 3308 -u root harvester < install_path\MySql_Backups\harvester_backup.sql

      mysql -P 3308 -u root -e "drop database poller"

      mysql -P 3308 -u root -e "create database poller"

      mysql -P 3308 -u root poller < install_path\MySql_Backups\poller_backup.sql

      mysql -P 3308 -u root -e "drop database data_retention"

      mysql -P 3308 -u root -e "create database data_retention"

      mysql -P 3308 -u root data_retention < install_path\MySql_Backups\data_retention_backup.sql

      mysql -P 3308 -u root mysql < install_path\MySql_Backups\proc_backup.sql

       

    9. (WS2012) Restart the NFA Services that you stopped in step g.
    10. (WS2012) Reconfigure the Windows Server 2012 system to use the Windows Server 2008 IP address.
  4. For the Windows Console:
    1. (WS2008) Stop the following services and disable them:
      • CA NFA RibSource

      • CA Performance Center SSO

      • NetQoS Reporter Manager Service

      • NetQoS Reporter/Analyzer General Services

      • NetQoS Reporter/Analyzer Pump Service

      • NetQoS Reporter/Analyzer Query Services

      • NetQoS Reporter/Analyzer Watchdog

      • NetQoS ReporterAnalyzer Report Service

    2. (WS2008) Create the directory install_path\MySql_Backups.
    3. (WS2008) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysqldump --routines --events --skip-lock-tables -u root -P 3308 reporter > install_path\MySql_Backups\reporter_backup.sql

      mysqldump --routines --events -u root -P 3308 mysql proc > install_path\MySql_Backups\proc_backup.sql

       

    4. (WS2008 and WS2012) Copy the install_path\MySql_Backups directory to the Windows Server 2012 system.

    5. (WS2008) Shutdown the Windows Server 2008 system.
    6. (WS2012) Stop the following services:
      • CA NFA RibSource
      • CA Performance Center SSO
      • NetQoS Reporter Manager Service
      • NetQoS Reporter/Analyzer General Services
      • NetQoS Reporter/Analyzer Pump Service
      • NetQoS Reporter/Analyzer Query Services
      • NetQoS Reporter/Analyzer Watchdog
      • NetQoS ReporterAnalyzer Report Service
    7. (WS2012) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysql -P 3308 -u root -e "drop database reporter"

      mysql -P 3308 -u root -e "create database reporter"

      mysql -P 3308 -u root reporter < install_path\MySql_Backups\reporter_backup.sql

      mysql -P 3308 -u root mysql< install_path\MySql_Backups\proc_backup.sql

    8. (WS2012) Restart the NFA services that you stopped in step f.
    9. (WS2012) Reconfigure the Windows Server 2012 system to use the Windows Server 2008 IP Address.
  5. For the Anomaly Detector:
    1.  (WS2008) Stop the following Anomaly Detector Services:
      • CA NFA Host Resolver Service
      • CA NFA Hunter Tracker Service
      • CA NFA Ribsource
    2. (WS2008) Create the directory install_path\MySql_Backups.
    3. (WS2008) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysqldump --routines --events -u root -P 3308 nsas > install_path\MySql_Backups\nsas_backup.sql

    4. (WS2008 and WS2012) Copy the install_path\MySql_Backups directory to the Windows Server 2012 system.

    5. (WS2008) Shutdown the Windows Server 2008 system.

    6. (WS2012) Stop the following Anomaly Detector Services:

      • CA NFA Host Resolver Service

      • CA NFA Hunter Tracker Service

      • CA NFA Ribsource

    7. (WS2012) Execute the following commands from a Command Prompt window:

      cd install_path\MySql\bin

      mysql -P 3308 -u root -e "drop database nsas"

      mysql -P 3308 -u root -e "create database nsas"

      mysql -P 3308 -u root nsas < install_path\MySql_Backups\nsas_backup.sql

    8. (WS2012) Restart the Anomaly Detector services that you stopped in step f.

    9. (WS2012) Reconfigure the Windows Server 2012 system to use the Windows Server 2008 IP Address

  6. (WS2012) Upgrade each CA NFA system to 9.3.6.

Standalone Deployment

Follow these steps:

  1. Install Windows Server 2012 R2 Standard Edition on a new server.
  2. (WS2012) Do a clean install of CA NFA 9.3.3 on the new server.
  3. (WS2008) Stop the following services and disable them:
    • CA NFA Collection and Poller Webservices
    • CA NFA Data Retention
    • CA NFA DNS/SNMP Proxies
    • CA NFA File Server
    • CA NFA Harvester
    • CA NFA Poller
    • CA NFA Reaper
    • CA NFA RibSource

    • CA Performance Center SSO

    • NetQoS Reporter Manager Service

    • NetQoS Reporter/Analyzer General Services

    • NetQoS Reporter/Analyzer Pump Service

    • NetQoS Reporter/Analyzer Query Services

    • NetQoS Reporter/Analyzer Watchdog

    • NetQoS ReporterAnalyzer Report Service

    • CA NFA Host Resolver Service (if Anomaly Detector is installed)

    • CA NFA Hunter Tracker Service (if Anomaly Detector is installed)

    • CA NFA Flow Cloner (if Flow Cloner is installed)
  4. (WS2008) Create the directory install_path\MySql_Backups.
  5. (WS2008) Execute the following commands from a Command Prompt window:

    cd install_path\MySql\bin

    mysqldump --routines --events -u root -P 3308 harvester > install_path\MySql_Backups\harvester_backup.sql

    mysqldump --routines --events -u root -P 3308 poller > install_path\MySql_Backups\poller_backup.sql

    mysqldump --routines --events -u root -P 3308 data_retention > install_path\MySql_Backups\data_retention_backup.sql

    mysqldump --routines --events --skip-lock-tables -u root -P 3308 reporter > install_path\MySql_Backups\reporter_backup.sql

    mysqldump --routines --events -u root -P 3308 mysql proc > install_path\MySql_Backups\proc_backup.sql

    If Anomaly Detector is installed:

    mysqldump --routines --events -u root -P 3308 nsas > install_path\MySql_Backups\nsas_backup.sql
  6. (WS2008 and WS2012) Copy the install_path\MySql_Backups directory to the Windows Server 2012 system.

  7. (WS2008 and WS2012) Copy the install_path\Netflow\datafiles directory to the Windows Server 2012 system.
  8. (WS2008) Shutdown the Windows Server 2008 system.
  9. (WS2012) Stop the following services:
    • CA NFA Collection and Poller Webservices
    • CA NFA Data Retention
    • CA NFA DNS/SNMP Proxies
    • CA NFA File Server
    • CA NFA Harvester
    • CA NFA Poller
    • CA NFA Reaper
    • CA NFA RibSource

    • CA Performance Center SSO

    • NetQoS Reporter Manager Service

    • NetQoS Reporter/Analyzer General Services

    • NetQoS Reporter/Analyzer Pump Service

    • NetQoS Reporter/Analyzer Query Services

    • NetQoS Reporter/Analyzer Watchdog

    • NetQoS ReporterAnalyzer Report Service

    • CA NFA Host Resolver Service (if Anomaly Detector is installed)

    • CA NFA Hunter Tracker Service (if Anomaly Detector is installed)

  10. (WS2012) Execute the following commands from a Command Prompt window:

    cd install_path\MySql\bin

    mysql -P 3308 -u root -e "drop database harvester"

    mysql -P 3308 -u root -e "create database harvester"

    mysql -P 3308 -u root harvester < install_path\MySql_Backups\harvester_backup.sql

    mysql -P 3308 -u root -e "drop database poller"

    mysql -P 3308 -u root -e "create database poller"

    mysql -P 3308 -u root poller < install_path\MySql_Backups\poller_backup.sql

    mysql -P 3308 -u root -e "drop database data_retention"

    mysql -P 3308 -u root -e "create database data_retention"

    mysql -P 3308 -u root data_retention < install_path\MySql_Backups\data_retention_backup.sql

    mysql -P 3308 -u root -e "drop database reporter"

    mysql -P 3308 -u root -e "create database reporter"

    mysql -P 3308 -u root reporter < install_path\MySql_Backups\reporter_backup.sql

    mysql -P 3308 -u root mysql< install_path\MySql_Backups\proc_backup.sql

    If Anomaly Detector is installed:

    mysql -P 3308 -u root -e "drop database nsas"

    mysql -P 3308 -u root -e "create database nsas"

    mysql -P 3308 -u root nsas < install_path\MySql_Backups\nsas_backup.sql

  11. (WS2012) Restart the NFA Services that you stopped in step 9.
  12. (WS2012) Reconfigure the Windows Server 2012 system to use the Windows Server 2008 IP address.
  13. (WS2012) Upgrade each CA NFA component to 9.3.6.

 

 

Additional Information:

In order to upgrade to NFA 9.3.6 or 9.3.7, you must also be running a 2 Tier NFA Environment.  In order to convert to a 2 Tier Enviornment, please see this document:

NFA 9.3.3 3-Tier to 2-Tier Conversion