Atlas 安装

centos5.5 64Bit

1	yum  install  -y libevent-devel lua-devel openssl-devel flex

升级python至2.6

yum install -y xz gettext-devel

1 2 3 4 5 6

xz -d glib-2.32.4. tar .xz tar  xvf glib-2.32.4. tar cd  glib-2.32.4 . /configure make make  install

1	for  a  in  ` find  . -name  '*.pc' `;  do  cp  $a  /usr/lib64/pkgconfig/ ;  done

设置环境变量

1 2 3 4 5 6

export  GLIB_CFLAGS= "-I/usr/local/include/glib-2.0" export  GLIB_LIBS= "-L/usr/local/lib/glib-2.0" export  GMODULE_CFLAGS= "-I/usr/local/include" export  GMODULE_LIBS= "-L/usr/local/lib" export  GTHREAD_CFLAGS= "-I/usr/local/include" export  GTHREAD_LIBS= "-L/usr/local/lib"

1	yum  install  -y mysql-server mysql-devel

1	unzip Atlas-master.zip

vim bootstrap.sh

修改mysql_config路径

修改pkgconfig路径

1

./configure --with-mysql=/usr/bin/mysql_config --prefix=/usr/local/mysql-proxy CFLAGS="-DHAVE_LUA_H -O2" LDFLAGS="-lm -ldl -lcrypto" LUA_CFLAGS="-I/usr/local/include/" LUA_LIBS="-L/usr/local/lib -llua" GLIB_FLAGS="-I/usr/local/include" GLIB_LIBS="-L/usr/local/lib -lglib-2.0" GMODULE_FLAGS="-I/usr/local/include" GMODULE_LIBS="-L/usr/local/lib -lgmodule-2.0" GTHREAD_FLAGS="-I/usr/local/include" GTHREAD_LIBS="-L/usr/local/lib -lgthread-2.0"

cat instance.cnf

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

[mysql-proxy] plugins = admin,proxy admin-username=zwhset admin-password=123456 admin-lua-script = /usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua proxy-backend-addresses = 192.168.100.210:3306 proxy-read-only-backend-addresses = 192.168.100.211:3306@2 daemon = true keepalive = true event-threads = 4 log-level = message log-path = /usr/local/mysql-proxy/log instance = test proxy-address = 0.0.0.0:3306 admin-address = 0.0.0.0:4401 min-idle-connections = 128 charset = utf8

1	chmod  0600 instance.cnf

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

#!/usr/bin/python #!coding:utf8 import  _mysql db = _mysql.connect(host = "192.168.100.100" ,user = "proxy2" ,passwd = "-------" ,db = "test" ,port = 3306 ) client = 0 #min-idle,Db1+DB2=20,DB1,DB2:max_connection=200; sum_min_idle = 30 try :      while  sum_min_idle > =  client:          db.query( """SELECT id,number FROM 200w""" )          ( id ,char) = db.store_result()[ 0 ]          print  "client:%s,id:%s,char:%s"  %  (client, id ,char)          client  =  client + 1 except :      print  "------------------------"

本文转自 煮酒品茶 51CTO博客，原文链接：http://blog.51cto.com/cwtea/1244788，如需转载请自行联系原作者