Posts Tagged ‘innodb’

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

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