Page 1 of 1
Monitoring solution for drop/create of clone database.
Posted: Fri Nov 21, 2014 7:02 am
by prateekagr1988
Please suggest if we there is a Nagios monitoring solution for drop/create of a clone database.
Re: Monitoring solution for drop/create of clone database.
Posted: Fri Nov 21, 2014 2:45 pm
by sreinhardt
Are you asking if nagios can drop and\or copy a database?
Re: Monitoring solution for drop/create of clone database.
Posted: Sat Nov 22, 2014 1:37 pm
by 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.
Re: Monitoring solution for drop/create of clone database.
Posted: Mon Nov 24, 2014 10:19 am
by 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
Re: Monitoring solution for drop/create of clone database.
Posted: Wed Dec 10, 2014 7:15 am
by 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 ?
Re: Monitoring solution for drop/create of clone database.
Posted: Wed Dec 10, 2014 1:00 pm
by 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/