Before a monitoring and notification system for MySQL (and other
infrastructure) can be fully conceived, a variety of questions
must be asked. I’ve attempted to put some of the most important
of them together in this post.
These are what I feel are some best practice
recommendations.
#1 Define what is to be monitored.
-
- Is it a HOST?
- Is it a SERVICE?
#2 Determine what level of health monitoring is
desirable.
-
- Basic Monitoring Probes (typically active checks)
-
- Simple TCP/IP port up/down
- Disk space, free memory, swap utilization, etc
- File exists (or does not exist, or is not of at least X
size)
…
-