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

|

Breakthrough: AMD and Intel settle antitrust dispute, reach new cross-license agreement

UPDATED Only exclusionary business practices, not some rebates, may be covered by a new agreement on Intel's future business conduct.

Windows Marketplace for Mobile now available in browser, iTunes' App Store still not

You can now check out what Windows Marketplace for Mobile has to offer without a Windows Phone.

Microsoft damage control after marketer claims Win7 inspired by Mac

Have you ever said anything you wish you could take back? Ever? No? Not even once? Well then, you won't sympathize with a mid-level Microsoft manager today.

Facebook for iPhone developer goes from Apple supporter to 'I quit!' in 3 months

Fed up with Apple's App Store policies, the developer of Facebook for iPhone has bailed on the iPhone.

Google acquires Gizmo5, builds IP telephony portfolio

Google Voice today confirmed rumors that it would acquire IP telephony company Gizmo5

'A pivot from war to peace:' The AMD + Intel armistice, in their own words

An extraordinary day in technology history is recognized by two long-time rivals that mutually decided it's futile to fight anyplace else except the marketplace.

PS3, Xbox to soon get Twitter, Facebook integration

Both Microsoft's Xbox 360 and Sony's PlayStation 3 will integrate with Facebook in the near future.

The iTunes App Store at 100,000: Can we stop counting, already?

Carmi Levy | Wide Angle Zoom: Is a six-digit number truly reflective of a healthy applications ecosystem? Or is it another type of bloat?

Analysis: The end of business-by-litigation?

The AMD v. Intel case ended neither with a bang nor a whimper, but almost with a song. Is it catchy enough for the rest of the PC world to sing in perfect harmony?

The agreement: Intel and AMD 'wipe the slate clean'

As the Securities and Exchange Commission document shows, AMD did indeed make some compromises in favor of Intel, especially with regard to conduct.

EC still holds Intel accountable even after AMD settlement

Though the future of relations between AMD and Intel may be peaceful now, the EC believes Intel may still owe restitution for its past conduct.