Amoeba实现Mysql读写分离部署文档
时间:2022-03-10 17:54
<poolConfig
class="com.meidusa.amoeba.server.MultipleServerPool">
# loadbalance:负载方式1:轮询2:加权重3:HA
<property name="loadbalance">1</property>
#组成员为slave
<property name="poolNames">slave</property>
</poolConfig>
</dbServer>
[root@amoeba ~]# vim /usr/local/amoeba/conf/amoeba.xml
调整amoeba.xml部分参数:
#amoeba监听端口3306,客户端请求时使用
<property name="port">3306</property>
<property name="authenticator">
<beanclass="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">
#指定客户端连接amoeba的账户与密码
<property name="user">amoeba</property>
<property name="password">zrer90</property>
<property name="filter">
#指定默认池
<property name="defaultPool">master</property>
#指定写dbserver
<property name="writePool">master</property>
#指定读dbserver
<property name="readPool">ReadPool</property>
[root@amoeba ~]# vim /usr/local/amoeba/bin/amoeba
调整DEFAULT_OPTS变量参数:第58行
DEFAULT_OPTS="-server -Xms256m -Xmx256m -Xss128k"
更改后:
DEFAULT_OPTS="-server -Xms256m -Xmx256m –Xss256k"
2.4:启动amoeba
[root@amoeba amoeba]# amoeba start & #不想看提示信息的话将上&>/dev/null
[root@amoeba ~]# netstat -anpt |grep java
tcp 0 0 ::ffff:127.0.0.1:21740 :::* LISTEN 2476/java
tcp 0 0 :::3306 :::* LISTEN 2476/java
tcp 0 0 ::ffff:192.168.1.49:57069 ::ffff:192.168.1.39:3306 ESTABLISHED 2476/java
tcp 0 0 ::ffff:192.168.1.49:37374 ::ffff:192.168.1.40:3306 ESTABLISHED 2476/java
本地监听3306端口接受客户端请求,amoeba服务器本地与master192.168.1.39:3306,slave192.168.1.40:3306建立连接;
停止amoeba:
[root@amoeba amoeba]# amoeba stop
本文出自 “” 博客,请务必保留此出处
Amoeba实现Mysql读写分离部署文档,布布扣,bubuko.com