mysql_proxy使用手册_MYSQL PROXY搭建手册

1.安装包

gcc* gcc-c++* autoconf* automake* zlib* libxml* ncurses-devel* libmcrypt* libtool* flex* pkgconfig*

libevent* glib* lua*

(若lua没有的话也可以下载源码包来下载：

cd /opt/install

wget http://www.lua.org/ftp/lua-5.1.4.tar.gz

tar zvfx lua-5.1.4.tar.gz

cd lua-5.1.4

vi src/Makefile在CFLAGS= -O2 -Wall $(MYCFLAGS)这一行记录里加上-fPIC，更改为CFLAGS= -O2 -Wall -fPIC $(MYCFLAGS)来避免编译过程中出现错误。

make linux

make install

cp etc/lua.pc /usr/lib/pkgconfig/

export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/lib/pkgconfig)

2.安装proxy

下载mysql-proxy：

wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-Proxy/mysql-proxy-0.8.1-linux-rhel5-x86-32bit.tar.gz

tar xzvf mysql-proxy-0.8.1-linux-rhel5-x86-32bit.tar.gz

mv mysql-proxy-0.8.1-linux-rhel5-x86-32bit /opt/mysql-proxy

3.创建mysql-proxy服务管理脚本

mkdir /opt/mysql-proxy/init.d/

vim mysql-proxy

--------------------------------------

#!/bin/sh

#

# mysql-proxy This script starts and stops the mysql-proxy daemon

#

# chkconfig: - 78 30

# processname: mysql-proxy

# description: mysql-proxy is a proxy daemon to mysql

# Source function library.

. /etc/rc.d/init.d/functions

#PROXY_PATH=/usr/local/bin

PROXY_PATH=/opt/mysql-proxy/bin

prog="mysql-proxy"

# Source networking configuration.

. /etc/sysconfig/network

# Check t