Chat now with support
Chat with Support

Foglight 5.9.5 - Installing Foglight on Windows with an External Microsoft SQL Server Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings HP patch checking tool Uninstalling Foglight Upgrading the Management Server Installing Foglight FAQ
Running the Management Server Installing and Upgrading Cartridges Installing Agents

High Availability mode

Before you install Foglight, determine if you are going to set up and run the Management Server in High Availability (HA) mode or as a standalone server. High Availability mode enables you to install multiple Management Servers where one server is the primary server and the others are standby servers. If the primary server stops responding, then one of the standby servers in the HA cluster takes over the responsibility.

Configuring multiple servers using HA mode offers the following benefits:

Automatic restart: The restart process (FoglightHA Daemon) runs on the same host as the Management Server it is monitoring and monitors the state of the server. If the server stops responding or has a fatal error, then the restart process stops and restarts the server automatically. The process can also send out email notifications about various conditions of the server.
Standby Server: To reduce outage times, a standby server instance is created (for a particular Foglight Management Server), and forms a partition. One server becomes the primary server and communicates with the agents, receives and processes data, and processes rules. All other servers are standby servers. If a primary server stops responding, one of the standby servers resumes service and becomes the primary server.

Considerations for running the Management Server in HA mode

If you plan to run the Management Server in HA mode, there are certain considerations:

For more information about installing and configuring HA mode, see the High Availability Field Guide.

Using an external database

An external instance of the Microsoft® SQL Server® database can be used if your database administrator has installed one. For information about the external databases supported for Foglight, see the System Requirements and Platform Support Guide.

A setup with an external database has the advantage of using existing infrastructure. For setup, a remote administrator user/password (with rights to create users, tables, and databases) is required. Remote administrator access must be granted.

Creating the database manually

If your database administrator intends to manually create the external database instance instead of using the create_db script, ensure that all of the following requirements are met:

In addition, if you are using an SQL Server cluster, Foglight requires the SQL Host name (that is, the actual server name), the SQL instance name, and the database name.

To reduce the size of the transaction logs, set the database to Simple Recovery mode. This step is optional, but recommended.

Related Documents