Databases Reference
In-Depth Information
Summary
Good tools are essential for administering MySQL. You'd be well advised to use some
of the excellent tools that are already available, widely tested, and popular, such as
Percona Toolkit (
nee
Maatkit). When we are introduced to new servers, practically the
first thing we do is run
pt-summary
and
pt-mysql-summary
. If we're working on a server,
we'll probably be watching it and any related servers in another terminal running
innotop
.
Monitoring tools are a more complicated topic, because they're so central to the orga-
nization. If you're an open source advocate and you want to use open source monitoring
systems, you might try either the combination of Nagios and Cacti with Baron's Cacti
templates, or Zabbix if you don't mind its complicated interface. If you want a com-
mercial tool for monitoring MySQL, MySQL Enterprise Monitor is quite well done,
and we know a lot of happy users. If you want something capable of monitoring your
whole environment, and all of the software and hardware in it, you will need to do your
own investigation—that is a bigger topic than we can tackle in this topic.
