Installation of TOKUDB database engine under Linux system CentOS6.5

Tokudb is an open source project on MySQL data Engine, and its features are described in three main points:

1, high compression ratio, the official claim can reach 1:12.

2, high Insert performance, the official said at least 9 times times higher than the InnoDB.

3, can be added online index and field, fast.

I installed the tokudb on a system with CentOS6.5 installed, and the following is a record of the process:

Installing TOKUDB is best used with Percona developed by the enhanced MySQL database =. =, so first uninstall the MySQL installed on the original machine,

Rpm–qa | grep –i Mysql;rpm–e–nodeps [package name];

The official website Https://www.percona.com/doc/percona-tokudb/installation.html#replace offers several different installation methods. I used the RPM package to install the method.

1. Install the Percona warehouse (can be used to view the Percona software available for download.)

Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/ percona-release-0.1-3.noarch.rpm

RHel/centos 5 does not support direct installation from a remote server, you can download and install it first:

wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/ percona-release-0.1-3.noarch.rpmRPM-IVH percona-release-0.1-3. noarch.rpm

2. View the packages in the Percona warehouse:

Yum grep Percona

3. Download the latest version of Percona-server

Yum Install percona-server-server-

4. At this point, you can view the RPM packages downloaded to the Local:

$ls*. Rpmpercona-server- About-debuginfo-5.6. --rel73.1. El6.x86_64.rpmPercona-server-client- About-5.6. --rel73.1. El6.x86_64.rpmPercona-server-devel- About-5.6. --rel73.1. El6.x86_64.rpmPercona-server-server- About-5.6. --rel73.1. El6.x86_64.rpmPercona-server-shared- About-5.6. --rel73.1. El6.x86_64.rpmPercona-server-test- About-5.6. --rel73.1. el6.x86_64.rpm

5. Installation

can be done by

RPM–IVH *.rpm

All installed. You can also install them separately.

6. At this point, the MySQL database can be started by servicemysql start. If the TOKUDB package is installed above, by:

ps_tokudb_admin–enable–uroot–p [Password]

You can see TOKUDB's current support situation.

CheckingifPercona Server is running with Jemalloc enabled ...grep:/proc/5440/Environ:permission denied>>Percona Server is running with JEMALLOC enabled. Checking transparent huge pages status on the system ...>>Transparent Huge pages is currently disabled on the system. CheckingifThp-setting=never option is already setinchConfigfile...>> Option Thp-setting=never is not setinchThe Configfile.>> (needed onlyifTHP isn't disabled permanently on the system) Checking tokudb plugin Status ...>> tokudb plugin is installed.

If Jemalloc is not installed, you will need to install Jemalloc

Yum Install Jemalloc

Tokudb also needs to close Transparent huge pages by executing:

echo never >/sys/kernel/mm/transparent_hugepage/echo never >/sys/kernel/mm/ Transparent_hugepage/defrag

At this point, the TOKUDB should be installed. Enter the database to see if there are any tokudb in the engine that appears through show engines.

And can be done by:

Select @ @tokudb_version

View the version of Tokudb

7.percona of uninstallation.

A. Shutting down the running MySQL service

Service MySQL Stop

B.remove Package

Yum Remove *percona-server*

C. Deleting data information and configuration information

rm –rf/var/lib/mysqlrm

Installation of TOKUDB database engine under Linux system CentOS6.5