Munin plugin for graphing MySQL slave delay

Sunday, 10 February 2008, 11:41 | Category : MySQL, Software Development
Tags :

I wanted to track the delay of a mysql slave server in Munin, and found nothing appropriate after a quick google. So, in case anyone else finds it useful, here is a plugin which will allow you to do just that.
Here’s a typical graph:

Download: mysql_slave (1 Kb)
EDIT: I wrote this so I could better [...]

MySQL gotcha using BETWEEN with dates

Friday, 16 November 2007, 12:47 | Category : MySQL, Software Development
Tags :

We just updated a development server from Ubuntu 6.06 to 6.10. As a result, MySQL went up a couple of point releases from 5.0.22 to 5.0.24a.
Suddenly, the web application we were working on stopped working. It wasn’t possible to log in.
We quickly narrowed it down to a clause in query which checked a users subscription [...]