OurDelta - Builds for MySQL

OurDelta build for MySQL 5.0.67 with patchset d7 is now available, in source (new!) and packaged binaries for RHEL/CentOS 4 and 5, Debian 4.0 Etch, Ubuntu 8.04 LTS (Hardy) and (new!) Ubuntu 8.10 (Intrepid).

If you already installed the OurDelta repository information, yum update or apt-get upgrade will install the updated packages for you. Please do review the special notes on backward compatibility below.

Fixes & Additions:

• Fixed up all backward compatibility and reserved keyword issues. You can now drop in an OurDelta build to replace a stock version. Generally this merely involved some minor changes to various patches; however Arjen worked on the MicroSlow patch so that it now accepts and returns fractional seconds. This makes it backward compatible with the stock MySQL. Percona has indicated it will also move to this new version of the patch.
• Note: if you are upgrading from the OurDelta 5.0.67.d6 build, or any of the earlier Percona builds, you will need to adjust your long_query_time from microseconds to fractional seconds. (This should be the only time we needed to do this, e.g. break something to unbreak things
• Added Mirrored Binlog and Fast Master Promotion patches (by Google, extracted by Percona).
• Added KILL IF IDLE and InnoDB Freeze patches (by Google, extracted by David Stainton, Spinn3r), now in a public build for the very first time!
• Added updated “innodb_rw_locks” patch (by Yasufumi Kinoshita); only in -Sail binary.
• Added new “adaptive flush of InnoDB buffer pool” patch (by Percona); only in -Sail binary.
• Bugfix “variables out-of-bounds on 32-bit” aka BIG_TABLES (launchpad#284123, mysqlbug#35346) by Antony Curtis.
• Bugfix “mysqld_safe open_files_limit” (launchpad#290190, mysqlbug#40368) by Erik Ljungstrom.
• Improved build process: creating patched source tarballs once, then feeding these into the various build machines. This means we now have those same source tarballs also available for you to download, just in case you wish to build them for another platform! Lots of script magic and time by Peter Lieverdink.
• All distro packages now also have the appropriate source packages available.
• Ubuntu 8.10 (Intrepid) builds added.
• RHEL/CentOS release RPM: further simplifies setup for YUM, with automatic mirrors and GPG key. Thanks Steve Walsh for that contribution!
• More documentation for each feature so that you know exactly which new configuration options and SQL commands you get, and how they work.
• All pages on the website now accept comments, so it’s even easier to provide corrections and other feedback on specific content pages and posts. Not intended for reporting bugs.

Build for Debian Etch done and available, simply click to the new Debian page for the info to set up your repo. Thanks to Peter Lieverdink (cafuego on the #ourdelta IRC channel) for the fast work!

Your interest (from 53 different countries according to Google Analytics!) and response has been great! Among the feedback, saw a few bug reports on minor issues in the packaging, most of which have already been addressed for the next build (bug handling progress is all visible on Launchpad). And discussion about various patches that are “around”; some mails came to people directly but we try to encourage using the oursql-developers team mailing list.

With the build system, repos, patches and launchpad sorted, we can release! First up is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite

• RHEL/CentOS 4.6/5.2 RPMs and YUM repo info
• Ubuntu Hardy DEBs and apt-get repo info

Other useful links:

• Launchpad project and patch repo
• Developer team and mailing list (do join!)
• Bug handling

Now, this being a first release into the wild, there are bound to be some glitches. Most likely in the packaging (and the repo instructions) but possibly also in the builds themselves. Trust comes over time, right? That’s ok, you can help! Simply report any issue using the above bugs link! And please do report success also, although that’s done best through the mailing list or a blog.

In case you’re wondering, 5.1 and beyond are also coming, with more interesting goodies! And you can help! Your first step is to join the mailing list.

A big thanks to everybody involved so far, this was a great team effort! (see the about page for a non-exhaustive list)