Drizzle 2011-03-14

It's been a long and crazy road to get to this point and the team would like to thank everyone that has helped us get here.

For quick summaries of what has been going on with the team, please check out Andrew Hutching's terrific 'Last Week In Drizzle' series - http://www.linuxjedi.co.uk/?tag=last-week-in-drizzle

For a general rundown of how we differ from MySQL, see here - http://docs.drizzle.org/mysql_differences.html

Here is a partial list of what you can find inside:

* Documentation is sphinx-based and available in-tree or online. It should be noted that they are licensed under Creative Commons! http://docs.drizzle.org/index.html
* Replication solutions will be log based. Both file-based and innodb-table based versions of the log are available and have been heavily tested / validated.
* Native replication available via the slave plugin. This solution utilizes the innodb-based replication log and has been subjected to significant testing.
* Easy migration from MySQL systems via the Drizzledump tool. - http://docs.drizzle.org/clients/drizzledump.html#mysql-migration-using-drizzledump
* Drizzleadmin tool - used to bypass the protocol’s max-connections setting to do tasks such as killing queries or clients. http://docs.drizzle.org/clients/drizzleadmin.html
* libdrizzle is included in the tree (no longer a separate project) and is BSD licensed
* ANSI-compliant INFORMATION_SCHEMA - http://krow.livejournal.com/697463.html
* DATA_DICTIONARY for custom, Drizzle-specific tables and data
* Innodb tables by default
* MyISAM available (temporary tables)
* Removed archive, blackhole, csv, and other engines (these can be reintroduced if faced with enough demand).
* HailDB engine = embedded Innodb, but better - http://www.haildb.com/2010/04/15/launching-haildb/
* Pluggable authentication - http://ronaldbradford.com/blog/understanding-drizzle-authentication-options-part-1-2010-03-12/
* SQLAlchemy integration - we now pass their test suite and use it as part of our continuous build and integration system
* Significant performance improvements
* Initial work for catalogs
* And tons more!