#371 stale dump checks
Closed: Fixed None Opened 16 years ago by mmcgrath.

We need to monitor the database dumps to ensure they're not older then 24 hours. We cross dump (mysql dumps to db1 and db2, postgres dumps to db2 and then rsyncs to db1) so we'll want to monitor both the local and remote dumps of each box.


Sounds like a job for Nagios' check_file_age plugin. Where do these database dumps live?

db1:/var/lib/mysql-backups/
db1:/var/lib/pgsql/backups/
db2:/var/lib/mysql-backups/
db2:/var/lib/pgsql/backups/

Ok, got last two locations, they should be viewable by nrpe.

db1:/var/lib/pgsql/backups/local/db-backup/koji.db
db2:/var/lib/pgsql/backups/remote/db-backup/koji.db

Looks like these checks have been running successfully for about 35 hours.

Resolving as fixed, thanks!

Login to comment on this ticket.

Metadata