amoeba高可用mysql_mysql-mmm+amoeba+keepalived实现mysql高可用和读写分离（二）

encoding="gbk"?>

/p>

"amoeba.dtd">

xmlns:amoeba="http://amoeba.meidusa.com/">

name="port">8066

name="ipAddress">192.168.1.163

name="readThreadPoolSize">20

name="clientSideThreadPoolSize">30

name="serverSideThreadPoolSize">30

name="netBufferSize">128

name="tcpNoDelay">true

name="user">root

name="password">password

name="queryTimeout">60

name="defaultManager"

class="com.meidusa.amoeba.net.MultiConnectionManagerWrapper">

name="subManagerClassName">com.meidusa.amoeba.net.AuthingableConnectionManager

name="server1">

class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">

name="manager">defaultManager

name="port">3306

name="ipAddress">192.168.1.113

name="schema">test

name="user">zhang

name="password">zhang123

class="com.meidusa.amoeba.net.poolable.PoolableObjectPool">

name="maxActive">200

name="maxIdle">200

name="minIdle">10

name="minEvictableIdleTimeMillis">600000

name="timeBetweenEvictionRunsMillis">600000

name="testOnBorrow">true

name="testWhileIdle">true

name="server2">

class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">

name="manager">defaultManager

name="port">3306

name="ipAddress">192.168.1.111

name="schema">test

name="user">zhang

name="password">zhang123

class="com.meidusa.amoeba.net.poolable.PoolableObjectPool">

name="maxActive">200

name="maxIdle">200

name="minIdle">10

name="minEvictableIdleTimeMillis">600000

name="timeBetweenEvictionRunsMillis">600000

name="testOnBorrow">true

name="testWhileIdle">true

name="server3">

class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">

name="manager">defaultManager

name="port">3306

name="ipAddress">192.168.1.112

name="schema">test

name="user">zhang

name="password">zhang123

class="com.meidusa.amoeba.net.poolable.PoolableObjectPool">

name="maxActive">200

name="maxIdle">200

name="minIdle">10

name="minEvictableIdleTimeMillis">600000

name="timeBetweenEvictionRunsMillis">600000

name="testOnBorrow">true

name="testWhileIdle">true

name="server4">

class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">

name="manager">defaultManager

name="port">3306

name="ipAddress">192.168.1.114

name="schema">test

name="user">zhang

name="password">zhang123

class="com.meidusa.amoeba.net.poolable.PoolableObjectPool">

name="maxActive">200

name="maxIdle">200

name="minIdle">10

600000

name="timeBetweenEvictionRunsMillis">600000

name="testOnBorrow">true

name="testWhileIdle">true

name="server5">

class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">

name="manager">defaultManager

name="port">3306

name="ipAddress">192.168.1.115

name="schema">test

name="user">zhang

name="password">zhang123

class="com.meidusa.amoeba.net.poolable.PoolableObjectPool">

name="maxActive">200

name="maxIdle">200

name="minIdle">10

name="minEvictableIdleTimeMillis">600000

name="timeBetweenEvictionRunsMillis">600000

name="testOnBorrow">true

name="testWhileIdle">true

name="master" virtual="true">

class="com.meidusa.amoeba.server.MultipleServerPool">

name="loadbalance">1

name="poolNames">server1

name="slave" virtual="true">

class="com.meidusa.amoeba.server.MultipleServerPool">

name="loadbalance">1

name="poolNames">server2,server3,server4,server5

class="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter">

name="ruleConfig">${amoeba.home}/conf/rule.xml

name="functionConfig">${amoeba.home}/conf/functionMap.xml

name="ruleFunctionConfig">${amoeba.home}/conf/ruleFunctionMap.xml

name="LRUMapSize">1500

name="defaultPool">master

name="writePool">master

slave

name="needParse">true