OurSQL Episode 75: Off the Charts, part 2

Part 1 of the monitoring series: http://bit.ly/oursql074
This week, we continue the monitoring series, talking about snmp, rrdtool, cacti, nagios, openNMS and zabbix.

News:
The next free Oracle Technology Network Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. Register for free here.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Use code PL-pod and save 10% off the early bird prices!. Early bird pricing is only good for about 7 more weeks, so make sure to register soon!

Monitoring
SNMP: http://en.wikipedia.org/wiki/Snmp
RRDtool: http://en.wikipedia.org/wiki/Rrdtool

How to avoid I/O hell w/ RRD

Cacti http://www.cacti.net/
MySQL Cacti templates: http://code.google.com/p/mysql-cacti-templates/

Nagios http://www.nagios.org/
Ethan Galstad, creator of Nagios, won the SAGE Outstanding Achievement Award at LISA 2011.

Nagios plugin for arbitrary MySQL variable/calculation/processlist monitoring: Project page, including whitepapers, videos, and the code download or direct code download.

OpenNMS: http://www.opennms.org
Masterzen: http://www.masterzen.fr/2010/01/10/mysql-snmp-10-snmp-monitoring-for-mysql/

Zabbix: http://www.zabbix.com/

Ear Candy
Sheeri: This week’s ear candy is about a specific access denied error:
"Host ... is not allowed to connect to this MySQL server"

At the Movies
This week in at the movies we show a video of a presentation Sheeri did about her nagios plugin last spring at several conferences, showing why she wrote it and how it works.

Where you can see us
Gerry will be at the February Seattle MySQL User Group on Monday February 6th from 7 - 9 pm. No subject has been set yet. Since the January meeting had to be cancelled at the last moment, it would be nice if you come prepared to share your MySQL year - like what you want to learn and what you’re planning on doing, such as upgrading.

Sheeri will be at the February Boston MySQL User Group on Monday February 13th from 7 - 9 pm. The meetup topic "Scaling MySQL with Transparent Database Sharding", by Liran Zelkha of ScaleBase. Every relational database has some machine scaling limits. In this month's meeting Liran will present the concept of Database Sharding - splitting the database to several independent databases, a solution proven highly effective for scaling MySQL. He will discuss the steps required for building a sharding solution, the implications and limitations of such solution, and will summarize by presenting ScaleBase solution to Database Sharding.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1146