Lenz Grimmer's blog

As I mentioned some time ago, Software Freedom Day 08 will take place on Saturday, 20th of September 2008.

Coincidentally, the a large number of Sun/MySQL Engineers and other Sun folks will be in Riga, Latvia for an internal developer meeting around this day. To make use of this opportunity, we plan to give a number of sessions and presentations (in english) about various topics and to contribute to this global celebration of Open Source Software.

We've set up a Team Page on the Software Freedom Day web site for this event - the venue will be the Cafeteria Conference room in the basement of the University of Latvia, Riga, which can accomodate 60-80 people:

Raiņa bulvāris 19
Rīga, LV-1586

There is no entrance fee and you don't have to register - just come by and meet with us! There will be free coffee, refreshments and cake during the breaks.

In the evening, Sun will host a social event (incl. free drinks and food) in the SAS Radisson Daugava hotel, starting at 19:30:

Radisson SAS Daugava Hotel
Kugu 24, Rīga, LV-1048, Latvia
Tel.:+371 6706 1147; Fax: +371 6706 1101

We've set up a tentative schedule (45 minutes per session plus 15 minutes of Q&A), please check the Wiki for eventual last-minute changes!

11:00-12:00: MySQL/Open Source in Latvia (Evijs Taube, Sun Microsystems)
12:00-13:00: Open Source Business Models: how to build a business around free software (Speaker TBD)
13:00-13:30: Lunch Break / Ask the Guru your tech questions
13:30-14:30: MySQL in the Enterprise: Customer references, commercial offerings (Rob Young/Robin Schumacher, Sun Microsystems)
15:00-16:00: MySQL Community Overview: How to engage and contribute (Giuseppe Maxia/Jay Pipes/Lenz Grimmer, Sun Microsystems)
16:15-17:15: MySQL Performance tuning best practices (Jay Pipes, Sun Microsystems)
17:15-18:15: Maintaining your Open source project with Bazaar and Launchpad (Lenz Grimmer/Giuseppe Maxia, Sun Microsystems)
19.30: Social event: Software demonstration, buffet and free beer in the SAS Radisson Daugava hotel

We'd like to thank Leo Trukšāns, Michael Dexter and Georg Richter for their help and support in getting this event arranged and organized! I look forward to being there and help to spread the word about the stuff that keeps me occupied for more than 13 years now

I had a nice chat with Kieran from Acquia at DrupalCon last week - we discussed how people running local Drupal user groups could expand their outreach into other communities, in particular into the MySQL User Groups. Scott Mattoon captured our conversation on video, which is now available on blip.tv:

Click To Play

The gist of what we talked about: if you are organizing a local Drupal User Group Meetup, check out http://mysql.meetup.com to find out if there is a local MySQL user group nearby. Chances are high that there is! And if not, you may find at least people in the area that would be interested in meeting about this subject. We also maintain list of user groups on the MySQL Forge Wiki. Consider extending your invitation for your next meetup to these folks as well! It's very likely that someone would be interested to learn more about Drupal. The same applies to other user groups, e.g. from the PHP community.

 

I personally run a MySQL User Group here in Hamburg, and I usually extend my invitations to a number of channels and mailinglists, including the local PHP, Perl and Linux User Groups. Every once in a while, a new member from these communities shows up.

So this thing works the other way around, too: if you are the organizer of a MySQL Meetup, have you thought about looking at http://groups.drupal.org/ yet? Maybe you will find a Drupal User Group in your very own town that you could invite to learn more about MySQL and exchange contacts? If you are looking for more tips on how to run and expand your User Group, I've created a page with useful hints about this topic on the MySQL Forge Wiki. Your feedback and additions are very welcome!

Last weekend I finally found some time to upload pictures that I had taken during various events that I attended in the past few months. So here are my impressions from the following events:

• PHP Unconference in Hamburg on 2008-04-26
• MySQL Meetup Mashup in Hamburg, 2008-04-07
• MySQL Meetup Mashup in Berlin, 2008-04-08
• MySQL Conference & Expo 2008 in Santa Clara, 2008-04 (these are available from flickr as well)
• CommunityOne in San Francisco, 2008-05-05
• JavaOne in San Francisco, 2008-05
• LinuxTag in Berlin, 2008-05

These are probably the last pictures that I have taken with my trusty old Pentax Optio S4 - I just received my new camera, a Canon PowerShot A720 IS. I have just started to toy around with it, but the first results look promising! The Pentax served me well for several years - I've taken 9745 pictures with it. But it had a few deficiencies, particularly the slow startup and flash recharge time and the bad quality of pictures indoors bothered me for quite a while. But it is very small and handy and the metal housing makes it quite sturdy.

The first picture taken with my new camera: a picture of the old one.

And probably the last picture taken using the old camera: my new Canon.

 

I made it to the US safely, even though I almost missed my connecting flight in Heathrow (even my luggage made it, hooray!). I reached the Hotel just in time to directly head off to the traditional pre-conference party at Mårten's house. However, we just stayed there shortly (barely long enough to say hi to everybody) and then headed to the MySQL pre-conference dinner (organized by Arjen). It was nice meeting such a large number of the key MySQL community people in one place! I was especially surprised about the presence of Jonathan Schwartz and Rich Green - this added a nice touch!

Today I am attending Stewart's tutorial session about MySQL Cluster. So far it has been quite entertaining and informative! We'll continue with hands-on excercises on setting up a cluster configuration on the attendees' laptops after the lunch break.

I have uploaded pictures from yesterday and this morning to my foto set on flickr (which I will also post to the MySQL Conference 08 Flickr group) and will try to continue doing so for the rest of the conference. Enjoy!

A gentle reminder: next week, there will be two more stops of the MySQL Meetup Mashup Tour:

• Monday, April 7th, 19:00: Hamburg, Germany. We will meet in the meeting rooms of the local Sun Microsystems offices ( Nagelsweg 55, 22097 Hamburg). There will be two technical sessions: Giuseppe will talk about the MySQL Sandbox, Kay Koll will give a presentation about how to combine MySQL with OpenOffice.org. He will also describe the new report generator and give an overview over the future of OpenOffice. You can register for this event via meetup.com or Xing.com.
• Tuesday, April 8th, 17:00: Berlin, Germany. This event will take place in the rooms of the Berlin offices of Sun Microsystems (Komturstrasse 18a, 12099 Berlin). This time, Giuseppe will talk about MySQL as an open platform, Kristian Köhntopp will share a few hints he gathered while doing consulting work at customer sites. Please use Xing.com to register for this event.

At both events, colleagues from Sun and MySQL will be present to answer questions and discuss the acquisition of MySQL by Sun and all things Open Source. There will be free drinks and food as well!

We look forward to welcome users from the various related Sun products/projects, e.g. OpenOffice, Java, OpenSolaris, Glassfish or Netbeans. There is so much opportunity for collaboration and exchange of experience - I am very excited to be at both meetings to meet and talk with people from these communities. See you there! 

 

 

As Kaj already pointed out, the Sun/MySQL Meetup Mashup Tour will also make a stop in Munich, Germany this Friday. I will be there as well, we will meet at 14:00 at the Hilton Munich Park Hotel. Kaj and some other Sun people will join us a bit later. If you are in the area, make sure to stop by!

By the way, the Meetup Mashup Tour will make at least one more stop in Germany - I am organizing an event in Hamburg, Germany which will take place on Monday, April 7th (19:00). This was initially planned as another regular MySQL Meetup, but I offered to expand the scope a bit. We will now meet at the Sun offices, Sun will sponsor some food and drinks! In addition to the usual MySQL Meetup crowd, we expect participation from various Sun communities (e.g. OpenOffice/StarOffice, Java or OpenSolaris). As usual, there will be a MySQL tech talk (this time held by Giuseppe).

I look forward to this event - it will be exciting to mingle with the people from these other communities and to exchange experiences and make new contacts. If you live somewhere around the Hambur area and would like to participate, please RSVP via Meetup.com or Xing.com soon!

 

Back when I still worked at SuSE, I was in charge of maintaining a number or packages of the distribution (actually, you should still be able to find traces of my work in the RPM changelogs). Nowadays, I maintain a number of packages for openSUSE and other distributions on the openSUSE Build Service, which is just brilliant for this purpose.

If you happen to live in northern Germany and are interested to learn more about the RPM package manager and how to build packages, consider coming to the TU Harburg this coming Thursday (March 13th). At 19:00, I will give a presentation about this topic in building, D, room D1023 (in cooperation with the Hamburg branch of the German Unix User Group). More information (in German) can be obtained from here.

See you there!

 

 

I have not been at CeBit for quite a while, but this year I will be there as a regular visitor this Thursday (6th of March). If you would like to meet with me, please send me an email or ping me via IM/Skype! I look forward to walking around the hallways, visiting my new employer's booth and finding out what other Open Source presences and activities there will be.

 

Just a short reminder: the Hamburg MySQL Meetup Group will meet next week, on Monday the 4th of February! As usual, there will be a MySQL-related talk - this time I will use this opportunity to practice my talk about "Performing MySQL Backups using LVM Snapshots" that I will present at the upcoming MySQL Conference & Expo 2008 in Santa Clara, CA. In addition to that I assume that there will be some questions about the acquisition of MySQL AB by Sun - I will try to answer these as good as I can. Looking forward to meet you next week. Please make sure to RSVP either via Meetup.com or Xing.com, so I can keep track of the number of attendees! Thanks!

 

 

I must be awake for about 24 hours now, things are getting a bit blurry. But I have arrived at our MySQL Staff Meeting here in Orlando safely! My flight with Northwest airlines from Frankfurt via Detroit was uneventful - the plane was pretty empty so I was happy to have two seats for myself! The board entertainment program was neat, I really prefer video on demand over scheduled movie broadcasts (I watched "The Nanny Diaries", which was quite funny, and "The Fantastic Four", which had some nice CG effects).

While standing in the immigration line in Detroit somebody in the line next to us waved to me - it was Tobias "Flupps" Asplund, one of our trainers! Quite a funny coincidence, he just had arrived via Amsterdam. We actually were on the same flight from Detroit to Orlando afterwards. After checking into the Hotel I finally found my way to the evening reception - it was nice and overwhelming at the same time to see so many MySQLers in one place! I enjoyed talking and meeting old friends as well as getting to know new colleagues that joined the company since the last time we met. The following days will be exciting, interesting and exhausting... But for now I am off to bed.

 

While some colleagues have already arrived in Orlando to meet fellow MySQLers, my plane from FRA to MCO (via DTW) does not leave until 10:20am tomorrow. Currently I am staying at my parents' place in Heidelberg, from which I will be picked up by an airport shuttle service early tomorrow morning (5:40am, ugh!).

I am looking forward to meeting with the other members of my team as well as old and new colleagues from the different departments. There seems to be some kind of outdoor team building event taking place on Wednesday afternoon - we have been split up into mixed groups and were asked to bring comfortable clothes and a light sweater or jacket. I hope I am not too jetlagged by the end of the day...

This will be my fourth MySQL staff meeting - when I joined the company in 2002, I was lucky to attend the third staff meeting in St. Petersburg, Russia right during the first week when I started my new job. Back then, we were around 40 people in total - the entire company still fitted in one coach that brought us from Helsinki, Finland to St. Petersburg. It's amazing to think that this staff meeting will host the tenfold amount of people!

 

There is a lot of exciting stuff happening inside of MySQL AB. But due to the distributed nature of our company it's hardly possible to get a good overview about what the various teams of our development department are currently working on and what they have achieved since the last time we met.

So one cool new idea for our currently ongoing MySQL Developer Meeting in Heidelberg was to let developers show off their work to each other. They were encouraged to prepare demos, either in the form of slide shows or by running live demonstrations from their laptops. Last Thursday and Saturday we allocated time for these team exhibitions and the exhibitors set up tables in the meeting rooms for others to sit next to them, see the new and cool stuff and chat about it. The non-exhibiting attendees received a sheet of paper where they could collect signatures for each demo point they visited, the one that managed to see the most demos was eligible for winning a price. I managed to visit ~8 of them on Thursday - there was way more stuff to look at than what one could actually get done in the given time frame. Therefore we decided to repeat some of Thursday's exhibitions and included some new ones on Saturday.

Here is a recap of the exhibitions I saw on Thursday:

• Alexey 'Holyfoot' Botchkov demoed the new and improved GIS (geospacial information) functionality that I already blogged about some time ago. It provides a number of new GIS functions and most of the already existing ones no longer use MBRs. Holyfoot actually prepared a visual demo application that displayed a map of the earth by getting the polygons to draw out of the database. It was then highlighting the current country under the mouse cursor, displaying some additional information about it. Moving the mouse across country borders immediately switched the highlighting to the respective state. When using the old, MBR-based functions this would only happen when you crossed the borders of the bounding rectangle.
• My fellow colleague Giuseppe Maxia performed some MySQL Proxy Magic, misusing the MySQL Proxy for some fun stuff and also demonstrating some useful use cases (e.g. crosstabs). See his blog entry for some examples of what he was showing.
• Jay Pipes demoed his work on MySQL Forge 2.0, now with more Ajax magic, rating and commenting on projects and snippets as well as the obligatory rounded corners! There's still some work to be done, but I look forward to seeing it go live soon.
• Monty Tailor explained his work on NDB/Connectors, which provides bindings to many programming languages like Ruby, Perl, Lua, PHP and others. They make it possible to connect to a MySQL Cluster without having to go through the MySQL API, if you don't need to use SQL and just want to use MySQL Cluster as a highly available datastore (similar to memcached). It was interesting to compare the various test scripts for each language with each other - the Perl version looked quite ugly in comparison to the Ruby code...
• An alpha version of the MySQL Workbench was demoed by Johannes Taxacher from the GUI team. He demonstrated how one can visually create tables and set up the relations between them. The GUI is quite nice, but they support Windows only for now - Mac OS X and Linux are also planned, however.
• Kent Boortz from the build team showed off his work on creating a self-contained ODBC build environment. I was quite impressed by the complexity and steps involved in creating the binary packages of the ODBC driver we provide. As we support quite a number of platforms, Kent had to come up with all kinds of interesting tweaks for exotic architectures and strange compilers.
• Jess Balint from the Connectors team demoed the ODBC 5.1 driver by connecting to a MySQL Server using MS Access or with a MS Visual C++ application. It was nice to observe the functional UTF-8 support.
• Paul DuBois, long time member of our documentation team explained the build system they created in order to cope with the massive amount of build targets that are being created from the DocBook sources of the reference manual. In addition to various formats of the manual itself (e.g. PDF, HTML, Windows Help), they also build the manual pages that are included in our *nix distributions as well as some README files and the Changelogs. It is written in Ruby and is capable of distributing the build jobs to several machines.

That's all I was able to see on Thursday. I just wish I had some more time to see all of the other demos. On Saturday I saw the following demos:

• Marc Alff was demoing LTP-GCOV, a tool that visualizes the output of gcov as HTML pages and allows one to find out which code has been covered during the test suite run. It would be great if we could combine it with our internal pushbuild system, which automatically rebuilds the MySQL Server and runs the test suite on a number of platforms for every ChangeSet that is being pushed into a source tree. We already perform gcov build runs to make sure that new code is properly covered by the tests, but this tool would be a very helpful addition, allowing us to find code with low coverage much easier.
• Kristian Nielsen showed an early implementation of a multi-threaded ndbd, the process that runs on a MySQL Cluster data node. This should boost performance on multi-core systems (the current implementation is single-threaded). However, it's still in an early prototype phase, but looks interesting!
• Chad Miller demonstrated an alternative revision control system: bzr. Similar to BitKeeper, it is a fully distributed system which does not require a central server. Creating a local branch of an existing MySQL code tree was quite easy and it seems to be very similar in using it. What impressed me in particular was its capability of connecting to remote SVN repositories - it is actually possible to use bzr locally to work against a remote Subversion server! This should give us a good opportunity to start testing it against our existing SVN trees and gather some more practical experience with it.

All in all I was very impressed and excited to learn about all the cool things that are going on inside of the development team. Even though there is always a lot of work to be done and they're busy getting the MySQL 5.1 release out the door, they still find time to experiment and come up with great ideas and improvements in other areas as well. I got the impression that everybody really enjoyed being able to show off his work and also receiving good feedback from the others that were passing by. I hope we will repeat these team exhibitions at our next meeting!

Hmm, long time no post! But I have the perfect excuse: I've actually been on vacation the past two weeks... Now I am back at work and busy trying to make a dent in the mail pile that has accumulated while I was gone. In addition to that, I am assisting with the organization of our MySQL Developer Meeting in Heidelberg, which will take place in September. See Kaj's blog post for more details about it. I am in charge of our community guests and really look forward to meeting most of our internal developers as well as community guests there! This is going to be a fun event.

In addition to that, I am applying the final touches to my upcoming presentation about our ongoing community activities: "Opening the doors (and windows) of the Cathedral", which will be held at the FrOSCon in St. Augustin, Germany this weekend. My colleague Giuseppe will also give a talk about "Logging and monitoring a database server" and last but not least Susanne will give her famous "PostgreSQL versus MySQL - Venus versus Mars" talk. I really enjoyed last year's FrOSCon, it was a very relaxed and well organized event, with many great sessions. This years program looks promising, too - so if you happen to be in the area, make sure to stop by!

Oh, and if you happen to be around the New York City area today and tomorrow, consider checking by the MySQL Camp II, which will start today! There may still be some free seats available, make sure to check the site for registration instructions.

Just a quick reminder for those of you located near Hamburg, Germany: on Monday, June 4th at 19:00 there will be our 7th MySQL Meetup. As usual, we will gather at the Chinese Restaurant "Ni Hao". This time, Sönke Ruempler will give a talk about the PHP-ORM-Framework "Propel". If you'd like to join, don't hesitate to RSVP via meetup.com or Xing.com right away! Thanks - see you there!

Even though MySQL is used to power a lot of web sites and applications that handle large binary objects (BLOBs) like images, videos or audio files, these objects are usually not stored in MySQL tables directly today. The reason for that is that the MySQL Client/Server protocol applies certain restrictions on the size of objects that can be returned and that the overall performance is not acceptable, as the current MySQL storage engines have not really been optimized to properly handle large numbers of BLOBs. To work around these limitations, these projects usually just store a reference to the object (e.g. a path name in a regular file system). This approach works around the limitations applied by the MySQL Server, but results in a disconnection and potential source of inconsistency between the database and the file system content. There was an interesting discussion about that topic on Sheeri's blog some time ago, with an excellent reply by Kristian, if you are curious to read more about this.

Thanks to the pluggable storage engine architecture of MySQL 5.1, we now see many independent storage engines emerging, one of them being PBXT by Paul McCullagh from SNAP Innovation. One of its strengths is going to be the handling of large binary objects in a performant way, so data objects can be stored in the database along with the other information related to it. To compliment this feature and to work around the limitations applied by the Client/Server Protocol, SNAP has now launched the Scalable BLOB Streaming Architecture for MySQL project, which intends to develop an architecture that accompanies the MySQL Client/Server protocol by providing an API to access and stream BLOBs stored in a MySQL database. See their press release (PDF) for the official announcement..

Paul will hold a BOF about this at the MySQL Conference and Expo this Tuesday at 19:30 in room San Thomas. So if storing and streaming large binary objects out of a MySQL Database is an essential requirement for your project, make sure to attend this session and provide Paul with your feedback and ideas!