How to switch from an embedded to an external database (4228304)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to switch from an embedded to an external database
Description

If Foglight requires more space and/or performance improvements, an external database can be used.
Cause

This KB describes how to migrate from using an embedded MySQL® database with the Management Server to using an external MySQL database.
Resolution

STEPS:
1. Stop the Management Server.
\bin\fms --stop
2. Start the embedded database manually:
\bin\runDb.sh
3. Export the database content:
<foglight_home>\mysql\bin\mysqldump ‑ uroot -p[password] --port=13306 –routines --databases foglight > <foglight_home>\foglight.dump
Note: default password is foglight
ie: mysqldump -uroot -pfoglight --port=13306 –-routines --databases foglight > C:\Quest_Software\Foglight\foglight.dump
adding this additional switch to avoid the lock tables error
–-single-transaction
ie: mysqldump -uroot -pfoglight --port=13306 –-routines –-single-transaction --databases foglight > C:\Quest_Software\Foglight\foglight.dump

Note: If see Potential ERROR:
mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect
-Ensure the Embedded Database is running command "runDb.sh"
4. Shut down the database:
\bin\shutdownDb.sh
5. Connect to the external MySQL instance via MySQL:
\mysql\bin\mysql -h [mysql host] -P [mysql port] -u root -p
6. Create the Foglight database instance by running:
mysql> source \scripts\sql\mysql_create_db.sql
7. Re-import the data dump:
mysql> source \foglight.dump
8. Configure the Management Server to use this new database by opening the following file:
\config\server.config
9. Update the following values in the above file:
server.database.host = "[mysql host]";
server.database.port = "[mysql port]";
server.database.embedded = "false";
10. Remove the part of your Foglight installation that was used for the embedded MySQL database by deleting the directory \mysql.
11. Restart the Management Server.
a) Open the most recent Management Server log file in \logs.
b) Look for the message Forge Server startup completed and ensure that there are no errors listed after it.
13. Verify that the Management Server connects to the migrated external MySQL database. There are two ways to do so:
• Open the most recent Management Server log file in \logs. Verify that the parameter server.database.host lists external MySQL database host as its value and that server.database.embedded is set to false.
• Log in to the browser interface and navigate to Dashboards > Administration > Setup & Support > Foglight configuration. Verify that external MySQL database host is listed in the Database Host box and that External is listed in the Database Location box.