Nov 30 2007

MySQL 5.1 Cluster DBA Certification Study Guide

Apart form the Xen book I coauthored earlier this year the nice folks of the MySQL documentation team asked me to review parts of their MySQL Cluster Certification guide.

After a long wait it's finally out !
In contrary to the other one, this book took over a year to finish because there was actually a lot of reviewing done by different people.

You can buy it now at Lulu.com !

John might want to read it to figure out about his 5th step.

Nov 14 2007

Drupal Registration procedure

As a Drupal newbie I`m wondering about the new user creation process.

Is it just me or is there a part missing int he admin/user/settings form. When you as an admin require users to be approved first. Don't you want the user to recieve multiple mails. One when he registered, telling him that he is awaiting approval/.
Then one when you approved his membership giving him the details on how to log on to the site ? (Or a another one telling him he wasn't approved)

Or am I looking in the wrong places for this feature ?

I see the mail form that will send out a mail that the user iss awaiting approval. But I can't find a template that is being sent upon approval. Neither can I see a mail departing from my system.
I find it a bit weird to send out userinformation to a user that doesn't end up to be a user afterall.

Nov 10 2007

Scaling Drupal

John Quinn writes about Scaling Drupal he is taking a one step at a time approach and is still writing his 4th and 5 stages.

His first step obviously is separating the drupal from a separate database server, and he chooses mysql for this purpose, moving your DB to a different machine is a good thing to do.

However then he gets this crazy idea of using NFS to share his his drupal shared files :(
(he even dares to mention that the setup ease is good) Folks, we abandonned NFS in the late nineties. NFS is still a recipe for disaster, it has performance issues , it as stability issues (stale locks), and no security admin in his right mind will tolerate portmap to be running in his DMZ.
(Also think about the IO path that one has to follow to serve a static file to a surfer when the file is stored on a remote NFS volume)

On top of that he adds complexity in a phase where it isn't needed yet. Because of the fact he needs to manage and secure NFS and he is storing his critical files on the other side of the ethernet cable he did create a single point of failure he didn't need creating yet.
Yes as soon as you start to scale you need to look at a scalable and redundant way to share your files.
When those files are pretty static you'll start out with a set of rsync scripts or scripts that push them to different servers upon deploying your application. When they are changing often you start looking into filesystems or block devices that bring you replication, such as DRBD or Lustre
But if today his NFS server goes down he is screwed, much harder than when his database has a hickup.

One could discuss the order of scaling, but adding more webservers might not always be the first step to take, one might want to tackle the database first depending on the application.
He decides to share the load of his application over multiple Drupal instances using apache mod_proxy , then adds Linux-HA to make it highly available.
I`m interested in knowing why he chose for apache mod_proxy and not for LVS

Although using NFS for me belongs in a How NOT to scale tutorial, his other steps give you a good idea of the steps to take.

I`m looking forward to his next steps :) I hope that in part 4 he also removes NFS in favour of a solution with no performance and locking issues that really takes away a big fat single point of failure. In part 5 he discusses how to scale your database environment. The actual order of implementing step 2 and 5 will be different for each setup.

Anyway.. I`m following up on his next steps.. interesting reading

Nov 08 2007

Barcamp #4: Dec 1 at mVillage

Barcamp Brussels 4 is comming

It’s decided! Barcamp Brussels #4 will take place on Saturday Dec 1st, in the mVillage business center in Schaarbeek, close to the Koninginneplein, Kruidtuin/Botanique and the Brussels North station (thanks for the help, Simon).

Nov 05 2007


So just when last weekend I started asking for a LinkedIn API , then ran into the Facebook API I ignored Google's OpenSocial announement.

And guess what .. the start for the OpenSocial Drupal is already there.. now when will the code show up ? :)

Nov 04 2007

Plaxo , what's the use ?

I just got an invite to connect to an old collegue on Plaxo Pulse

I`ve been ignoring Plaxo for a while now as the only thing it did for me was keeping an online addressbook.
I already have an online addressbook it's called LinkedIn.

Upon accepting the invite Plaxo proposed me to import my contacts from both Facebook (which I don't even actively use) and LinkedIn . Now this is the first time an app proposed me to import my contacts from LinkedIn.. an API was announced but I haven't found it yet.

I browsed around on the new Plaxo Beta but honestly I can't say I found anything interresting on it so it'ss yet another passive social network account for me.

However it made me wonder if there are already drupal frameworks out there that let you use FaceBook or LinkedIn data. And I promptly ran into the Facebook one still pretty young. I couln't find a LinkedIn one yet however .. altough that one would interrest me more

Any takers ? :)

Nov 03 2007

Drupal Form API

Being a Drupal newbie with some web experience today I`m struggling with creating a form and using the input from that form to display items on the next page.

Unless I`m mistaken (which given my newbie status is perfectly possible) in a _form_submit you parse your data then return a link to the next page you are displaying.

When inserting and updating a page this works perfeclty because you point back to the page that displays the data you edited . But so far the only thing I found out that takes input from a form and displays it in the next page is by using a multipage form.

This article on Lullabot explains how to create such a page .. but I call that far from simple.
Anyone got a better way to do this .. Al I want to do is have a form where I can select some values, then based on those values get some data from my database and display that. There has to be an easier way than multipage forms. But this Drupal newbie can't find it :(

Next step is to get the above example working ..

Nov 01 2007

Why I stopped creating websites

about a decade ago:

Only the actual quote was.. I want the Green to be Greener

Oct 30 2007

Drupal Community Events in Gent

The folks from Krimson.be are organizing a couple of Drupal workshops in Gent
and even a full development tutorial day.

I already met half of the Krimson crew so I`m looking forward meeting the other half and learning from them ...

Oct 15 2007

Open Source Conferences on this Planet

Maty Asay points us to .. yet another incomplete list of Open Source events on this planet

Now if one could just make either an RSS feed of this or a create a calender out of it so we can integrated it in our favourite calendaring client. Or just create a group on upcoming and keep that group consistently filled up.

They probably should already add Fosdem.org and Linuxtag.org 2007
as the dates for those conferences are already announced.

They should also keep an eye on Sven Guckes page as he has some updates on events.
and als on Martin Schulzes page

Anyone else knows some locations where to find good conferences ?
And yes the more specific conferences such as the ones on MySQL , Drupal or OpenOffice also deserve a place in that list !