OurSQL Episode 49: Stalking MySQL

Reminder: Due to busy summer conference schedules, we are going to be publishing the podcast every other week.

This week we talk about a monitoring plugin from PalominoDB that uses caching (like the cacti templates) and allow for arbitrary calculations of thresholds based on status and system variables, and items from the PROCESSLIST.

Nagios
pnp4nagios - from the site, "PNP is an addon for the Nagios Network Monitoring System. PNP provides easy to use, easy to configure RRDTools based performance charts feeded by the performance data output of the Nagios Plugins."
Cacti

MySQL checks that come with the official Nagios plugins:
check_mysql
check_mysql_query

Nagios exchange plugins for MySQL

Information for the PalominoDB Nagios plugin is kept up-to-date on the Projects page -- that page has links to the white paper, presentation slides and videos, and the link to actual download the code.

blog post about the Nagios plugin, which has examples for Nagios commands and services.

Other open source monitoring systems: munin, zabbix, zenoss

Commercial monitoring systems: MySQL Enterprise Monitor, MONyog, Oracle Grid Control, using the free Pythian MySQL plugin for Oracle Grid Control, Hyperic HQ

Ear Candy
Manual page for replication options, including SSL options.
Even though the commandline mysql command does NOT require the --ssl option when using certificate options such as --ssl-ca; however when using replication options such as MASTER_SSL_CA, the option MASTER_SSL=1 is required.

Where you can see us

Sarah will be at the Velocity Conference, Tuesday June 14th through Thursday June 16th in Santa Clara CA, speaking about the many layers of caching in the modern web stack. Get 20% off registration by using discount code FRIEND

She'll additionally be at Devopsdays on June 17-18th.

We will both be at Open Source Bridge from Tuesday, June 21st – through Friday, June 24th in Portland, Oregon.

Sheeri will be at Kscope 11, an Oracle Developer Conference, from Sunday, June 26th through Thursday, June 30th in Long Beach, California speaking about Securing MySQL.

We will both be at OSCon 2011 from Monday, July 25th through Friday, July 29th in Portland, Oregon. Get 20% off registration using the discount code os11com.

Feedback
Facebook group
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/1119