Jan Walraven
DevOps



Categories:
  • Arduino (2)
  • CSS (3)
  • Docker (10)
  • ESXi (1)
  • Git (4)
  • Javascript (6)
  • Linux (31)
  • Mac (6)
  • Magento (4)
  • Mysql (13)
  • PHP (9)
  • Zend framework 2 (9)
  • Posted on June 25, 2012

    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