Page 1 of 2

Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 8:31 am
by sandeepatil
Hi Need your help to the below mention configuration,

Scenario :
Configured agent with two Nagios XI servers (Primary / Secondary), both the servers receiving data from client and writing in database.

Requirement :
Stop data writing data in database of secondary server and start log shipping from primary server database to secondary server database.

Question :
Can we stop data writing in database received from client and allow log shipping data write in database.

Re: Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 9:09 am
by eloyd
Only one Nagios XI server should be monitoring at at any given time, assuming that this is an HA arrangement. Your secondary should not be checking as long as your primary is up, or you are violating the terms of your Nagios license.

Re: Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 9:29 am
by sandeepatil
We have two Nagios XI servers with separate license and configured failover using script. We are trying to avoid data loss using explained Scenario.

Re: Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 9:46 am
by eloyd
Two Nagios servers monitoring the same things will need to have two different databases and logs. Not all service/host checks will run cotemporaneously on both servers. If you are truly doing failover, though, then you will need to make your script disable/enable the secondary Nagios's monitoring so that it's only monitoring when the primary is not monitoring. As for logging to the same place, you'll need to get more complex than Nagios directly allows on its own, which requires shared databases and file storage.

Re: Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 9:54 am
by sandeepatil
Share database not allowed in our environment, this reason to trying another way.

Please confirm, can we stop the data to wring in database.

Re: Nagios XI Database related configuration

Posted: Wed Jul 05, 2017 4:46 pm
by tgriep
The only truly way to stop the writing data to the SQL database, you would have to stop the Nagios process and the ndo2db process and then it will not be running so it cannot ship the logs to the other server.

Re: Nagios XI Database related configuration

Posted: Thu Jul 06, 2017 1:40 am
by sandeepatil
We want to stop write data from client and allow to write log shipping data come from other server not ship log to other server.

Re: Nagios XI Database related configuration

Posted: Thu Jul 06, 2017 7:08 am
by eloyd
Without knowing more about your requirements and environment, it will be difficult to assist you further. Nagios works a certain way and it sounds like you want it to work differently.

Re: Nagios XI Database related configuration

Posted: Thu Jul 06, 2017 8:50 am
by sandeepatil
Can you explain, what details you required regarding my requirements and environment.

Please give me points, this good for me to share exact details and you to understanding.

Re: Nagios XI Database related configuration

Posted: Thu Jul 06, 2017 8:55 am
by eloyd
For one, you wrote:
sandeepatil wrote:Share database not allowed in our environment, this reason to trying another way.
I'm trying to understand what your limitations and requirements are.