mysql amoeba 链接111_amoeba_mysql 读写分离

[root@ ~]# wget http://jaist.dl.sourceforge.net/project/amoeba/Amoeba%20for%20mysql/amoeba-mysql-1.3.1-BETA.zip

[root@ ~]# mkdir /usr/local/amoeba/ -p

[root@ ~]# mv amoeba-mysql-1.3.1-BETA.zip /usr/local/amoeba/

[root@ ~]# cd /usr/local/amoeba/

[root@ amoeba]# unzip amoeba-mysql-1.3.1-BETA.zip

[root@ amoeba]# chomod +x bin/*

[root@ amoeba]# vim conf/amodeba.xml

# 贴关键配置

3306

192.168.31.139

***

root

mysql123

60

***

defaultManager

3306

192.168.31.140

test

amoeba

amoeba123

***

defaultManager

3306

192.168.31.130

test

amoeba

amoeba123

***

1

server1

1

server1,server2

${amoeba.home}/conf/rule.xml

${amoeba.home}/conf/functionMap.xml

${amoeba.home}/conf/ruleFunctionMap.xml

1500

server1

server1

server2

true

[root@ amoeba]# nohup bin/amoeba &

[root@ amoeba]# netstat -lntp | grep 3306

tcp 0 0 ::ffff:192.168.31.139:3306 :::* LISTEN 1898/java