Tomorrow, Thursday 13th Sept. at 13:00 UTC (15:00 CEST/9:00am EST/6:00am PST) Jan will perform a MySQL University session providing an Overview of the MySQL Proxy. If you like to attend, please add your name to the session page and read the Instructions for Attendees. All you need is a PDF viewer to see the slides, an IRC client to post questions and comments and an application capable of playing an OGG audio stream.
Version 0.6.0 of the proxy has just been tagged and we're waiting for the mirror sites to catch up before we publicly announce it and update the download pages.
Better late then never: I've now uploaded a few pics that I've taken during this year's FrOSCon to my gallery. Have fun!
After getting very annoyed about the behaviour of pinepg in combination with gpg2 on my openSUSE 10.3 beta test system, I have now scratched my itch and switched to an alternative tool: pine-gpg-filter:
The distinguishing characteristic of this package (when compared against similar pine and gpg wrappers) is its ability to handle multiple roles or identities (i.e. different keys for different email addresses). Unlike some of the other pine and gpg wrappers, this one performs no passphrase caching (consider using gpg-agent in gnupg2).
They provide a "noarch" RPM directly from that site, but I've now also added it to my home:LenzGr repository in the openSUSE build service. Enjoy!
Just came off today's MySQL University session about How to Build MySQL on Windows - Reggie did a great job on explaining how to build the MySQL Server from Source on Windows using the Microsoft development toolchain and some additional required tools. I am glad to hear that we're making progress on making it easier for Windows developers to work with the source code and Reggie and the other members of our Windows Task Force (what a nice acronym this one makes!) have plenty of other ideas for improving that experience.
If you missed his session, the audio file and IRC log will be published from the MySQL University pages shortly.
And in case you haven't heard about MySQL University before, check out the pages on the MySQL Forge and take a look at the upcoming schedule! Next week, Jan is going to give an introduction to the MySQL Proxy, which will to be an interesting session for sure. Did I mention that attending MySQL University is free and everybody is welcome to join? All you need is an IRC client to post questions and discuss the topic and an application capable of playing OGG audio streams for listening to the presenter. The MySQL Forge Wiki has detailed instructions on how to get going. See you next week!
In addition to the binary downloads that we provide from our site, Linux RPM builds of the MySQL Proxy (both the latest stable version as well as SVN snapshot releases, named mysql-proxy-snapshot) are now available for download from the server:/database repository of the openSUSE build service. It provides packages for a number of Linux distributions, e.g. Fedora 5/6, SLES 9/10 SuSE/openSUSE 10.x. By the way, this repository also contains RPMs of the current 5.0.45 MySQL Community Server for the distributions mentioned above. Thanks a lot to Darix for the initial checkin of the proxy package!
I've returned home safely from my trip to St. Augustin, Germany (near to Bonn), where I attended this year's FrOSCon. As last year, it was a very well organized event, kudos and thanks to the conference organizers (who are all volunteers!). The conferece program was packed with good sessions again and the ones I attended were interesting and well done. Many OSS projects also exhibited in the hall way, it was nice to stop by and chat with these folks.
I gave a talk about "Opening the doors (and windows) of the Cathedral - Enabling an architecture of participation around the MySQL Server", which describes the ongoing activity at MySQL to open up the development processes to the Community. Given that I gave this talk for the first time, I think it went very well, at least I did not run out of time 
The slides are now available from the session page linked above or from the MySQL presentations section on my site. The talk was also recorded, a video clip should be available from the FrOSCon pages in the near future, too.
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.
I am happy to announce that my
MySQL Dev Zone interview with David Axmark just went live - if you are curious to hear a few stories about how David and Monty started this whole thing more than 10 years ago, make sure to spend a few minutes and read it
here!
JFYI, I recently updated several packages in my home:LenzGr and the devel:tools:scm repositories of the openSUSE Build Service:
Enjoy! And Kudos to the folks that develop and maintain the build service, this is a great service to the Community.
OSCON, the Open Source Convention organized by O'Reilly is coming up next week (July 23rd-27th, Portland, OR).
MySQL AB will be present in the exhibition area and we will also be giving some talks:
There are some other talks related to MySQL, that might be of interest for you:
Just a quick heads-up - I just commited a change to the
Planet MySQL code that slightly modifies how the RSS feed is being created: now the author name is put in front of each posting's title, similar to how many other feed aggregators mark the different articles. I hope you find this change useful, let me know if you experience any problems or have any other suggestions for improvements. Thanks!
Today, I again spent about an hour to revert changes made by spambots on various
MySQL Forge Wiki pages. As I was really sick of this, I now installed a new plugin:
reCAPTCHA - this will hopefully raise the bar for spambots to create new user accounts automatically for spamming the Wiki. If you are a registered user already, you will probably not notice the change - by default, CAPTCHAs are only displayed on the following events:
- New user registration
- Anonymous edits that contain new external links
- Brute-force password cracking
Let's hope it helps! Please let me know if you still experience spam problems on the Wiki.
As I felt the itch to do some quick hacking yesterday, I decided to provide an RPM spec file for the MySQL proxy. The changes have been commited to the SVN trunk now and I added some hints to the INSTALL file on how to perform an RPM build.
Here is a quick summary of how to convert the current SVN code into an installable RPM. You build environment needs to fulfill a few additional prerequisites (a gcc compiler and the C library header files are taken for granted here), I added the versions I used on my openSUSE 10.2 system for reference:
- autoconf 2.56 or newer (autoconf-2.60)
- automake 1.9 or newer (automake-1.9.6)
- MySQL 5.0.x include files (MySQL-devel-5.0.41)
- pkg-config (pkgconfig-0.20)
- libevent 1.x or newer (libevent-1.1)
- lua 5.1 or newer (lua-5.1.1)
- glib2 2.4.0 or newer (glib2-2.12.4)
The following steps need to be performed:
# Check out the trunk of the SVN repository
$ svn co http://svn.mysql.com/svnpublic/mysql-proxy/trunk mysql-proxy
# Enter the directory and bootsrap autoconf/automake
$ cd mysql-proxy
$ sh ./autogen.sh
# Build the source distribution tarball
$ ./configure && make distcheck
# Convert the source tarball into a binary RPM
$ rpmbuild -tb --clean mysql-proxy-<version>.tar.gz
RPM will now perform the compiling and packaging. The end result will be an installable binary RPM package which will end up in the RPMS directory. Depending on your distribution this location will vary, on my openSUSE system the package ended up in in the following location from where I installed it directly:
$ sudo rpm -Uhv /usr/src/packages/RPMS/i586/mysql-proxy-0.5.1-0.i586.rpm
The mysql-proxy will be installed into /usr/sbin, the documentation and example scripts are being put into the default documentation directory (/usr/share/doc/packages/mysql-proxy in my case).
For now, you still have to start the proxy manually. Next thing is to create an init script that starts up the process at boot time.
I'd like to bring two announcements to your attention, that I posted to our internals Mailing list a few days ago - both refer to ongoing activities at MySQL AB to further open up our development processes and to establish an Architecture of Participation around the MySQL Server and related applications.
I am excited to be able to talk about this topic at the upcoming FrOSCon, which will take place on August, 25th-26th in Sankt Augustin, Germany. The title of my presentation will be "Opening the doors of the Cathedral - Enabling an architecture of participation around the MySQL Server". Here's the abstract:
Even though the MySQL Server is released and distributed as Open Source Software (OSS) under the GPL, the development itself so far has mostly been performed in a very closed-source fashion, as most of the developers are employed by MySQL AB. This talk covers some of the ongoing efforts to establish an architecture of participation around MySQL that attempts to move the MySQL server development process into the public, making it more accessible to other developers interested in contributing.
I submitted two additional talks about "HA Solutions for MySQL" and "Working in a virtual company: benefits, challenges and tools" - unfortunately both were rejected. However, there are two additional talks related to MySQL: "Logging and monitoring a database server" provided by Giuseppe Maxia and "PostgreSQL vs. MySQL: Venus vs. Mars" provided by Susanne Ebrecht.
I personally enjoyed last year's FrOSCon very much and I look forward to this year's edition! Make sure to mark the date in your calendar and come over to meet with us and other OSS people!
Without further ado, here's a repost of the two announcements I sent out:
Continue reading "Expanding the architecture of participation and talking about it at FrOSCon"
Yesterday I migrated the image Gallery from Gallery v1 to Version 2.2. The process was quite painless, thanks to the excellent documentation. Just one caveat: in version 2.2, the Gallery v1 migration plugin has to be downloaded and installed first, it did not ship with the "Typical" installation package. Oh, and make sure you have configured PHP to be able to use lots of memory, too! I had to change the settings so it was able to allocate around 42 MB for importing my 3600 images from the previous version...
I hope the migration was successful, please let me know if you notice anything weird! One thing I really like about the new version is the WebDAV support - now I can simply copy new pictures from Konqeror or any other KDE application into the Gallery.
