This article provides a comparison between the MyISAM and InnoDB storage engines for MySQL. InnoDB is commonly considered to perform worse than MyISAM, but this article aims to dispel this myth by describing the differences between these engines and what makes InnoDB a good fit for many database needs.

In addition, a look at when it is better to use MyISAM and a case study of the drupal.org site provide insight for determining which engine is best for a given situation.

read more

It seems like Jeremy wants to be MySQL community president this week :)

The announcement of a MySQL yum repository is a good one but it's slightly confusing me .. didn't Jeremy already have this with
Dorsal, where there are also 5.1 builds. So what's the difference between Dorsal and the new yum repo anyway .

But he asks for Adittionals packages , well 5.1 to start with, apart from that the CentosPlus repo also has builds for Cluster , having a uniform place go get those to would be good.

And what about builds for CGE ?
Oh and …

For a company that wants to become the RedHat of Drupal, Kieran is pointing a lot to RedHat's competition :)

But indeed the Brainstorm idea is a good one... if Sun wants to keep up the "big user community, no contributor community" model for it's products this is the least they can do.

Kieran also calls for more crossposting between the mysql and drupal planets :)

It is not always easy to scale Drupal -- not because Drupal sucks, but simply because scaling the LAMP stack (including Drupal) takes no small amount of skill. You need to buy the right hardware, install load balancers, setup MySQL servers in master-slave mode, setup static file servers, setup web servers, get PHP working with an opcode cacher, tie in a distributed memory object caching system like memcached, integrate with a content delivery network, watch security advisories for every component in your system and configure and tune the hell out of everything.

…

I'd call this the 3rd strike and everybody knows what happens next

Marc Fleury has some good answers to the most clueless industry reporter around, starting with:
Spring is touting itself as a JBoss replacement. Smart PR, but false. Spring is a development framework comprising wrappers and dependency injection on top of Hibernate and Tomcat runtimes, both developed, and monetized by JBoss.

You can drop some balls, no one can keep track of what's going on in Open Source land, it's difficult enough to track what's going on in MySQL, Drupal, Virtualization and Distribution land but if you realize you don't have the whole picture (like not …

While I invited Kris Buytaert to present at the Drupal developer room at FOSDEM, I couldn't make it to his presentation as it was scheduled for the last presentation of the day. Oops! Fortunately, Luc Van Braekel recorded almost all Drupal presentations at FOSDEM so I'm sharing the video of Kris's presentation to make up for it. It's is well worth a look, and no, we are not family.

While posting about my talk on MySQL Cluster and Drupal I realized something very important about Open Source and how it differs from proprietary software.

Looking at a traditional software and infrastructure consultancy shop you will see that they carry a broad range of products which they care about and which they are actively offerering to customers. For this products they have formal arrangements with suppliers that will both give them licenses, support but also incentives to sell those licenses.

So when a sales guy or a consultant arrives at a customer they are already biased to plug a certain product, and they will try to convince the customer that the product they are selling is the right fit. Even tough when it's a total Misfit.

With the Open Source consultant he won't be plugging a product, he will be listening to his customer and will use the …

So yesterday I presented my findings on MySQL Cluster (ndbd) and Drupal.

I`ll be writing them out in a more detailed document some day soon ..
But the short summary is that MySQL-Cluster and Drupal are not a good fit.
One has to realise that MySQL cluster isn't always a good solution and that every problem has it's own solutions. The nature of the tables of Drupal means that you need enormous amounts of memory.

I was a bit afraid that the present MySQL crowd woudln't really appreciate my findings, however I was wrong I got some good feedback from the present MySQL crowd , they too seem to want to promote the idea that Cluster is not a fit for every problem, and they were great help in answering some of the audience questions.

The presentation is here …

Fosdem is over .. and it was ... overcrowded :(

Honestly trying to squeeze into an overcrowded bar, then on saturday overcrowded rooms, or even not being able to enter that room (Mozilla and Embedded) , Fosdem is starting to become the victim of it's own success.

Some people are suggesting Fosdem to move to the Arenberg campus in "Brussels-East" dunnow if Leuven can actually host enough beds for Fosdem :)
However the Beer event problem would be solved but Philip will have to make arrangements with 'The greatest bar of Western Europe"

The talk about Xen on ARM was interresting however the grande finale missed, the MiniOS just didn't boot :( Kettle was interresting …

Luc just pointed me with to his recording of my talk about Drupal and MySQL HA yesterday at the Drupal Room at Fosdem

He also uploaded some other video's from the Drupal room.

More about my Fosdem 2008 experience later :)