Lenz Grimmer's blog

While visiting the CeBit Trade Show in Hannover on 2008-03-06, Kaj and myself stopped by the booth of our new employer for meetings with some of our new colleagues. During our stay, they performed a short video interview with us (in German), to get our take on the MySQL acquisition and what this means to us and our users - it is now available from the Sun@CeBit2008 pages. Enjoy!

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!

Last week at CeBit I once again had a conversation with an application developer that was not aware that it's possible to embed the MySQL Server inside an application instead of running it as a separate process. I experienced something similar at FOSDEM recently, while talking with the Amarok developers - how come that this feature is so little known? In fact, there are two possibilities for embedding MySQL (and both of them are licensed under the GPL): the first one is using the libmysqld embedded library, which is suitable if you are developing C/C++ applications:

The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application. The main benefits are increased speed and more simple management for embedded applications.

The embedded server library is based on the client/server version of MySQL, which is written in C/C++. Consequently, the embedded server also is written in C/C++.

The API is identical for the embedded MySQL version and the client/server version.

Especially consider the last sentence - it's actually fairly easy to create an application that supports connecting to both an embedded or a standalone server instance! Here are some related links to get you going:

• libmysqld, the Embedded MySQL Server Library
• MySQL C API functions
• Embedding the MySQL Server Library in a C Program by Russell Dyer
• Embedded MySQL Discussion Forum

If you're a Java developer, you should consider taking a look at our Connector/MXJ product - this allows you to embed a MySQL server in your Java application:

MySQL Connector/MXJ is a Java Utility package for deploying and managing a MySQL database. Deploying and using MySQL can be as easy as adding an additional parameter to the JDBC connection url, which will result in the database being started when the first connection is made. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users.

MySQL Connector/MXJ makes the MySQL database appear to be a java-based component. It does this by determining what platform the system is running on, selecting the appropriate binary, and launching the executable. It will also optionally deploy an initial database, with any specified parameters.

Included are instructions for use with a JDBC driver and deploying as a JMX MBean to JBoss.

Some related links to further information/help:

• MySQL Connector/MXJ documentation
• MySQL Connector/MXJ Downloads
• JDBC and Java discussion forum
• MySQL and Java Mailing list

Does your application make use of an embedded MySQL Server already? Please let me know! I'd love to learn more about the use cases and experiences you have made.

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.