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

逃离我推掉我的手 2022-10-27 13:49 8阅读 0赞

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

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 linux keepalived和nginx高可用配置(二)

相关 mysql 读写分离 proxy_mysql proxy读写分离

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

相关 MHA高可用架构与Atlas读写分离

相关 keepalived+nginx实现高可用(二)

相关安装Centos7 、 Mysql8 集群，实现读写分离高可用（二）-- 数据库安装篇

相关 Atlas实现MySQL读写分离

相关安装Centos7 、 Mysql8 集群，实现读写分离高可用（四）-- MyCat读写分离

相关 MySQL高可用实现：主从结构下ProxySQL中的读写分离

相关 Mysql的高可用架构的搭建（同时实现读写分离）