Zabbix Templates for MySQL

We recently had a client come to us, and ask us to improve their MySQL monitoring in Zabbix. So, we did. The approach we took was to port the MySQL script from the superb mysql-cacti-templates project to work with Zabbix. This works out well, because Zabbix is like cacti and nagios combined, and, what we wound up getting, are some templates that can alert us when InnoDB uncheckpointed bytes starts climbing rapidly.

In addition to the above benefit, you also get every MySQL graph that comes from the mysql-cacti-templates project making Zabbix with appaloosa-zabbix-templates* a first-class replacement for cacti when it comes to MySQL trending.

Finally,  the same client is also generously donating time to create templates for Memcached/Membase and Bind9. So, look forward to more out of this project as we go forward into next year.

 

* Did you notice we really like our horses, here at PalominoDB?

Comments

Hey LinuxFood,Thanks a lot for your contribution. I am going to use you Zabbix templates.Cheers.

Sun, 03/04/2012 - 17:35

The answer is of course, "it depends", and a whitepaper would be required to really answer it well. When you say monitoring, do you mean monitoring for trend and workload analysis, or for fault detection and alerting? \

Generally for either, one will want to track basic OS stats - CPU consumption, load average, memory utilization, swapping usage and swapping activity, IO activity for disk (response time, queues, throughput, distribution of reads to writes etc...) as well as network statistics.

Next step is MySQL specific - and this can vary but basics include replication lag, counter statistics (how many selects, inserts, updates, deletes), innodb specific counters, sorts, select handlers (range scans vs. key lookups vs. full table scans), usage of your query cache, myisam key buffer and innodb buffer pool...

There's a lot out there. For trending and workload analysis I prefer to cast a wide net, as you never know where a bottleneck or the symptoms of a problem might manifest. For alerting, you need to decide what is going to impact your service and alert accordingly - http://dev.palominodb.com/docs/nagios_plugins_2011_04.pdf

Laine Campbell
Thu, 11/10/2011 - 09:26

Hi
Thanks a lot for this topic.
May anyone give me some guidance about important parameters in mysql monitoring?in fact,which parameters is important to focus ?

Thanks in advance

Anonymous
Thu, 11/10/2011 - 06:04

Yes, there are screenshots at the Google Code page that was linked in the blog post. http://code.google.com/p/appaloosa-zabbix-templates/

Sheeri Cabral
Fri, 12/17/2010 - 14:25

any shiny screenshots to stare at ? :)

Richlv
Fri, 12/17/2010 - 08:49

That's great. I never had a customer willing to sponsor this port but always hoped it would happen.

Tue, 12/14/2010 - 13:13

In case it's not clear, this project is 100% free, open source, and accepts community contribution.

Sheeri Cabral
Tue, 12/14/2010 - 12:07

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.
Website by Digital Loom