Migrating supervisor from Linux to Windows

[jbrandibas]

Hello,

  I am looking at migrating our supervisor from a Linux box to Windows.  Is it possible to also migrate all of the job histories and qube settings that are stored on that box as well, or do I have to start fresh?

Thanks,

jbrandibas

[shinya]

Hi jbrandibas,

Yes, it's possible to migrate data and configurations from one supervisor to
another, but it does require some careful planning and manual execution.

Please also refer to our online knowledge-base article (although I think it's
slightly dated), at:
 http://www.pipelinefx.com/support/knowledgeBase.php#Migrating_Supervisor_to_new_host

In a nutshell, here's the step-by-step:
* make sure all jobs are terminated
 qbkill 0   (run as root or Administrator)

* stop the supervisor and mysql services on the old host
 Linux:
 /etc/init.d/supervisor stop
 /etc/init.d/mysqld stop
 OSX:
 /Library/StartupItems/supervisor/supervisor stop
 /Library/StartupItems/MySQLCOM/MySQLCOM stop
 Windows:
 net stop qubesupervisor
 net stop PfxMysql

* install the qube-core and qube-supervisor packages on the new

* stop the supe and mysql services on the new

* copy all mysql database files from the old to the new (Linux: /var/lib/mysql, OSX: /usr/local/mysql/data, Windows: C:\Program Files\pfx\qube\mysql\data)

* copy qb.lic, qb.conf, qbwrk.conf (if applicable) files from the old to new (Linux, OSX: /etc, Windows XP: C:\Windows)

* copy supervisor_logpath (Linux, OSX: /var/spool/qube/, Windows: C:\Program Files\pfx\qube\logs) from old to the new

* copy supelog file(s) (Linux, OSX: /var/log/supelog, Windows: C:\Program Files\pfx\qube\logs\supelog*) from old to new

* if my.cnf was modified on the old, manually add the modifications to the new host's my.cnf (Linux, OSX: /etc/my.cnf, Windows: C:\Program Files\pfx\qube\mysql\my.cnf)

* start the mysql service on the new

* start the supe service on the new

* verify the migration