使用Amoeba实现MySQL读写分离详细步骤(推荐的方式)

喜欢ヅ旅行 2023-10-08 11:02 16阅读 0赞

> 什么是Amoeba

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70][]

> 为什么使用Amoeba

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 1][]

> 安装Amoeba

![20191223141455991.png][]

①安装jdk并配置环境变量

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 2][]

vi /etc/profile

![20191223141926282.png][]

source /etc/profile 使配置生效

![20191223142014605.png][]

上传Amoeba安装文件: 如果没有安装zip/unzip软件先yum install一下

![20191223142309103.png][]

![20191223142427558.png][]

修改配置文件:

![20191223142614491.png][]

vi dbServers.xml

输入d + G清空配置文件中的内容, 重新进行配置

![20191223143838377.png][]

> dbServer.xml配置内容:

<?xml version="1.0" encoding="gbk"?>
    
    <!DOCTYPE amoeba:dbServers SYSTEM "dbserver.dtd">
    <amoeba:dbServers xmlns:amoeba="http://amoeba.meidusa.com/">
    
    		
    		
    	<dbServer name="abstractServer" abstractive="true">
    		<factoryConfig class="com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory">
    			<property name="connectionManager">${defaultManager}</property>
    			<property name="sendBufferSize">64</property>
    			<property name="receiveBufferSize">128</property>
    				
    			
    			<property name="port">3306</property>
    			
    			
    			<property name="schema">msb</property>
    			
    			
    			<property name="user">root</property>
    			
    			<property name="password">123456</property>
    		</factoryConfig>
    
    		<poolConfig class="com.meidusa.toolkit.common.poolable.PoolableObjectPool">
    			<property name="maxActive">500</property>
    			<property name="maxIdle">500</property>
    			<property name="minIdle">1</property>
    			<property name="minEvictableIdleTimeMillis">600000</property>
    			<property name="timeBetweenEvictionRunsMillis">600000</property>
    			<property name="testOnBorrow">true</property>
    			<property name="testOnReturn">true</property>
    			<property name="testWhileIdle">true</property>
    		</poolConfig>
    	</dbServer>
    
    	<dbServer name="writedb"  parent="abstractServer">
    		<factoryConfig>
    			
    			<property name="ipAddress">192.168.85.11</property>
    		</factoryConfig>
    	</dbServer>
    	
    	<dbServer name="slave"  parent="abstractServer">
    		<factoryConfig>
    			
    			<property name="ipAddress">192.168.85.12</property>
    		</factoryConfig>
    	</dbServer>
    	<dbServer name="myslave" virtual="true">
    		<poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
    			
    			<property name="loadbalance">1</property>
    			
    			
    			<property name="poolNames">slave</property>
    		</poolConfig>
    	</dbServer>
    </amoeba:dbServers>

> amoeba.xml配置内容:

<?xml version="1.0" encoding="gbk"?>
    
    <!DOCTYPE amoeba:configuration SYSTEM "amoeba.dtd">
    <amoeba:configuration xmlns:amoeba="http://amoeba.meidusa.com/">
    
    	<proxy>
    	
    		
    		<service name="Amoeba for Mysql" class="com.meidusa.amoeba.mysql.server.MySQLService">
    			
    			<property name="port">8066</property>
    			
    			
    			
    			
    			<property name="connectionFactory">
    				<bean class="com.meidusa.amoeba.mysql.net.MysqlClientConnectionFactory">
    					<property name="sendBufferSize">128</property>
    					<property name="receiveBufferSize">64</property>
    				</bean>
    			</property>
    			
    			<property name="authenticateProvider">
    				<bean class="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">
    					
    					<property name="user">root</property>
    					
    					<property name="password">123456</property>
    					
    					<property name="filter">
    						<bean class="com.meidusa.toolkit.net.authenticate.server.IPAccessController">
    							<property name="ipFile">${amoeba.home}/conf/access_list.conf</property>
    						</bean>
    					</property>
    				</bean>
    			</property>
    			
    		</service>
    		
    		<runtime class="com.meidusa.amoeba.mysql.context.MysqlRuntimeContext">
    			
    			
    			<property name="executeThreadSize">128</property>
    			
    			
    			<property name="statementCacheSize">500</property>
    			
    			
    			<property name="serverCharset">utf8</property>
    			
    			
    			<property name="queryTimeout">60</property>
    		</runtime>
    		
    	</proxy>
    	
    	
    	<connectionManagerList>
    		<connectionManager name="defaultManager" class="com.meidusa.toolkit.net.MultiConnectionManagerWrapper">
    			<property name="subManagerClassName">com.meidusa.toolkit.net.AuthingableConnectionManager</property>
    		</connectionManager>
    	</connectionManagerList>
    	
    		
    	<dbServerLoader class="com.meidusa.amoeba.context.DBServerConfigFileLoader">
    		<property name="configFile">${amoeba.home}/conf/dbServers.xml</property>
    	</dbServerLoader>
    	
    	<queryRouter class="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter">
    		<property name="ruleLoader">
    			<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>
    			</bean>
    		</property>
    		<property name="sqlFunctionFile">${amoeba.home}/conf/functionMap.xml</property>
    		<property name="LRUMapSize">1500</property>
    		<property name="defaultPool">writedb</property>
    		
    		<property name="writePool">writedb</property>
    		<property name="readPool">myslave</property>
    		<property name="needParse">true</property>
    	</queryRouter>
    </amoeba:configuration>

> 启动amoeba

如果出现栈内存配置不够的错误提示, 需要改下配置文件, 进入amoeba文件夹, vi jvm.properties

![20191223144228818.png][]

![20191223144129342.png][]

./launcher启动amoeba:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 3][]

> 登录:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 4][]

> 测试amoeba

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 5][]

将写库所在的节点停掉:

![20191223144832776.png][]

再进行insert的操作,会报错:

![20191223144913874.png][]

同样地,如果将读库所在的节点停掉, 也会报错:

![20191223145042422.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191223141103628.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191223141232360.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[20191223141455991.png]: https://img-blog.csdnimg.cn/20191223141455991.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2019122314184130.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[20191223141926282.png]: https://img-blog.csdnimg.cn/20191223141926282.png
[20191223142014605.png]: https://img-blog.csdnimg.cn/20191223142014605.png
[20191223142309103.png]: https://img-blog.csdnimg.cn/20191223142309103.png
[20191223142427558.png]: https://img-blog.csdnimg.cn/20191223142427558.png
[20191223142614491.png]: https://img-blog.csdnimg.cn/20191223142614491.png
[20191223143838377.png]: https://img-blog.csdnimg.cn/20191223143838377.png
[20191223144228818.png]: https://img-blog.csdnimg.cn/20191223144228818.png
[20191223144129342.png]: https://img-blog.csdnimg.cn/20191223144129342.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191223144359994.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191223144502290.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/201912231445326.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2E3NzIzMDQ0MTk=,size_16,color_FFFFFF,t_70
[20191223144832776.png]: https://img-blog.csdnimg.cn/20191223144832776.png
[20191223144913874.png]: https://img-blog.csdnimg.cn/20191223144913874.png
[20191223145042422.png]: https://img-blog.csdnimg.cn/20191223145042422.png