Feeds

Drizzle plans to wash away DBMS past

Cloud database says 'no' to Windows and SQL compliance

Combat fraud and increase customer satisfaction

A new database management system (DBMS) designed for web applications and cloud computing could be the start of a new direction in DBMS development and, indeed, in software as a whole.

Drizzle - unveiled recently at the O'Reilly Open Source Convention (OSCON) by MySQL director of architecture Brian Aker - is described as a "slimmed down version of MySQL" and defined as much by what it doesn't do as by what it does.

It will have no unnecessary features, won't support Windows or be compatible with MySQL, and neither will it be "SQL relational compliant". The decision to fly in the face of convention could be either bold - or stupid.

Brian Aker at Oscon: Picture Gavin Clarke

Aker: features optional

Aker blogged that Drizzle is the result of discussions with a number of MySQL-interested parties on issues such as feature bloat and performance. The starting point is the creation of a micro-kernel which strips out many features, which are traditionally considered essential in a modern DBMS.

Specifically, Drizzle does not have stored procedures, views, triggers, query cache and prepared statements. Field-data types have been simplified and Aker also noted that SHOW command could be migrated to client environments. Aker argues that, if any of these facilities are needed, they can be provided externally through interfaces and libraries.

"We have taken to a very micro-kernel design where code is being removed from the center and pushed out to the edges via interfaces. We are taking a Linux/Apache tightly coupled design for modules," Aker wrote.

The main reason for stripping down Drizzle to the bare minimum is so it can deliver high performance in an environment defined by web applications based on "cloud" components and multi-core architectures. Currently, the performance goal has yet to be realized because - as noted by Aker on the Drizzle FAQ: "I certainly do not believe the code is production quality. Right now we are defaulting many configure operations to generate debugging code for us so our binaries are not optimal. "

While it is not an official project, it is sanctioned by Sun and some development is being carried out by MySQL employees. Aker described the open collaboration approach - involving both internal and external developers - as "organic open source'".

He expects this will lead to a rapid development cycle with regular releases. It also means that those frustrated with slow progress in development of MySQL will be able to get their hands on features quickly. As MySQL originator Michael "Monty" Widenius blogged Drizzle will have the latest versions of add-ons such as the InnoDB plug in.

The open development model has also helped to define the development technology and tools used to build Drizzle. The code is licensed under the GNU GPLv2 and Aker insists that development should be based on a GNU tool chain. The core development is based on C99 and Posix.

As a result of adopting a GNU tool chain, Drizzle will only be available for Posix based operating systems. Currently these include Linux (Fedora), Solaris Express and Mac OS X.

Greatest thing since data slices?

This means that there are no plans to support Windows. Aker defended the decision with the assertion that Microsoft is irrelevant to the future of software development and went on to compare it to Sony as a "non-innovator".

Drizzle moves into what is currently the most exciting space for DBMS development - large-scale databases that break with the established SQL relational model. If it is successful it could stack up against products such as Amazon's SimpleDB and Google's BigTable.

The big question, though, is whether moving away from the dominant DBMS model - not to mention eschewing support for Windows - will make or break Drizzle. If it works, Drizzle will certainly mean a sea change in DBMS development and could well become a model for a different approach to building software based on a minimalist model. If it doesn't, Drizzle will live up to its namesake by becoming something of passing and inconsequential interest.®

Combat fraud and increase customer satisfaction

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Oh no, Joe: WinPhone users already griping over 8.1 mega-update
Hang on. Which bit of Developer Preview don't you understand?
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
New Facebook phone app allows you to stalk your mates
Nearby Friends feature goes live in a few weeks
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
prev story

Whitepapers

SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.