Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Monitoring a group of servers can be a lot of work. The tools needed to properly mon- itor a server are numerous and while most are easy to use once you understand what they do, they still require a bit of work to get going. Scripting and even some creative web hosting can help manage the execution of the various tools and the collection of the data, but as the number of servers to monitor grows, the task of collecting and analyzing all of the data can become time-consuming. The monitoring techniques discussed so far in this book can become unmanageable for installations with more than a few servers. Indeed, manual monitoring and reporting can turn into a full-time job for one or more technicians in an organization with dozens of servers. We focus on monitoring in this chapter, but the same can be said about administration. Specifically, administrators often see time savings when they use administration tools that permit automation of common tasks, such as running scripts to populate tables, performing table mainte- nance, etc. Fortunately, this problem isn't new, nor is it insurmountable. Indeed, there are several enterprise monitoring suites that can make life in a sea of servers much easier. One of the most underestimated tools available for monitoring MySQL is the MySQL Enterprise Monitor (MEM), which comes with the MySQL Enterprise subscription. The MEM tools can greatly enhance monitoring and preventive maintenance and can