How to move the Performance Manager Spectrum Data Source Integration DB to a new One Click server.
Spectrum OneClick server host migration while integrated with Performance Management
Need to migrate the Spectrum OneClick tomcat web server to a new host. The OneClick server is integrated with Performance Management as a Data Source.
Some environments use Performance Management Groups whose membership is derived from the members in a synchronized Spectrum Global Collection (GC). The same Performance Management Groups can be set for use in a variety of functions like Dashboards, Reports, Threshold Profiles, etc. These relationships are defined by IDs set in the databases that represent the Groups and GCs. Maintaining those relationships critical to success. Critical to maintaining those relationships is ensuring the database IDs representing the GCs don't change. Any interruption to these relationships will break the integration and require a large effort to manually rebuild the lost relationships. Global Collection names and IDs are stored in the Spectrum SpectroSERVER SSdb. As long as the SSdb isn't rebuilt, those names and IDs won't change. As a result any Performance Management Group Rules referencing synced Spectrum Global Collections for it's membership should continue to function post OneClick host change.
How to migrate the netqos_integ MySql database to a new OneClick web server host.
All supported DX NetOps releases
Migrate the Portal and Spectrum integration MySql database (netqos_integ) from old to new host.
NOTE: See step 4.5 below if the IP or Hostname is also changing for the OneClick host.
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.
To remove it follow these steps to drop the database. These commands are not OS dependent.
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)