drizzle
Profile
Search
 
Hosted by The Rackspace Cloud
Drizzle Features

Contents

Main Points

Data types supported

please refer datatypes [removed] from MySQL 6.0
Following are the datatypes currently supported.

(Since INT is optimised around 32/64 bit, need not / should not say INT(<SIZE>), instead just say INT) (Auto-increment is supported)



New and Upcoming Features

Following are extracted from Brian's Blog Post

Authorization with LDAP

Planned for Cherry milestone.
Drizzle will have direct support for LDAP where Drizzle will be able to fetch authorization informaiton from LDAP.
External http server and HTTP authentication can be used to authenticate to access Drizzle

Freeing Schema / Database from filesystem directories

Schema is a real objects and not linked to filesystem directories.
All Metadata about Schema and Tables are now stored inside the storage engine as google proto messages.
Best side effect is now DDL can be part of the transaction and crash safe.
In near future you may be even able to point Drizzle to an existing database like embedded innodb or Cassandra like NoSQL database or a Cloud Service. New TableIdentifier also add to it as it talks in terms of database objects like SchemaName or TableName instead of a filesystem path.

New communication Protocol

Current protocol defaults to MySQL on port 3306, but the new protocol (which under heavy development) will be using port 4427.

Embedded Innodb

Drizzle will be moving to InnoDB Embedded Server instead of the InnoDB plugin. and is being developed by Stewart Smith
Embedded InnoDB has a very small footprint (around 800K) but is ACID compliant with support for Transactions.
With Embedded InnoDB, Drizzle inherited many features used to monitor the configuration and performance of InnoDB
Compared to the InnoDB plugin which is used currently in Drizzle and MySQL, Embedded InnodDB will use new storage engine APIs which is very clean and efficient. For more information:
DATA_DICTIONARY.INNODB_CONFIGURATION :- Provides informaiton about the configuration parameters.
DATA_DICTIONARY.INNODB_STATUS :- Provides Innodb Status information

New Generation Storage Engine APIs

Complete Re-thinking is done for a much cleaner and simple interface to accommodate new storage engines. Drizzle development team is designing the new interface / API from stratch using the lessons they learned so far with Drizzle and its ancestor - MySQL.
Drizzle Developers are considering all valuable feedback from storage engine developers and community aswell.
For further Reading please refer Jay Pipe's blog post

Query Rewrites

Allows Drizzle to use full potential of Storage Engines. In the future, database views will be using this feature.

New Data Dictionary (data_dictionary) schema

New Data Dictionary is providing lots of information for DBAs without much overhead of the legacy systems.
few are:
TABLE_DEFINITION_CACHE and
TABLE_CACHE
COLUMNS


Last Updated : Jobinau 10:42, 10 March 2010 (UTC)