Nagios DB hosted on remote server

[avijit_bhardwaj]

Hi,
We are implementing 4 instances of Nagios XI servers in our environment. I wanted to confirm if we can host all databases of these servers on a remote sql server as one instance. Is this feasible and is a good practise to do so?

[abrist]

Totally possible, though you do not want to use ndo/nagiosql instances as this will increase individual query times and may skew things like availability and sla reports.
You will want to edit each nagios XI server's config.inc.php and specify new database names for ndoutils and nagiosql, as you do not want to cross-contaminate these databases with multiple XI servers' historical and config data.

You will also need to drastically increase the number of max connections for the sql server, and potentially make other performance tweaks depending on the size of each monitored environment.

Does that make sense?

[avijit_bhardwaj]

So do hosting a DB on remote server can have performance issue? I am sorry for for questions however I am bit new to Nagios. What is best recommended , hosting a DB on nagios server (in built) or offloading it to a remote db server?

[ssax]

If you have a large environment with a lot of checks that impact the performance of the server it is generally recommended that you create a RAMDisk and offload the DB so that you can reduce the load on the XI server. Also, a dedicated DB server can be tuned/administered differently than a combo XI/DB install.

Here is some general information on those processes, you'll have to follow abrist's advice for pointing multiple XI instances to a single DB.
http://assets.nagios.com/downloads/nagi ... Server.pdf

http://assets.nagios.com/downloads/nagi ... giosXI.pdf