HandlerSocket安裝記錄

HandlerSocket[@more@]

tar zxvf ahiguti-HandlerSocket-Plugin-for-MySQL-1.0.6-23-g4cfc840.tar.gz
cd ahiguti-HandlerSocket-Plugin-for-MySQL-4cfc840

./autogen.sh

You should add the contents of `/usr/share/aclocal/libtool.m4' to `aclocal.m4'.

cat /usr/share/aclocal/libtool.m4 >> aclocal.m4

./configure --with-mysql-source=/root/Percona-Server
--with-mysql-bindir=/usr/local/Percona-Server-5.1.51-rel11.5-132-Linux-x86_64/bin
--with-mysql-plugindir=/usr/local/Percona-Server-5.1.51-rel11.5-132-Linux-x86_64/lib/mysql/plugin

錯誤configure: error: cannot find macro directory `m4'

mkdir m4
再次configure

make
make install

Append configuration options for handlersocket to my.cnf.

[mysqld]
loose_handlersocket_port = 9998
# the port number to bind to (for read requests)
loose_handlersocket_port_wr = 9999
# the port number to bind to (for write requests)
loose_handlersocket_threads = 16
# the number of worker threads (for read requests)
loose_handlersocket_threads_wr = 1
# the number of worker threads (for write requests)
open_files_limit = 65535
# to allow handlersocket accept many concurrent
# connections, make open_files_limit as large as
# possible.

Log in to mysql as root, and execute the following query.

mysql> install plugin handlersocket soname 'handlersocket.so';

If handlersocket.so is successfully installed, it starts
accepting connections on port 9998 and 9999. Running
'show processlist' should show handlersocket worker threads.

Client

tar zxvf ahiguti-HandlerSocket-Plugin-for-MySQL-1.0.6-23-g4cfc840.tar.gz
cd ahiguti-HandlerSocket-Plugin-for-MySQL-4cfc840/

./autogen.sh
./configure --disable-handlersocket-server
make
make install

#cd perl-Net-HandlerSocket
#perl Makefile.PL
#make
#make install

tar zxvf php-handlersocket-0.0.6.tar.gz
cd php-handlersocket

/usr/local/php/bin/phpize
./configure --with-php-config=/usr/local/php/bin/php-config
make
make install

adjust php.ini and add an extension=handlersocket.so