With all the recent buzz on Planet MySQL about using LVM to perform "semi-hot" backups of MySQL on Linux, I remembered that we once created such a Perl script for a server project that we worked on in cooperation with a hardware vendor. As this particular backup method was also mentioned and recommended in my talk about MySQL backup and security on Linux and the script hasn't actually been publicly available so far, I offered to take over the ownership and release it under the GPL. The first tarball release (0.1) is now available from …

At the 2004 Foo Camp, Danese Cooper, a few other FLOSS advocates (forgive me, Foo Camp is a blur and I don’t remember who you were) and myself gave an ad hoc session on the methods and strategies that we each used to advocate FLOSS and to help people working closed environments become more open.

The session was a blast (and well-received), so much so that Danese and I proposed the session for last year’s OSCON. We didn’t make the cut, but I still tried again for this year’s EuroOSCON and, this time, the session was accepted.

The session should be fun to present, but a bit of a bear to write. I have only 45 minutes to try to fit in the most …

I had lunch with a company's IT staff yesterday, and asked them, "Which open source projects/products do you use?" They listed off several projects (Tomcat, etc.), but I had to prompt for the most obvious one: "And Linux? I assume you're running Linux?"

"Linux? Oh, of course, I guess we had forgotten that's open source."

This was a hugely telling remark. For this company (and, frankly, for most of the industry), "open source" is short-hand for many things, and sometimes connotes a cutting-edge, not fully baked product. This is accurate in some respects, and wholly inaccurate in others (no one could sanely call Apache, MySQL, etc. "not fully baked").

In this company's mind, Linux is just there. It works, requires no special justification, etc. It just is.

Give JBoss and MySQL a year or two, and they'll be the same. Along with hordes of other open source projects.

For those of you who, like I, have been …

HackFest B: Creating a New SHOW Command by Brian Aker at the MySQL Users Conference

Brian stepped through the steps for those attending to modify and deploy new functionality in the mysql server. Cool. The end result I would consider for an experienced developer as relatively easy (after avoiding the pitfalls).

NOTE: I wasn’t able to complete this successfully during the session, but I’ve posted this, so hopefully the input and review of others can help in overcoming the current issues. See Outstanding Issues throughout my notes.

Our goal: Produce a new command SHOW CONFERENCE;

The following commands were performed on CentOS 4.2. There may be some …

The JAX Innovation Award is intended to honour and recognise the most remarkable and outstanding European contributions in the world of Java and Eclipse. These contributions can include products, open source projects, ideas, concepts, publications, or break-through technological innovations. What's your most favourite innovation or project?

You can submit your proposal online or by downloading and filling out forms provided from this page. The winner can win a 10kEUR prize, which will be presented during the JAX, Enterprise Architecture, and Eclipse Forum Europe …

The organizers of the PHP Québec Conference were gracious enough to give me an unedited copy of my Copyright, Contracts and Licensing for PHP Developers session.

I cleaned the audio up last night, stripping out some of the more odious filler words (I seem to say “Umm” rather often), shortening pauses as I switched slides, removing redundant asides (like asking if there are any questions, when no questions then follow) and excising the introduction and applause.

After a good deal of consideration, I did chose to leave the errors and other flaws in the content presented. These flaws were presented to the audience and they should stay in the recording.

Of course, I don’t want people to be mislead by any of the flaws; to prevent this, I am transcribing the entire talk, …

I don’t think I’ve ever installed MySQL via .rpm I have always installed via .tar.gz primarilarly because I’m an /opt system administrator from my old UNIX days. so my first experience installing on my CentOS 4.2 (aka RHEL 4).


$ rpm -Uvh MySQL-server-standard-5.0.19-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-standard-5.0.19-0.rhel4.i386
Suggested resolutions:
perl-DBI-1.40-8.i386.rpm
$ rpm --import /usr/share/doc/centos-release-4/RPM-GPG-KEY
$ yum install perl-DBI-1.40-8
$ rpm -Uvh MySQL-server-standard-5.0.19-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server-standard …

Given a new Linux Installation, the following is my recommendation for installation of MySQL for a experienced software developer giving flexibility in a development environment.

1. Under normal circumstances, most distros include MySQL either in a default server installation or on the distribution CD’s. You should first ensure MySQL is not installed.

2. All products can be downloaded from the MySQL Downloads page.

3. Download MySQL 5.1 Beta - Linux (non RPM, Intel C/C++ compiled, glibc-2.3), this product is close to production release and stable. This also includes both Server and Client as well as provides flexibility in installation location and …

I was asked a simple question today by a collegue who is an experiened Java Developer and Oracle user and had just installed SUSE on his personal laptop, to align closer with his work environment. What MySQL should I install, the MySQL web site has this and this and this?

Simple question, but the answer isn’t as simple, especially when MySQL now has a number of different products encompassing client functionality in addition to the MySQL server.

Oracle got it right with the latest edition Oracle 10g Express Edition (XE). A simple one rpm install that includes the Oracle Server, Oracle client, a Web Based Administrator, Query Tool and Application Development tool. I guess as we are all experienced, the simple question isn’t something we have a some notes on handy, hence the purpose of my entry …

Recently I've been working on a large-ish project where all of the UI is written in Javascript. That, in itself, is great. The environments (the browsers) are crappy crappy for development though. Sure, there are Firefox extensions etc etc to help, but it's Just Not Great. Javascript = Great. Ajax = Yay. Browsers = Bah.

Over the weekend I spent all sorts of time getting a simple Rails application running with Apache and mod_fcgid. When I gave up and tried making it work with lighttpd I got server error galore. Yay. What was wrong? My fastcgi? The fcgi Ruby extension? My ruby installation is in /pkg/packages/ruby-1.8.4 or some such and the gem tool couldn't find its own libraries after being installed there. Maybe something similar for something else? I have no idea, I got no error messages anywhere. Ruby = Great. Rails = Very nice[1]. Ruby Gems = It sure is no CPAN.pm. FastCGI/lighttpd/etc = Loosely coupled? No mister, you have some way to …