安装准备
unzip amoeba-mysql-3.0.5-RC-distribution.zip
java -version查看是否安装 没有安装 yum -y install java
主服务器 IP:10.10.120.56 wuwu2
中间件 IP:10.10.120.55 wuwu1
从服务器IP:10.10.120.57 wuwu3
amoeba配置文件:
vi amoeba.xml
<service name="Amoeba for Mysql" class="com.meidusa.amoeba.net.ServerableConnectionManager">
<property name="port">8066</property>
<property name="ipAddress">10.10.120.55</property>
<property name="authenticator">
<bean class="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">
<property name="user">wuwu</property>
<property name="password">123456</property>
<queryRouter class="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter">
<bean class="com.meidusa.amoeba.route.TableRuleFileLoader">
<property name="ruleFile">${amoeba.home}/conf/rule.xml</property>
<property name="functionFile">${amoeba.home}/conf/ruleFunctionMap.xml</property>
<property name="sqlFunctionFile">${amoeba.home}/conf/functionMap.xml</property>
<property name="LRUMapSize">1500</property>
<property name="defaultPool">master</property># 设定默认节点
<property name="writePool">maseter</property> # 设定可写节点,节点定义见dbServers.xml文件
<property name="readPool">readpool</property> # 设定只读池,可配置多个slave节点
#readPool或writePool可以是dbServers中的multiPool名称,用multiPool来设置负载均衡。
<property name="needParse">true</property>
# 读写分离配置,读池和写池和dbServer.xml中配置的节点相关
<dbServer name="abstractServer" abstractive="true">
<factoryConfig class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">
<property name="manager">${defaultManager}</property>
<property name="sendBufferSize">64</property>
<property name="receiveBufferSize">128</property>
<property name="port">3306</property>
<property name="schema">test</property>
<property name="user">root</property>
<property name="password"></property>
# 默认连接mysql server的密码,以上两项如不在下文中的dbserver中单独定义,则直接继承此处定义
# 定义连接mysql服务的用户amoeba和密码my123和数据库chejecms
# 定义后端MySQL的IP地址,一个master,一个slave
<dbServer name="master" parent="abstractServer">
<property name="ipAddress">172.19.200.204</property>
<!-- <property name="user">amoeba</property>
<property name="password">my123</property> -->
<dbServer name="slave1" parent="abstractServer">
<property name="ipAddress">172.18.109.213</property>
<!-- <property name="user">amoeba</property>
<property name="password">my123</property> -->
<dbServer name="readpool" virtual="true">
<poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
<!-- Load balancing strategy: 1=ROUNDROBIN , 2=WEIGHTBASED , 3=HA-->
<property name="loadbalance">1</property>
<!-- Separated by commas,such as: server1,server2,server1 -->
<property name="poolNames">master,slave1</property>
#1为轮询策略,里面的master,slaver1按请求轮询调用
sh /root/amoeba-mysql-3.0.5-RC/bin/launcher