How to move the Performance Manager Spectrum Data Source Integration DB to a new One Click server.
Currently supported versions of DX NetOps components
The below steps are for a Spectrum environment with the following details:
MySQL User -
Export Database from Existing System
Disable the Spectrum Data Source under – Administration / Data Sources in the Performance Center Portal
Shut down the Tomcat server on the existing One Click Integration server
Export the netqos_integ database:
( If you do not supply a password, you will be prompted to enter it. )
Linux
Export: ./mysqldump --defaults-file=../my-spectrum.cnf --routines --databases -uSPEC_admin -p netqos_integ > netqos_integ_backup.sql
Windows
Export: ./mysqldump.exe --routines --databases -uSPEC_admin -p netqos_integ > netqos_integ_backup.sql
Copy the exported database to the new system.
Import Database to new system
On the New One Click Integration Server:
Shut down the Tomcat server
Import the netqos_integ database to the new system:
( If you do not supply a password, you will be prompted to enter it. )
If the Database already exists you will receive an error :
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1007 (HY000) at line 1: Can't create database ‘netqos_integ’; database exists
Linux
Ensure DB exists: ./mysql --defaults-file=../my-spectrum.cnf -uSPEC_admin -p -e 'create database netqos_integ;'
Import: ./mysql --defaults-file=../my-spectrum.cnf -uSPEC_admin -p netqos_integ < netqos_integ_backup.sql
Windows
Ensure DB exists: ./mysql --defaults-file=../my-spectrum.cnf -uSPEC_admin -p -e 'create database netqos_integ;'
Import: ./mysql.exe -uSPEC_admin -p netqos_integ < netqos_integ_backup.sql
Start the Tomcat server on the new system
Change the Spectrum Data Source hostname and port to reflect the new server and enable the data source.
Confirm Spectrum data source synchronization was successful and is Available
Validate the Inventory->Data Sources->Spectrum->All Spectrum Global Collections reflects the GCs in OneClick.
Validate that Spectrum -> Performance Center Event Integration works, if enabled.
Remove Database from original System
Once the proper functionality of the Integration has been validated the netqos_integ database should be removed from the original Integration One Click server.
./mysql --defaults-file=/opt/ca/spectrum/mysql/my-spectrum.cnf -uSPEC_admin -p0n3cl1Ck
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mibtools |
| mysql |
| netqos_integ |
| performance_schema |
| reporting |
| sys |
+--------------------+
7 rows in set (0.16 sec)
mysql> drop database netqos_integ;
Start Tomcat Service