The default Uptime Infrastructure Monitor installation includes a bundled MySQL database. There are several scenarios in which it may be desirable to implement a dedicated database server. This article provides instructions for moving your datastore to the new remote host.
In the following example, Host1 is the current server and Host2 is the remote database server being installed.
- Check version of Uptime Infrastructure Monitor installed on Host1.
- Install the same version of Uptime Infrastructure Monitor on Host2.
- Stop all Uptime Infrastructure Monitor services on both systems.
- Move Host2's ...\uptime\datastore\ folder to another location (e.g. ...\tmp\).
- Copy Host1's ...\uptime\datastore\ to Host2 ...\uptime\datastore\.
- Open ...\uptime\uptime.conf for editing and change 'dbHostname=localhost' to reflect Host2's hostname.
- Start the Uptime Infrastructure Monitor datastore service on Host2.
Log into Host2's MySQL database using the following command:
...\uptime\mysql\bin\mysql -uroot -puptimerocks -P3308 --protocol=TCP
At the MySQL prompt, execute the following command to grant remote access to the database:
grant all privileges on uptime.* to "uptime"@"%" identified by "uptime";
Note
For additional security (to whitelist only Host1), replace % with the IP address or hostname of Host1.
- Start the Uptime Infrastructure Monitor data collector (core) and Web Server (httpd) on Host1. Do not start the Uptime Infrastructure Monitor datastore on Host1, as it is no longer required for operation.
- Login to Host1 as usual and confirm that your data is sound. You can confirm your active configuration in the 'support' link at the top right corner of the Uptime Infrastructure Monitor web interface.