MySQL Proxy 编译安装 By CentOS

NetSeek

MySQL Proxy Download: http://dev.mysql.com/downloads/mysql-proxy/
MySQL Proxy Wiki: http://forge.mysql.com/wiki/MySQL_Proxy

1、lua 安装
Get lua from: http://www.lua.org/

   1. vi Makefile (将 "INSTALL_TOP= /usr/local" 变为 "INSTALL_TOP= /yourpath/lua")
   2. make ansi
   3. make install

2、GLib 安装
Get GLib from: http://www.gtk.org/

   1. ./configure --prefix=/yourpath/glib2
   2. make
   3. make install

Note: newer version need newer pkg-conifg 0.xx
Get pkg-config from: http://pkg-config.freedesktop.org/releases/

   1. ./configure
   2. make
   3. make install

3、libevent 安装
Get libevent from: http://monkey.org/~provos/libevent/

   1. ./configure --prefix=/yourpath/libevent
   2. make;make install

4、check 安装
Get check lib from: http://check.sourceforge.net/

   1. ./configure --prefix=/yourpath/check
   2. make
   3. make install

5、MySQL Proxy 安装
编译前先要设置一下环境变量(export)，类似于 Windows 下的 PATH

   1. export LUA_CFLAGS="-I/yourpath/lua/include" LUA_LIBS="-L/yourpath/lua/lib -llua -ldl" LDFLAGS="-lm"
   2.  
   3. export GLIB_CFLAGS="-I/yourpath/glib2/include/glib-2.0 -I/yourpath/glib2/lib/glib-2.0/include"
   4. export GLIB_LIBS="-L/yourpath/glib2/lib -lglib-2.0"
   5.  
   6. export CPPFLAGS="$CPPFLAGS -I/yourpath/libevent/include"
   7. export CFLAGS="$CFLAGS -I/yourpath/libevent/include"
   8. export LDFLAGS="$LDFLAGS -L/yourpath/libevent/lib -lm"
   9.  
  10. ./configure --prefix=/yourpath/mysql-proxy --with-mysql=/yourpath/mysql --with-check=/yourpath/check
  11. make
  12. make install

测试是否安装成功，看下边这条语句是否可以正常输出 MySQL Proxy 的帮助

   1. /yourpath/mysql-proxy/sbin/mysql-proxy --help-all