centos 下mysql 与memcached的整合

最新推荐文章于 2024-11-16 17:04:03 发布

iteye_9466

最新推荐文章于 2024-11-16 17:04:03 发布

阅读量145

点赞数

文章标签： MySQL memcached CentOS Linux Vmware

一、成功安装的软件列表

mysql-5.1.43-linux-x86_64-icc-glibc23.tar.gz

libvent-1.4.7-stable.tar.gz

memcached-1.2.6.tar.gz

libmemcached-0.26.tar.gz

memcached_functions_mysql_1.0.tar.gz

二、安装步骤

通过filezilla 以root 用户登录把

libevent-1.4.7-stable.tar.gz

memcached-1.2.6.tar.gz

libmemcached-0.26.tar.gz

memcached_functions_mysql_1.0.tar.gz

这4个安装文件传输到 centos 下的/root/Desktop 目录下

把mysql-5.1.43-linux-x86_64-icc-glibc23.tar.gz

传输到 centos 下的/usr/local 目录下

1、安装MySQL

先检查系统是否装上了mysql，如果有将其卸载掉

rpm -qa | grep -i mysql

注意mysql的大小写，大小写都有可能。

定要用—nodeps卸载，不检查依赖性关系(强制性卸载)

rpm -e --nodeps mysql*

创建用户mysql，并设置密码

groupadd mysql

useradd -g mysql mysql

passwd mysql

将MySQL安装在/usr/local/mysql的目录下并设置相关权限操作

cd /usr/local

由于刚开始以用户siku 登录所以会报权限不够的错误。

执行 su root

输入root 的密码如下图：

tar xzvf mysql-5.1.43-linux-x86_64-icc-glibc23.tar.gz

ln -s mysql-5.1.43-linux-x86_64-icc-glibc23 mysql

cd mysql

./scripts/mysql_install_db --user=mysql

如果出现下列错误请安装compat-libstdc++-33-3.2.3-61.x86_64.rpm，

执行rpm -ivh compat-libstdc++-33-3.2.3-61.x86_64.rpm。

./scripts/mysql_install_db --user=mysql

文件安装成功。

chown -R root .

chown -R mysql data

cd /etc/rc.d/init.d

cp /usr/local/mysql/support-files/mysql.server mysql

chmod +x mysql

/sbin/chkconfig --del mysql

/sbin/chkconfig --add mysql

/etc/rc.d/init.d/mysql start

运行命令，进入命令行操作，默认密码为空

/usr/local/mysql/bin/mysql

安装成功！

2、安装libevent到/usr/lib目录

memcached使用了libevent，所以必须先安装libevent。安装libevent到/usr/lib:

cd /root/Desktop

tar xvf libevent-1.4.7-stable.tar.gz

cd libevent-1.4.7-stable

./configure --prefix=/usr

make

make install

安装成功

3、安装memcached到/usr/local/memcached目录

Cd ..

tar xvf memcached-1.2.6.tar.gz

cd memcached-1.2.6

./configure --prefix=/usr/local/memcached --with-libevent=/usr

make

make install

运行如下命令测试安装是否成功：

/usr/local/memcached/bin/memcached -h

提示/usr/local/memcached/bin/memcached: error while loading shared libraries: libevent-1.4.so.2:

cannot open shared object file: No such file or directory

出现上述错误一般是由于库文件依赖有问题，这是需要使用libs命令

#LD_DEBUG=libs /usr/local/memcached/bin/memcached -h

30596: find library=libevent-1.4.so.2 [0]; searching

30596: search cache=/etc/ld.so.cache

30596: search path=/lib64/tls/x86_64:/lib64/tls:/lib64/x86_64:/lib64:/usr/lib64/tls/x86_64

/usr/lib64/tls:/usr/lib64/x86_64:/usr/lib64

(system search path)

30596: trying file=/lib64/tls/x86_64/libevent-1.4.so.2

30596: trying file=/lib64/tls/libevent-1.4.so.2

30596: trying file=/lib64/x86_64/libevent-1.4.so.2

30596: trying file=/lib64/libevent-1.4.so.2

30596: trying file=/usr/lib64/tls/x86_64/libevent-1.4.so.2

30596: trying file=/usr/lib64/tls/libevent-1.4.so.2

30596: trying file=/usr/lib64/x86_64/libevent-1.4.so.2

30596: trying file=/usr/lib64/libevent-1.4.so.2

30596:

/usr/local /memcached/bin/memcached: error while loading shared libraries: libevent-1.4.so.2:

cannot open shared object file: No such file or directory

可以看到是在加载/usr/lib64/libevent-1.4.so.2文件时出现了问题，系统中确实是没有该文件的，查找后发现 libevent-1.4.so.2存在于/usr/lib目录，这可能是libevent在64位Linux系统上的一个bug吧，没有关系，复制一份或者建一个软链接即可解决问题。

下面建立一个软链接:

#ln -s /usr/lib/libevent-1.4.so.2 /usr/lib64/libevent-1.4.so.2

笔者采用上述memcached版本出现上述蓝色部分的错误，当没错误的使用，可以使用命令：

/usr/local/memcached/bin/memcached –h

看memcached命令帮助信息如下结果：

memcached 1.4.4

-p <num> TCP port number to listen on (default: 11211)

-U <num> UDP port number to listen on (default: 11211, 0 is off)

-s <file> UNIX socket path to listen on (disables network support)

-a <mask> access mask for UNIX socket, in octal (default: 0700)

-l <ip_addr> interface to listen on (default: INADDR_ANY, all addresses)

-d run as a daemon

-r maximize core file limit

-u <username> assume identity of <username> (only when run as root)

-m <num> max memory to use for items in megabytes (default: 64 MB)

-M return error on memory exhausted (rather than removing items)

-c <num> max simultaneous connections (default: 1024)

-k lock down all paged memory. Note that there is a

limit on how much memory you may lock. Trying to

allocate more than that would fail, so be sure you

set the limit correctly for the user you started

the daemon with (not for -u <username> user;

under sh this is done with 'ulimit -S -l NUM_KB').

-v verbose (print errors/warnings while in event loop)

-vv very verbose (also print client commands/reponses)

-vvv extremely verbose (also print internal state transitions)

-h print this help and exit

-i print memcached and libevent license

-P <file> save PID in <file>, only used with -d option

-f <factor> chunk size growth factor (default: 1.25)

-n <bytes> minimum space allocated for key+value+flags (default: 48)

-L Try to use large memory pages (if available). Increasing

the memory page size could reduce the number of TLB misses

and improve the performance. In order to get large pages

from the OS, memcached will allocate the total item-cache

in one large chunk.

-D <char> Use <char> as the delimiter between key prefixes and IDs.

This is used for per-prefix stats reporting. The default is

":" (colon). If this option is specified, stats collection

is turned on automatically; if not, then it may be turned on

by sending the "stats detail on" command to the server.

-t <num> number of threads to use (default: 4)

-R Maximum number of requests per event, limits the number of

requests process for a given connection to prevent

starvation (default: 20)

-C Disable use of CAS

-b Set the backlog queue limit (default: 1024)

-B Binding protocol - one of ascii, binary, or auto (default)

-I Override the size of each slab page. Adjusts max item size

(default: 1mb, min: 1k, max: 128m)

各参数的含义在另一文档有说明，启动memcached命令：

#/usr/local/memcached/bin/memcached -d -m 1024 -u root -l 127.0.0.1 -p 11211

至此，memcached安装成功并在本地以11211端口启动!

4、安装libmemcached

安装命令如下：

cd /root/Desktop

tar xzf libmemcached-0.26.tar.gz

cd libmemcached-0.26

./configure –with-memcached=/usr/local/memcached/bin/memcached

make

make install

5、安装memcached UDFs for MySQL

命令如下：

cd /root/Desktop

tar xzf memcached_functions_mysql-1.0.tar.gz

cd memcached_functions_mysql-1.0

./configure --with-mysql=/usr/local/mysql/bin/mysql_config --libdir=/usr/local/mysql/lib/mysql/

执行上述命令后，如果出现找不到libmemcached的错误，那么请执行下列命令：

export LD_LIBRARY_PATH=/usr/local/lib

然后再执行：

make

make install

编译完成后，将编译好的库文件复制到mysql 的插件目录下，以便加载使用。

cp /usr/local/mysql/lib/mysql/libmemcached_functions_mysql* /usr/local/mysql/lib/plugin/

进入memcached_functions_mysql的源码目录，在目录下添加UDF的SQL文件用于初始化，命令如下：

#/usr/local/mysql/bin/mysql <sql/install_functions.sql

至此，相关的软件的编译和安装完成。

四、注意事项和错误解决方案

1、注意事项

MySQL官方提供三个版本下载，分别是RPM/二进制/源码版，由于编译安装memcached UDFs for MySQL时需要指定MySQL的相关信息，采用RPM版（安装文件路径分散，对Linux和MySQL不是非常熟悉的人，难以把握）不合适。MySQL官方不推荐使用源码版（个人觉得那是高手使用的东西，需要自己编译，安装特别麻烦，用它是自找苦吃），故本人采用的是二进制版（MySQL已经编译完成）的MySQL。至于如何区别MySQL的二进制版和源码版的信息，自己Google!