Moving a QueueMetrics instance to a new server
2012-08-08If you need to move your existing QueueMetrics server to a different host and do not want to lose your current data and configuration, you can do that easily using yum. As a side effect, your system will be updated to the latest version. In this tutorial we expect that the MySQL server was on the old QM server and you want to use a new one on your new server, so you will have to move the database as well. Asterisk may be local on the old server or on a separate server altogether.
See also:
- Stop any qloaderd running, so the current database is in a stable state
- Make a complete backup of your existing system (configuration and database - see below)
- Stop the old QueueMetrics instance
- Install QueueMetrics using yum on your new server
- When it's working (you are able to log in), turn it off
- Edit the memory settings for your new system
- Overwrite the QueueMetrics database on the new server with the database dump from the old server
- Copy
web.xml
and the various properties files from theWEB-INF/
folder of the old system to the new system - Make sure the access parameters for the database are correct (they usually already are, as the database is searched for on 'localhost')
- Start the new QueueMetrics instance
- When you connect to the new QueueMetrics, it will sense that the database comes from an older version and will automatically update it, if needed
- Edit your qloaderd properties (usually stored in
/etc/sysconfig/qloaderd
on the Asterisk server) so that it can upload data to the new database - Restart qloaderd
- Check that it is able to upload data to the new database (you may need to create a MySQL grant so that qloaderd can connect to the new server)
- The new system should be working now!
See also: