Nagios Support Forum

Hi Experts,

Base on my understanding and observation, NagiosXI perform better when the size of database is smaller. It is the role of dbmaint script to ensure that the database is in shape as it was configured to.

We have a requirement that the retention period for the system should be 7 year base on the regulation by the gov. It is really hard to achieve right now as i cant find any archiving function inside nagiosxi that i can use to avoid extending the retention period for nagios.
I can dump the database every 3 month but i cant see any way to restore it when needed. Future more, its not just the database, we also need to factor the perfdata for performance graphing (although yeah , it wont be important and accurate for past 7 years).

Should we use the backup files stored as a solutions. How do we restore without impacting the current production data? Do we need another license for it or any others workaround that we can play with?

Thanks,
Safuan

Hi Safuan,

That would be correct, we normally advise customers to keep the table sizes smaller for performance, especially on big systems.

As far as check results go, the log files are never deleted and are archived automatically, you'll find those files in the /usr/local/nagios/var/archives folder. You can still run most of the reports in XI on historical data even it's not in the database itself, those scripts will parse the log archives.

Performance data is similar, those are stored in RRD files, and are never deleted. They do not grow in size as older data points are averaged over time using consolidation functions (essentially the older data will lose some resolution to prevent the files from becoming too large).

See: RRDtool

It's probably a good idea to maintain an archive of full backups on a fixed schedule for data retention purposes. You can also restore data on a test server to avoid disrupting your productions system. The Nagios XI license allows for 3 activations, production, test and backup.

See: Nagios XI license Entitlements

Let me know if you have more questions.

--Benjamin

Hi Benjaminsmith,

benjaminsmith wrote: As far as check results go, the log files are never deleted and are archived automatically, you'll find those files in the /usr/local/nagios/var/archives folder. You can still run most of the reports in XI on historical data even it's not in the database itself, those scripts will parse the log archives.

If i understand correctly,
1. Regardless of retention configured in nagiosxi (3 month for example). The RRD file will always kept the data since it first generated.
2. Some of the report that ship with nagios XI does not rely on database to generate the report.
Can you help list which one require database for report generation and which is not.


Thanks,
Safuan

Hi Safuan,

The audit log, capacity planning, data visualizations would be polling the database Most of the main reports like availability, executive summary, notifications, event log are able to parse the nagios.log files for historical data.

Hope that helps answer your question.

Regards,
Benjamin

Hi benjaminsmith

I dont have further question on this topic
Thank you

Regards,
Safuan