CentOS 5.8 Mysql-proxy 0.8.3 安装
CentOS 5.8 Mysql-proxy 0.8.3 安装相关链接:mysql-proxy: http://dev.mysql.com/downloads/mysql-proxy/
MySQL: http://www.mysql.com/
lua: http://www.lua.org/
相关说明:Mysql 在 07年发布Mysql-proxy, 可用来做数据库的代理, 在复杂的网络中可以使用到, 因为它支持lua脚本语言使它发挥出特别大的用处, 比如可以对数据库语句做读写分离, 查询统计, 查找语句BUG等等….在以前的版本使用中, 一直听说是非常不靠谱的东西. 但从0.8版本后也越发越好. 可以勉强放在生产机上用.
我们使用linux系统来进行安装.
安装过程:安装编译所需要的依赖包yum -y install gcc gcc-c++ autoconf libevent-devel pkgconfig libtool mysql-devel make ncurses ncurses-devel编译安装glib2cd ..
wget http://ftp.gnome.org/pub/gnome/sources/glib/2.18/glib-2.18.4.tar.gz
tar -xzvf glib-2.18.4.tar.gz
cd glib-2.18.4./configure --prefix=/usr/local/glib-2.18.4
make
make install编译安装readlinecd ..
wget ftp://ftp.cwru.edu/pub/bash/readline-6.2.tar.gz
tar -xzvf readline-6.2.tar.gz
cd readline-6.2./configure
make
make install编译安装luacd ..
wget http://www.lua.org/ftp/lua-5.1.4.tar.gz
tar -xzvf lua-5.1.4.tar.gz
cd lua-5.1.4#指定安装位置
sed -i 's#^INSTALL_TOP=.*#INSTALL_TOP= /usr/local/lua-5.1.4#gi' ./Makefile
#如果系统为64位请执行下面这条命令
#sed -i 's#^CFLAGS=.*#CFLAGS= -O2 -fPIC -Wall $(MYCFLAGS)#gi' ./src/Makefile
make linux
make installmkdir /usr/local/lua-5.1.4/lib/pkgconfig
cp ./etc/lua.pc /usr/local/lua-5.1.4/lib/pkgconfig
sed -i 's#^prefix=.*#prefix= /usr/local/lua-5.1.4#gi' /usr/local/lua-5.1.4/lib/pkgconfig/lua.pc编译安装mysql-proxycd ..
wget http://cdn.mysql.com/Downloads/MySQL-Proxy/mysql-proxy-0.8.3.tar.gz
tar -xzvf mysql-proxy-0.8.3.tar.gz
cd mysql-proxy-0.8.3export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/glib-2.18.4/lib/pkgconfig:/usr/local/lua-5.1.4/lib/pkgconfig
./configure --prefix=/usr/local/mysql-proxy-0.8.3
make
make installmkdir /usr/local/mysql-proxy-0.8.3/lib/mysql-proxy/lua/new
cp ./lib/rw-splitting.lua /usr/local/mysql-proxy-0.8.3/lib/mysql-proxy/lua/new
cp ./lib/admin-sql.lua /usr/local/mysql-proxy-0.8.3/lib/mysql-proxy/lua/new
mkdir /usr/local/mysql-proxy-0.8.3/etc
mkdir /usr/local/mysql-proxy-0.8.3/logs验证安装:
/usr/local/mysql-proxy-0.8.3/bin/mysql-proxy --help到此我们已经完成了安装.
摘自:http://www.boll.me/archives/301
CentOS 5.8 Mysql-proxy 0.8.3 安装
页:
[1]