I rarely see the point of posting the slides of a presentation for people who didn't see the original presentation. Yet, this is often requested. I don't have a problem with posting my latest slides (PDF, 2.9M), but they are of little value without context and I do have a problem with posting things of little value, so here's the context.

Slide 1

Welcome to my presentation about CouchDb. This is a ca. 80 minute ride through the world of non-relational data storage.

Slide 2

I'm Jan, from Münster, Germany. I'm a developer focussing mostly on the web. If time permits I'm studying computational linguistics. I mostly do freelancing consultance work on the web and gained experience with scaling high traffic LAMP sites doing that. I'm also the co-founder of freisatz, a company bringing typographic bliss to everyone.

I had little time and no internet while preparing the slides. …

Build notes and Tuning tips for Solaris

lighttpd seems to be increasingly popular, so much so that netcraft has started tracking it's use on production websites. I've spent some time building, tuning and running simple performance stress tests on lighttpd 1.4.15 on Solaris and thought I'd share what I learnt.

Building lighttpd

My build of lighttpd uses the openldap library from Cool Stack. I also built and installed pcre-7.1 in /opt/coolstack using the following script :

#!/bin/sh
INSTALLDIR=/opt/coolstack
CFLAGS="-fast -xipo -xtarget=generic"

make distclean
./configure --prefix=$INSTALLDIR CFLAGS="$CFLAGS"
make
make install
…

Build notes and Tuning tips for Solaris

lighttpd seems to be increasingly popular, so much so that netcraft has started tracking it's use on production websites. I've spent some time building, tuning and running simple performance stress tests on lighttpd 1.4.15 on Solaris and thought I'd share what I learnt.

Building lighttpd

My build of lighttpd uses the openldap library from Cool Stack. I also built and installed pcre-7.1 in /opt/coolstack using the following script :

#!/bin/sh
INSTALLDIR=/opt/coolstack
CFLAGS="-fast -xipo -xtarget=generic"

make distclean
./configure --prefix=$INSTALLDIR CFLAGS="$CFLAGS"
make
make install
…

So, I hear you ask (ask dagnammit!), what does a MySQL Cluster hacker do when not hacking MySQL Cluster?

Well,

Today, a box arrived:

I eagerly opened the box… eager for what was inside:

Hrrm… this does look promising! Quickly I turned it all up the right way:

It’s here! It’s here! Only about a month after Michael got his copies! Gah international shipping (and moving addresses) can be casually annoying sometimes. But anyway, it’s here, it looks sweet and now I can go set up a …

In the first two articles in this series, I discussed archiving basics, relationships and dependencies, and specific archiving techniques for online transaction processing (OLTP) database servers. This article covers how to move the data from the OLTP source to the archive destination, what the archive destination might look like, and how to un-archive data. If you can un-archive easily and reliably, a whole new world of possibilities opens up.

In MyISAM, we do have LOAD INDEX INTO CACHE. In InnoDB this does not work. For benchmarking I often require a way to preload the innodb_buffer_pool with the primary key and data after a server restart to shorten warmup phases.

According to Blackhole Specialist Kai, the following should work: CODE:mysql> create table t like innodbtable;
mysql> alter table t engine = blackhole;
mysql> insert into t select * from innodbtable; Another win for the unbreakable BLACKHOLE storage engine.

MySQL’s latest advertising campaign (called “The 12 Days of Scaleout“) is getting a bit of a kicking in the MySQL blog space.

I am sure that this is slightly uncomfortable for the MySQL team, but at the same time the team is lucky that people who care about MySQL still take the time to explain what they don’t like.

Perhaps it would be a good time for them to go back and add some meat to the case studies?

…

As I am happy to report a number of people have responded on my initial challenge of 3+3 lessons on building open source business, I wanted to post the links so far, enjoy:

Mårten Mickos, CEO of MySQL

Stephen Walli, an Open Source Expert

Ignacio Correas, CEO of Warp

Stephen O’Grady, Redmonk

Michael Tiemann, President of Open Source …

Zimbra is today's featured scale out example as part of our 12 days of scale out series.  I've always had a soft spot for Zimbra since I first met CEO Satish Dharmaraj a couple of years back at the first Red Hat Summit in New Orleans. Their ambition is significant: they offer a plug-in replacement for Microsoft exchange that is open-source, cross-platform and more scalable. Zimbra Collaboration suite can handle multiple hundreds of thousands of email …

MySQL AB today published a case study on Wikipedia's successful use of the MySQL database to help manage its massive popularity. The winner of the 2005 'MySQL Application of the Year' Award, Wikipedia is today's featured user in the vendor's "Twelve Days of Scale-Out" educational initiative. The campaign is live at www.mysql.com/scaleout.