I had an interesting conversation yesterday with Juanjo Hierro from the Morfeo Project, a Spanish community of open source communities set up to speed up the development of Service Oriented Architectures-related software standards and create business opportunities for local suppliers.

Hierro explained that the Morfeo Project is based on “The Law of Conservation of Attractive Profits”, articulated by Clayton Christensen in his book The Innovator’s Solution:

“When attractive profits disappear at one stage in the value chain because a product becomes modular and commoditized, the opportunity to earn attractive profits with proprietary products will usually emerge at an adjacent stage.”

Christensen’s law has also been used by Tim O’Reilly …

Seeing my recent love affair with solid state drives I thought I would test drive one of the latest greatest drives out their the 80GB intel x-25m80GB.  Like a child on Christmas morning, I felt true excitement as the generic UPS envelop arrived on my porch today.

While it did not show up until late in the day, I can’t just let it sit their without starting to test it can I?

Benchmarks are running as I write this and I will provide the full breakdown of the drives performance as I finish up the tests.

But to wet your appetite, check this out:

50-50 read/write sysbench test:  1899 IO requests per second!!!  Thats huge!!!

Thats compare to the 284 IOPS I got on the memoright GT, a performance improvement of 6.6x, with a higher capacity 80GB -vs- 32GB, and a Lower cost $773 -vs- $680…  outstanding!!!

Here are the first unverified sysbench test runs:

Note that I’m talking about using these tools in some kind of professional way, and more specifically, I’m talking about using Excel as a database, and using VPS hosting to host “professional” web sites. By “professional”, I mean something other than your personal blog, picture gallery, or other relatively inconsequential site.

Excel is not a database

Here’s the thing: Excel isn’t a database. Most people who don’t work in IT don’t seem to understand this, and they’re deathly afraid to actually communicate with anyone in IT, so they take matters into their own hands, and create problems so big that IT is forced to get involved, because at some point this spreadsheet becomes “critical” to some business function. Then IT gets even more bitter toward the non-IT folk, validating some of the reasons the non-IT folk went that route in the first place, and virtually guaranteeing that they won’t come to the IT …

Previously on Log Buffer: Log Buffer #119.

And now.

Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).

I admit I had no idea of the community or state of the PostgreSQL RDBMS, and so I definitely learned some new stuff this week. First off, over on “The Scale-out Blog” Robert Hodges invites us all to get our …

VentureBeat and OStatic are among the news source reporting the launch of Cloudera a new vendor set up to provide support for Apache Hadoop and related projects.

Given the current economic outlook it’s great to see a new open source start-up rearing its head, and the list of founders indicates that this one has a good chance of survival. While VentureBeat is focused on the fact that Ex-Google, Yahoo, and Facebook employees are on the team, my eye was caught by the fact that Mike Oslon, Sleepycat Software founder and former CEO has been tempted out of semi-retirement.

(Or “the return of 451 CAOS Links“)

Having been a bit busy for the last three weeks I have a bit of catching up to do on the latest open source software news. Here’s the headlines that caught my eye.

MySQL co-founder resigns from Sun
No, not that one. David Axmark resigned stating “I HATE all the rules that I need to follow, and I also HATE breaking them. It would be far better for me to “retire” from employment and work with MySQL and Sun on a less formal basis.” If I may paraphrase Oscar Wilde, to lose one co-founder may be regarded as a misfortune; to lose both …

Pimp My Drive by Richard and Barb

There’s remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.

I’m a Linux geek, have been since 1993 (Slackware!). All of SmugMug’s datacenters (and our EC2 images) are built on Linux. But the current state of filesystems on Linux is awful, and …

So, I recently ran into one of those situations where a customer complains that his MySQL database is slow, and “it worked great until about two weeks ago”. The first thing I look at in these situations is not the queries or any code, but the indexes. Once I determined that the indexes were almost nonsensical, I had a look at the queries themselves, which proved that the indexes were, in fact, nonsensical. Running the queries as written in the code, from a mysql shell, with EXPLAIN, I was able to further confirm that the indexes (most of them, anyway) were never used.

Easy right? Just reindex the table!

NOTE: I’m going to skip the talk about all of the database design issues on this gig and just go straight to solving the immediate problem at hand. Just know that I had nothing to do with the design.

But, supposing this table has 15 million rows and is running on a machine with 2GB of RAM and only …

I thought I'd share a note I sent earlier in the week to Sun's leaders - about the turmoil we're seeing in the markets, and how I want our team focusing their efforts.

_______________________________________________________________________________

Begin forwarded message:
From: Jonathan Schwartz
Date: September 30, 2008 12:02:29 AM PDT
To: All Sun
Subject: Headlines, Financial Crisis, etc.

You can't have missed today's headlines - the American Congress failed to pass a critical bill authorizing the Treasury to put a floor under the US banking sector. The market swooned, and politicians in the US, and across the world, are bickering over the right long term answer - jump in and take action to save the troubled institutions, or step aside and …