Design two Nagios Failover/Redundant topology - need help !

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
karen9876543210
Posts: 11
Joined: Thu Apr 21, 2016 3:33 am

Design two Nagios Failover/Redundant topology - need help !

Post by karen9876543210 »

Hello !
I am using nagios core 3 ! and I am trying to make failover monitoring, according to nagios documentation (Redundant and Failover Network Monitoring,Scenario 2 - Failover monitoring) it work fine. For last service state information on backup host, I am using ocsp command on master, and nsca addon on backup host .

The question is - if my backup host go down, send nsca will fail sanding data , and after comming up I will not have history on my backup host . Is there any solution exept rsyncing logs ?

And the second question is - is there any solutions for nagions to read/write plugin output data, perfdata and history in/from mysql ?
Thanks

Moderator Edit: This thread has been split from another - https://support.nagios.com/forum/viewto ... =7&t=25051
In the future, please create a new thread and link to the old one instead of adding on.
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Design two Nagios Failover/Redundant topology - need hel

Post by mcapra »

karen9876543210 wrote: The question is - if my backup host go down, send nsca will fail sanding data , and after comming up I will not have history on my backup host . Is there any solution exept rsyncing logs ?
If you're referring to the state history (host/service up/down at time), rsync is probably your best bet for Nagios Core.
karen9876543210 wrote: And the second question is - is there any solutions for nagions to read/write plugin output data, perfdata and history in/from mysql ?
NagiosQL does a little bit of this. Might solve parts of your use-case.
Former Nagios employee
https://www.mcapra.com/
karen9876543210
Posts: 11
Joined: Thu Apr 21, 2016 3:33 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by karen9876543210 »

Thank You for response !!
NagiosQL is for configuration, keepeng configuration in database, and web ui for configuration!
I do not neet that, I need some tool to pull out host/service status data, check output data... fom mysql to nagios ! is there any available ?
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Design two Nagios Failover/Redundant topology - need hel

Post by mcapra »

I don't know of any solution that sends the logging info and performance data from Nagios Core to a MySQL database. NagiosQL really is the closest thing to that, but I understand it is not a 100% solution to your use case.

Nagios XI includes some of that information in MySQL tables, but the back-end is almost exclusively using the RRD files for performance data and the log files for reporting.
Former Nagios employee
https://www.mcapra.com/
karen9876543210
Posts: 11
Joined: Thu Apr 21, 2016 3:33 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by karen9876543210 »

There is ndoutils for sending data from nagios core to mysql, but I need opposite opportunity !! From mysql to nagios !!
Also I find out that it is possible to compile nagios with mysql support !!
http://nagios.manubulon.com/traduction/ ... ta-db.html
But unfortunatelyI need rpm ! ))
If anybody tried this pleas responce !
In any case thank You for reply !! it helps me !!
User avatar
nozlaf
Posts: 172
Joined: Sun Nov 09, 2014 9:50 pm
Location: Victoria, Australia

Re: Design two Nagios Failover/Redundant topology - need hel

Post by nozlaf »

karen9876543210 wrote: And the second question is - is there any solutions for nagions to read/write plugin output data, perfdata and history in/from mysql ?
is this because you want to keep it in sync or another reason?
Looking forward to seeing you all at #NagiosCon2019?
-Dedicated Lover of Nconf,PNP4Nagios and Nagvis
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by rkennedy »

karen9876543210 wrote:There is ndoutils for sending data from nagios core to mysql, but I need opposite opportunity !! From mysql to nagios !!
Also I find out that it is possible to compile nagios with mysql support !!
http://nagios.manubulon.com/traduction/ ... ta-db.html
But unfortunatelyI need rpm ! ))
If anybody tried this pleas responce !
In any case thank You for reply !! it helps me !!
A lot of modifications / addons have been made for Core, while what you posted above may work, it this isn't something we can directly support. Let us know if you have any further questions.
Former Nagios Employee
karen9876543210
Posts: 11
Joined: Thu Apr 21, 2016 3:33 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by karen9876543210 »

nozlaf wrote:
karen9876543210 wrote: And the second question is - is there any solutions for nagions to read/write plugin output data, perfdata and history in/from mysql ?
is this because you want to keep it in sync or another reason?

yes You are right !! for syncing !
karen9876543210
Posts: 11
Joined: Thu Apr 21, 2016 3:33 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by karen9876543210 »

rkennedy wrote:
karen9876543210 wrote: A lot of modifications / addons have been made for Core, while what you posted above may work, it this isn't something we can directly support. Let us know if you have any further questions.
I would like to know is there any solution for nagios core 3 to implement failover using mysql for syncing data!! If yes please let me know how !
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Design two Nagios Failover/Redundant topology - need hel

Post by rkennedy »

karen9876543210 wrote: I would like to know is there any solution for nagios core 3 to implement failover using mysql for syncing data!! If yes please let me know how !
We do not have a way that we can recommend / support.
Former Nagios Employee
Locked