How to Monitor DB2/Oracle/Mysql Database from ICINGA

Icinga 2
1

How to Monitor DB2/Oracle/Mysql Database from ICINGA2

Do i need to install any modules for DB2/Oracle/Mysql in ICINGA2 before i start adding hosts in icinga director?
Oracle/DB2/MYSQL Modules installed by default in icinga 2?
How can i integrate DB2 and start monitoring with ICINGA2?
Where can i find Plugins for DB2/ORACLE/MYSQL for ICINGA2?
Where can i find Spoon feeding/Dummy documents for ICINGA2 to monitor DB2/ORACLE/MYSQL?

2

yes you can monitor your database using icinga , please find these links below

https://icinga.com/docs/icinga2/latest/doc/05-service-monitoring/

https://icinga.com/2016/08/01/monitoring-mysql-database-size/

https://icinga.com/2017/06/12/how-to-monitor-your-mysql-servers-with-icinga-2/

3

to monitor any of these databases we need to install perl modules

  1. MYSql( Perl-module DBD::Sybase )
  2. DB2 ( Perl-Module DBD::DB2 )
  3. ORACLE ( perl-modules DBI and DBD::Oracle )

do we need to install these in ICINGA server / target servers?
Post this
Addind the all the Oracle/DB2/MYSQL hosts in icinga director and start monitoring form dashboard?

4

Hi,
for monitoring databases you could try the scripts fom https://labs.consol.de/.
If you have to install some libraries which the scripts needs, you have to install in on that Icinga Server who runs it.
Some scripts needs also the db driver on the server.

5

BTW: @theFeu I think this thread is about monitoring other databases. So in my eyes it is the wrong category :wink:

6

Thanks for bringing it to my attention, that is absolutely correct!
I moved it to Icinga 2 Core, but this topic kind of tackles topics from all sorts of categories…
Should be fine there though :slight_smile:

7

thanks for moving to correct categeory