Preparing for the future: MySQL conference 2009

March 25th, 2009

Here is a list of talks at the MySQL user conference that focus on new and upcoming features in MySQL. I will try to attend most of these myself, although I have some certifications to acquire and other topics of interest. It’s almost like I would like to split myself in multiple threads so I could see it all :)

Tuesday

Wednesday

Attending these presentations should give you a good feel of what is up and coming in the MySQL world.

MySQL Conference & Expo 2009

Getting excited for the MySQL Conference 2009

February 22nd, 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 :) Read the rest of this entry »

Using the google graph API with MySQL stored functions

February 21st, 2009

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.

Read the rest of this entry »

Video interview with Jack Adams at #fosdem

February 11th, 2009

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

February 8th, 2009

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 opportunity presents itself we will.

==

Monty resigned, planned to be at FOSDEM but had other things to do
Marten Mikos also resigned this week, makes very clear these two are not related

Karen Tegan Padir is new MySQL Boss, worked for Red HAt before. Boss since friday 4pm eu time, keys to teh kingdom were handed over :)

What will happen now?
==

expects MySQL to be more integrate into sun “but not to lose it’s soul”

Less swedish drinking songs :)

He sometimes still talsk in third person, not on purpose

All of his interactions with senior sun people has been very good, not interfering too much

Services and sales distinction => internally important

===

Roadmap
==

Community implications => no too much detail since he doesn’t know them
doesn’t know any other company that takes community that serious -> not bragging
, they are just good

===

MySQL Strengths

refocusing core goals => stability performace ease of use
===

Mysql weaknesses

-Feature set used to be a big weakness, not so much anymore
-slow release cycles => thinks 3 years from 5.0 - 5.1 is too long. must improve
-contribution process=> has many reasons, thinks signing a paper before even considering is a bug hurdle and seems unfriendly. It is inherent because of dual licensing. need for discussing attitude and processes inside sun/mysql.

===

MySQL opportunities

Enterprise is not about binary difference in server daemon.
when you pay -> you get additional software. good way for community and business to live side by side

Cluster -> has a lot of value for HA and is FOS

Support team -> support is great, very big plus for mysql

Volume marketing -> not so important fro FOS, improtant for getting money. bridge between the 10 million users and 100 check signers. White papers and webinars. Nothing wrong with keepin track by signing up for white paper. downing more than 2 white papers is red flag for being customer.

=====

MySQL Threats

Founder headaches, founders gone -> sees monty as more of an opporutnity in swot context

“it’s just a toy”-thought is still remaining, but it is diminishing

====

Start of questions and concerns, sun Lenz Grimmer taking notes,

explains: not what we say will happen, but what we say is being taken seriously

==

What are we not so good at? tell us

1) half backed features

things that have been known for long time, but not fixed. SP exception handling needs fixinf, will only be worked on in 6.0

Kaj -translates to backporting or currentporting of fixes
Giuseppe - not that tehy don’t know, they do. Started to complain when he was still outside. when he was in mysql he could start change. marten assembled Team from community engineering and support. to gather all of the half backed features and prioritise. Results in the next weeks.

2) interoprability with other products

Kaj - migrate to and from is easy. interoperability with other products is on per-case basis

3) after acquisition look at branding and designs. big custs not interested at open source, but low TCO.

Kaj - might brand it more as online database instead of open source database. nothing to do with opensource, jut marketing

4) storage engines and mysql have problem when things are true for storage engine A but not for B. Needs more clear in manuals and articles

Kaj - refrases
example; show status in myisam and innodb different performance

5) Scale up is also importnat, not only scale out

====

Help with roadmap, what should happen now?

InnoDb is not active so much, this should change
Deeper integration for external storage engine needed on business and technical aspects
Faster updates, more frequent smaller updates makes upgrading easier
Cluster needs to be easier and pricing model should be changed

Contribution process needs improvement
External storage engines need more support, like federated engines

various questions with hand raising => stability, ease of use and performance are still reasonable

shorter release cycles again. attendee: implementing something yourself is useless maybe when you need to take it out or change later

===

End talk, summary, more feedback welcome
Slides:

Live from FOSDEM 2009

February 8th, 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

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

Interesting visitors pass by here from time to time as our stand seems to be the meeting point for MySQL’ers old and new. We are here with Lenz Grimmer, and yesterday and today among the people passing through were Kaj Arno, David Axmark and Giuseppe Maxia. Many more are coming by and are around all day. Interesting times!

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

February 6th, 2009

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.

Read the rest of this entry »

Testing environment: Installing CentOS 5.2 on VirtualBox

February 5th, 2009

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! Read the rest of this entry »

What to do when everything needs attention

January 26th, 2009

The problem

Every once in a while it happens. A customer comes to us for a review of their site or application. We have our initial interview and start picking up the signs: they are developing their product alone. They are self-taught, self made men/women. They word certain concepts in slightly strange way. Then, we log in to the server to take a first look, and there it is: no primary keys. no indexes. Everything is a VARCHAR(100), sometimes even TEXT or LONGTEXT. There is no my.cnf, or it is only 5 lines long. No updates have been run on the server since it was installed 2 years ago. The code is spaghetti and has no comments in it. Read the rest of this entry »

Call for ideas for the MySQL project stand at FOSDEM 2009

January 11th, 2009

A few months ago I decided to attend FOSDEM 2009, a free open source conference in Brussels, just 150 kilometers from my home in Rotterdam.
A few weeks later I bumped into a call for participation on Lenz Grimmer’s blog. I signed up, thinking I could spare a few hours and it would be fun to tell other people about this product I have come to care so much about.

Read the rest of this entry »