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 …

As I am writing and publishing more and more blog entries, it becomes important that I have good and reliable backups. I know that if something happens and I cannot recover my entries and comments, I would be terribly upset. So I want to share my process here. Please feel free to share your backup methods by commenting. Hopefully somebody will find it useful.

Backup comprises two parts:

1. File backup

On a Linux machine with Apache, the default web files and directories reside in /var/www/html. Yours may be different. This include all php files and sub-directories like wp-content, wp-include, etc.

The easiest way to do it is to use tar command with -z to compress them. My post here gives you a pointer on tar.

These files are fairly static, so you do not need to back them up …

Today, there seemed to be several interesting news items, so let me elaborate on a couple of them.

Besides the fact that the Mandrake founder Gael Duval isn’t part of Mandriva anymore, the part that interested me was the fact that he was running Mandriva’s Community Department. Their goal was “to improve Mandriva’s image in the open source arena.” Swap Mandriva, with MySQL, and thats me. From engineering grit right up to attending conferences, thats what Community does. Its funny thats what Mandriva chose to close first, seeing their dismal quarter results - basically without an OSS community, you’re nowhere in the OSS world.

I’m a regular lurker on #conary, and reading rPath Creates Malleable, Serviceable Linux Distribution made me …

Another slightly disappointing article regarding MySQL, this one from a printed magazine. Below are my comments to the editor of Linux Format. The Dear Editor is an email link should others wish to make any comments. (Previous article comments What makes your blood boil?, Review of Database Magazine Article - ?The Usual Suspects?)

Dear Editor,

I’ve recently subscribed to LXF, and have generally been very happy with the content in past months. I’m disappointed in your recent LXF77 article “Harness a database” Pg 57. Being a strong MySQL supporter, your article includes a number of practices which are less then ideal, and especially for the newly initiated, overly complicated when simplier alternatives exist.

I am happy to see that you had the …

Apache JMeter is a 100% pure Java desktop application designed to load test functional behavior and measure performance. It was originally designed for testing Web Applications but has since expanded to other test functions. Specifically it provides complete support for database testing via JDBC.

Some References: Homepage http://jakarta.apache.org/jmeter/  ·  Wiki Page  ·  User Manual

Initial Installation Steps

$ su -
$ cd /opt
$ wget http://apache.planetmirror.com.au/dist/jakarta/jmeter/binaries/jakarta-jmeter-2.1.1.tgz
$ wget …

FrOSCon is a two-day conference on free software and open source, which takes place on 24th and 25th June 2006 at the University of Applied Sciences Bonn-Rhein-Sieg, in St. Augustin near Bonn, Germany.

The Call for Papers ends on March 15th - so you better hurry if you want to give a presentation there! I proposed two MySQL-related talks and also asked some other colleagues to file a few submissions. There is enough stuff happening here to talk about

By the way, their registration frontend is very slick - it's called pentabarf (which I personally think is a weird name) and is powered by Ruby on Rails.

Alfredo announced the availability of version 1.0.5 beta of the MySQL Workbench, the latest product in the MySQL GUI tools family (also check out the Administrator, Query Browser and the Migration Toolkit).

I downloaded the RPM for SUSE Linux 9.3, which installed flawlessly on my SUSE 10.0 system. To test the reverse engineering capabilities, I installed the latest version of the Sakila …

I made reference previously to Testing/Trialing new MySQL Releases using VMWare.

Well, I’ve just about completed my own Image for the lastest MySQL 5.0 (given I’m now running MySQL 5.1). I’m interested in sharing my experiences, and even providing some images for users if there is any demand out there.

What I’ve decided on is to use the VMWare supplied Browser Appliance which is Ubuntu 5.10. The great thing is the image autoboots into graphical mode, auto logins and loads a browser. My goal now is to get a suitable startup page describing the MySQL environment, links, manual etc.

The only requirements to run would be the …

Some recent posts regarding Oracle (See Smart moves by MySQL AB and Larry Ellison still doesn’t understand open source) leads me to put in my 2 cents worth.

My background I’m sure like a lot of experienced MySQL people is in Oracle, and indeed in Ingres before that (starting in 1988). I have also worked for a number of years at Oracle Corporation. Ironically I started as their resident Ingres Specialist, in an international research project of DMS (Design & Migration Services) of re-engineering Ingres applications into an Oracle Designer Repository some 10 years ago in 1996. I of course moved into a number of other Oracle roles for clients following that. I still retain some …

Some days ago I interviewed Ian Linden, the Director of Operations at Linden Lab (the company behind the virtual world simulation Second Life) about Second Life, Linux, MySQL and other OSS usage for their operations. I actually performed the interview inside of Second Life, which was quite fun, especially now that there is a Linux client! You can read the full interview on the MySQL Developer Zone. Have a nice weekend!

Update: The interview is now listed on the Featured Articles page on the MySQL Developer Zone, too. If you would like to know more about Second Life and MySQL, Ian will …