Nagios Support Forum

We have integrated our SAP Business Intelligence with Nagios so that we can create Performance/Availability reports. We are wondering what solutions are out there for keeping performance data in separate databases for historical reports. We are aware that most performance data is only typically kept for a short period of time but we are looking for a solution to keep it longer.

What database types are supported for this sort of solution?

Thanks,

Well, the typical way that we store that performance data is in round robin database files, which is held indefinitely, but the values can become increasingly averaged. Another way we handle reporting is by writing host/service returns to the NDO database for reports such as the Availability Summary. It sounds like you don't have that tool fully integrated yet.

What database types are supported for this sort of solution?

In your case, would entirely depend on the tool you are using, and what it accepts, perhaps their support team has worked with Nagios integration before? I would definitely check with them first, before you get plugging away at one type of database and find out it wont work properly.

What we need is the ability to provide performance reports on a weekly/monthly basis. We also need the ability to keep historical data. What we don't want is to impede on the performance of Nagios XI.

You can tweak performance settings in XI (specify data retention intervals) by going to Admin->Performance Settings->Databases tab-><make mods>->Update Settings.

Is it an easy/common task to have the nagios database on a separate server?

It is pretty easy, yes, while I would not necessarily label it as common, I've seen it quite a few times.

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