* You are viewing the archive for February, 2009

Getting excited for the MySQL Conference 2009

I finally received confirmation that I’m attending the MySQL Conference 2009, yay! I didn’t really dive deep into all the conference has to offer just because I didn’t want to get too excited and then not be able to go. Now that I do know I’m going, I’m full on with excitement and thought I would share that excitement here :) Continue Reading

Using the google graph API with MySQL stored functions

After reading Alex’s blog post on generating graphs using google’s graph API I decided to do something similar for MySQL. I created a stored function that takes a height, width and a graph type from the list of available graph types in the graph API. The function returns a url to a google graph that you can then use as you like. The possibilities are endless.

Besides the nice google graph API, the function shows how to use a cursor in combination with a handler to loop through it and retrieve values from it.

In the example I use a query that determines the relative size of each database on a MySQL server, but you can change that to whatever you like.

Follow the jump for the code.

Continue Reading

Video interview with Jack Adams at #fosdem

This was an interview Jack Adams did with me at the MySQL/OpenSolaris booth at FOSDEM last weekend.

Jack adams is an OpenSolaris mascotte, look around on YouTube for more funny interviews with him.

Semi-live blog from Q&A with Sun/MySQL VP of community

Here’s  my sort of transcript of the most important things that were said during the Q&A with Kaj Arno at FOSDEM09. If you have any questions (or corrections if you were there and think i misinterpreted) please use the comments.

It is virtually unedited, so it’s rough but I don’t have the time right now to write it all out..

==

Kaj Arno – Recent developments / roadmap of MySQL

Kaj shows who he is -> VP MySQL of community relations

Non-paying customers = community

when want to pay or can pay => customer marketing steps in

don’t want to turn whole community into customer, but when … Continue Reading

Live from FOSDEM 2009

I am now at FOSDEM, volunteering at the MySQL project stand and attending sessions in between.
Today is the most important day for MySQL. At 13:15 CET there will be a talk by Kaj Arno covering recent events at Sun/MySQL.

I am here with Santo Leto from HoneySoftware at the moment and he is going to attempt live blogging that session. Internet has not been the best here so far, so keep your fingers crossed!

Left-to-right: Me, Santo Leto for MySQL and Kristian Vlaardingerbroek for the OpenSolaris project

Continue Reading

MySQL ‘godfather’ Monty leaves MySQL: what’s next?

For those of you who haven’t heard, first go read this: Monty Leaves MySQL

Now, let’s play for a bit ;)

I think this is a very interesting turn of events that took surprisingly long to happen.

Continue Reading

Testing environment: Installing CentOS 5.2 on VirtualBox

In the previous post of this series we installed and set up VirtualBox. We prepared it for a default install of CentOS 5.2. This time, we cover the installation of the OS itself. Changes since the last article are an upgrade from v2.0 to v2.1, and the fact that I’m running VirtualBox on my Asus eee under eeebuntu now. The great thing is that VirtualBox is cross-platform, so it runs perfectly fine and acts almost exactly the same. Now, let’s get started! Continue Reading