Follow

Migrate Traverse Linux install to new server

Please find steps below for migrating an existing Traverse install on Linux to a new server. Note that in the steps below, the term 'TRAVERSE_HOME' should be replaced with your actual installation location, for example '/usr/local/traverse' (without the quotes):

 

  • Install the identical Traverse revision on the (new) destination server, as the original server
  • Stop Traverse software components on the destination server
  • Stop Traverse software on the (original) source server
  • Copy the 'TRAVERSE_HOME/etc/licenseKey.xml' from the source to the same destination on the new server.
  • Copy 'TRAVERSE_HOME/etc/plugin' directory from source to the same destination on the new server.
  • Copy 'TRAVERSE_HOME/webapp/WEB-INF/web.xml' from source to the same destination on the new server.
  • Apply any customization from 'TRAVERSE_HOME\etc\emerald.xml' and 'TRAVERSE_HOME/etc/dge.xml' (namely the unique dge name) on the source to the same file on the destination server. One way to achieve this is to compare the two files to highlight the differences (e.g. 'diff' or 'compare' commands)
  • In the rare case that changes have been made to any device signatures in 'etc/typedef', copy the customized device signatures from the source server to overwrite the copies in the destination server. Altering files in this folder is not recommended as the folder is overwritten during upgrades.

On Source Server:

# Start the database servers and perform a backup

cd TRAVERSE_HOME
etc/dgedb.init start
etc/provdb.init start
utils/db_backup.sh

Copy mysql database backup, derby database and misc files to destination server 

  • scp -r TRAVERSE_HOME/database/backup/backup-mm-dd-yy,hh-mm.tar.gz newhost:/TRAVERSE_HOME/database/mysql/
  • scp –r TRAVERSE_HOME/database/derby newhost:/TRAVERSE_HOME/database/
  • scp –r TRAVERSE_HOME/apps/silk/data newhost:/TRAVERSE_HOME/apps/silk/ 

Restore the MySQL databases

On the destination server:

  • cd TRAVERSE_HOME/database/mysql
  • tar zxf backup-mm-dd-yy,hh-mm.tar.gz
  • cd database/backup
  • cp –R * ../../
  • cd ../../
  • rm –rf database backup-mm-dd-yy,hh-mm.tar.gz
  • cd TRAVERSE_HOME
  • etc/dgedb.init start restore
  • # Performance DB
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf --skip-column-names -u root --password= -e 'show tables;' --database=backup_dge > /tmp/tables.txt
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/dropDGEdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createDGEdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createDGEdbUsers.sql
  • for i in `cat /tmp/tables.txt`; do apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= --execute "RESTORE TABLE $i FROM 'TRAVERSE_HOME/database/mysql/backup_dge'" aggregateddatadb; done
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createDGEdbProcs.sql
  • # Summary DB
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf --skip-column-names -u root --password= -e 'show tables;' --database=backup_cse > /tmp/tables.txt
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/dropCSEdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createCSEdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createCSEdbUsers.sql
  • for i in `cat /tmp/tables.txt`; do apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= --execute "RESTORE TABLE $i FROM 'TRAVERSE_HOME/database/mysql/backup_cse'" summarydb; done
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createCSEdbProcs.sql
  • # Live Events DB
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf --skip-column-names -u root --password= -e 'show tables;' --database=backup_rtm > /tmp/tables.txt
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/dropRTMdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createRTMdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createRTMdbUsers.sql
  • for i in `cat /tmp/tables.txt`; do apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= --execute "RESTORE TABLE $i FROM 'TRAVERSE_HOME/database/mysql/backup_rtm'" liveeventsdb; done
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createRTMdbProcs.sql
  • # Scheduler DB
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf --skip-column-names -u root --password= -e 'show tables;' --database=backup_srs > /tmp/tables.txt
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/dropSRSdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createSRSdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createSRSdbUsers.sql
  • for i in `cat /tmp/tables.txt`; do apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= --execute "RESTORE TABLE $i FROM 'TRAVERSE_HOME/database/mysql/backup_srs'" schedulerdb; done
  • # Process DB
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf --skip-column-names -u root --password= -e 'show tables;' --database=backup_apm > /tmp/tables.txt
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/dropAPMdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createAPMdb.sql
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createAPMdbUsers.sql
  • for i in `cat /tmp/tables.txt`; do apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= --execute "RESTORE TABLE $i FROM 'TRAVERSE_HOME/database/mysql/backup_apm'" processdb; done
  • apps/mysql/bin/mysql --defaults-file=etc/mysql.conf -u root --password= < database/schema/mysql/createAPMdbProcs.sql

Restore Derby DB (Network Configuration Managment)

  • cd TRAVERSE_HOME
  • rm -f database/derby/netconf/log/* database/derby/netconf/db.lck

Restore provisioning database:

  • cd utils
  • ./databaseUtil.pl --action import --file ../database/mysql/backup_provisioning.xml --batch
  • ./db_optimize.pl --run

 

Start the Traverse components on the (new) destination server

  • TRAVERSE_HOME/etc/traverse.init start
  • # Confirm everything is working correctly within Traverse Web Application.
  • cd TRAVERSE_HOME/database/mysql
  • rm –rf backup_dge backup_rtm backup_srs backup_apm backup_sla backup_provisioning.xml
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.