Percona welcomes Drizzle 7.1

The Drizzle team has published the first Drizzle 7.1 stable release. The announcement on the Drizzle blog covers some of the major improvements in this release over the previous stable release, Drizzle 7.0. I plan to write a variety of blog posts on each of the new features over the coming weeks. Major features include:

• Multi sourced replication
• XtraBackup included
• IPv6 data type
• ZeroMQ plugin
• Log output to syslog is enabled by default
• Updated DEB and RPM packages
• Query log plugin and auth_schema
• JS plugin: execute JavaScript code as a Drizzle function
• HTTP JSON API (experimental)
• Some of the Percona InnoDB patches have been merged

Since Drizzle 7.0 (which was released last year), there have been over 3,500 commits to Drizzle from around 50 contributors (no doubt the translations add more too).

Some interesting statistics about this Drizzle release:

• The diffstat from the previous stable release is: 3891 files changed, 473733 insertions(+), 210435 deletions(-)
• The size of the Drizzle kernel (drizzled directory in the source) has shrunk from 149,586 to 146,454 lines of code (according to sloccount).
• Out of 78 plugins there are only ten that have more than 1,000 lines of code. The remaining 68 plugins are not all trivial either, they include: authentication via PAM, authentication via HTTP, various DATA_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication via LDAP. This shows that major pieces of functionality can be implemented in relatively small amounts of code.

Installing Drizzle 7.1.33-stable

The source tar package is available from the Drizzle Launchpad download area. Please see the Drizzle manual on how to install Drizzle 7.1.33-stable from source tar package.

The Ubuntu packages are available from the Drizzle PPA. Instructions on how to install from the PPA are in the Drizzle manual.

CentOS 6 packages are available from download.drizzle.org. Instructions on how to install them with yum are in the Drizzle manual.

Note: For Drizzle 7.1.33-stable, only 64-bit packages were built for RedHat/Centos.