Posts Tagged ‘xtradb’

MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS

You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

(note: give the mirrors some hours to sync up)

Quick overview

  • See the Release Notes for relevant bugfixes.
  • Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview).
  • 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), including on CentOS 5 (no separate “compat” RPM required).
  • This release for the first time also has packages (in YUM repo) for RHEL/CentOS 5. The MariaDB RPMs should purposely conflict with any 5.0, as well as any 5.1 of different origin, so that you consciously have to choose to upgrade and won’t accidentally end up for instance automatically upgrading from 5.0 to 5.1. We say should because while we tested various scenarios, the real world is bound to teach us more. Just be cautious, and please file bugs if you spot anything weird.
  • We didn’t build RHEL/CentOS 4 RPMs, because it originally came with MySQL 4.1 which is ancient, this means that other packages on that system have a dependency on libmysqlclient.so.14. If you do have a need for RHEL 4 packages, please let us know.
  • Generic Linux binary tarballs and the base source tarball to create all builds are also available, although to recreate one of the packages it’s easiest to use the relevant source package.

Please enjoy, and if you encounter any problems, file bugs with OurDelta or MariaDB on Launchpad.

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

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

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: , , , , , , , , , , , , , , , ,

Building 5.1.38-maria packages

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)

Tags: , , , , , ,