Archive for October, 2009

MariaDB 5.1 packages for Debian and Ubuntu

You can now apt-get your way to MariaDB 5.1, courtesy of OurDelta and in close cooperation with Monty Program Ab. To get started, simple follow the info on the Debian and Ubuntu pages.

Quick overview

  • For MariaDB we use different repository directories to ensure that you can’t accidentally upgrade or revert major versions without you explicitly choosing to do so.
  • At this point we have Ubuntu Hardy, Intrepid, Jaunty and Karmic for you, as well as Debian 4 (Lenny). Etch (Debian 4) is waiting on a small fix (thanks to Antony Curtis for helping with that).
  • The package names start with mariadb*, except for mysql-common which has a hard dependency elsewhere in the Debian/Ubuntu environment.
  • The binaries and directories are generally called mysql* although there are some Maria engine command line tools as well.
  • Apart from possible build glitches and bugs, this is a drop-in replacement for stock MySQL 5.1
  • If you are upgrading from 5.0, please review the upgrade information first before diving in.
  • The packages take care of backward compatibility with the older .so.15 client library (5.1 has .so.16)
  • MariaDB includes these new/replacement storage engines: XtraDB (the enhanced InnoDB plugin, by Percona) and PBXT (by Primebase Technologies).
  • Monty has merged/rewritten the microslow patch, so (most of) the detail/filtering you’ve become used to from the 5.0 OurDelta builds are there. All the Percona InnoDB patches are of course in the XtraDB plugin.
  • For Debian/Ubuntu, you will find a nice baseline my.cnf that, among other sane settings, defaults to InnoDB and strict mode by default – just like the Windows config wizard has done for a few years already.
  • The GRAPH computation engine didn’t quite make this build, but if you’d like us to build the plugin library for you for any of these distros/architectures, just ask. For DIY, you can just grab the exact source tarball we used to build the MariaDB packages, compile the plugin against it from the launchpad repo and copy the .so library to the plugin directory. Instructions are in the docs and the engine/INSTALL file.

Lots more to tell, but that would make it not be a quick overview ;-)

Please enjoy, and if you encounter any problems, file bugs with OurDelta or MariaDB. Don’t worry about picking the right project, if you get it wrong Launchpad lets us toss it across, and some bugs actually require fixes on both ends so they get attached to both!

If you’d like to keep up to date about MariaDB developments, there is a Planet MariaDB. If you create a feed relevant for MariaDB, you can submit it through the site.

Tags: , , , , , , , , , , , , , , , ,

OurDelta 5.0.86-d10-Sail sources/binaries with OQGRAPH Engine

These are now available for download from

For the GRAPH Engine documentation, see http://openquery.com/graph/doc. It’s not another general purpose engine, it’s a computation engine. Different beast altogether, but darn useful!

Since it’s new code, it’s only in the -Sail patchset (bleeding edge).

Tags: , , ,

Hidden tests of the MySQL test suite

Some of you may have run the mysql-test-run tool which is the MySQL test suite. But did you know there are actually multiple suites? If you just run the tool, you don’t get everything!

Check out the mysql-test/suites subdirectory. That’s all the stuff you don’t get when just running the tool normally. If you take a peek at the Makefiles, you will find a target test-bt (build team) which shows the extra calls and parameters for the additional suites.

OurDelta has had some interesting cases where a build that’s otherwise ok would fail when users tried the test suite on their installation. We reckon such a test should definitely pass, and thus we had some more homework to do. So now OurDelta builds with as many tests as exist enabled, on all platforms and architectures. Slow yes, but that’s not an argument to not test something, right? Failing tests are often indicative of other issues, so at the very least they merit some attention.

For instance… we found that on some platforms, the default distro packages are actually broken in fairly interesting ways. The testsuite in particular falls victim to this, making one wonder whether the distros actually test what they build, and which tests they do.

Tags: , , ,