Monitoring solution for drop/create of clone database.

[prateekagr1988]

Please suggest if we there is a Nagios monitoring solution for drop/create of a clone database.

[sreinhardt]

Are you asking if nagios can drop and\or copy a database?

[prateekagr1988]

No.. we are performing a clone of database, and there are unix scripts (NetApp snapshot) running which creates/drops the clone.. we require a monitoring solution so as to ensure the create/drop has taken place correctly.

[tmcdonald]

If there is a Unix script you could edit, it should be pretty trivial to have it send a passive check back to Nagios using NRDP or something similar:

http://assets.nagios.com/downloads/nrdp ... erview.pdf
http://assets.nagios.com/downloads/nagi ... ith_XI.pdf

[prateekagr1988]

Hello.

In this case a database is created at a specific time in the morning, and dropped at another specific time in the evening.
Is there an option to monitor the database creation and drop ?

[slansing]

As has been mentioned, you could modify the script to add support for passively sending a check result to your Nagios server. Alternatively, you could create a plugin and either actively call it from XI to check a metric which tells you if the database has been created, or dropped, and then return that to you, or have it passively ran by cron via NRDP twice a day to check the same metric. Alternatively, depending on the software, you may be able to find a plugin that will already do that for you here:

http://exchange.nagios.org/