A Lightweight SQL Database for Cloud Infrastructure and Web Applications

Drizzle 2011-03-14

Milestone information

Project:
Drizzle
Series:
7.0
Version:
2011-03-14
Released:
2011-03-15  
Registrant:
Patrick Crews
Release registered:
2011-03-15
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
33 Andrew Hutchings, 2 Brian Aker, 20 David Shrewsbury, 2 Joe Daly, 10 Monty Taylor, 11 Patrick Crews, 3 Stewart Smith, 10 marisa plumb
Blueprints:
2 Implemented
Bugs:
2 Won't Fix, 87 Fix Released

Download files for this release

After you've downloaded a file, you can verify its authenticity using its MD5 sum or signature. (How do I verify a download?)

File Description Downloads
download icon drizzle7-2011.03.13.tar.gz (md5, sig) source tarball - version 2011.0.13 3,309
last downloaded 3 weeks ago
Total downloads: 3,309

Release notes 

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!

Changelog 

This release does not have a changelog.

2 blueprints and 89 bugs targeted

Blueprint Priority Assignee Delivery
Native Replication 4 High David Shrewsbury  11 Implemented
Allow micro and nano-second timestamps 3 Medium David Shrewsbury  11 Implemented
Bug report Importance Assignee Status
728260 #728260 ALTER TABLE FORCE exists (and does nothing useful) 5 Low Stewart Smith  4 Won't Fix
728892 #728892 libdrizzle should translate errno 5 Low Andrew Hutchings  4 Won't Fix
729372 #729372 Semicolon causing slave plugin to stop replicating 2 Critical David Shrewsbury  10 Fix Released
729372 #729372 Semicolon causing slave plugin to stop replicating 2 Critical David Shrewsbury  10 Fix Released
731189 #731189 REPLICATE=FALSE broken 2 Critical Brian Aker  10 Fix Released
731189 #731189 REPLICATE=FALSE broken 2 Critical Brian Aker  10 Fix Released
731738 #731738 multi message statements replayed out of order on slave 2 Critical Joe Daly  10 Fix Released
731738 #731738 multi message statements replayed out of order on slave 2 Critical Joe Daly  10 Fix Released
732849 #732849 drizzledump handles multi-part indexes incorrectly 2 Critical Andrew Hutchings  10 Fix Released
732849 #732849 drizzledump handles multi-part indexes incorrectly 2 Critical Andrew Hutchings  10 Fix Released
720433 #720433 'replication' schema being used vs. actual schema for certain INSERTs with the slave-plugin 3 High David Shrewsbury  10 Fix Released
720433 #720433 'replication' schema being used vs. actual schema for certain INSERTs with the slave-plugin 3 High David Shrewsbury  10 Fix Released
722773 #722773 select against TIME type broken 3 High Andrew Hutchings  10 Fix Released
722773 #722773 select against TIME type broken 3 High Andrew Hutchings  10 Fix Released
724451 #724451 drizzle_escape_string doesn't handle blob data correctly 3 High Andrew Hutchings  10 Fix Released
724451 #724451 drizzle_escape_string doesn't handle blob data correctly 3 High Andrew Hutchings  10 Fix Released
726741 #726741 Do not pass FLUSH or ANALYZE through replication stream 3 High David Shrewsbury  10 Fix Released
726741 #726741 Do not pass FLUSH or ANALYZE through replication stream 3 High David Shrewsbury  10 Fix Released
726784 #726784 dbqp not properly resetting itself after a test failure 3 High Patrick Crews  10 Fix Released
726784 #726784 dbqp not properly resetting itself after a test failure 3 High Patrick Crews  10 Fix Released
728314 #728314 mysql socket file not created 3 High Andrew Hutchings  10 Fix Released
728314 #728314 mysql socket file not created 3 High Andrew Hutchings  10 Fix Released
728581 #728581 need to define boost deprecation flag to support 1.46 3 High Monty Taylor  10 Fix Released
728581 #728581 need to define boost deprecation flag to support 1.46 3 High Monty Taylor  10 Fix Released
728667 #728667 drizzle client needs to send unix username 3 High Andrew Hutchings  10 Fix Released
728667 #728667 drizzle client needs to send unix username 3 High Andrew Hutchings  10 Fix Released
728990 #728990 libdrizzle: Re-using a result struct without freeing causes infinite loop 3 High Andrew Hutchings  10 Fix Released
728990 #728990 libdrizzle: Re-using a result struct without freeing causes infinite loop 3 High Andrew Hutchings  10 Fix Released
729340 #729340 Need drizzledump to output InnoDB replication log information for slave provisioning 3 High Andrew Hutchings  10 Fix Released
729340 #729340 Need drizzledump to output InnoDB replication log information for slave provisioning 3 High Andrew Hutchings  10 Fix Released
730644 #730644 libdrizzle: drizzle_query_run_all re-uses result struct 3 High Andrew Hutchings  10 Fix Released
730644 #730644 libdrizzle: drizzle_query_run_all re-uses result struct 3 High Andrew Hutchings  10 Fix Released
730936 #730936 Slave plugin needs an option to indicate where to begin retrieving messages from the master replication log 3 High David Shrewsbury  10 Fix Released
730936 #730936 Slave plugin needs an option to indicate where to begin retrieving messages from the master replication log 3 High David Shrewsbury  10 Fix Released
732061 #732061 need a way to execute dtr test cases with the slave plugin 3 High Patrick Crews  10 Fix Released
732061 #732061 need a way to execute dtr test cases with the slave plugin 3 High Patrick Crews  10 Fix Released
732219 #732219 drizzle-automation having issues with the auth plugin, needs to specify a user 3 High Patrick Crews  10 Fix Released
732962 #732962 drizzledump doesn't preserve replicate=false 3 High Andrew Hutchings  10 Fix Released
732962 #732962 drizzledump doesn't preserve replicate=false 3 High Andrew Hutchings  10 Fix Released
734033 #734033 slave.basic test failing on OSX 3 High Patrick Crews  10 Fix Released
734033 #734033 slave.basic test failing on OSX 3 High Patrick Crews  10 Fix Released
693253 #693253 drizzleadmin needs a manpage 4 Medium marisa plumb  10 Fix Released
693253 #693253 drizzleadmin needs a manpage 4 Medium marisa plumb  10 Fix Released
717706 #717706 Debian Dependencies 4 Medium marisa plumb  10 Fix Released
717706 #717706 Debian Dependencies 4 Medium marisa plumb  10 Fix Released
722855 #722855 Can't run drizzle on FreeBSD 8.1 4 Medium Monty Taylor  10 Fix Released
722855 #722855 Can't run drizzle on FreeBSD 8.1 4 Medium Monty Taylor  10 Fix Released
723669 #723669 string compartive like doc error 4 Medium marisa plumb  10 Fix Released
723669 #723669 string compartive like doc error 4 Medium marisa plumb  10 Fix Released
725236 #725236 randgen transaction log tests need to be implemented using dbqp / randgen 4 Medium Patrick Crews  10 Fix Released
725236 #725236 randgen transaction log tests need to be implemented using dbqp / randgen 4 Medium Patrick Crews  10 Fix Released
725238 #725238 innodb.replication-log options not using zero_tokens 4 Medium Andrew Hutchings  10 Fix Released
725238 #725238 innodb.replication-log options not using zero_tokens 4 Medium Andrew Hutchings  10 Fix Released
726914 #726914 Need to update dbqp randgen config files for slave_plugin 4 Medium Patrick Crews  10 Fix Released
726914 #726914 Need to update dbqp randgen config files for slave_plugin 4 Medium Patrick Crews  10 Fix Released
727440 #727440 RedHat docs fixes needed 4 Medium marisa plumb  10 Fix Released
727440 #727440 RedHat docs fixes needed 4 Medium marisa plumb  10 Fix Released
727455 #727455 need to explain versioning & release naming conventions in a new doc 4 Medium marisa plumb  10 Fix Released
727455 #727455 need to explain versioning & release naming conventions in a new doc 4 Medium marisa plumb  10 Fix Released
729397 #729397 Slave plugin producer/IO thread needs optimized 4 Medium David Shrewsbury  10 Fix Released
729397 #729397 Slave plugin producer/IO thread needs optimized 4 Medium David Shrewsbury  10 Fix Released
730202 #730202 configure doesn't work with python3 is in the path as python 4 Medium Monty Taylor  10 Fix Released
730202 #730202 configure doesn't work with python3 is in the path as python 4 Medium Monty Taylor  10 Fix Released
730312 #730312 sphinx setup breaks hard on 0.6 4 Medium Monty Taylor  10 Fix Released
730312 #730312 sphinx setup breaks hard on 0.6 4 Medium Monty Taylor  10 Fix Released
731293 #731293 max-commit-id should persist value in slave 4 Medium David Shrewsbury  10 Fix Released
731293 #731293 max-commit-id should persist value in slave 4 Medium David Shrewsbury  10 Fix Released
709500 #709500 Incorrect result for IN/ANY subquery with HAVING condition 5 Low Andrew Hutchings  10 Fix Released
709500 #709500 Incorrect result for IN/ANY subquery with HAVING condition 5 Low Andrew Hutchings  10 Fix Released
712194 #712194 Add default plugin configs to source 5 Low Monty Taylor  10 Fix Released
712194 #712194 Add default plugin configs to source 5 Low Monty Taylor  10 Fix Released
720501 #720501 starting slave with relative path or non existant slave.config-file does not error out 5 Low David Shrewsbury  10 Fix Released
720501 #720501 starting slave with relative path or non existant slave.config-file does not error out 5 Low David Shrewsbury  10 Fix Released
722981 #722981 PBMS Warnings, Fedora 14 5 Low Andrew Hutchings  10 Fix Released
722981 #722981 PBMS Warnings, Fedora 14 5 Low Andrew Hutchings  10 Fix Released
722988 #722988 wrong message for drizzled --verbose 5 Low Andrew Hutchings  10 Fix Released
722988 #722988 wrong message for drizzled --verbose 5 Low Andrew Hutchings  10 Fix Released
728288 #728288 enum_query_type is unused 5 Low Stewart Smith  10 Fix Released
728288 #728288 enum_query_type is unused 5 Low Stewart Smith  10 Fix Released
728432 #728432 Remove write_bin_log() since it is no longer used. 5 Low David Shrewsbury  10 Fix Released
728432 #728432 Remove write_bin_log() since it is no longer used. 5 Low David Shrewsbury  10 Fix Released
729425 #729425 mysql-unix-socket-protocol plugin needs documenting 5 Low Andrew Hutchings  10 Fix Released
729425 #729425 mysql-unix-socket-protocol plugin needs documenting 5 Low Andrew Hutchings  10 Fix Released
729642 #729642 libdrizzle should have a flag to enable multi-statement 5 Low Andrew Hutchings  10 Fix Released
729642 #729642 libdrizzle should have a flag to enable multi-statement 5 Low Andrew Hutchings  10 Fix Released
731447 #731447 The filtered_replicator plugin needs documentation 5 Low David Shrewsbury  10 Fix Released
731447 #731447 The filtered_replicator plugin needs documentation 5 Low David Shrewsbury  10 Fix Released
732477 #732477 Installing from source doc bzr instructions fix 5 Low Andrew Hutchings  10 Fix Released
732477 #732477 Installing from source doc bzr instructions fix 5 Low Andrew Hutchings  10 Fix Released
This milestone contains Public information
Everyone can see this information.