As many of us know, the 5th annual MySQL Conference and Expo is happening April 20-23rd, 2009 in Santa Clara, California. The theme is Innovation Everywhere, and this year the conference organizers have taken an innovative page from OSCon and decided to host a free “camp” during the conference.

As far as I know, MySQL Camp is the only free, non-commercial programming occurring. We already have a fantastic lineup of speakers and last week I was surprised with another bounty — MySQL Camp has been extended to Thursday!

While you are making your travel and lodging arrangements, remember that on Sunday April 19th on the mezzanine of the conference hotel there will be a Games Day from 12 noon - 12 midnight. Stop by, play …

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The 380.6 Mb .mov movie (1 hr 16 min) can be played directly in your browser at http://technocation.org/node/671/play or downloaded at http://technocation.org/node/671/download.

Notes:
The partitioning part of the MySQL Manual is at: …

Hello and welcome to my Log Buffer, the weekly review of database blogs. My name is Keith Murphy and I am the editor of MySQL Magazine, a free digital magazine with information for MySQL administrators and developers, released quarterly.  I am also a MySQL database administrator at Pythian.

I am losing count of how many of these Log Buffers I have done. If I recall correctly, this is number three. But then again, it could be number four. You know what they say though—the more the merrier!

This week’s Buffer features a great allegory about a database, some tips, feature requests, and breaking news. It seems that this week, people shared information that was relevant across database servers, so I recommend that no …

The Pythian Group added another feather to its cap today. Our Nicklas Westerlund passed his MySQL Cluster DBA Certification exam, making him part of an elite group of 57 MySQL Cluster Certified DBAs worldwide, and now two here at Pythian, the other being Augusto Bott. We have a wealth of hands-on experience setting up and maintaining the MySQL Cluster. Nick’s and Augusto’s certified creds make them our go-to guys for MySQL Clustering.

Congratulations, Nick!

This post is more of a personal note than most on the Pythian blog, but over the holidays, I couldn’t help thinking about my turbulent last year.

First, MySQL

In 2008, I worked at three different companies. It was about a year ago (January 15th will be a year) I was at MySQL AB’s first company-wide meeting in a few years with more than 400 of my colleagues, when all of a sudden we get the announcement: “Sun acquired MySQL for 1 billion dollars”. Many thought it was a joke, just in time to watch Jonathan Schwartz come up live on video to greet us. Talk about an intense way of starting a year! For some reason, nobody thought that toasting with a shot of vodka before 9:00am was the oddest thing to happen that morning.

Working for MySQL was, most likely, the wildest ride I will ever have. True Open Source spirit (no matter what the rest of the world says), start-up mentality, and growth equal to one order of magnitude …

Hello everyone! Before I move to the seasonal greetings, let me share some exciting news.

2008 was quite remarkable for Pythian and, in addition to our ongoing success and growth, we established Pythian Europe back in May. To top it off, we have now laid the foundation for Pythian East Asia Pacific.

Pythian Australia Pty Ltd was incorporated and started official operations in Australia this month, taking over service delivery for the region. We have a few local clients and already signed some new ones, so this is quite an exciting beginning.

Today, there are three of us working in Sydney office:

A little bit of history. Pythian has operated in Australia for almost three years by now (well, longer than …

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

http://technocation.org/files/doc/stophatingmysql.pdf

View the video online at http://technocation.org/node/646/play or download the 202.5 MB Flash video file (.flv) directly at http://technocation.org/node/646/download.

Here are some notes and links I referred to:

read more

Sorry for the outage, everyone. We’re looking into the causes of the downtime (and sponging the sweat off our keyboards), but for now we’re happy just to be back. Stay tuned for a real blog article soon.

Notice to readers:
This is an excerpt of my liveblogging of the Keynote where the Exadata Storage Server was announced.

It is a mix of my comments in real time, and my quotes from things Larry Ellison said that I felt were worthy of mention.

You may be interested in reading more about Oracle’s Exadata platform. I would suggest taking a gander at Oracle’s product page and also reading up on Christo Kutrovsky’s Analysis of the Exadata and Oracle Database Machine announcement from a different point of view.

You may also be interested in the complete liveblog transcript of …

As part of a project of Technocation, Inc I took a whole bunch of videos at OSCon 2008. The conference was about a month ago, and about 2 weeks ago I’d finished processing and uploading all the videos, but it was only today where I had the 5-6 hours I needed to finish posting all the video, and making this matrix of video.

The video may not be the quality that the O’Reilly folks took and put up on blip tv’s OSCon site, but all the videos here are freely downloadable or playable in your browser.

(more…)