We timed our Use Case Competition to coincide with summer holidays, and are now prolonging the duration of the Use Case Competition with one month, until 30 September 2008.

To recap, here’s the original posting (with an updated deadline):

With 5.1 having officially been in Release Candidate status since September 2007 and soon approaching GA status, the MySQL Community Team launches a competition for the users of new features of MySQL 5.1:

Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 30 September 2008 and have a chance of winning one of our prizes:

• 1st-3rd prize: A MySQL Conference & Expo 2009 Pass, …

This book is just "too" popular ;-) It took a bit of jiggling with Amazon's stock levels (they say in-stock but if you order some quantity it'll delay the shipping, then you can tweak down and find out ;-), as well as a deal with the friendly people at Australian book distributor Woodslane, but Open Query can now offer anyone who participates (either an open course or custom/in-house training) in one or more training days between now and the end of this year a copy of High Performance MySQL (2nd edition).

You can also see this as an offer that benefits you directly rather …

September 16, 10:00 am PST, 1:00 pm EST, 18:00 GMT

I'm proud to inform you that I will be hosting a MySQL Workbench Webinar, September 16. You can find the announcement right here.

I have spent quite a deal of time testing MySQL Workbench. Thanks to the hard work of the MySQL Developer Tools Team, the tool just becomes better and better each new build. Personally, I think it is high time to present its features and benefits in a web seminar, and when Giuseppe asked me to do it, I was more than happy to oblige.

I'll shortly post an outline of some of the key features I will be presenting. Most likely, I'll address a number of issues I've seen recurring on the …

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…)

Recently I added the first code to support multiple MySQL backends in HSCALE (see svn.hscale.org). As a “side note” I have to thank Giuseppe Maxia for MySQL Sandbox which made multi server testing a bliss!

While coding this I started to feel that writing HSCALE on top of MySQL Proxy is no more as easy and clean as it started out to be. And finally I reached the point where I have to say:

HSCALE (and maybe other advanced multi-server applications) and (current) MySQL Proxy don’t fit very well.

Before I go into details please let me make clear that this is mostly due to the specific nature of MySQL Proxy being a connection and protocol based proxy. MySQL Proxy is great and there are a lot of cool applications that fit perfectly with it.

Aside from some other minor glitches (like …

I have not said much about Drizzle here; that is because there is not much to say. It is premature, really, to say anything about it at this point. Some have said they will support Drizzle; as Pythian supports several database systems, it is very likely that we will support Drizzle as well. Particularly since there is in-house Drizzle expertise already. But I digress; my point is that it is premature to really say much about Drizzle.

My involvement in Drizzle goes back to around the end of April/beginning of May 2008. Given my early involvement, (more…)

My friend today asked me how to convert all spaces in filenames under a specified directory to underscores. Also, at the same time lowercase all of the filenames. Here is a quick script to do what is needed. Let us start with creating some test data in a temp directory:

mkdir temp
cd temp
touch Foo FooO "Foo Bar" "FOO BAaR"
\ls | while read -r FILENAME
do
mv -v "$FILENAME" `echo $FILENAME| tr ' ' '_'| tr '[A-Z]' '[a-z]'`
done

Note:  I intentionally have slash in front of ls (\ls).  \ls means that we want to make sure there is no ls alias overwriting our command. This is needed if your system has alias setup to display ls in a different way instead of default listing.  mv -v shows us the filenames being renamed as your script goes through the whole dir.  Your output should be like:

`Foo' -> `foo'
`FOO BAaR' -> …

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there’s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read …

"The State of" Lightning talks, moderated by Josh Berkus, is always a great highlight.
OSCon 2008's speakers and projects included:

• Alan Kasindorf: Memcached
  
• Glynn Foster: OpenSolaris
  
• OSI: Danese Cooper
  
• MySQL: Monty Widenius
  
• PostgreSQL: Bruce Momjian
  
• GNOME: Dave Neary
  
• Gentoo: Donnie Berkholz
  
• OpenOffice.org: Louis Suarez-Potts
  
• Jabber: Peter Saint-Andre
  
• Mozdev: Brian King
  
• OpenID: Scott Kveton
  
• Open Scrum: James Dixon
  
• Talking Book Project: Cliff Schmidt
  

read more

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there?s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read …