With Drizzle, Sun's MySQL gets skinnier, forgoing features for speed

By Jacqueline Emigh | Published July 23, 2008, 3:45 PM

"Drizzle," a recently announced offshoot of MySQL, is taking the open source database in a wholly different direction than the bigger, feature-full database widely foreseen since Sun's MySQL buyout.

Running only on Linux, Sun Solaris Express, and Apple's OS X, the trimmed-down Drizzle database won't be getting Windows support any time soon, if at all. It essentially component-izes the software, making it so businesses can select which features they need and leave out those they don't, much like a Linux kernel.

Created by a team of open source developers, Drizzle is not a Sun product, "though several of the authors do work for Sun/SQL," said Brian Aker, MySQL's director of architecture, in a FAQ for Drizzle.

In Drizzle's microkernel-based architecture, code will be taken out of the MySQL database core and moved through interfaces into modules. Meanwhile, MySQL -- a database now owned by Sun -- will remain a separate entity, according to Aker.

Drizzle will be licensed under the GPLv2. "Windows is not supported and will stay that way unless it gets a working posix layer, a autoconf system (aka becomes a platform that is reasonable to support)," he contended.

In a blog posting, Aker said that, although he'd been envisioning a slimmer database for quite some time, he was spurred to action by a conversation with the CTO of Rackspace -- a hosting company -- about Memcached, a distributed memory object caching system, and Gearman, a system for dispatching function calls to other machines.

"He asked me whether I had ever thought about creating a slimmed down version of MySQL to work with them," according to Aker.

"After I got off the phone the idea stuck in the back of my mind. The next day I woke up and started playing with the idea of seeing what a cut down version would look like. One day turned into months. Somewhere along the way I decided to bring in a few people and see what they thought. The reaction was more ideas, and code followed. We went about asking the question of 'What if.'"

Under Aker's database diet plan, the functionality to be removed from MySQL for Drizzle will include stored procedures, prepared statements, query cache, access control lists, modes, views, triggers, data conversion inserts, and some data types

Meanwhile, with Sun's buyout of MySQL in January, industry experts have been pointing to challenges for Sun in bringing MySQL to the same levels as Oracle, Microsoft's SQL Server, and IBM's Universal Database (UDB) in terms of performance, scaleability, and installed base.

"As good as MySQL is as a database, there are probably some development issues ahead. Sun might get some limited success among its current customer base -- but still, they have their work ahead of them," said Charles King, principal analyst at PundIT, in an interview with BetaNews in January.

On the other hand, if Sun is successful in optimizing SQL, "that could cause a real [competitive] shift, especially is Sun can raise performance through benchmarking," said the 451 Group's Raven Zachary, in another interview with BetaNews, also at the time of the buyout.

Drizzle is not available yet, and no release date has been set. Who might be using the skinny database? Aker described Drizzle's target as "a certain class of applications/developers and see it this is useful. As an example: 1) Web based apps; 2) cloud components; 3) Databases without business logic (aka stored procedures); 4) multi-core architecture," he said.

Comments

View comments by with a score of at least

But Windows is fully POSIX compliant, you don't even need Cygwin. I find it disappointing that Windows Server 2008 isn't supported.

Score: 0

|

"functionality to be removed from MySQL for Drizzle will include stored procedures, prepared statements, query cache, access control lists, modes, views, triggers, data conversion inserts, and some data types"

In other words, they're going to remove everything which was added in the last decade specifically to change MySQL from a toy database into a real one. Sorry... been there, done that with MySQL 3 and the MyISAM engine. If I need a lightweight, limited functionality, open source database, I can use SQL Lite and get full cross-platform compatibility.

Score: 0

|

"Windows is not supported and will stay that way unless it gets a working posix layer, a autoconf system (aka becomes a platform that is reasonable to support)"
Typical 1inukz guRuz arrogance. If mysql does work on windows now, why do they need posix for that? And if they don't know how to use Visual Studio, what is wrong with autoconf in cygwin?

Score: 0

|

Google Chrome 4: Yes, it's fast, but is it usable?

As Betanews readers have responded to our stories about Chrome's JavaScript superiority...Does that mean we'd actually use this browser? Well...

Video: Netflix on PlayStation 3

Netflix has come to the PlayStation 3 via Blu-ray and BD-Live.

Verizon Wireless launches new Android, Chocolate, and ruggedized phones

The lower-priced Eris joins the Droid, while the Chocolate gets a touchscreen and more music playback.

Early sales figures for Windows 7 nicely high, but do we know why?

Fans of triple-digit surges in figures quoted by Betanews will love this one, as it appears Microsoft rediscovered how to pull off a software launch.

Myka announces its latest Linux-based 'net top box'

Myka's ION brings Boxee, XMBC, and much more to HDTVs.

What hath Mac wrought? A remembrance after a quarter-century

The reason there's a Macintosh today is not because of some brilliant flash of engineering genius, but because Apple had the audacity to learn from its mistakes.

Early build of Moblin 2.1 improves connectivity, but not device support

The Linux Foundation's Atom-centric OS yesterday received a major overhaul with the project release of Moblin 2.1 for netbooks and nettops.

The iPhone's China syndrome: Sales of 5,000 and climbing

There's actually a country where Apple's device is not a godsend, where sales can be measured in the dozens.

New European counterpart to FCC will ensure 'a more neutral net'

Late Thursday night, the ruling telecom administrators of the EU's member nations signed away their final authority to a new entity overseen by the EC.

Sophos study suggests Windows 7 UAC's default setting is self-defeating

Without any anti-virus installed, a Sophos test showed, User Account Control was only capable of thwarting just one malware package out of ten samples chosen.

Indiscreet tweet trips awareness of Web SSL vulnerability

A group of high-level security engineers had been making progress on thwarting a low-level threat to the Web, until somebody blurted it all out on Twitter.