mysqlreport v3.3 is ready. Changes:

• –all is now the default option and all the sub-report options like –dms, –sas, etc. have been removed. All reports that can be made are made automatically.
• Slow line now displays long_query_time and log_slow_queries
• Created Temp Table line now displays tmp_table_size
• The mysqlreport tgz and zip now extract into their own directory

The mysqlreport Documentation and The Guide To Understanding mysqlreport have been updated to reflect these changes.

DRBD 8.2.3 was released today. Even though just a micro release in terms of version numbering, it comes with a couple of very handy brand new features: on-line device verification, and tunable processor affinity.
(more…)

YouTube, it turns out, uses MySQL as its backend.

Paul Tuckfield, the YouTube DBA, speaks about using MySQL at YouTube.

Before I even finished listening to the whole presentation, I got several key points:

• Paul Tuckfield started out at YouTube with a lot of database experience under his belt as an Oracle DBA--but no MySQL experience. Which tells me that switching from Oracle to MySQL, while retaining people, should not be an obstacle.
• MySQL scales, nicely. YouTube has three DBAs. They served 100 million videos a day, back in mid-2006. Without DB2 or Oracle.
• Scaling MySQL to YouTube-scale is non-trivial. Tuckfield talks about using master/slave architecture and doing clever things with replication, to …

Modified by Henrik Ingo from
original picture by "Just Taken Pics'" @ Flickr. CC-BY

I haven't written much on this blog related to my work. There's a simple reason: Apart from some welcome exceptions, my work at Sesca is not at all related to Open Source. And even when it is, we are not supposed to talk about our work much in public. Also, as a manager my work is rather boring sometimes, not something I'd want to write about.

All of this is about to change though. On Monday I will start working as a Sales Engineer (or some call it "pre-sales consultant") for MySQL! Here's a list of things I'm looking forward to:

read more

Hi all - boy, have I got news for you!

I would like to announce that The MySQL UDF Repository is no more. The rumour is that its growing popularity has caused it to be noticed by some folks at MySQL AB's legal department, kindly requesting that the project's name be changed to something even cooler.

However, these are just rumours - this is only the internet, so relying on a first-hand source, I can safely confide in you that the project's name and website are being changed mainly out of religious conviction to offer even more and better free UDFs for the MySQL …

While I haven’t spent much time going through the linux.conf.au 2008 schedules, it is now less than a few weeks away, and I’m stoked. If you’re there for the Mini-conf’s, I suggest freeing up your Tuesday, to spend it at MySQL.conf.au :) There are a bunch of interesting talks, and there will be a lot of MySQL’ers around. In fact, Giuseppe Maxia is flying in all the way from Sardinia, Italy, to give a talk. And I can assure you, he gives entertaining Proxy talks.

When I have more time to read through the schedules, I’ll work up a timetable, I’m sure. Time? There’ll be plenty, as I hop on a plane next Monday for a lengthy flight to Florida.

…

It is that time of year when folks promise themselves to get into better shape.  This is usually my time every year to do that.  The holidays always put some extra weight on me.

I know from going to conferences that there are some health conscious geeks out there.  Well, I found a geeky way to help with that.

Some guys here in Huntsville have started a fitness and health tracking site called Gyminee.  They are in the same business incubator that dealnews was in several years ago.  It is all Rails and MySQL.  It is quite convenient for me and some other guys at work since they built an iPhone interface.  Basic accounts are free and fairly full featured.  There are some advanced features that do require a small membership fee.  If I would just quit buying one …

Yes - it's that time again ;-)


The new year has just started which means the MySQL Conference and Expo is little more than 3 months away. I am very glad to have the opportunity to attend, and even more glad to be speaking.

I will be doing two sessions:

• 
  
• Writing MySQL UDFs - A 3 hour tutorial for people that want to get started writing MySQL UDFs. PHP and/or Java skills recommended - No pre-existing C skills required.
• …

I try to do a decent job of advocating for caring about good backups and business continuity strategies in my 7 Deadly Habits article. But this one beats them all:

Just too funny and great not to share. Found via this reddit article, where there is a lively discussion underway.