MySQLProxy快速實現(xiàn)讀寫分離以及負載均衡

1、MySQL中文網(wǎng)MySQLProxy快速實現(xiàn)讀寫分離以及負載均衡1.安裝下載已經(jīng)編譯好的安裝包，或者預(yù)編譯安裝包均可，在這里，使用預(yù)編譯版本。#tarzxfmysql-proxy-0.6.0-linux-rhas4-x86.tar.gz#cdmysql-proxy-0.6.0-linux-rhas4-x86#可以看到有2個目錄mysql-proxy-0.6.0-linux-rhas4-x86#lssbinsharemysql-proxy-0.6.0-linux-rhas4-x86#mvsbin/mysql-proxy/usr/local/sbin/mysql-proxy-0.6.0-linux

2、-rhas4-x86#lssharemysql-proxytutorial-constants.luatutorial-packets.luatutorial-rewrite.luatutorial-warnings.luatutorial-basic.luatutorial-inject.luatutorial-query-time.luatutorial-states.lua#將lua腳本放到/usr/local/share下，以備他用mysql-proxy-0.6.0-linux-rhas4-x86#mvshare/mysql-proxy/usr/local/share/#刪除符號連接等

3、垃圾代碼mysql-proxy-0.6.0-linux-rhas4-x86#strip/usr/local/sbin/mysql-proxy2.啟動編譯一下啟動管理腳本：s1#vi/etc/initd/mysql-proxy#!/bin/shexportLUAPATH=/usr/local/share/mysql-proxy/?luamode=$1if-z$mode;thenmode=startficase$modeinstart)mysql-proxy-daemon-admin-address=:4401-proxy-address=:3307-proxy-backend-addresses

4、=:3306-proxy-read-only-backend-addresses=192.168133232:3306proxy-read-only-backend-addresses=101074.61:3306一一proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.lua；stop)killallmysql-proxyrestart)if$0stop;then$0startelseechoretartfailed!exit1esacexit0現(xiàn)在解釋一下啟動腳本：-daemon采用daemon方式啟動-admin-addre

5、ss=:4401指定mysqlproxy的管理端口，在這里，表示本機的4401端口-proxy-address=:3307指定mysqlproxy的監(jiān)聽端口，也可以用:3307表示-proxy-backend-addresses=:3306指定mysql主機的端口-proxy-read-only-backend-addresses=:3306指定只讀的mysql主機端口-proxy-read-only-backend-addresses=:3306指定另一個只讀的mysql主機端口-proxy-lua-script=/usr/local/share/mysq卜proxy/rw-splittin

6、g.lua指定lua腳本，在這里，使用的是rw-splitting腳本，用于讀寫分離完整的參數(shù)可以運行以下命令查看：mysql-proxy-help-all運行以下命令啟動/停止/重啟mysqlproxy：#/etc/init.d/mysql-proxystart#/etc/init.d/mysql-proxystop#/etc/init.d/mysql-proxyrestart3.試用#mysql-h-uroot-P3307mysqlshowprocesslist;TOC o 1-5 h z+|Id|User|Host|db|Command|Time|State|Info|+|30052|r

7、oot|localhost:9656|NULL|Query|0|NULL|showprocesslist|+可以看到，產(chǎn)生了一個新連接。用sysbench測試一下，看會不會掛掉：#sysbench-test=oltp-mysql-table-engine=innodb-oltp-table-size=1000000-mysql-socket=/tmp/mysql.sock-mysql-user=root-mysql-db=testprepare#sysbench-test=oltp-mysql-table-engine=innodb-oltp-table-size=1000000-mysql-socket=/tmp/mysql.sock-mysql-user=root-mysql-db=testrunThreadsfairness:events(avg/stddev):10000.0000/0.00executiontime(avg/stddev):23.0387/0.00還好，沒給大家丟臉，剩下的測試自己完成吧:)4.其他mysqlproxy還可以實現(xiàn)連接池的功能，這在很多LAMP開發(fā)中是