How to install Mariadb 5.5.x with PBXT on Centos 5.x and 6.x

This manual will explain howto install mariadb 5.5.x with PBXT on centos 5.x or centos 6.x

Requirements:

Install the following packages:

yum install gperf-devel rpm-devel rpm-build rpmdevtools libdbi bzr
yum install libtool bison-devel ncurses-devel zlib-devel
yum install libaio-devel
yum install ncurses-base ncurses-static

Cmake

Because the default cmake is too old, we will install it from source.

rpm -e cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.8.tar.gz
tar -zxf cmake-2.8.8.tar.gz
./configure --prefix=/usr/
gmake
make install

MariaDB

Download the latest version at http://downloads.mariadb.org/mariadb/5.5/

generate RPM’s with PBXT

The following commando will generate RPM’s with PBXT. When using Centos 6, please change centos5 to centos6.

tar -zxf mariadb-5.5.25.tar.gz
cd mariadb-5.5.25
cmake -DRPM=centos5 -DWITH_PBXT_STORAGE_ENGINE=1 .
make package

Configure Mysql

To enable PBXT after installing the RPM packages, edit /etc/my.cnf.d/server.cnf and add:

[mysqld]
pbxt=on