1.介绍
Amoeba是mysql代理，增强mysql。类似的产品还有MyCat （mysql代理）
2.资源：点击打开链接c82k
3.准备：amoeba是基于java的所以必须有jdk
4.上传amoeba
5.解压tar包
6.配置文件
amoeba配置文件两个
dbServers.xml 多个数据源，多个数据库
amoeba.xml 启动参数，谁负责读，谁负责写，谁负责负载均衡
##################################dbServers.xml-start######################################
<?xml version="1.0"encoding="gbk"?>
<!DOCTYPE amoeba:dbServers SYSTEM"dbserver.dtd">
<amoeba:dbServersxmlns:amoeba="http://amoeba.meidusa.com/">
<!--
EachdbServer needs to be configured into a Pool,
Ifyou need to configure multiple dbServer with load balancing that can besimplified by the following configuration:
add attribute with name virtual ="true" in dbServer, but the configuration does not allow the elementwith name factoryConfig
such as 'multiPool' dbServer
-->
<dbServername="abstractServer" abstractive="true"><--建立抽象server动态代理-->
<factoryConfigclass="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">
<propertyname="manager">${defaultManager}</property>
<propertyname="sendBufferSize">64</property>
<propertyname="receiveBufferSize">128</property>
<!--mysql port ，所有的主从复制的数据库的用户名和密码都要用一套-->
<propertyname="port">3306</property>
<!--mysql schema默认的要去检查schema，一般是test的数据库默认不变 -->
<propertyname="schema">test</property>
<!--mysql user，用户名默认都是root -->
<propertyname="user">root</property>
<!-- mysql password ，密码是root-->
<propertyname="password">root</property>
</factoryConfig>
<poolConfigclass="com.meidusa.amoeba.net.poolable.PoolableObjectPool">
<propertyname="maxActive">500</property>
<propertyname="maxIdle">500</property>
<propertyname="minIdle">10</property>
<propertyname="minEvictableIdleTimeMillis">600000</property>
<propertyname="timeBetweenEvictionRunsMillis">600000</property>
<propertyname="testOnBorrow">true</property>
<propertyname="testOnReturn">true</property>
<propertyname="testWhileIdle">true</property>
</poolConfig>
</dbServer>
<dbServername="master" parent="abstractServer"><-默认继承了上面的abstractServer，所以是公用一套上面的配置--->
<factoryConfig>
<!--mysql ip 主的ip地址-->
<propertyname="ipAddress">192.168.170.43</property>
</factoryConfig>
</dbServer>
<dbServername="slave" parent="abstractServer">
<factoryConfig>
<!--mysql ip -->
<propertyname="ipAddress">192.168.170.85</property>
</factoryConfig>
</dbServer>
<dbServername="multiPool" virtual="true"><--多个池-->
<poolConfigclass="com.meidusa.amoeba.server.MultipleServerPool">
<!--Load balancing strategy（负载均衡算法）: 1=ROUNDROBIN轮询 , 2=WEIGHTBASED权重 , 3=HA高可用-->
<propertyname="loadbalance">1</property>
<!--Separated by commas,such as: server1,server2,server1配置那个数据库是负责读数据的 -->
<propertyname="poolNames">master,slave</property>
</poolConfig>
</dbServer>
</amoeba:dbServers>
##################################dbServers.xml-end######################################
##################################amoeba.xml-end######################################
<?xml version="1.0"encoding="gbk"?>
<!DOCTYPE amoeba:configuration SYSTEM"amoeba.dtd">
<amoeba:configurationxmlns:amoeba="http://amoeba.meidusa.com/">
<proxy>
<!--service class must implements com.meidusa.amoeba.service.Service -->
<servicename="Amoeba for Mysql"class="com.meidusa.amoeba.net.ServerableConnectionManager">
<!--port ，amoeba的端口-->
<propertyname="port">8066</property>
<!--bind ipAddress ，绑定地址，谁可以访问amoeba，如果要让所有的主机都可以访问，就不需要设置-->
<!--
<propertyname="ipAddress">127.0.0.1</property>
-->
<propertyname="manager">${clientConnectioneManager}</property>
<propertyname="connectionFactory">
<beanclass="com.meidusa.amoeba.mysql.net.MysqlClientConnectionFactory">
<propertyname="sendBufferSize">128</property>
<propertyname="receiveBufferSize">64</property>
</bean>
</property>
<propertyname="authenticator">
<beanclass="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">
<propertyname="user">root</property><-访问amoeba的用户名和密码--->
<propertyname="password">root</property>
<propertyname="filter">
<beanclass="com.meidusa.amoeba.server.IPAccessController">
<propertyname="ipFile">${amoeba.home}/conf/access_list.conf</property>
</bean>
</property>
</bean>
</property>
</service>
<!--server class must implements com.meidusa.amoeba.service.Service 阿米巴监控的，不需要监控默认不修改-->
<servicename="Amoeba Monitor Server"class="com.meidusa.amoeba.monitor.MonitorServer">
<!--port -->
<!-- default value: random number
<propertyname="port">9066</property>
-->
<!--bind ipAddress -->
<propertyname="ipAddress">127.0.0.1</property>
<propertyname="daemon">true</property>
<propertyname="manager">${clientConnectioneManager}</property>
<propertyname="connectionFactory">
<beanclass="com.meidusa.amoeba.monitor.net.MonitorClientConnectionFactory"></bean>
</property>
</service>
<runtimeclass="com.meidusa.amoeba.mysql.context.MysqlRuntimeContext">
<!--proxy server net IO Read thread size这些事实时运行的配置，默认不用改 -->
<propertyname="readThreadPoolSize">20</property>
<!--proxy server client process thread size -->
<propertyname="clientSideThreadPoolSize">30</property>
<!--mysql server data packet process thread size -->
<propertyname="serverSideThreadPoolSize">30</property>
<!--per connection cache prepared statement size -->
<propertyname="statementCacheSize">500</property>
<!--query timeout( default: 60 second , TimeUnit:second) -->
<propertyname="queryTimeout">60</property>
</runtime>
</proxy>
<!--
EachConnectionManager will start as thread
managerresponsible for the Connection IO read , Death Detection
-->
<connectionManagerList>
<connectionManagername="clientConnectioneManager" class="com.meidusa.amoeba.net.MultiConnectionManagerWrapper">
<propertyname="subManagerClassName">com.meidusa.amoeba.net.ConnectionManager</property>
<!--
default value is avaliable Processors
<propertyname="processors">5</property>
-->
</connectionManager>
<connectionManagername="defaultManager"class="com.meidusa.amoeba.net.MultiConnectionManagerWrapper">
<propertyname="subManagerClassName">com.meidusa.amoeba.net.AuthingableConnectionManager</property>
<!--
default value is avaliable Processors
<propertyname="processors">5</property>
-->
</connectionManager>
</connectionManagerList>
<!--default using file loader 指定刚刚配置过的dbServer.xml文件，将配置文件读入-->
<dbServerLoaderclass="com.meidusa.amoeba.context.DBServerConfigFileLoader">
<propertyname="configFile">${amoeba.home}/conf/dbServers.xml</property>
</dbServerLoader>
<queryRouterclass="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter">
<propertyname="ruleLoader">
<beanclass="com.meidusa.amoeba.route.TableRuleFileLoader">
<propertyname="ruleFile">${amoeba.home}/conf/rule.xml</property>
<propertyname="functionFile">${amoeba.home}/conf/ruleFunctionMap.xml</property>
</bean>
</property>
<propertyname="sqlFunctionFile">${amoeba.home}/conf/functionMap.xml</property>
<propertyname="LRUMapSize">1500</property>
<propertyname="defaultPool">master</property><--默认池只有master能写，所以要配主-->
<propertyname="writePool">master</property><--master能写，所以要配主-->
<propertyname="readPool">multiPool</property><--dbServer.xml中配置过能写的数据库，把他的属性写过来-->
<propertyname="needParse">true</property>
</queryRouter>
</amoeba:configuration>
##################################amoeba.xml-end######################################
7. 打开8066端口
/sbin/iptables -I INPUT -p tcp --dport 8066 -j ACCEPT
/etc/rc.d/init.d/iptables save #修改生效
/etc/init.d/iptables status #查看配置
8.启动和关闭amoeba
启动：./bin/amoeba start 或 ./bin/amoeba start &
关闭：
./bin/amoeba stop
9.启动报错
是因为jdk默认（128k）的栈太小了，而根据上述报错，栈需要228k才行
默认配置Xss比较小128k，启动时提示太小，则修改/amoeba/bin/amoeba文件，修改为256k即可。
DEFAULT_OPTS="-server -Xms256m-Xmx256m -Xss256k"
再次启动，ok
检查是否启动成功
10.使用第三方软件链接amoeba
使用主从复制的bug来检查是链接到了主还是从，将主数据库和从数据库中各添加一条独特的数据
11.如果链接上amoeba后发现查不出数据
根据状态可知主从配置失败了，需要从新配置
从错误可知，主键重了，重新配置
1）将从停了
2）到主上查看位置pos
重新执行挂接命令
启动从服务
验证
然后根据那个bug来看，经过amoeba链接的是从还是主
上图链接的是主
修改的话修改的是主数据库
