Nagios-XI database monitoring

[Rinil Raveendran]

Dear All,

Could you please let me know the supported database versions for nagios-XI(5.4.11) ?

Does it allow the below versions ?

SQL 2000, SQL 2005, SQL 2008, SQL 2008R2, SQL 2012, SQL 2016
ORACLE 10g and ORACLE 11g

Regards,
Rinil

[npolovenko]

Hello, @Rinil Raveendran. I think you can monitor all the suggested databases with Nagios XI. It's just a matter of finding the right plugins and figuring out what exactly you want to monitor. Keep in mind that different monitoring counters are available/supported on various versions of MySQL.
You can find plenty of database monitoring plugins on Nagios Exchange portal: https://exchange.nagios.org/

[Rinil Raveendran]

Thank you npolovenko

Do you have any idea if the database wizards available with nagios-XI is working agentless ?

Or do we need to configure nrpe/nscd clients for these as well(for database monitoring) ?

[npolovenko]

@Rinil Raveendran. Yes, I think a basic database check plugin would connect to the database X, run a certain query and then return the output to Nagios. This wouldn't require any agents on the server side. Some users would create a separate username in the DB for Nagios because they would rather not provide the admin credentials.
If you go to Configure/Configuration Wizards in XI and start typing either "SQL", or "Oracle", you'll see some wizards. You can take a look at those, as well as the ones on the exchange. What exactly are you planning to monitor in your DB's? Do you have all the listed DB's running at the same time? I guess it would be easier if we could focus on one DB at a time