centos6.4配置mysql+memcached

操作系统：CentOS6.4 64bit
mysql：5.1.66




1、安装libevent和memcached
2、下载并安装libmemcached-0.34
0.37以后的版本，memcached_functions_mysql-1.0与之memcached.h不匹配，会有以下错误
servers.c: In function ‘memc_servers_set’: 
servers.c:121: error: ‘memcached_st’ has no member named ‘hosts’ 

./configure --prefix=/usr/local/libmemcached34 --with-memcached=/usr/bin/memcached
make &&　make install
echo "/usr/local/libmemcached34" > /etc/ld.so.conf.d/memcached-x86_64.conf
ldconfig
3、下载并安装memcached_functions_mysql-1.0
要安装mysql-devl 编译memcached_functions_mysql-1.0需要mysql的头文件
./configure --prefix=/usr/local/memcache_functions_mysql-1.0 --with-mysql=/usr/bin/mysql_config --with-libmemcached=/usr/local/libmemcached34
make &&　make install


4、将memcached_functions_mysql-1.0源码下的function拷贝到mysql的plugin
cp sql/libmemcached_functions_mysql.* /usr/lib64/mysql/plugin/


5、将function导入mysql
memcached_functions_mysql-1.0安装包目录下有个sql目录，将两个sql脚本install_functions.sql和trigger_fun.sql导入mysql
cd /home/memcached_functions_mysql-1.0/sql;
mysql> source install_functions.sql;