I have accepted invitation from David Van Couvering to attend his session and present the PHP features in NetBeans. The session will take place this Thursday, 23rd October and will start at 9:00 Pacific Time (18:00 CET, 17:00 BST). We will use DimDim presentation system so everybody can attend. But  the session has limited capacity of attendees. More info about the session you can find here.

If you are interested, attend the session.

I get a few questions how to set DiskPageBufferMemory.

Before discussing that let's recap a few things:

• Non-indexed attributes (or explicitly defined in CREATE TABLE..) are stored on disk in table spaces.
  
• Indexed attributes are stored in DataMemory
• The hash of the Primary Key is stored in the IndexMemory

Determining how much IndexMemory/DataMemory/Tablespaces that are needed, you can use the dimensioning toolkit.

Now you can setup Undobuffers etc according to my post on disk data a while back.

But what about the DiskPageBufferMemory?! If you have used …

I just came upon a pretty good Hadoop introduction paper posted on Sunâ€s wiki. Apache Hadoop is a free Java software framework that supports data intensive distributed applications. It enables applications to work with thousands of nodes and petabytes of data. Hadoop was inspired by Google's MapReduce and Google File System (GFS) (wikipedia). I wouldnâ€t call it an alternative to mysql – theyâ€re in completely different weight categories. I like …

I think Giuseppe (the man with too many blogs!) was a little too optimistic in his last post… the MySQL Conference Call for Participation has received an amazing amount of proposals, but not enough by our standards.

I personally believe there should be a 1:3 accepted-rejected ratio. Currently, its not there yet. Why do I like such high ratios? It means that there are actually so many good talks, and we (the voting committee) pick the best of the best, to give attendees the most mileage for their time and money. Or am I too harsh?

Anyway, the word on the street is that we will extend the Call for Participation, mostly because it is the right thing to do, and lots of people expect it. Expect an official announcement to go out soon about this. But …

I've ported my AWS S3 storage engine to Drizzle.

The source is at bzr branch lp:~fallenpegasus/drizzle/awss3. Pull it and build it like you would the main Drizzle. The engine is built-in, no need to plugin load it.

Example use:

   CREATE TABLE colors
     (nam VARCHAR(32) NOT NULL PRIMARY KEY, val BLOB)
        ENGINE='AWSS3'
        CONNECTION='awss3 bucket_name aws_id aws_secret';
   SELECT val FROM colors WHERE nam='BlueViolet';

I will try to keep it tracking the main Drizzle dev tree.

Guy Kawasaki's latest book is a blueprint for tech entrepreneurs and intrapreneurs alike READ MORE

Microsoft wisely chooses to sidestep the "either/or" discussion around open source READ MORE

A few weeks ago I got a copy of "High Performance MySQL" (from now on referred to as HPM) and just the other day they also send me "Refactoring SQL Applications" (aka "RSA"). Actually I had a copy of HPM at the office already, but its nice to have my own, seeing that its already severely beating up from having to live in my backup. Good to have a neat copy for the company book shelve. I have gotten to chapter 4. So far there has not been all that much earth shattering, but considering the hours I spend reading posts on planetmysql, I guess its not a huge surprise. But at the same time there is also nothing I feel is missing, so in the sense this book fulfills my expectations 100%: its a well written summary of advanced techniques that people have found in the trenches. And yes of course I did learn a few things still.

For example I was not entirely up to snuff with MyISAM's index prefix compression and recent advances in index merging. In …

Good news Kettle fans!

Our community is bound to become a bit larger as a whole group of students (38) at the Katholieke Hogeschool Mechelen (Batchelor level) will receive a one day workshop with Pentaho Data Integration (Kettle).  This workshop will take place in early November, most likely the 4th.

It’s interesting to see that during that day we’ll be able to go through most of the work involved in reading and staging the data, data cleansing and a few slowly changing dimensions with a fact table.  On top of that we’ll explain how to use Pentaho Data Integration in that setting.  When time permits we’ll show how to set up a metadata model on top of that data to create reports on it.  On top of that the students will get an idea about what exactly open source is all about.

Obviously, the …

krow asked for two more plugin types for Drizzle: Scheduler (which allocates and controls threads, and assigns them to sessions), and (drumroll), Parser.

People have been asking for plugin parsing for MySQL for years.

Drizzle is about to get it.

:)