Lenz Grimmer's blog (Entries tagged as article)

What have I been up to lately?

nospam@example.com (Lenz Grimmer) — Fri, 02 Sep 2011 13:51:00 +0200

Despite my best intentions, I haven't posted on this blog for a while, which is a shame! I've become busy writing on so many other places since I moved into my new role in the Oracle Linux product management team in April. I've learned a lot and I am feeling quite at home here! The team is excellent and very nice to work with — I am slowly getting the "Big Picture".

But even though I've been neglecting this blog, there are a lot of things that are publicly visible and document some of my activites:

I've created two podcasts for the Oracle Linux podcasts:

In addition to working the @ORCL_Linux Twitter account and FaceBook page, I've been blogging on the Oracle Linux blog:

From time to time, I'm a guest blogger on the OTN Garage blog:

I also created new content and updated pages on the main Oracle web site and the Oracle Technology Network (OTN):

A new technical white paper about Oracle Linux and the Unbreakable Enterprise Kernel
An article about How to Extract Files from an Oracle Linux RPM Package Without Installing the Package
Added a new page about our Oracle Linux support offering
Updated the OCFS2 product page
Updated the Oracle Linux technical information page.

I've been traveling a bit as well and attended a few conferences where I spoke about Oracle Linux (and MySQL):

MySQL High Availability at COLLABORATE 11, Orlando (FL), USA
An introduction to Oracle Linux at the HEPiX Spring 2011 Workshop, Darmstadt, Germany
What's new in MySQL 5.5 at LinuxTag 2011, Berlin Germany
Updates on Oracle Linux and Oracle VM at fisl12, Porto Alegre, Brazil

I probably forgot a few things in my reflection of the past few months, but these were some of the highlights.

Check out my followup blog post on what I'm up to in the coming weeks and months!

Some friendly advice for bootstrapping your OSS project

nospam@example.com (Lenz Grimmer) — Thu, 29 Oct 2009 21:12:00 +0100

So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!

Keep the following saying in mind, which especially holds true in the Open Source world: "You never get a second chance to make a first impression!". While the most important thing is of course to have a compelling and useful product, this blog post is an attempt to highlight some other aspects about community building and providing the adequate infrastructure. This insight is based on my own experiences and my observations from talking with many people involved in OSS startups and projects.

Continue reading "Some friendly advice for bootstrapping your OSS project"

Interview with Adam Donnison, web developer at MySQL.com

nospam@example.com (Lenz Grimmer) — Tue, 25 Nov 2008 16:02:32 +0100

It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

Some new MySQL nuggets from blogs.sun.com and elsewhere

nospam@example.com (Lenz Grimmer) — Fri, 04 Jul 2008 11:56:38 +0200

Thankfully my RSS reader has builtin-search capability, so I can quickly skim the full RSS feed from blogs.sun.com for keywords of interest. I found the following articles quite helpful:

Setting up MySQL Cluster using Solaris Zones by Hashamkha Pathan walks through the steps involved of setting up a virtual MySQL Cluster setup on a single Solaris instance (for evaluation purposes only - this is probably not the best idea for a productive HA environment)
Mixing SQL and shell commands in MySQL by Amit Saha explains how to write scripts that execute both SQL statements and unix shell commands using the MySQL command line client
Improving filesort performance in MySQL by Neelakanth Nadgir provides some background information about MySQL's filesort operation that is being performed when records have to be sorted using ORDER BY.
Ubuntu, PHP, NetBeans - part I by Petr Pisl is the first part of an article series that will explain how to develop PHP/MySQL applications using NetBeans on Ubuntu Linux. This part describes the basic installation of the required LAMP stack components.

If you are would like to learn more on how to develop on NetBeans with using a MySQL Server and how to create web apps that use MySQL as a backend, take a look at these two tutorials:

Over on the Novell Cool Solutions pages (which are powered by Drupal, by the way), I found this introduction on how to set up MySQL replication by Damian Myerscough. It walks you through the steps involved in setting up a classical master-slave replication setup.

Running Drupal 6 on MySQL 6 using the Falcon Storage Engine

nospam@example.com (Lenz Grimmer) — Mon, 28 Apr 2008 17:22:31 +0200

This article describes how to install the Drupal 6.2 CMS on MySQL 6.0, using the Falcon Storage Engine. The operating system is a default Ubuntu 8.04 "Hardy Heron" (x86) installation.

I will make a few assumptions here, in order to keep the instructions simple: a fresh OS install, no other MySQL databases or web services are running or have already been installed. Both MySQL and the web server are installed on the same host. You should be able to become root to install packages and to have access to the local file system and the system configuration.

This article will explain how to install and configure Apache/PHP, MySQL 6.0 and Drupal 6.2.

Continue reading "Running Drupal 6 on MySQL 6 using the Falcon Storage Engine"

MySQL gems from Sun bloggers

nospam@example.com (Lenz Grimmer) — Fri, 25 Apr 2008 20:19:22 +0200

While being subscribed to the full blogs.sun.com feed certainly feels like drinking water from a firehose, every once in a while I stumble over very well-written and useful articles about MySQL. Below is a collection of helpful posts, especially if you run MySQL on Solaris (surprise!). And while I still am an avid Linux user, I must admit that Solaris has a few neat features - particularly DTrace and ZFS are quite intriguing. If only userland would not feel so weird for someone coming from a GNU/Linux background!

From Jenny Chen's blog:

From Ritu Kamboj's blog:

From Krish Shankar's Blog:

More to come in the near future!

Linux tip: Automatically rotate/archive your fetchmail/procmail log files

nospam@example.com (Lenz Grimmer) — Wed, 06 Feb 2008 14:05:50 +0100

When it comes to handling my work-related email, many people will probably conclude that I am an old fart in Linux terms: I still use the console-based Pine as my MUA of choice, as my fingers have been hardcoded to its key combinations over the years (my first encounter with Pine was around 1994 on a shared DEC Ultrix box in my university). So far, I have not found any other application that allows me to process email as quickly as by using this tool.

I admit that I do use Thunderbird for my personal email, though, to gather experience with it (and to toy around with the various extensions, especially Nostalgy is a gift from heaven for people like me!). And of course because the mail volume there is less critical to cope with! But I am not going to start a holy war here - this article is supposed to explain how I have configured my mail setup to rotate the log files that keep track of all my incoming mails.

Continue reading "Linux tip: Automatically rotate/archive your fetchmail/procmail log files"

Community Team interview with Mårten Mickos about the Sun Acquisition

nospam@example.com (Lenz Grimmer) — Wed, 06 Feb 2008 11:57:00 +0100

We have just published an interview with our CEO Mårten Mickos on our Developer Zone, where he answers a number of questions from the Community Team about Sun's plans to acquire MySQL AB and what this means for the MySQL User Community and the direction of the product (thanks to Colin for compiling and editing the text). I hope that the comments help to calm the concerns of some people about the future of MySQL with regards to Open Source, support of platforms or language bindings:

CT: Is MySQL fully committed to free and open source software, and the GPL?
Mårten: Yes.
CT: What does the Sun acquisition mean for Linux support? What about Windows, Mac OS/X and other platforms?
Mårten: One of the reasons for us to be interested to discuss an acquisition with Sun was their new strategy to work with technologies and companies that previously had been seen as competitors. Our mandate within Sun is to grow our database business - on all operating systems and with all development and scripting languages and on all hardware platforms. Linux remains the most important operating system for our business. Windows remains the top operating system among our downloads. Mac OS X is a vital platform and many of our own engineers use Mac notebooks.
CT: Will all the language bindings still be supported? i.e Will PHP, Perl, Ruby, etc. be treated as well as Java?
Mårten: Absolutely. See my previous answer. Our goal and mandate is to grow our business on all fronts.

I personally am very excited about this change and expect many good things to come out of it. Sun is really trying hard to "not screw this up" (quoting Jonathan Schwartz).

UPDATE: I just stumbled over another article about this topic, which I also consider recommended reading: Mårten Mickos: Why Did I Change My Mind?:

I may sound naively excited about Sun in my writing here, and perhaps I am. Perhaps I drank the Kool-Aid along with the traditional Swedish vodka shot when we closed the deal. But in my life and my professional career so far, I have never regretted using my gut instinct to choose between two rational alternatives.

Mini-tutorial about using the spatial extensions in MySQL 5.0

nospam@example.com (Lenz Grimmer) — Tue, 29 Jan 2008 11:56:31 +0100

While helping a user with some questions about the geospatial extensions of MySQL on the #mysql-dev IRC channel on Freenode, I stumbled over this blog: How to use MySQL Spatial Extensions. There currently is just one post, but it was exactly what we were looking for: "Using Circular Area Selection". Nice work! I hope the author will soon provide more examples of how to make use of this functionality.

By the way, there is work in progress to improve the GIS functionality in MySQL - if you are looking for new GIS functions that do not use MBRs, take a look at our GIS feature preview on the MySQL Forge. We plan to publish a new set of preview binaries once the 5.1.23 release has been published and merged into this code base.

From Visions to Reality - an interview with David Axmark, Co-Founder of MySQL AB

nospam@example.com (Lenz Grimmer) — Thu, 02 Aug 2007 22:58:13 +0200

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!

Interview with Andrey “Poohie” Hristov now available from the MySQL DevZone

nospam@example.com (Lenz Grimmer) — Fri, 19 Jan 2007 11:21:57 +0100

Some days ago I had the pleasure to interview Andrey Hristov, who is a developer at MySQL AB. He joined the team after working on a new feature for the MySQL Server as part of his master's thesis. You can read the full interview on the MySQL Developer Zone. Enjoy!

OSCON Interviews: Solid

nospam@example.com (Lenz Grimmer) — Thu, 31 Aug 2006 17:43:59 +0200

It's already a month old, but I just stumbled over this ITtoolbox Interview with Jonathan Cheyer (Open Source Community Manager) and Murat Demiroglu (Senior Product Manager) from Solid Information Technology, in which Dru Lavigne talks with them about Solid (the company) and the solidDB for MySQL storage engine, which is currently in beta testing. I still remember Solid from my times at SUSE Linux, where it used to be a part of the Linux distribution along with MySQL, PostgreSQL, Adabas D and several other DBs...

Using Excel to analyze MySQL data

nospam@example.com (Lenz Grimmer) — Wed, 12 Jul 2006 18:43:00 +0200

Just stumbled over this article, which might come in handy for our Microsoft Office users out there: "Using Excel to analyze MySQL data" by Jason Gilmore explains how to set up the MySQL Connector/ODBC and connecting to a MySQL database using Microsoft Excel.

If you're a Linux user, this article on NewsForge covers a similar topic, using OpenOffice.org

to connect to a MySQL Server.

Update: Thanks to Guillermo Roditi for pointing out that both links pointed to the same article - now fixed. Sorry about that.

Article about MySQL and Java installation published

nospam@example.com (Lenz Grimmer) — Mon, 03 Jul 2006 12:55:01 +0200

Last week I was notified that my article about how to install and configure MySQL and the MySQL Connector/J was published in the Java Starter Magazine, a special edition of the german Java Magazin. It covers the basic installation of MySQL and Connector/J on Windows and Linux and how to write a small example program to connect to to MySQL with Java using the Eclipse framework. They were kind enough to send me a number of copies that I plan to give away at tonight's Hamburg MySQL User Group Meeting.

Interview with Paul McCullagh, developer of the PrimeBase XT Storage Engine

nospam@example.com (Lenz Grimmer) — Fri, 02 Jun 2006 15:10:18 +0200

Paul McCullagh works on a new pluggable transactional Storage Engine for MySQL, called PrimeBase XT. I met him for an interview a few days ago - you can now read it on the MySQL Developer Zone. Enjoy and have a nice weekend!