Posts Tagged ‘ourdelta’
Until now, MariaDB 5.2 was lacking a yum repository for easy installs and upgrades. It is now available, thanks to OurDelta.
Just follow our very simple installation instructions.
MySQL 5.0.87-d10 OurDelta builds are now available (32 and 64-bit):
- Debian: Etch (4), Lenny (5)
- Ubuntu: Hardy (8.04), Intrepid (8.10), Jaunty (9.04), Karmic (9.10)
- RHEL/CentOS: 4, 5
- Binary tarballs: generic Linux, built on Ubuntu Hardy
Then please contact us: i n f o (at) o u r d e l t a (dot) o r g
What are the requirements? Having a server with HTTP access and no hassles with low traffic limits. At this stage you’ll need about 5GB disk space, and you’ll use rsync to sync from the master servers (we’ll provide you with a script to help with that). Thanks!
With the new releases the traffic is up (not surprising) and while our existing mirrors appear to be doing ok so far, it’ll be good to have more available before we run into capacity or speed problems. We also haven’t yet split for geographic location, that too becomes a possibility with more mirrors.
- 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.
These are now available for download from
- Binaries: http://master.ourdelta.org/bin/
32 and 64-bit Linux tarballs
32 and 64-bit OSX tarballs and DMGs
- Source tarball: http://master.ourdelta.org/src/
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).
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.
We’ve been able to do MySQL 5.1 binary tarballs for a bit now (great working together with Kristian Nielsen of Monty Program), but packages are bit more tricky. Peter has been working on Debian/Ubuntu while I’ve focused on RH/CentOS. The following is from an OurDelta (trial build run) RPM install on CentOS 5 x64:
$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.38-maria-beta1-ourdelta (OurDelta - http://ourdelta.org/) mysql> CREATE TABLE test.t1 (i int) ENGINE=PBXT; Query OK, 0 rows affected (0.10 sec) mysql> SHOW CREATE TABLE test.t1\G *************************** 1. row *************************** Table: test.t1 Create Table: CREATE TABLE `test.t1` ( `i` int(11) DEFAULT NULL ) ENGINE=PBXT DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> INSERT INTO test.t1 values (1); Query OK, 1 row affected (0.03 sec) mysql> SELECT * FROM test.t1; +------+ | i | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> SHOW ENGINE PBXT STATUS\G *************************** 1. row *************************** Type: PBXT Name: Status: 090929 23:05:41 PBXT 1.0.08d RC STATUS OUTPUT Record cache usage: 65675 Record cache size: 33554432 Record cache high: 65675 Index cache usage: 0 Index cache size: 33554432 Log cache usage: 295128 Log cache size: 16756712 Data log files: 1 row in set (0.00 sec)
So yes, PBXT is fully in there, as is XtraDB (the enhanced InnoDB plugin).
mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_version'; +----------------+----------+ | Variable_name | Value | +----------------+----------+ | innodb_version | 1.0.3-6a | +----------------+----------+ 1 row in set (0.00 sec)
Last year, Erik Ljungstrom (sensei in the #ourdelta IRC channel on Freenode) created patch for a bug Arjen identified with the handling of (among others) the open-files-limit option; the patch was first included in the OurDelta build of MySQL 5.0.67.
Now, Sun engineer Guilhem Bichot has committed the (modified) patch into the 6.0-maria tree, so it should appear in 6.0 and potentially 5.4. That’s good.
See http://bugs.mysql.com/40368 for details and history.
We had to apply a weird tweak as the default Ubuntu Jaunty packages are named something like 5.1.30really-5.0.xx. Several people have filed bugs on it with Ubuntu on Launchpad.
What I suspect happened (unconfirmed!) is that Canonical was contemplating putting 5.1 into Jaunty, had it in a beta but went back to 5.0 before release. Since downgrading by version number is a manual process in apt-get, the above hack allows a downgrade that looks like an upgrade…
Our original Jaunty build worked fine if you were starting from scratch, however an upgrade from the default MySQL on Jaunty would not work. Peter has built 5.1.30really-5.0.77-d8-ourdelta, which upgrades happily from the default Jaunty install or any other earlier install (such as from Intrepid). If you upgrade from an earlier Ubuntu version, do make sure you fix up your /etc/apt/sources.list.d/ourdelta.list with the release name jaunty. Easy as. Then run apt-get update then apt-get upgrade.
OurDelta builds of MySQL 5.0.77-d8 for Ubuntu 9.04 (Jaunty) builds are done, thanks to some smart and fast work by Peter. The packages are getting copied to the main site right now, and the mirrors should be up-to date within half a day or so.