Page 1 of 1
Nagios DB hosted on remote server
Posted: Mon Mar 30, 2015 3:14 am
by 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?
Re: Nagios DB hosted on remote server
Posted: Mon Mar 30, 2015 2:45 pm
by 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?
Re: Nagios DB hosted on remote server
Posted: Mon Mar 30, 2015 11:09 pm
by 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?
Re: Nagios DB hosted on remote server
Posted: Tue Mar 31, 2015 9:48 am
by 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