Moving the Spectrum Data Source to a different One Click server
search cancel

Moving the Spectrum Data Source to a different One Click server

book

Article ID: 259170

calendar_today

Updated On:

Products

Network Observability Spectrum CA Performance Management

Issue/Introduction

Migrating Spectrum OneClick with Performance Management Integration

This document addresses the process of migrating your Spectrum OneClick server (and its associated netqos_integ MySQL database) to a new host, specifically when it's integrated with Performance Management.

The primary concern during such a migration is ensuring the continuity of Performance Management Groups whose membership is derived from synchronized Spectrum Global Collections (GCs). These relationships are critical for dashboards, reports, and other functions, and rely on unique database IDs. Any disruption to these IDs could break the integration and require significant manual effort to rebuild.

Key Point:

  • Global Collection names and their unique IDs are stored within the Spectrum SpectroSERVER (SSdb).
  • As long as the SpectroSERVER database (SSdb) is not rebuilt, these Global Collection IDs will remain unchanged.

Implication for Migration:

Since the Global Collection IDs persist in the SpectroSERVER, any Performance Management Group Rules that reference synchronized Spectrum Global Collections for their membership should continue to function correctly after the OneClick host migration.

Therefore, the main task involves successfully migrating the netqos_integ MySQL database to the new OneClick web server host without impacting these foundational relationships.

Environment

All supported DX NetOps releases

Resolution

Migration Guide: Portal and Spectrum Integration MySQL Database (netqos_integ)

This guide outlines the steps to migrate the netqos_integ MySQL database, used for Portal and Spectrum integration, from an old OneClick host to a new OneClick host.

Important Note: If the IP address or hostname of the OneClick host is also changing, you must refer to Step 5.5 at the end of this guide for the necessary update.

Step 1: Disable Spectrum Data Source in Portal (Old Host)

This step temporarily halts data synchronization to prevent inconsistencies during the migration.

  1. Navigate to Administration -> Data Sources -> Data Sources.
  2. Select the Spectrum Data Source.
  3. Click the Edit button.
  4. Set the Status value to Disabled.
  5. Click Save.

Step 2: Backup the Database on the Old OneClick Host

  1. Stop the Tomcat Web Server Service on the old OneClick host.

  2. Open a terminal (Linux) or Command Prompt (Windows).

  3. Navigate to the Spectrum installation directory or ensure $SPECROOT is set correctly.

  4. Execute the appropriate command below to create a netqos_integ_backup.sql file. You will be prompted for the root password.

    • For Linux:
      bash $SPECROOT/mysql/bin/mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uroot -p netqos_integ > netqos_integ_backup.sql
    • For Windows:
      cmd $SPECROOT/mysql/bin/mysqldump.exe --routines --databases -uroot -p netqos_integ > netqos_integ_backup.sql

  5. Optional: If you need to perform other tasks on the old host before proceeding, you may Start the Tomcat web server service. Otherwise, it can remain stopped.

Step 3: Transfer the Backup File to the New OneClick Host

  1. Copy the netqos_integ_backup.sql file created in Step 2 from the old OneClick host to a suitable location on the new OneClick host (e.g., the $SPECROOT/mysql/bin directory).

Step 4: Create Database and Load Data on the New OneClick Host

  1. Stop the Tomcat Web Server Service on the new OneClick host.

  2. Open a terminal (Linux) or Command Prompt (Windows) on the new host.

  3. Navigate to the Spectrum installation directory or ensure $SPECROOT is set correctly.

  4. Create the netqos_integ database:
    Execute the appropriate command. You will be prompted for the root password.

    • For Linux:
      bash $SPECROOT/mysql/bin/mysql --defaults-file=../my-spectrum.cnf -uroot -p -e 'create database netqos_integ;'
    • For Windows:
      cmd $SPECROOT/mysql/bin/mysql --defaults-file=../my-spectrum.cnf -uroot -p -e 'create database netqos_integ;'
    • Note: If the database already exists (e.g., from a previous installation or attempt), you might see an "ERROR 1007" message. This is expected, and you can safely proceed to the next step.

  5. Load data into the netqos_integ database:
    Execute the appropriate command to import the data from the backup file (netqos_integ_backup.sql). You will be prompted for the root password.

    • For Linux:
      bash $SPECROOT/mysql/bin/mysql --defaults-file=../my-spectrum.cnf -uroot -p netqos_integ < netqos_integ_backup.sql
    • For Windows:
      cmd $SPECROOT/mysql/bin/mysql.exe -uroot -p netqos_integ < netqos_integ_backup.sql

  6. Start the Tomcat Web Server Service on the new OneClick host.

Step 5: Enable Spectrum Data Source in Portal (New Host)

This step re-enables data synchronization with the newly migrated database.

  1. Navigate to Administration -> Data Sources -> Data Sources.
  2. Select the Spectrum Data Source.
  3. Click the Edit button.
  4. Set the Status value to Enabled.
  5. Optional: Update OneClick Host Information If the OneClick host's name or IP address has changed as part of this migration, you must update it here.
    • Update the Name or IP Address field to reflect the new host details.
  6. Click Save.

Additional Information

Will the the old OneClick host be repurposed as a OneClick host for a new environment?

Once the functionality of the migrated integration has been validated, the netqos_integ database should be removed from the original OneClick server.

  • No longer using it as a Portal integration host? It's worth removing it to clean the system.
  • Integrating the old OneClick to a different Portal host from a different environment? It will need to be removed before creating a new DS for the old OneClick in a different Portal system.

To remove it follow these steps to drop the database. These commands are not OS dependent.

  1. Connect to the MySql Prompt with the following command. Enter the password when prompted.
    • $SPECROOT/mysql/bin/mysql  --defaults-file=../my-spectrum.cnf -uroot -p
  2. Run the following command. Note: Sample below shows a normal expected database list.
    • show databases;
  3. Run the following to remove the netqos_integ database.
    • drop database netqos_integ;
  4. Run the show databases command from step 2 again to confirm it's removed.

Sample output for 'show databases;' command.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mibtools           |
| mysql              |
| netqos_integ       |
| performance_schema |
| reporting          |
| sys                |
+--------------------+
7 rows in set (0.16 sec)

Powered by Wolken Software