Archive for the ‘Cacti’ tag
This is a quite short book that covers some of the breadth but very little of the depth of Cacti. For example, it focuses on Cacti as an SNMP tool for graphing network data, but SNMP is only one of the many ways Cacti can collect data, and of course it graphs anything, not just networks. Each chapter takes the reader through the most important topics, with some code listings and screenshots. On the plus side, this makes it very easy to read quickly, because it doesn’t go off on many tangents about special cases and errors.
I don’t want to criticize too much, but I think I should give a summary of the major shortcomings. First, the book is just too small, especially for the price. It is also not very well edited; it seems to have been edited by non-English speakers. Finally, it constantly refers to Cacti as a monitoring tool, even talking about the need to find out about crashed equipment and so on — but it doesn’t clearly say that Cacti is only for performance graphing, not for monitoring and alerting. I wish they had not flung the word “monitoring” around so casually.
In terms of topics, it has an overview, installation, creating graphs, creating templates, managing users, SNMP, data queries, and basic administration. The strongest point is the explanation of SNMP. The other chapters have a lot of needless information and screenshots. The installation chapter, for example, goes through installing prerequisites from APT — which APT can do itself.
In the end it’s light reading that shouldn’t take you long to finish — an overview in case you don’t know much about Cacti.
If you’d like some improvements to the Cacti templates (MySQL, Apache, Memcached, and more) I’ve been maintaining, please make your voice heard — either write to the mailing list, or post a new issue (or comment on an existing one) on the issue list. I’ve got a bunch of work underway, including a test suite for ss_get_by_ssh.php.
I’ve released version 1.1.4 of my improved Cacti templates. Unlike the prior release, which was solely bug fixes, this one includes new graphs in the MySQL template. Some of the graphs are of data that’s exposed in standard MySQL versions, but some of it is available only in Percona’s high-performance builds of the MySQL database server. If you don’t have a Percona build, those graphs will just contain nothing, but there is no detrimental effect.
This template release is fully backwards compatible with the previous release. The upgrade process is to copy the new PHP file into place and import the new template file. You can then add the new graphs to your hosts.
I’ve also taken the opportunity to address many of the other open issues. Most of these were minor, such as a debug log to help troubleshoot. Some are big improvements, such as no longer using GET_LOCK() in MySQL to arbitrate access to the cache file. A list of open issues can always be found at http://code.google.com/p/mysql-cacti-templates/issues/list.
To ease the process of future upgrades, I’ve also added in a gratuitous GPRINT definition, which is unused and merely records the installed version of the template (both the template version, and the version of the PHP file against which it was generated).
The full changelog follows.
2009-10-25: version 1.1.4 * Changed SSH options so host keys are accepted automatically (issue 68). * Parsing of the pending_ibuf_aio_reads property was broken. * Parsing of the pending_aio_log_ios property was broken. * Parsing of the pending_aio_sync_ios property was broken. * Added a debugging log for ss_get_mysql_stats.php (issue 54). * Added the --lint_check option to make-template.pl (issue 80). * Removed the use of GET_LOCK() and changed to flock() instead (issue 78). * The template and script version is now recorded in a GPRINT (issue 79). * Restored unflushed_log, which was accidentally deleted in 1.1.3. * Added the InnoDB Internal Hash Memory Usage graph (issue 75). * Added the InnoDB Checkpoint Age graph (issue 73). * Added the InnoDB Insert Buffer Usage graph (issue 74). * Added the InnoDB Active/Locked Transactions graph. * Added the InnoDB Memory Allocation graph. * Added the InnoDB Adaptive Hash Index graph. * Added the InnoDB Tables In Use graph (issue 32). * Added the InnoDB Current Lock Waits graph. * Added the InnoDB Lock Structures graph (issue 32).