If you're already using an SNMP monitoring tool like OpenNMS, mysql-agent is a great way to add a number of
graphics using Net-SNMP. However mysql-agent has a small bug that
drove me crazy. I will try to highlight the process on how I
discovered it (and hence fix it) since it involved learning about
SNMP, how to diagnose it and eventually, once all the pieces came
together, how simple it is to write your own agents.
Although versions are not that important, just for the sake of
completeness we were using CentOS 5.5, MySQL 5.5.8 Community
RPMs, Net SNMP version 5.3.22 and OpenNMS Web Console
1.8.7.
The Problem
I …
Feb
01
2011
Feb
01
2011
Hudson developers vote for Jenkins. SugarCRM turns cash flow positive. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# The Hudson developer community voted overwhelmingly to rename the project Jenkins, and will continue without Oracle.
# SugarCRM turned cash flow positive in 2010 as billings increased 52% year on year.
# BonitaSoft announced the release of version 5.4 of Bonita Open Solution.
# WANdisco …
[Read more]
Jan
31
2011
I’ve done this in the past, but thought this time I’ve got to take notes. It can be used as a crude check list in the future. Don’t underestimate the power of a practical, down-to-earth check list! Perhaps documents like this should be kept in a wiki page, for easy updating to avoid being stale, a proeblem with blog entries, it seems.
P in LAMP here stands for php, not Python or Perl. L is CentOS (I used CentOS 5.5) or Red Hat Linux. I am not covering moving all databases in a MySQL instance, just a select few or just one.
I’d appreciate your comments or suggestions.
Software install and configuration
MySQL:
MariaDB or Percona.
For Percona server and client tools, it’s best to have direct access to Percona’s repository:
yum install gpg rpm -Uhv …[Read more]
Jan
25
2011
VMware grows 41%. Evidence of Java infringement disputed. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# VMware announced full year revenue growth of 41% to $2.9bn.
# Alleged evidence of infringing Java code in Android disputed.
# Oracle nominated SouJava, the Brazilian Java User Group, to a seat in the JCP Executive Committee.
# The Document Foundation launched LibreOffice 3.3. …
[Read more]
Jan
21
2011
Every so often you need to use a queue to manage operations in an application. Python makes this very simple. Python also, as I’ve written about before, makes threading very easy to work with. So in this quick program I’ll describe via comments, how to make a simple queue where each job is processed by a thread. Integrating this code to read jobs from a mysql database would be trivial as well; simply replace the “jobs = [..." code with a database call to a row select query.
#!/usr/bin/env python
## DATE: 2011-01-20
## FILE: queue.py
## AUTHOR: Matt Reid
## WEBSITE: http://themattreid.com
from Queue import *
from threading import Thread, Lock
'''this function will process the items in the queue, in serial'''
def processor():
if queue.empty() == True:
print "the Queue is empty!"
sys.exit(1)
try:
job = queue.get()
print "I'm operating on job item: %s"%(job)
queue.task_done()
except:
print …[Read more]
Jan
18
2011
Funding for OpenGamma. Riptano becomes OpenStax. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# OpenGamma raised $6m series B funding.
# Apache Cassandra-supporter Riptano changed its name to DataStax and has added 50 customers in 6 months.
# WANdisco acquired the SVNForum.org Subversion user community.
# Univa hired the principal engineers from the Grid Engine team, will publish a …
[Read more]
Jan
15
2011
A special extended edition of Tech Messages for 2011-01-12 through 2011-01-15:
-
Hg Init: a
Mercurial tutorial by Joel Spolsky
An introduction to Mercurial (hg) by Joel Spolsky. Includes a special introductory chapter for Subversion users. -
lessfs | Open source data de-duplication
Open source filesystem with de-duplication. -
UCS B-Series and C-Series Servers Log Memory
Errors due to Intel 5600 Erratum Issue
On a subset of Intel Xeon 5600 series processors, during packet C6 transitions, CPU circuit marginality or internal signaling noise in the may lead to an invalid memory DRAM state, system hang, reboot, memory ECC errors or unpredictable system behavior. This could …
Jan
14
2011
Bid for Novell patents still on. Google drops H.264. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# The withdrawal of CPTN Holding proposal to acquire Novell’s patents is purely procedural, said Microsoft.
# Karsten Gerloff explained why the FSFE is concerned about the sale of Novell’s patents to CPTN.
# Google announced plans to support WebM and Theora in Chrome and Chromium, and drop H.264.
# Pentaho …
[Read more]
Jan
11
2011
Black Duck acquires Olliance Group. Funding for Zend and PHP Flog. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# Black Duck Software acquired Olliance Group.
# Viola Private Equity invested $7m in Zend Technologies.
# PHP Fog raised $1.8m from Madrona Venture Group, First Round Capital, Founder’s Co-op, and other angel investors.
# The proposal for CPTN Holdings to acquire Novell’s patents has …
[Read more]
Jan
06
2011
Congratulations to the Drupal community for getting version 7.0 released! This is a major mile stone and an excellent reason to celebrate!
If you want to give Drupal 7 a try without having to install anything, I've now updated my Drupal 7 appliances on SuSE Studio to the latest release. The appliance is based on openSUSE Linux 11.3 and is available in two variants:
- A text-mode only appliance to which you connect using your local web browser via the network.
- A …