Amoeba新版本MYSQL读写分离如何配置

小编给大家分享一下Amoeba新版本MYSQL读写分离如何配置，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

官方简介

Amoeba的中文意思是变型虫

主要解决：

• 降低 数据切分带来的复杂多数据库结构

• 提供切分规则并降低 数据切分规则 给应用带来的影响

• 降低db 与客户端的连接数

• 读写分离

个人简单描述

可能你还没明白Amoebla这鬼东西主要干麻的呢！比方说PHP环境众所周知，PHP没有数据连接池，如果PHP环境下MYSQL访问量大时会蹦掉，除非配置Cluster集群，而Amoeba就是在PHP程序和MYSQL之间，充当一个缓冲的作用。

准备工作

Server:192.168.1.208 #Amoeba

Server:192.168.1.11  #NDBD1（主）

Server:1921.68.1.13  #NDBD2（从）

注：11和13两台服务器上，事先请安装好MYSQL单向步

另请安装MYSQL版本必须5.1以上，因为新版的Amoeba2.10对5.1以下版本不稳定。

结构图

Step 1:配置Amoeba192.168.2.8读写分离

1：解压安装包

[root@Management down]# mkdir /usr/local/amoeba

[root@Management down]# tar -zxf amoeba-mysql-binary-2.1.0-RC5.tar.gz -C /usr/local/amoeba/

2：进入配置目录，浏览文件

[root@Management down]# cd /usr/local/amoeba/

[root@Management amoeba]# ll

total 88

drwxr-xr-x 2 root root    4096 Jul 26 11:57 benchmark

drwxr-xr-x 2 root root    4096 Feb 28 09:25 bin

-rw-r--r-- 1 root root    3983 May 18 13:43 changelogs.txt

drwxr-xr-x 2 root root    4096 Jul 26 11:57 conf

drwxr-xr-x 3 root root    4096 Jul 26 11:57 lib

-rw-r--r-- 1 root root 34520 May 18 13:43 LICENSE.txt

-rw-r--r-- 1 root root    2031 May 18 13:43 README.html

3：进入主配置文件目录

[root@Management amoeba]# cd conf/

[root@Management conf]# ls

access_list.conf    amoeba.xml        dbServers.xml    functionMap.xml    log4j.xml    ruleFunctionMap.xml

amoeba.dtd                dbserver.dtd    function.dtd     log4j.dtd                rule.dtd     rule.xml

在这里我主要介绍配置  amoeba.xml、    dbServers.xml、 log4j.xml 三个主要的配置文件，其它文件没有特殊需要默认就可以了夺

4：vi amoeba.xml 修改主配置文件

4.1）把默认端口8066改成3306

3066

4.2）把默认连接用户名和密码改成自己的

<property name="user">sky</property>

                                                                                123456

4.3）把默认的客户端线程数，请求数及服务端回应数改成200，300，300

<property name="readThreadPoolSize">200</property>

<property name="clientSideThreadPoolSize">300</property>

                                                300

4.4）把默认注释掉的读写分离选项，把注释去掉并readpool修改成server2

                                -->

                                server1

<property name="readPool">server2</property>

5：vi dbServers.xml 增加SEVER2模块，里面的连接用户名密码及地址都表示两台MYSQL的物理机器，192.168.1.11和192.168.1.13 另SERVER1是写，SERVER是读

需要手动增加SERVER2代码如下：

  <dbServer name="abstractServer" abstractive="true">

<factoryConfig class="com.meidusa.amoeba.mysql-.MysqlServerConnectionFactory">

<property name="manager">${defaultManager}</property>

      <property name="sendBufferSize">64</property>

<property name="receiveBufferSize">128</property>

      <!-- mysql port -->

      <property name="port">3306</property>

      <!-- mysql schema -->

<property name="schema">test</property>

      <!-- mysql user -->

      <property name="user">root</property>

<!--    mysql password

      -->

      <property name="password">123456</property>

    </factoryConfig>

<poolConfig class="com.meidusa.amoeba-.poolable.PoolableObjectPool">

      <property name="maxActive">500</property>

<property name="maxIdle">500</property>

      <property name="minIdle">10</property>

<property name="minEvictableIdleTimeMillis">600000</property>

      <property name="timeBetweenEvictionRunsMillis">600000</property>

<property name="testOnBorrow">true</property>

      <property name="testWhileIdle">true</property>

    </poolConfig>

</dbServer>

  <dbServer name="server1"    parent="abstractServer">

    <factoryConfig>

      <!-- mysql ip -->

<property name="ipAddress">192.168.2.11</property>

    </factoryConfig>

  </dbServer>

最终改变成如下：

<?xml version="1.0" encoding="gbk"?>

<!DOCTYPE amoeba:dbServers SYSTEM "dbserver.dtd">

<amoeba:dbServers xmlns:amoeba="">

    <!--   

Each dbServer needs to be configured into a Pool,

If you need to configure multiple dbServer with load balancing that can be simplified by the following configuration:

add attribute with name virtual = "true" in dbServer, but the configuration does not allow the element with name factoryConfig

such as multiPool dbServer

    -->

  <dbServer name="abstractServer" abstractive="true">

<factoryConfig class="com.meidusa.amoeba.-.MysqlServerConnectionFactory">

      <property name="manager">${defaultManager}</property>

<property name="sendBufferSize">64</property>

      <property name="receiveBufferSize">128</property>

<!-- mysql port -->

      <property name="port">3306</property>

      <!-- mysql schema -->

<property name="schema">test</property>

      <!-- mysql user -->

      <property name="user">root</property>

      <!--    mysql password

      -->

<property name="password">123456</property>

    </factoryConfig>

<poolConfig class="com.meidusa.amoeba-.poolable.PoolableObjectPool">

      <property name="maxActive">500</property>

      <property name="maxIdle">500</property>

<property name="minIdle">10</property>

      <property name="minEvictableIdleTimeMillis">600000</property>

<property name="timeBetweenEvictionRunsMillis">600000</property>

<property name="testOnBorrow">true</property>

      <property name="testWhileIdle">true</property>

    </poolConfig>

  </dbServer>

<dbServer name="server1"    parent="abstractServer">

    <factoryConfig>

      <!-- mysql ip -->

<property name="ipAddress">192.168.2.11</property>

    </factoryConfig>

  </dbServer>

<!-- ########################把如上的内容复制到下面，来增加SERVER2############################ -->

  <dbServer name="abstractServer" abstractive="true">

<factoryConfig class="com.meidusa.amoeba.mysql-.MysqlServerConnectionFactory">

<property name="manager">${defaultManager}</property>

      <property name="sendBufferSize">64</property>

      <property name="receiveBufferSize">128</property>

<!-- mysql port -->

      <property name="port">3306</property>

      <!-- mysql schema -->

<property name="schema">test</property>

      <!-- mysql user -->

      <property name="user">root</property>

<property name="password">123456</property>

    </factoryConfig>

<poolConfig class="com.meidusa.amoeba-.poolable.PoolableObjectPool">

      <property name="maxActive">500</property>

      <property name="maxIdle">500</property>

<property name="minIdle">10</property>

      <property name="minEvictableIdleTimeMillis">600000</property>

<property name="timeBetweenEvictionRunsMillis">600000</property>

      <property name="testOnBorrow">true</property>

<property name="testWhileIdle">true</property>

    </poolConfig>

  </dbServer>

<dbServer name="server2"    parent="abstractServer">

    <factoryConfig>

      <!-- mysql ip -->

      <property name="ipAddress">192.168.2.13</property>

</factoryConfig>

  </dbServer>

 <dbServer name="multiPool" virtual="true">

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

      <!-- Load balancing strategy: 1=ROUNDROBIN , 2=WEIGHTBASED , 3=HA-->

<property name="loadbalance">1</property>

      <!-- Separated by commas,such as: server1,server2,server1 -->

<property name="poolNames">server1</property>

    </poolConfig>

  </dbServer>

</amoeba:dbServers>

6：修改log4j.xml 取消日志文件生成（太大了，磁盘很容易满）

改成

7：性能优化，打开bin/amoeba

DEFAULT_OPTS="-server -Xms256m -Xmx256m -Xss128k"

改成

DEFAULT_OPTS="-server -Xms512m -Xmx512m -Xmn100m -Xss1204k"

8：启动amoeba

nohup /usr/local/amoeba/bin/amoeba start 2>&1 >/dev/null &

看完了这篇文章，相信你对“Amoeba新版本MYSQL读写分离如何配置”有了一定的了解，如果想了解更多相关知识，欢迎关注行业资讯频道，感谢各位的阅读！