mysql db / master nagios failover

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
zaji_nms
Posts: 616
Joined: Tue Oct 16, 2012 12:28 am

mysql db / master nagios failover

Post by zaji_nms »

Dear Expert ,

is it possible as shown in an attached image ( mysql db write to two db active and remote ) , i have 192.168.1.1 up and running when i add / del any service from CCM it should reflect to 192.168.1.1 ( mysql and 192.168.2.1 ( remote mysql )

if above scenario not possible what are other alternative ?
You do not have the required permissions to view the files attached to this post.
Zajil NMS
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: mysql db / master nagios failover

Post by tmcdonald »

It's certainly possible using standard database replication configurations to have two databases synchronized, but Nagios XI does not have an option to write to two separate databases directly.
Former Nagios employee
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: mysql db / master nagios failover

Post by Box293 »

We don't have any procedures to do this.

However in relation to HA, this presentation at the Nagios Conference will most likely be the solution that best fits your needs:

Jeremy Rust & Devin Vance: Scaling Across Data Centers Using High Availability
https://www.youtube.com/watch?v=EVMbTbh9zV4
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked