Seperate MYSQL DB Server for Nagios1

[gm_rajkumar]

Hello,

I am preparing for POC, there are 100 servers and 500 services running on the environment. I wanted to store Nagios database seperately into the stand-alone MySQL server. As per my understanding that Nagios installation cum along with MySQL server. Is it possible to have DB seperately, is it possible to communicate with the Server?

Let me know if any challenges to move DB Separately and if any documentation available to do that?

How much bandwidth and log size does Nagios require for monitoring, approx 500 services for 100 Servers? just give a approx nos.

[tmcdonald]

We absolutely do have documentation for this:

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

As for your bandwidth and logging question, that all depends on quite a few factors like check frequency, type of check (http is a lot lighter than WMI), which states you are logging (log all or just changes?), and others. Two otherwise identical servers can have radically different storage and bandwidth needs with a change in just one of the mentioned settings.

[gm_rajkumar]

Hi,

I already have this document, Is this to reduce CPU load on their central Nagios server? or can we have bring the DB into central and make it as redundant.

What would be the challenge to bring the DB into Central or is it recommended to move?

Let me know am i making you clear on this?

Relating to bandwidth and log size queries, do you have any ballpark value for this? Is there any calculation made already with sample no servers X services + log all or changes like that. This is helpful for us to plan the capacity, i hope you can able to understand.

[tgriep]

Here is a link to the hardware requirements document.

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

Without knowing what types of checks, where the hosts are, network topology , etc.. it is hard to give you any information on your bandwidth needs.

Offloading the MYSQL database to a separate server is one way to reduce CPU load on the Nagios server if it is having performance issues.

[gm_rajkumar]

hi,

Got your views, but my question is like we are trying to plan for remote DB (By Clustering two DB's), so that Nagios application and work freely as our current POC is having huge number for servers geographically distributed. To start with we picked 100 Servers, not sure probes may increase not fixed a fixed, as well we may add more servers while we expand monitoring.

We feel taking remote DB would be the best bet to attain max performance while we extend Nagios monitoring.

Our question below are....

1) How to install Nagios in remote DB (In this case cluster name or iP would be the configuration for nagios app to connect DB )
2) Is there any data grooming job will be executed by app. If so what would be the data retention period.
3) Is it possible to add additional Nagios application servers to the existing DB.

We highly appreciate your inputs on the above...

-Thanks in Advance!

[tgriep]

1) Here is the link to off load the mysql database.
http://assets.nagios.com/downloads/nagi ... Server.pdf

2) There isn't any data grooming that happens automatically, but the repair databases scripts need to be put on the remote mysql server and run from there if there are any corrupt databases.

3) You cannot share the same mysql database between multiple Nagios servers. They all have to unique to each other.

[aa00461404]

***Need Help***

Greetings,

We also have a plan for a similar setup with some HA level. We are looking for Nagios with a failover environment. I initially went through this post and came up to setup a different DB and make the Nagios master servers available via Linux HA. Could someone please advise if this can be accomplished.


Thanks
Aravind

[rkennedy]

Are you looking to offload your SQL in a HA environment or have XI run HA in general?

We don't have anything officially supported for a HA XI setup, but Linbit offers this service that would work with your Nagios XI system.
Take a look at this article -
https://www.nagios.com/news/2015/10/pre ... nagios-xi/