安装TokuDB 6.5.0 for MySQL 5.5.24

〇〇

data目录下有个错误文件
[root@redflag11012602 data]# cat redflag11012602.err
121008 19:36:15 mysqld_safe Starting mysqld daemon with databases from /opt/tokudb/mysql/data
121008 19:36:15 [Note] Plugin 'FEDERATED' is disabled.
/opt/tokudb/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
121008 19:36:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121008 19:36:15 InnoDB: The InnoDB memory heap is disabled
121008 19:36:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121008 19:36:15 InnoDB: Compressed tables use zlib 1.2.3
121008 19:36:15 InnoDB: Initializing buffer pool, size = 128.0M
121008 19:36:15 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
121008 19:36:15  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121008 19:36:15  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
121008 19:36:15  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121008 19:36:15  InnoDB: Waiting for the background threads to start
121008 19:36:16 InnoDB: 1.1.8 started; log sequence number 0
121008 19:36:16 [ERROR] Unknown/unsupported storage engine: TokuDB
121008 19:36:16 [ERROR] Aborting

121008 19:36:16  InnoDB: Starting shutdown...
121008 19:36:17  InnoDB: Shutdown completed; log sequence number 1595675
121008 19:36:17 [Note] /opt/tokudb/mysql/bin/mysqld: Shutdown complete

121008 19:36:17 mysqld_safe mysqld from pid file /opt/tokudb/mysql/data/redflag11012602.pid ended

〇〇

upgrade也不行
[root@redflag11012602 mysql]# /opt/tokudb/mysql/bin/mysql_upgrade
Looking for 'mysql' as: /opt/tokudb/mysql/bin/mysql
Looking for 'mysqlcheck' as: /opt/tokudb/mysql/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
/opt/tokudb/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

〇〇

跳过授权表也不行
[root@redflag11012602 mysql]# su - mysql
-bash-3.2$ ./bin/mysqld --skip-grant &
[1] 13935
-bash-3.2$ -bash: ./bin/mysqld: 没有那个文件或目录

[1]+  Exit 127                ./bin/mysqld --skip-grant
-bash-3.2$ cd /opt/tokudb/mysql
-bash: cd: /opt/tokudb/mysql: 权限不够
-bash-3.2$ exit
logout
[root@redflag11012602 mysql]# cd ..
[root@redflag11012602 tokudb]# ls -l
总计 196652
drwxr-xr-x  3 tokudb tokudb      4096 10-08 16:32 Desktop
lrwxrwxrwx  1 root   root          44 10-08 19:22 mysql -> mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64
drwxr-xr-x 13 mysql  mysql       4096 10-08 19:11 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64
-rw-rw-r--  1 tokudb tokudb 201158829 10-08 16:34 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64.tar.gz
[root@redflag11012602 tokudb]# cd mysql
[root@redflag11012602 mysql]# ./bin/mysqld --skip-grant &
[1] 13980
[root@redflag11012602 mysql]# 121008 19:55:15 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
121008 19:55:15 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
121008 19:55:15 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
./bin/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
121008 19:55:15 [ERROR] Aborting

121008 19:55:15 [Note]

[1]+  Exit 1                  ./bin/mysqld --skip-grant

〇〇

--defaults-file也不行
[root@redflag11012602 mysql]# ./bin/mysqld --skip-grant --defaults-file=/etc/my.cnf &
[1] 26455
[root@redflag11012602 mysql]# 121009 13:31:58 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
121009 13:31:58 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
121009 13:31:58 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
./bin/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
121009 13:31:58 [ERROR] Aborting

121009 13:31:58 [Note]

[1]+  Exit 1                  ./bin/mysqld --skip-grant --defaults-file=/etc/my.cnf

〇〇

修改了server文件头部，依然不行
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# vi /etc/init.d/mysql

#!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind

# MySQL daemon start/stop script.

# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
# When this is done the mysql server will be started when the machine is
# started and shut down when the systems goes down.

# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.

# Comments to support LSB init script conventions
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $local_fs $network $remote_fs
# Should-Start: ypbind nscd ldap ntpd xntpd
# Required-Stop: $local_fs $network $remote_fs
# Default-Start:  2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: start and stop MySQL
# Description: MySQL is a very fast and reliable SQL database engine.
### END INIT INFO

# If you install MySQL on some other places than /usr/local/mysql, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=/opt/tokudb/mysql
datadir=/opt/tokudb/mysql/data

"/etc/rc.d/init.d/mysql" 384L, 10694C 已写入                                                                     
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# pwdd
-bash: pwdd: command not found
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# pwd
/opt/tokudb/mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ./bin/mysqld --skip-grant &
[1] 24763
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# 121011 15:52:46 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
121011 15:52:46 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
121011 15:52:46 [Warning] Can't create test file /usr/local/mysql/data/redflag11012602.lower-test
./bin/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2)
121011 15:52:46 [ERROR] Aborting

121011 15:52:46 [Note]

[1]+  Exit 1                  ./bin/mysqld --skip-grant

〇〇

发现这个相应/opt/tokudb/mysql/share
目录下确实没有errmsg.sys文件，从english子目录复制一个也不行
只好往错误信息指定的地方复制，偷懒用了软连接，这次错误不同了
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ln -sv /opt/tokudb/mysql /usr/local/mysql
创建指向“/opt/tokudb/mysql”的符号链接“/usr/local/mysql”
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ll  /usr/local/mysql
lrwxrwxrwx 1 root root 17 10-11 16:17 /usr/local/mysql -> /opt/tokudb/mysql
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ./bin/mysqld --skip-grant &
[1] 25841
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# 121011 16:18:18 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

121011 16:18:18 [ERROR] Aborting

121011 16:18:18 [Note] ./bin/mysqld: Shutdown complete

〇〇

查了手册，添加user=root启动，离完成更近了
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ./bin/mysqld --skip-grant --user=root &
[1] 26145
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# 121011 16:25:28 [Note] Plugin 'FEDERATED' is disabled.
121011 16:25:28 InnoDB: The InnoDB memory heap is disabled
121011 16:25:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121011 16:25:28 InnoDB: Compressed tables use zlib 1.2.3
121011 16:25:28 InnoDB: Initializing buffer pool, size = 128.0M
121011 16:25:28 InnoDB: Completed initialization of buffer pool
121011 16:25:28 InnoDB: highest supported file format is Barracuda.
121011 16:25:28  InnoDB: Waiting for the background threads to start
121011 16:25:29 InnoDB: 1.1.8 started; log sequence number 1595675
121011 16:25:29 [ERROR] Unknown/unsupported storage engine: TokuDB
121011 16:25:29 [ERROR] Aborting

121011 16:25:29  InnoDB: Starting shutdown...
121011 16:25:29  InnoDB: Shutdown completed; log sequence number 1595675
121011 16:25:29 [Note] ./bin/mysqld: Shutdown complete


[1]+  Exit 1                  ./bin/mysqld --skip-grant --user=root

〇〇

上面说没找到引擎，我想起来了系统表还没初始化，尝试初始化
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# /opt/tokudb/mysql/bin/mysql_upgrade
Looking for 'mysql' as: /opt/tokudb/mysql/bin/mysql
Looking for 'mysqlcheck' as: /opt/tokudb/mysql/bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
/opt/tokudb/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1  Can't create/write to file '/opt/tokudb/mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64/data/mysql/db.MYI' (Errcode: 13)
121011 16:30:33 [ERROR] Aborting

121011 16:30:33 [Note] ./bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
./data for more information.

〇〇

修改了安装根目录的属性后初始化貌似部分成功，与以前完全不同的错误
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ll /opt/tokudb
总计 196652
drwxr-xr-x  3 tokudb tokudb      4096 10-08 16:32 Desktop
lrwxrwxrwx  1 root   root          44 10-08 19:22 mysql -> mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64
drwxr-xr-x 13 mysql  mysql       4096 10-08 19:11 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64
-rw-rw-r--  1 tokudb tokudb 201158829 10-08 16:34 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64.tar.gz
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# chown -R mysql:mysql /opt/tokudb
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# scripts/mysql_install_db --user=mysql
ERROR: 1  Can't create/write to file '/opt/tokudb/mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64/data/mysql/db.MYI' (Errcode: 13)
Installing MySQL system tables...
121011 16:30:33 [ERROR] Aborting

121011 16:30:33 [Note] ./bin/mysqld: Shutdown completeOK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h redflag11012602 password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

〇〇

果然有个东西在运行
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# netstat -nlp| grep 3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      4127/mysqld         
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]# ps -ef|grep mysqld
root      1401  4753  0 20:56 pts/0    00:00:00 grep mysqld
root      3976     1  0 Jun24 ?        00:00:00 /bin/sh /usr/local/Calpont/mysql//bin/mysqld_safe --defaults-file=/usr/local/Calpont/mysql//my.cnf --datadir=/usr/local/Calpont/mysql/db --pid-file=/usr/local/Calpont/mysql/db/redflag11012602.pid
mysql     4127  3976  0 Jun24 ?        00:00:00 /usr/local/Calpont/mysql/libexec/mysqld --defaults-file=/usr/local/Calpont/mysql//my.cnf --basedir=/usr/local/Calpont/mysql/ --datadir=/usr/local/Calpont/mysql/db --user=mysql --log-error=/usr/local/Calpont/mysql/db/redflag11012602.err --pid-file=/usr/local/Calpont/mysql/db/redflag11012602.pid --socket=/usr/local/Calpont/mysql/lib/mysql/mysql.sock --port=3306
[root@redflag11012602 mysql-5.5.24-tokudb-6.5.0-48167-linux-x86_64]#