{"id":308,"date":"2014-02-05T09:25:03","date_gmt":"2014-02-05T09:25:03","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=308"},"modified":"2014-02-05T09:25:03","modified_gmt":"2014-02-05T09:25:03","slug":"tokudb-installation-debian-7-2-x64","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=308","title":{"rendered":"TokuDB installation (Debian 7.2 x64)"},"content":{"rendered":"

„Pure“ MySQL is dead. Thanks to Oracle approach, thanks to very few inventions in last years (=versions). Among MariaDB there are few other players trying to attract customer. TokuDB<\/a> is from my opinion the best choice for mature storage engine.<\/p>\n

<\/p>\n

First surprise – TokuDB is supporting only 64-bit linux at this moment. Nah, no problem \ud83d\ude42<\/p>\n

j@debian:~\/install$ ls -la<\/strong><\/span><\/span>
\ntotal 287184<\/span>
\ndrwxr-xr-x\u00a0 2 j j\u00a0\u00a0\u00a0\u00a0\u00a0 4096 Feb\u00a0 4 15:53 .<\/span>
\ndrwxr-xr-x 28 j j\u00a0\u00a0\u00a0\u00a0\u00a0 4096 Feb\u00a0 4 10:17 ..<\/span>
\n-rwxrwx—\u00a0 1 j j 294061828 Feb\u00a0 4 15:23 mariadb-5.5.30-tokudb-7.1.0-linux-x86_64.tar.gz<\/span>
\nj@debian:~\/install$ <\/span><\/p>\n

Well, this package is typical .tar „portable“ solution. No installer, no binary files. I will follow 2 things from now – all actions will be done as root + i\u00b4m following QuickGuide.pdf (also downloadable from TokuDB site).<\/p>\n

Preparation phase<\/strong><\/p>\n

Creating new group dedicated to mysql, creating mysql user, creating home directory for TokuDB, extracting files from tar.gz into this directory:<\/p>\n

root@debian:~# groupadd -g 927 mysql<\/strong><\/span><\/span>
\nroot@debian:~# useradd -r -u 927 -g mysql mysql<\/strong><\/span><\/span>
\nroot@debian:~# mkdir -pv \/opt\/tokutek<\/strong><\/span><\/span>
\nmkdir: created directory `\/opt\/tokutek‘<\/span>
\nroot@debian:~# cd \/opt\/tokutek<\/strong><\/span><\/span>
\nroot@debian:\/opt\/tokutek# tar -xzf \/home\/j\/install\/mariadb-5.5.30-tokudb-7.1.0-linux-x86_64.tar.gz <\/strong><\/span><\/span><\/p>\n

Linking directory to mysql, changing ownership of all files within this directory:<\/p>\n

root@debian:\/opt\/tokutek# ls<\/strong><\/span><\/span>
\nmariadb-5.5.30-tokudb-7.1.0-linux-x86_64<\/span>
\nroot@debian:\/opt\/tokutek# ln -sv mariadb-5.5.30-tokudb-7.1.0-linux-x86_64 mysql<\/strong><\/span><\/span>
\n`mysql‘ -> `mariadb-5.5.30-tokudb-7.1.0-linux-x86_64′<\/span>
\nroot@debian:\/opt\/tokutek# cd mysql<\/strong><\/span><\/span>
\nroot@debian:\/opt\/tokutek\/mysql# chown -R mysql:mysql .<\/strong><\/span><\/span><\/p>\n

Copying my.cnf into \/etc directory + changes in this file:<\/p>\n

root@debian:\/opt\/tokutek\/mysql# cp -v support-files\/my-small.cnf \/etc\/my.cnf<\/strong><\/span><\/span>
\n`support-files\/my-small.cnf‘ -> `\/etc\/my.cnf‘<\/span>
\nroot@debian:\/opt\/tokutek\/mysql# nano \/etc\/my.cnf<\/strong><\/span><\/span><\/p>\n

Main configuration file is very messed up with comments in default. In production system my.cnf should not consist of any comments or not so long \ud83d\ude42 Followed by guide, i just inputed these new variables into [mysqld]<\/strong> section:<\/p>\n

datadir = \/var\/lib\/mysql<\/span><\/p>\n

basedir = \/opt\/tokutek\/mysql<\/span><\/p>\n

user = mysql<\/span><\/p>\n

Filling system tables in mysql:<\/p>\n

root@debian:\/opt\/tokutek\/mysql# scripts\/mysql_install_db –user=mysql<\/strong><\/span><\/span>
\nInstalling MariaDB\/MySQL system tables in ‚\/var\/lib\/mysql‘ …<\/span>
\nOK<\/span>
\nFilling help tables…<\/span>
\nOK<\/span>
\n…<\/span><\/p>\n

Linking and running mysql service finaly \ud83d\ude42<\/p>\n

root@debian:\/opt\/tokutek\/mysql\/support-files# ln -sv \/opt\/tokutek\/mysql\/support-files\/mysql.server \/etc\/init.d\/mysql<\/strong><\/span><\/span>
\n`\/etc\/init.d\/mysql‘ -> `\/opt\/tokutek\/mysql\/support-files\/mysql.server‘<\/span>
\nroot@debian:\/opt\/tokutek\/mysql\/support-files# service mysql start<\/strong><\/span><\/span>
\nStarting MySQL<\/span>
\n[ o. <\/span><\/p>\n

Checking that TokuDB is really running:<\/p>\n

j@debian:~$ ps -ef | grep mysql<\/strong><\/span><\/span>
\nroot\u00a0\u00a0\u00a0\u00a0\u00a0 3527\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 09:15 pts\/0\u00a0\u00a0\u00a0 00:00:00 \/bin\/sh \/opt\/tokutek\/mysql\/bin\/mysqld_safe –datadir=\/var\/lib\/mysql –pid-file=\/var\/lib\/mysql\/debian.pid<\/span>
\nmysql\u00a0\u00a0\u00a0\u00a0 3820\u00a0 3527\u00a0 0 09:15 pts\/0\u00a0\u00a0\u00a0 00:00:03 \/opt\/tokutek\/mysql\/bin\/mysqld –basedir=\/opt\/tokutek\/mysql –datadir=\/var\/lib\/mysql –plugin-dir=\/opt\/tokutek\/mysql\/lib\/plugin –user=mysql –log-error=\/var\/lib\/mysql\/debian.err –pid-file=\/var\/lib\/mysql\/debian.pid –socket=\/tmp\/mysql.sock –port=3306<\/span>
\nj\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4056\u00a0 3458\u00a0 0 10:14 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep mysql<\/span><\/p>\n

Verification phase<\/strong><\/p>\n

j@debian:~$ \/opt\/tokutek\/mysql\/bin\/mysql<\/strong><\/span><\/span>
\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.<\/span>
\nYour MariaDB connection id is 1<\/span>
\nServer version: 5.5.30-tokudb-7.1.0-MariaDB MariaDB Server<\/span><\/p>\n

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.<\/span><\/p>\n

Type ‚help;‘ or ‚\\h‘ for help. Type ‚\\c‘ to clear the current input statement.<\/span><\/p>\n

MariaDB [(none)]> show plugins;<\/strong><\/span><\/span><\/p>\n

| TokuDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | STORAGE ENGINE\u00a0\u00a0\u00a0\u00a0 | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_trx\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_locks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_lock_waits\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_file_map\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_fractal_tree_info\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n| TokuDB_fractal_tree_block_map\u00a0 | ACTIVE\u00a0\u00a0 | INFORMATION SCHEMA | ha_tokudb.so | GPL\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n…<\/span>
\n49 rows in set (0.03 sec)<\/span><\/p>\n

MariaDB [(none)]> show engines;<\/strong><\/span><\/span><\/p>\n

| TokuDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | DEFAULT | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | YES\u00a0 | YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/span>
\n…<\/span>
\n11 rows in set (0.00 sec)<\/span><\/p>\n

MariaDB [(none)]> <\/span><\/p>\n

As usual, storage type must be declared in a time of table creation:<\/p>\n

create table lala (ID int(11) not null) engine=TokuDB;<\/strong><\/span><\/p>\n

-a-<\/p>\n","protected":false},"excerpt":{"rendered":"

„Pure“ MySQL is dead. Thanks to Oracle approach, thanks to very few inventions in last years (=versions). Among MariaDB there are few other players trying to attract customer. TokuDB is from my opinion the best choice for mature storage engine.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,13],"tags":[],"_links":{"self":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/308"}],"collection":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=308"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}