search

mozilla / identity-ops

Tools and Chef cookbooks used by Mozilla Services Operations to provision and manage Persona
Other
24 stars 12 forks source link

Create Opsview DB MySQL query monitors #154

Open gene1wood opened 10 years ago

gene1wood commented 10 years ago

Currently we don't monitor the content of the mysql servers and that we can query that content. Should be easy to do.

gene1wood commented 10 years ago

Sheeri has some existing checks we could employ

MySQL - checks that MySQL is running

MySQL Config Diffs - checks that the running MySQL config is the same as /etc/my.cnf. Useful to make sure that if a machine restarts, the config will be the same.

MySQL DB uptime - useful to catch if MySQL is restarted and Nagios doesn't catch when MySQL is actually down. We check to see if MySQL was restarted in the previous 30 minutes.

MySQL Replication - useful to check replication lag (you already have this)

MySQL Table Checksum - after pt-table-checksum is run on the master (we have scripts for this in puppet), the tables on the slaves are checked to ensure that the data on the slave is in sync with the data on the master.