环境:

系统centos6.2

mysql版本mysql5.6.10

HandlerSocket插件版本 1.1.1 (mysql5.6.10安装1.0的插件报错)

1.1.1版本地址https://github.com/DeNA/HandlerSocket-Plugin-for-MySQL


首先安装mysql确保可以正常运行

/usr/sbin/groupadd

/usr/sbin/useradd -g mysql mysql

mkdir -p /data

mkdir -p /data/data/

chown mysql:root /data

yum -y install cmake bison bc ncurses ncurses-devel

wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.12.tar.gz

tar zxvf mysql-5.6.12.tar.gz

cd mysql-5.6.12

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/data/mysql.sock -DMYSQL_DATADIR=/data/data -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1

make

make install

cd ..

chmod +w /usr/local/mysql

chown -R mysql:mysql /usr/local/mysql


然后安装插件

unzip HandlerSocket-Plugin-for-MySQL-master.zip  (注意:版本是1.1.1)

cd HandlerSocket-Plugin-for-MySQL-master

./autogen.sh

./configure --with-mysql-source=/web/src/mysql-5.6.10/ --with-mysql-bindir=/usr/local/mysql/bin/ --with-mysql-plugindir=/usr/local/mysql/lib/plugin/ --prefix=/usr/local/HandlerSocket

make

make install


注释: --with-mysql-source=/web/src/mysql-5.6.10/  #MYSQL的安装源码目录,来自mysql-5.6.10.tar.gz的解压

注释: --with-mysql-bindir=/usr/local/mysql/bin/   #MYSQL安装目录里的BIN目录.

注释: --with-mysql-plugindir=/usr/local/mysql/lib/plugin/  #MYSQL安装目录里的PLUGIN的目录

注释:  --prefix=/usr/local/HandlerSocket  #HandlerSocket插件的安装目录


安装完毕以后 修改/etc/my.cnf配置文件

[root@WEB-C src]# cat /etc/my.cnf

[mysqld]

datadir=/data/data/

pid-file=/data/mysqld.pid

#socket=/var/lib/mysql/mysql.sock

socket=/data/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

-----------此部分是新添加内容----------------------

plugin-load=handlersocket.so

loose_handlersocket_port = 9998

loose_handlersocket_port_wr = 9999

loose_handlersocket_threads = 16

loose_handlersocket_threads_wr = 1

open_files_limit = 65535

-----------------------------------------

[mysqld_safe]

log-error=/data/binlog/mysqld.log


可以去参考一下文章:

http://blog.csdn.net/zzq900503/article/details/12969091

http://www.livingelsewhere.net/tag/handlersocket/