MYSQLʵÏÖ¶Áд·ÖÀë

LUA°æ±¾£ºlua-5.1.4.tar.gz
MySql_proxy°æ±¾£ºmysql-proxy-0.6.1-linux-rhel4-x86-32bit.tar.gz
 
´úÀí»ú£ºLinuxºìñ £¨222.31.76.229£©
Êý¾Ý¿â·þÎñÆ÷£ºAÖ÷£º£¨222.31.76.99£©£¬B´Ó£º£¨222.31.76.102£©
 
AºÍB°²×°Mysql
5.1   £»
´úÀí»ú°²×°LUA£¬MYSQL_PROXY£»
1¡¢ LUAµÄ°²×°
[root@localhost ~]#tar zxvf lua-5.1.2.tar.gz  -C /usr/local
[root@localhost ~]# cd /usr/local/
[root@localhost local]# mv lua-5.1 lua
[root@localhost lua]# cd lua
[root@localhost lua]# make linux;make linux
install;
µ¼³ö»·¾³±äÁ¿£º
[root@localhost lua]#export
LUA_CFLAGS="-I/usr/local/include" LUA_LIBS="-L/usr/local/lib
-llua -ldl" LDFLAGS="-lm"
 
 
ÒÆÖ²LUA ²é¿´INSTALLÎļþ£¬¿½±´¶ÔÓ¦Îļþ¼°È¨ÏÞ
 
 
 
2¡¢MySQL Proxy °²×°  
[root@localhost ~]#tar -zxvf mysql-proxy-0.6.1-linux-rhel4-x86-32bit.tar.gz
-C /usr/local/mysql/
[root@localhost ~]#cd /usr/local/mysql
[root@localhost mysql]#mv mysql-proxy-0.6.1-linux-rhel4-x86-32bit/
mysql-proxy
[root@localhost sbin]# export
PATH=$PATH:/usr/local/mysql/mysql-proxy/sbin/
[root@localhost ~]# mysql-proxy --help-all
 
 
Æô¶¯mysql_proxy£º
 
[root@localhost sbin]#LUA_PATH="/usr/local/mysql/mysql-proxy/share/mysql-proxy/?.lua"
/usr/local/mysql/mysql-proxy/sbin/mysql-proxy
--proxy-read-only-backend-addresses=222.31.76.102:3306
--proxy-backend-addresses=222.31.76.99:3306
--proxy-lua-script=/usr/local/mysql/mysql-proxy/share/mysql-proxy/rw-splitting.lua
&
 
·Ö±ð½øÈëA,B   MYSQL´´½¨Ô¶³ÌÁ¬½ÓÊý¾Ý¿âÓû§
MYSQL>grant all on *.* to
'yl'@'222.31.76.229' identified by '123456';
 
¿Í»§¶Ë¿ªÆôÁ¬½Ó£º
 
[root@localhost ~]# mysql –u¡¾user¡¿ -p¡¾password¡¿ -P4040 –h¡¾hostip¡¿ -D¡¾dbname¡¿
 
²»ÄÜÁ¬½ÓÊý¾Ý¿â
Ô­Òò£º¿ÉÄÜÓû§Ã»ÓÐȨÏÞ
         ¿ÉÄÜ·À»ðǽ