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

|

Will Firefox beat IE9 to Direct2D rendering?

Just days after Microsoft executives gave conference attendees a peek at a new rendering technology, a Mozilla contributor revealed he's working on the same thing.

AOL's decision to rebrand as Aol. takes a bad brand and makes it worse

The idea behind the social Web is to crowd source before bringing out something new. But not at AOL, which new logo debuted with a cry of "fail!" across the blogosphere and Twittersphere today.

Microsoft's Bob Muglia and Ray Ozzie on Silverlight vs. standards

Bob Muglia: "We're trying to provide people with an environment that has capabilities that you just simply can't do today in the standards-based world."

Uh-oh, netbooks -- not Windows 7 -- will lift 2009 PC sales

Santa may bring a lump of coal to the Windows PC industry this holiday season. Netbook sales will sap PC margins, while weak Windows 7 PC sales could further drive down average selling prices.

Kindle 2 update adds battery life, native PDF reader

Amazon has pushed out an update to the Kindle 2 e-reader that lengthens battery life and adds a native PDF viewer.

Safari on iPhone gets competition from a $1 browser app

Apple likes to say it gives iPhone users a full browsing experience, but a new competitor tries to incorporate more desktop browser features.

Action Replay maker sues Microsoft for Xbox 360 'predatory technological barriers'

Third-party video game accessory maker Datel has filed an antitrust lawsuit against Microsoft over the Xbox 360's recent Dashboard update.

Where there's smoke: Apple warranty stance raises troubling questions

Carmi Levy | Wide Angle Zoom: Smoking can be dangerous not only for your lungs, it appears, but for your Apple hardware warranty.

Microsoft's .NET Micro Framework is now free and open source

The latest version of Microsoft's .NET Micro framework is now in the hands of the FOSS community.

Google's value proposition for Chrome OS: Should we feel insulted?

For a search engine that has direct access to all the world's online history, it appears to have taught Google nothing about selling a machine.

E-book readers will be in short supply this holiday season

E-readers are hot this year, and a lot of compelling new products have been released, but are there enough electrophoretic displays to go around?