Drizzle

Drizzle source tarball, version 2011.02.10 has been released.  We are proud to announce that this is an RC (Release Candidate) release.

With a GA not too far away, we would greatly appreciate folks helping us to check things out.  We have been working hard on a number of features and would like your feedback.

• New BOOLEAN type
• New UUID type
• Drizzle can now fork to background via --daemon: https://bugs.launchpad.net/drizzle/+bug/565053
• NOTE: Cartesian joins no longer work and will throw an error - this might break some applications.  They can still be achieved via CROSS JOIN or through the use of a WHERE clause.  It was put in place to prevent runaway queries.
• Innodb transaction log is working and tested.  Both the file-based and innodb-based logs are available.
• Continued work on system variables
• Removed lint.am file as Drizzle no longer uses it
• Continued work on catalogs
• Continued work on our documentation
• Various other bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2011.02.09 has been released.

We'd like to thank everyone that has been providing feedback and bug reports -  please keep them coming!  We are making some huge strides in the quality and availability of our documentation so please be sure to check it out and write up a bug if something is missing or wrong : )
We're also quite excited to have a working SQLAlchemy dialect!  We plan on incorporating more of that project's tests into our own build system soon.  Thanks to Monty Taylor for making this happen.

In this release:

• Continued progress on catalogs.
• HailDB now can get rec_per_key index statistics (via HailDB 2.3 cairo API)
• HailDB now supports ANALYZE for updating table stats
• drizzledump has added --my-data-is-mangled for handling certain MySQL charset migration issues
• SQLAlchemy dialect is now available for Drizzle (merged into SQLAlchemy main)
• new experimental test-runner, dbqp.py, is in the tree for testing.  test-run.pl remains in the tree as our standby while development continues.
• migrated unittests to boost + additional work on expanding them and their usage.
• various updates to our online documentation
• various other bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2011.01.08 beta has been released.

In this release:
* Bug blitz release 40+ fixes + several others closed out or pending release in the next tarball.

The Drizzle download file can be found here

HailDB source tarball, version 2.3.2 Cairo has been released.

This is a Developer Release.

In this release:

• HailDB source tarball, version 2.3.1 has been released.

• HailDB 2.3.1 - Baghdad release.

• This is a Developer Release.

The HailDB download files can be found here

Drizzle source tarball, version 2010.01.07 beta has been released.  This is the first Drizzle release of 2011 (aka the year of Drizzle!).

In this release:

• Clean up of drizzled command line options
• Refactored drizzleslap code - thanks to Vijay Samuel for tackling this : )
• Updated innobase plugin to be based on innodb 1.1.4 from MySQL 5.5.8
• All timers in Drizzle have been updated to be microsecond internally
• New TIME data type
• New BOOLEAN data type (storage is engine-dependent)
• New assert() function.  Evaluates an expression and errors out based on true/{false/NULL}
• New typeof() function.  Evaluates an expression and returns our internal type
• New result_type() function.  Returns the internal result type that is being used (ie STRING, INT, DECIMAL,...)
• updates to storage engine api and testing tool
• continued work on transaction log code
• various bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2010.12.06 beta has been released.

In this release:

• The InnoDB plugin is now based on innodb 1.1.3 from mysql 5.5.7
• New UUID data type
• Embedded InnoDB now supports ON DUPLICATE KEY UPDATE functionality
• HailDB can now send all messages to the drizzle logging plugins vs. just stderr
• Documentation additions and improvements
• Continued work on sys_var refactoring
• Continued improvements to the transaction log.  Two very tricky bugs have finally been killed thanks to David Shrewsbury.
• Several bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2010.11.04 has been released, just in time for Thanksgiving : )

This is a beta-quality release.

In this release:

• NOTE: Drizzle now recognizes mixed-case table names.  Previously, such names were converted to lower-case.  Now mixed-case is accepted and preserved, but previously created tables will still be lower-case.
• Updated innobase plugin to be based on innodb_plugin 1.0.9
• Added support for barriers.  These are objects that assist with coordinating several connections.  Please see the docs for more details
• New DATA_DICTIONARY table functions for user convenience:
  - USER_BARRIERS
  - USER_DEFINED_VARIABLES
  - USER_LOCKS
  - USER_SAVEPOINTS
• Additional debugging functionality for transaction_reader (utility for the transaction log)
• EXECUTE can now be CONCURRENT and with NO RETURN
• Continued code refactoring
• Various Bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2010.11.03 has been released.
This is our 3rd beta release.  Many thanks to everyone who keeps downloading and using the software.  We've seen an uptick in downloads and bug reports since going beta.  Please keep the feedback coming : )

In this release:

• NEW DEPENDENCY - We now require libboost-iostreams-dev
• Drizzle now listens on port 4427 by default (clients use that port by default as well).  This allows for Drizzle and MySQL to run using their default ports on the same machine
• We now support the MySQL UNIX Socket protocol. It is now possible to connect to a Drizzle server with a mysql command line client via sockets. Start the server with the option --protocol-mysql-unix-socket.path=/tmp/mysql.sock. You can then connect to the socket file via your mysql client.
• Added adjustable global upper cap for sort buffers. This is to limit the sum of all sort buffers across all running threads.  You can read more about this here and here
• Added additional information to drizzleslap output to assist with bug diagnosis
• Automated randgen tests of the transaction log
• Added several additional options to the transaction_reader utility to help a user view the transaction log contents
• Work on removing locks from table shares
• Continued work on catalogs
• Continued work on documentation
• Continued code cleanup / refactoring
• 30 bug fixes

The Drizzle download file can be found here

Drizzle source tarball, version 2010.10.02 has been released.

This is a beta-quality release.

Many thanks to everyone for the patches and bug reports.  Please keep them coming!

In this release:

• Added user locks
• Continued code cleanup and refactoring
• Removed two dead plugins (bad schedulers)
• Added documentation on replication
• Added options to the drizzled/messages/transaction_reader program, which allows us to convert transaction.log content into SQL: /path/to/transaction_reader path/to/transaction.log = SQL output of log contents.
  We can now:
  * view raw log ouput (rather than converted to SQL)
  * view contents of the log from a specific message onward
  * view the contents of a specific message
• Added UTF8 test cases for Tamil
• Added EXECUTE functionality:
  We can do:
  * SET @VAR = "SELECT 1";
  * EXECUTE @VAR;
  * EXECUTE "SELECT 1";

The Drizzle download file can be found here