读写分离指的是客户只能在主服务器上写，只能在从服务器上读，当然了，这也是要看配置，你可以在主服务器配置读的功能，但是在从服务器上只能读不能写，因为从服务器是基于binlog对主服务器的复制，如果在从服务器上写的话，会造成主从不一致的结果。mysql实现读写分离，写的压力虽然没有减少，但是读的压力瞬间就减少了一半。
Amoeba的中文意思是阿米巴、变型虫
Amoeba是一个以MySQL为底层数据存储，并对应用提供MySQL协议接口的proxy代理服务器。它集中地响应应用的请求，依据用户事先设置的规则，将SQL请求发送到特定的数据库上执行。基于此可以实现负载均衡、读写分离、高可用性等需求。与MySQL官方的MySQL Proxy相比，作者强调的是amoeba配置的方便（基于XML的配置文件，用SQLJEP语法书写规则，比基于lua脚本的MySQL Proxy简单）。
Amoeba相当于一个SQL请求的路由器， 目的是为负载均衡、读写分离、高可用性提供机制，而不是完全实现它们。用户需要结合使用MySQL的 Replication等机制来实现副本同步等功能。amoeba对底层数据库连接管理和路由实现也采用了可插拨的机制，第三方可以开发更高级的策略类来 替代作者的实现。这个程序总体上比较符合KISS原则的思想。
1、环境介绍
Master–IP:192.168.1.135(主服务器)
Slave—IP:192.168.1.136(从服务器)
Amoeba–IP:192.168.1.137(代理服务器)
Client–IP:192.168.1.138(客户机)
2、安装JDK
#mkdir /Amoeba
#tar –xvf jdk-7u40-linux-x64.tar.gz
# vim /etc/profile
JAVA_HOME=/Amoeba/jdk1.7.0_40
export JAVA_HOME
PATH=$JAVA_HOME/bin:$PATH
export PATH
CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar:$CLASSPATH
export CLASSPATH
3、安装Amoeba
#:mkdir /usr/local/amoeba
#:unzip amoeba-mysql-1.3.1-BETA.zip -d /usr/local/amoeba
#:chmod -R +x /usr/local/amoeba/bin/
# java -version java version “1.7.0_40″Java(TM) SE Runtime Environment (build 1.7.0_40-b43)
Java HotSpot(TM) 64-Bit Server VM (build 24.0-b56, mixed mode)
4、主从授权，增加用户
mysql–>grant all privileges on *.* to amoeba@’%’ identified by ‘amoeba123’;
mysql–>flush privileges;
5、amoeba相关的配置
<?xml version=”1.0″ encoding=”gbk”?>
<!DOCTYPE amoeba:configuration SYSTEM “amoeba.dtd”>
<amoeba:configuration xmlns:amoeba=”“>http://amoeba.meidusa.com/”>
<!–
amoeba开放接口相关配置
–>
<server>
<!– proxy server绑定的端口 –>
<property name=”port”>9006</property>
<!– proxy server绑定的IP –>
<property name=”ipAddress”>192.168.1.137</property>
<!– proxy server net IO Read thread size –>
<property name=”readThreadPoolSize”>20</property>
<!– proxy server client process thread size –>
<property name=”clientSideThreadPoolSize”>30</property>
<!– mysql server data packet process thread size –>
<property name=”serverSideThreadPoolSize”>30</property>
<!– socket Send and receive BufferSize(unit:K) –>
<property name=”netBufferSize”>128</property>
<!– Enable/disable TCP_NODELAY (disable/enable Nagle’s algorithm). –>
<property name=”tcpNoDelay”>true</property>
<!– 对外验证的用户名 –>
<property name=”user”>root</property>
<!– 对外验证的密码 –>
<property name=”password”>aixocm</property>
<!– query timeout( default: 60 second , TimeUnit:second) –>
<property name=”queryTimeout”>60</property>
</server>
<!–
每个ConnectionManager都将作为一个线程启动。
manager负责Connection IO读写/死亡检测
–>
<connectionManagerList>
<connectionManager name=”defaultManager” class=”com.meidusa.amoeba.net.MultiConnectionManagerWrapper”>
<property name=”subManagerClassName”>com.meidusa.amoeba.net.AuthingableConnectionManager</property>
<!–
default value is avaliable Processors
<property name=”processors”>5</property>
–>
</connectionManager>
</connectionManagerList>
<dbServerList>
<!–
一台mysqlServer 需要配置一个pool，
如果多台 平等的mysql需要进行loadBalance，
平台已经提供一个具有负载均衡能力的objectPool：com.meidusa.amoeba.mysql.server.MultipleServerPool
简单的配置是属性加上 virtual=”true”,该Pool 不允许配置factoryConfig
或者自己写一个ObjectPool。
–>
<!–
master授权相关设置
–>
<dbServer name=”server1″>
<!– PoolableObjectFactory实现类 –>
<factoryConfig class=”com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory”>
<property name=”manager”>defaultManager</property>
<!– 真实mysql数据库端口 –>
<property name=”port”>3306</property>
<!– 真实mysql数据库IP –>
<property name=”ipAddress”>192.168.1.135</property>
<property name=”schema”>test</property>
<!– 用于登陆mysql的用户名 –>
<property name=”user”>amoeba</property>
<!– 用于登陆mysql的密码 –>
<property name=”password”>amoeba</property>
</factoryConfig>
<!– ObjectPool实现类 –>
<poolConfig class=”com.meidusa.amoeba.net.poolable.PoolableObjectPool”>
<property name=”maxActive”>200</property>
<property name=”maxIdle”>200</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>
<!–
slave数据库授权相关设置
–>
<dbServer name=”server2″>
<!– PoolableObjectFactory实现类 –>
<factoryConfig class=”com.meidusa.amoeba.mysql.net.MysqlServerConnectionFactory”>
<property name=”manager”>defaultManager</property>
<!– 真实mysql数据库端口 –>
<property name=”port”>3306</property>
<!– 真实mysql数据库IP –>
<property name=”ipAddress”>192.168.1.136</property>
<property name=”schema”>test</property>
<!– 用于登陆mysql的用户名 –>
<property name=”user”>amoeba</property>
<!– 用于登陆mysql的密码 –>
<property name=”password”>amoeba</property>
</factoryConfig>
<!– ObjectPool实现类 –>
<poolConfig class=”com.meidusa.amoeba.net.poolable.PoolableObjectPool”>
<property name=”maxActive”>200</property>
<property name=”maxIdle”>200</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>
<!–
master均衡负载
–>
<dbServer name=”master” virtual=”true”>
<poolConfig class=”com.meidusa.amoeba.server.MultipleServerPool”>
<!– 负载均衡参数 1=ROUNDROBIN , 2=WEIGHTBASED , 3=HA–>
<property name=”loadbalance”>1</property>
<!– 参与该pool负载均衡的poolName列表以逗号分割 –>
<property name=”poolNames”>server1</property>
</poolConfig>
</dbServer>
<!–
slave均衡负载
–>
<dbServer name=”slave” virtual=”true”>
<poolConfig class=”com.meidusa.amoeba.server.MultipleServerPool”>
<!– 负载均衡参数 1=ROUNDROBIN , 2=WEIGHTBASED , 3=HA–>
<property name=”loadbalance”>1</property>
<!– 参与该pool负载均衡的poolName列表以逗号分割 –>
<property name=”poolNames”>server1,server2</property>
</poolConfig>
</dbServer>
<!–
读写分离配置
–>
</dbServerList>
<queryRouter class=”com.meidusa.amoeba.mysql.parser.MysqlQueryRouter”>
<property name=”ruleConfig”>${amoeba.home}/conf/rule.xml</property>
<property name=”functionConfig”>${amoeba.home}/conf/functionMap.xml</property>
<property name=”ruleFunctionConfig”>${amoeba.home}/conf/ruleFunctionMap.xml</property>
<property name=”LRUMapSize”>1500</property>
<property name=”defaultPool”>master</property>
<property name=”writePool”>master</property>
<property name=”readPool”>slave</property>
<property name=”needParse”>true</property>
</queryRouter>
</amoeba:configuration>
6、启动Amoeba
# cd /usr/local/amoeba/bin
这种启动方便看nohup.log日志.防止提示溢出
#:nohup bash -x amoeba &
#:重启amoeba要先杀死amoeba进程
#ps -ef|grep amoeba|awk ‘{print $2}’|xargs kill -9
#echo >nohup.out
#nohup bash -x amoeba &
常见错误：1
The stack size specified is too small, Specify at least 228k
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
解决办法:
# vim /usr/local/amoeba/bin/amoeba
#DEFAULT_OPTS=”-server -Xms256m -Xmx256m -Xss128k” 注释
DEFAULT_OPTS=”-server -Xms256m -Xmx256m -Xss256k” 增加
7、测试是否读写分离
1、在(master)主上的test库建立一个alvin的表
Mysql->use test;
Mysql->create table alvin(id int,name char(10));
2、在(slave)从上查看test库是否同步了alvin表
Mysql-> use test;
Mysql->show tables;
3、在主(master)操作.插入一条数据.
mysql–>insert into alvin values(1,’master’);
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAakAAAByCAIAAABmwLlUAAAIyUlEQVR4nO3d24GrIBCA4fREOxZDL9RCKfaxD9koyIBMotEh//dyTrzAoDILmsvjAQBITWGO3l0bg/Nx/hemb5bvfDynxpT+CE/hxINRsxyk42s9+/web4n40r7x9nH7ynVt3R0y3+LsM1aW/51rRF3LdWdlCiemJzs98lbdwtBxs+Tcc1zrSMmfs6x267mvnjiUx7my+VGJqVGOidynD9L5qNnhZsnmZuGM4eQ/b+I1OoU14zkf0wDGzX3Kesh9TYognY/Ru1fum0LffjdLNjcLZwiVYzqFOXoftncapmVJvpO0PBnZ5au2l23Wy+V4avUmK4rRo7S8nvumoq2NesXF1fbWq24pcl+zfEX4u3H2p5XqaanE82hdb73ndzd+geqmWVFBch4U/cL5OMcY53meg38WuTvI0Fy3jX6zhJPu0brOX1XfaJL/BY3hRbEi6RTZaK22fLOuWPI8DzGEmF8x28uzVW/SJfx66tcQtvXLuS+/ioX/p/Vmh2wKtdYVPsx99fIPjrM391XLb10PR5xfTZBJtZ2prxGoql+8/ut8fK7enWHprtusQGH1dlH9Ol9Xk/sqi/Nl66va8tfL8hiHKVmzXBv5am29nQ2Uc5+qXVmXFKr7du47Ok5F7uu4dnaP/3vnVzfnnaN3zzlv937V3NfbL9ILPXqnvbu0f9ykuhoNqF7nP6s153WtLWvHvTf3rbtlBezej2ue76RSec7yfvlpu+pTkwtyXzkH/DDO/rQilt+I51Efd5fbtw/XRc863ukX/blPdd0mlYkrpdxX76c/ST4G5477XpdCPgBcVn84Lsir7Br3iddEs12V1jX65GnPOqb9u/eaON9IK/kuzXjk8ytuf9S47z3fH/cpr9t1q0lcR+7bV+vUzZ7efb+vWJBs/f9nLsaYn/PGzfee+0HFCK19A7J+TdTu44TqXRmpvULBPSqbS+Vv/3i8htPvxdmbVurly/HUS69tXzm/e/Efoz/3Va8Tfe7TXLfrYvk2pjb3NW+RjOr/PQCZRs+THhO1nqOtA/lafqzskGxTLX8tXN46el+0ZFN+65qQ621MJaX2LvuoxinVniKWv38cOuN8KIZUO1PqWs3C+a1u3yinGv8xFLlPvk70c17ddZsurXXGNCZyn+jb49/88cYv0B/h15X+1cOkfxyKQZx+EwGL1sgAwFdJkz8AAAAAAAAAAAAAAO7FyodbrMSpNWq7gLuz0vesxKk1aruAu7PS96zEqTVqu4CbKj/1d8+PMlmJU2vUdgFmSOOOtWPmq65abiXOo9oF4HxW+p6VOLVGbRdwd1b6npU4tUZtFwAAAAAAAAAAAAAAwJG077HY+cWx096yMep7QUZtF3B3B/c9cp/SqO0C7o7cd61R2wXcHbnvWqO2C7g7Rd9bflN3e79vWSH9nvyX43zej1x//jeNNfnylKUs5+McY5zneQ7+uX6tRy7mUOQ+4BqfP+tIftLd+XjWj41rct+aqtKfm59CntSey52Pc/TuuV+Ykoo27TopQ5H7gGt8nPvyAi6f827SVG23ZfnSnteS7b+66tXIfcA1Ps19m9eX54hGPOsMNpn21nJf+eWi5D5gJCOO+8Tcl05/O8d93/geZXIfcI0R7/fVcl/2gGMv9+XJ0vl4TiYk9wHX6O575SQwTQw3e84r7ZY95fW7477/vU+d8D7IfcBVrPQ9K3Fqjdou4O6s9D0rcWqN2i4AAAAAAAAAAAAAAIAjWXmPhZU4tUZtF3B3VvqelTi1Rm0XcHdW+p6VOLVGbRdwU+Wnc8/8cuL3WYlTa9R2AWZI4461Y+arrlpuJc6j2gXgfFb6npU4tUZtF3B3VvqelTi1Rm0XAAAAAAAAAAAAAADAkay8x8JKnFqjtgu4Oyt9z0qcWqO2C7i77/e91ie86q7JEdnvk59VA7kPuMBlfU9ZMbkPwJFGy33OxznGOM/zHPxzhLnsl3x5SlrWFIRvUim/aCXJgeseeWKcwhy9r6z8rF0AjjVk7vPumbvClOw4hbWAZDyXFTyFIpkVGSxZ9qosXaU8nOQ+4Boj5r4wJTvIO65Lp9BIV0Luy8trvepC7gOu8UO5L5nb9kyFX7vkua+cC5P7AIt+JvflaUwsrsx08riveh+P3AeY8Uu5Lx/pPV85H6S7gElpzbGg8zF/BkLuA2y4oO/V5p57O304582mtn4trjHlzYIVn/Pme5D7ADOs9D0rcWqN2i7g7qz0PStxao3aLgAAAAAAAAAAAAAAgCNZeY+FlTi1Rm0XcHdW+p6VOLVGbRdwd1b6npU4tUZtF3BT5VcxdX7P8JdZiVNr1HYBZkjjjtqvCV213EqcR7ULwPms9D0rcWqN2i7g7qz0PStxao3aLgAAAAAAAAAAAAAAgJEtv7N2f+O9PWW8FgE42pB5wtBfHuBtrU9a/ZryV8k79uj+jF3NO5+BO9uQKR2QcLE/3sh9wlFLyugqrra9tpxjMfLDz9DkvinM0fuw/d6RaVnyWiT0oP1OtRSTbvbcbSrq7Cmn2FoopvxClZ6eLzQmO44dGaS2vbYcZXs3y8tTT/LDr1DmvrK7JIMT5+P/6rLUznq2Xe+Zm9Isq8kpU1i3FuMs13UpG7OJe7e1te215ejbO4XkHDrvN80m9+FXqMd9rrVseTWFZw96LXA+dlUj5T6p/FaM4iaVONedDsl9U3hm6t0Ca9try1G3d+8IkvvwKz7MfTvjlynEGKN33T1Kyn2qcVA2jc1nj7lPcl/ZnMvGfcr27p4Ich9+xUnjvte9wejdFKL3obNDHZD70o2zRwj1CA541nHd/b60yP327hxBUh9+xqe5r3VfKcbg3WMZ/PVU8Wnucz4kd7/SjJa9cj42ZtYdxORXfz7rfNxOTY95zqtvb/t+H4/98QOS54PyIz9pD2mrZH6V9FTnY3IPa3cwUXngqh/3iVPAbYul4aviOe9DvIHZeF+ekPuOen/fG+2tHgdGfQB2jTdEGq9FAAAAAAAAAAAAgGV/V/hNLzQkO6wAAAAASUVORK5CYII=" alt="" />
4、在从(slave)操作,插入一条数据.
mysql–>insert into alvin values(2,’slave’);
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYEAAABtCAIAAADIyko+AAAExElEQVR4nO3d23GrMBAAUPdEOy6GXqiFUujjfvjGICOw5EfIinN+MgEDu5nZDQIjLhcAAAAAAAAAAAAAAAAAAAAAAKAZ12Ea++7oKJ6LEmetVvOCUlFqIEqctVrNC0pFqYEocdZqNS94ouvHaWW4Hh3WSpQ4a7WaF1TL/R+eCyRdddTyKHF+Ki84kyg1ECXOWq3mBaWi1ECUOGu1mhcAAAAAAAAAs9p7w10/7n2f92u3mlu9h91qXlDqwzWgB1VqNS8opQcdq9W8oJQedKxW84JSFTVwHTae776vGPv+6B50u151jyiJdfGw+n1fXT9O4zhO0zQN/W39fJz8bj5KD+Ls3r8mfR3uJdr1Y+7Z8E+o6UFzy1jEdrkOaXO5Le/6cRr77rbdcF0c6CGvL3UKPYize7sHpTs4fCz20C62Nrsvv+fzs+TxZ93hq+lBnN27Pejh98NrdSeeeWS1GI5t9aD1JGN6EHxDi+dB2R60HJYVngf9xryGehBn1+L1oK0elFyIftaD0qbV9eN3OpIexNkV18B6cLIs0D92Xyy3WXJXrH96HvR/668OxC56EESpgShx1mo1LygVpQaixFmr1bwAAAAAAAAAmEW5Nxwlzlqt5gWlotRAlDhrtZoXlIpSA1HirNVqXvDE+umvb04W+LoocdZqNS+olvs/PBdIuuqo5VHi/FRecCZRaiBKnLVazQtKRamBKHHWajUvAAAAAAAAAGZR7g1HibNWq3lBqSg1ECXOWq3mBaV+vwb2nlzYdkytpi9n/dIR9CBO7bAaqDywHgRtaq0Hdf04jeM4TdM09LczrvQVz+tTsPltqot+s/Na2eUWq9dej32/sfK9vKBVTfagvrv1kOGavD9+3sHi/CbZ8XVYNZVVJ1ks+znYclXln1MP4uxa7EGb74/P7e467LSNTA9K97f3WxE9iLM7UQ9ajLlKhmg/m6Q9aD1G04PgHafpQWk7ye5u3XHy50Gb13n0IKh2ph6Unvncfuv6IXeVaLG33XOjrh/Ta9V6ENQ5oAa2xkTPNnpzLJYMufp5dztDsSTY7H2xdAs9CKpFqYEocdZqNS8oFaUGosRZq9W8AAAAgL8ryvWIN+Nc3Pz6W28zjfL3h2+JUgOfifN+5/7PiPL3h2859vtB5f1AD4I2/XYNLL9YfH+2vYAeBG06tgbKj14R5855Vr4HZb8pnRzwYbut+YNeoAdxdofWQMVpSXGcu/MB5Q64Ma/QckfJZjvzB71AD+LsDqyBqolSa3rQ9iefNr3lYZInzZYt6L3ZOrYPCGd0VA3stor850s/vvMQarYHbT5D+/+YyUa78we9QA/i7A6pgdoGdHktzvxcHOv5gDbnFboO09hfV9eCPnlVWw/i7H6/Bl5oQJeauTv25gPKT1OWm1do/vjjleed+YNeoAdxdgfcm39pKFMe5/58QPeRV34q1/7hMNchd/Nra/6gF+hBnF2UGogSZ61W84JSUWogSpy1Ws0LAAAAAAAAgFmUe8NR4qzVal5QKkoNRImzVqt5QakoNRAlzlqt5gVPrKeg+HNvnLhcLnHirNVqXlAt9394LpB01VHLo8T5qbzgTKLUQJQ4a7WaF5SKUgNR4qzVal4AAAAAAAAAJ/QPJrqYbs4YHqYAAAAASUVORK5CYII=" alt="" />
注意因为从同步主的数据。所以这里有2条数据，在slave上插入2条数据目的是为了和主服务器内容上存在差异，这样更好的显示轮询均衡负载的查看效果，
5、在Amoeba机器上操作
在192.168.1.138上面测试(能够连接到安装了amoeba的主机都可以充当客户机),这个密码就是配置文件里面对外的验证密码root 和密码，对外开放的密码，一定要街上端口号，端口号可以自己定义
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZ8AAABpCAIAAABqPLlzAAAPVklEQVR4nO2brXLyTBTHj4qLiMhUMPMS2XkEBkNzAxVVQVShmE5mqrEITE0Uwx10egHBVyMxuYdeAv4Vye6e/cgHLVBC/7/pPAObs5tNsvvP+eAhAgAAAMDP8ZIijLsYToJk3mIS59pQcRZEjnE8uzHOB8mkyyQAuD3m4Tr3f3sSN4OXFMNl5onPpbL4ae5To9DE+TBtEjgvyQdMAf304LKfBMuDOIV4rOKkfnroJrUA3A5QtxMyD5S4HP5bH/5bH4brPEzLD0WYzD1h6qeVgfNPiVecBdHEj0uFKoKIiOahPBplgVuzhI1w+rwk19y9OK89tVBnAPqHlxTszX9SdYuywTILUnuTTIJlESS5tn+ibGBup0mwVBtbeCjzcF2onRnnDdvPSwqhKawLTYJltXWZ92RPyTpRNZOO3ZWPNlznPotM/bQIIi381B+BeQ81wYrz4boI00JelJ+q8yodFDezMouzcFmUR/3UviH1juTpItmmawTg1FQOhb7mTq1u64PY0oYW2HpXaxnGmopxg6YIK8oG6lomQWp3Vyd1TUkbXH7u2j3KwiQLmVh7SREm2SCd+2kRxHM/arx1bA7aA2Jy46e5ryfgeGrPi+deNQ2nPM1DPtvzqxuJl40prACcELHInCp2cnUTo2m5JK4LzZaVRA7d/lrjbKNsYG8kTfJULswxJW0m4kRHdSfyEyWplU8XTYLSd0s1KRzUBIZhTBTP1TXq6hbGc4qygbhdWuGidPriLIiUs6lcvHXuR0xhL6Jugmo+cOXA6TlS3cRadAV3Le/hKBtIB0ELISfBUu9Ya0nkyJpXMWN7sCOjXTlPS0dYvGlfi0rG2xFfW/dJsDyEaS5tylSXF02qfBm/ZHGZlZQYJVEOS5DJJyhF1lC3QTqv5NWlnsOT+W7HrhCoGzg7zsj0pDT5bpa61fhuXlIM08zwjLykGCRzp7vkRiqmpSm1UyIiEZCqEPWI7hMvIj82NXGwLOSGF2UBOYK6A1yGNH0xIlN9EtaPTqr6gxfnYTKpotRSOg3ZQmQKbpLzVhVq824uT8e2lKqnh4QiXG2cKks58WvUxldeklvdKM6Hac7vyXHdiUSGiyf+RFlAz9MN0tyobDpoVDcml5NgeZD1hzDJWtWtrmaKqgK4GS5YM40sYzNimodr5Z15STHkVYJlu9fJaqb8olQeqsmdZHPQT9StuwqKy4Kp+gWG7rLJRllgLYLkuMjUMYdIr1pE7ep2wbwbADdAbRz3c9xZ/CukVFiuEZa6aSJe/l8F4+dvQ5aUVL6bKFkoJa3/WUmoTUDUKwAA3+R86mYEqgAAcFHOo25wPQAAAAAAAAAAAADAdbDY0mL025No543oieiV6O10Y/4jev/2icar3VfFbjW2Wz9mDlPWSLOPL0drA6MF7TedLC9AT5YN+Nv0ZJlembrNPpQojVe7St9mH1Lp1Edn43i1U6I4Wyl5bGCzv6In1ZNlA36DxZY2UxotaLugzZ72e9ou2OERbbe02NCeHRottK9lS233fWWslqA15lR8rv5Kv2BK+y3JTtONPjLjjuiZ6JHoheiF6E60y5ZnZla2lIce2CDy0IM5vIEtOu9Er0SfRJ9E/5jlu6vxlRmXhz71v6e6E5VPykAJGhERzT52qzHR7IO5YcKkvdGNed6pctz6smyctw7cLtNqTZRPvVx55QLYGEvKtfIMy7ru6jPr5RiTiFwvYWOouvV5R/RCdE9ERA9Ej5ZB2ViaEdEz0QPRvVA9InpkovYshurMuxCgJ+aCvboaSUjbP20At+/mYLGl/V7bvZa6fX3Mjm1cuSNTfYXwOciH0qNlY986cINUj1nPm/BMynTDFjRfXvWWrY3EV6E1pmkgUP7atCnRI2WLdM0ivfFOHHokumdfeXcieiB64Lms9pzUO3O4PhsbqSbS7KpuFcK12UytyPTra7cal3HneLUrD5Vf6xr17rvV2L1CKnTPqH/Lht86cHvUqZt8K2ox4Ii2+uvOaVnXqAUOcklZY8qJmQkUsZeaI4s7pmhc3R5EsPnSQd34n+39NfLOfDHplzkbSUSmBj9QN14q2K1W3/HdzMYGddMkrI/LBur2J7Aj07qXsLVMu7+E3Zmy7su0bJy6X9oSp7rZDl2Dulnu3ll9t++rW1t41T3FphptdauwI9Nui6G75SWXDSLTv4isKtQmUIwF8b0ECtF0wxIoNcvUfqNWb/LG3x+0qttjo7qRnne7P3vezalun1ajSY0Dq+qcLEjtXjNlgqaVTx3ntQs7fVk2qCr8aZqLXyPL+BvFr4YXe4VwFjQtG9G2LY6oi0wfWaTZrG6kl1OP5Bs1U5s3q2baFR6Zjh2tbb93Uz93aymf2oWdXi8b8FeoDQcu0r1x6Jaw9Ap4t2qgN4jzEWPZgB5wtcv0qn4WX8OfUDcnWDagB1znMi1jlqt/A0Pdfqd7HT1ZNgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABw83hJEcZdDCdBMm8xiXNtqDgLom/PC4C/wjxc5/5vT+Jm8JJiuMw88XmQTIjIT3OfiOK8/Oogzodpk8B5ST5gCuinB8t+EiwP/62rv2oOcS5b/lvbXQC4caBuJ2QeVPo1D6WmrPMwLT8UYTL3hKmfHrj0GH9KieIsiCZ+XKpkEURENA/l0SgLNPdQf5pxLqW2lL9aeQXgNvCSgr3GT6puUTZYZkHK3IeKSbAsgiTXPIsoG6wNy0mwVBtbeCjzcF2oQEzbsY5LE5rCujC/hm1ve0rWiaqZdOyufLThOvdZZOqnRRBp4af+CMx7qAlWnA/XRZgW8qL8VJ3X8sga1K3dQ+xC08wB+D0qh6JpP/yQKBusD2JLG1pg612tZRhrO5Mb+OmhNpkVZQN1LZMgtburk7qmpA0uP3ftHmVhkoVMrL2kCJNskM79tAjiuR813jo2B+0BsXjWT3NfT8BZqb1L+G7lK0R/fwDwS4jl6FSxk6ubGE3zFLguNFtWEjl0+2uNs42ygb3lNMlTuTDHlLSZiBMd1Z3IT5SkVj5dNAlK3y3VpHBQE5OGMVE85wrF1S2M5xRlA3G7WtXtnHm3yqWFKwd+kyPVTaxaV3DX8saOsoF0FkzHQe9Ya0nkyJpXMWN7WCSjXTlPS0dYvGlfi7gbUuaO6D4JlocwzaWNl+RBRF40qfJl/JLFZVbKZZREOUyh5BOUInuM79bKsc8d6gauCGdkelKafDdL3Wp8Ny8phmlmeEZeUgySudNdciM3tqUptVMiIhGQqhD1iO4TLyI/NjVxsCykNIiygBxB3QEuoFr8aESm+iROqm5dQWQKrpfzVhVq824uT8e2lKqnh4QiXG2capSFYhx+jdr4yktyqxvF+TDN+T05rjsR0TxcZp6W+BNlAT1PN0jzqvrZ6Ls1qJsul3QBdUNVAfSIC9ZMI8vYrJnOw7XyzrykGPIqwbLd62Q1U35RqujZ5E6yOegn6tZdBcVlwTSXRy0NKhtlgbUIkuMiU9cc3L93O4fvBsCfpDaO+znuLP4VUiosjy5dHha/lkmQzI2fvw1ZUlL5bqJkoZQUbhQAF+J86mYEqgAAcFHOo26lX9MLxw0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALhtXonefjzIJ9G/bo0AgP6w2NJi9NuTaOeN6OlnWvZWL1i/om4dr2i82n19fX19fe1WY0cra2dtH7NvjEk0+7AGYIM2j1o35vevSM2m42UREdFoQftNu9ll6Mnmul168gB+rm6fRO9ETzWHrlbdSsarHdOC2Yfa6eLIeLVjTe0aY46p95qtVuOqjY/aKi/GmEdckfriPFHngTf7K1rPPdlcp2axpc2URgvaLmizp/2etgt2eETbLS02tGeHRgvta9lS231fGauba405FZ+rv/KNN6X9lmSn6UYfmXFH9Ez0SPRC9EJ0J9plyzMzK1vKQw9sEHnowRzewNaCf0SfRJ+6OrwTvYp2rk3/hLQZxp+WT+dsfGXDynbZ8m5N6ZPotbHRcUXlkqhB29zGTufKIJs6+DmWYtpdtMYuAvNddWs7NPtw67V506bKcevL5mp87v1iWl1teT3lPS0vbWPcLNc9NSzruqvPrJdjTCJyvV6Moeru/B3RC9E9ERE9ED1aBmVjaUZEz0QPRPdC9YjokYnasxjqSF4twSq/PjHRkWal0Bgdn3TBshtJCBmXSz6+7MV9w1dh72x0s9jSfq9tAEGzupm6VKcFbWOuzMj0Yr6bMXvjRPap9X0k4Yu5R5ur/rn3hOoC9IwAzxFMN+xR8RtXb9naSPz+WmOaBgLlr02bUhhStkjXLNIb78ShR6J79pV3J6IHogctydMx1WKrm5SST1e7/YGYcjkb7bMYlv+E0r3r3hnVNzYivAO2dRsjUyODZauDG23M2ceXPqYKUj865tPseR5lKR++KyqVjc59VKF7Rv3bXI7n3hPq1E3qvRYDjmirC7nTsq5Rc4nlzbLGlBMzUwNilTT7zHdM0bi6PYhg86WDuvE/2/vrgK1uUpKkPDldNqels5FEZMp5Z/HmJxv/3RWEOhvraVU3noPfrVZG+NhNhzr5g6aMXiQynX3oUqp5og3qpklYHzdXf9Wtwo5M614v1gPo/npxZ8q6P4Cycep+HUmc6mY7dA3qZrl7Z/LdXnUZendZtvputro11xy+U6noGJnWHjpC2qwx9exdqW6tIXDLmN+15CdyB8R2ZNpty3S3vOTm6n1kaiCrCrWpAeNSv5caIJpuWGqg5gHY74rqHdVYWW9Vt8dGdSM973Z/xrzbm65NpcQcm3cz1M3I672xf0n3Fp2NDrpXFWRJk7h3VS9t49XO9Zqo1y4xlD6kFvF2G7OrpSat2llbsn3yptnlr75srhuqKug0l3VGlvE3yjoNr6wK8RrUtGxE2zYPuS4yfWSRZrO6kV5OPZI33SOT8aZdMzU8Jil2x9ZMDV6tsJSXR58aG49A/9kXS/fr6TDz12FMEmx9cY7JW6U1tzR/P9JlzK6WmtuurLvVR8hV/ur15roFah3di3RvHLolLL1WWgNGcIM4NwI21y9ztQ/gqn7wfQxQN1CBzfXLXOcDKL3xfr5boG6gApsLAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADA+fgfnqGYqpnvUmYAAAAASUVORK5CYII=" alt="" />
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdwAAABqCAIAAACZJXd+AAAOs0lEQVR4nO2br3KzTBjFH4VDIJgKZr4gOxUxMQk3UBFFRFUV02EmOhYRU4Pq5A46uQDiqyNjcg+9hPpPLLs8+wdC2rQNfc9vIsiyLBu6HA5nt0QAAAAAAAAAAAAAAAAAAAAAAPBbTP1k6irPgpSVx2WQ9GsvLsPU2eA5JFXIT5eUQeyo5cWtJ+rY5eeV/4k+AAD+bbLwpZ92fBk//3CoT1KNXo6NFMZlZPYnC18+/pMf1YKfH8M088zm5M+Jy4gdpT6jouSHeGkVpRnv4SjPzCaJvPRoN1U3yDvv6EzHXsE0KI5RXlo/BADwj3JZUdYElGsotThHP9dlKy4jhyxmYVF6NA0K2YKwyU6znFSRUcitaDyt5S8pg7g277IPWahOrRt2L62aTmrtTwNLT/28Tb4dP99Lj2Ey9RLtEeJ8MAAA/ixeemS3/aWdcpIp3YzyKjxhLbOwqMKCiZFTlGvxFdJMbIO89GhKsKNLrnwgqUYvxzA/qi75+TFIK6cyniXKWmX2Exy/K6l0/Z0Ghetl4rPof2gAwNVR21j9Rr14fFE36KVHQ19sp8z0S+psi3iFCUkny/wykZdWQljDhCipdD2V6UGLKCtt9fPK1+sYne+KL4pPinKtmEkl3ycurMi8550ZCwDgx5F3plN8vyNTzsJGrZr2TVGOyzDNguJDaFMtkSwLVqJZy1xchmnp52UQNyFJlGbG/KEm9EIHk8b/NiZXF+Uw0Uy6JcqXiC+4KBvBS1xG36ub06BAMALA1XCmKMsbWJMJZ2HXGRsLKV/SdVFu5MxPq5CFxVIZG0fsxVlQfIyK0k+Pozzzkswj8lNxuGkwnaKsKjSLJZhSqyujwhBDlLXg+7QonyOvcRmZdnsapCel89y/EUQZgGvEGV98A8IGmoGpKcpeXG9pCuie6Kt3BXkVqfm9hG0zukW5wYgv9J26KE+D4hgVPeOLJu8+ifDU4ldoE32Xe3dBfAHAAPjeiT4+Hae37F63a7/IG6KskuKiDOpFdVlYlF5cRnlmB7heWgWxOPXnRVl3u2xVBp1yyn0WHUsJDhPnauszZL0bTPQBMEQuviSuaU0mDPKrLcpJZTrNDqfsSAYcb/peepRO8+z4omm2aE5k6n6XKOvy3YfvFGUAwD+PWg+nIWOTQtcvZ5DStk5ZWUsmpm0LokWEOnqp/KQScY2afIsKqbDcKauHh/SwTcds0awl3kppHf/20gPXz4G9BQAAAAAAAAAAAAAAAAAAAAAAAEBfVjtajX+7E6d5JpoTLYme/8qJJuv9fj0544Dxig6bb+vOmQxk2AAwQAZyd0GUaXO4or/UQIYNAL1Z7WizoPGKdivaHOhwoN2K7R7TbkerDR3YrvFK+ypKWg8/1JWbO8dqcyG3649wYQs67EgdtNjoLTNuiB6I7omeiJ6IbmS5Knlg1USJ2DVjjahdM7N5A1srX4nu5Pab3L4jepOfJTt8KQtf9cIlq3/nPJH4SzmYrPf79Xr7LhD6Olnv+VdV0Sh8lEfVbB/t5s3zLhqbPJRh03rpALgiFvVQFoNV3DBi3G6MO8F1wxg12w5vttlRjjaJyGV5jKbabqsboieiWyIimhHdWxVEoahGRA9EM6JbKdZEdM+0+EE21RunKL8SzWXhUhbOmRZzWV+yA7tY7ehw0ESHqNZazetO1vtaXx+3ao+zsN7hcsr6COF9UH+UAQ0b96UD4BqoR6eeCfKUcLFh9yG/K9prniwkfvNYbZoVJI07XnSFmEptSZda0gtv5K57olv2lR9ORDOiWeMpu02koE2Ul66aSqnvWgS6B9JI1n+mRm1reMHjtt50Fsrqmig7R0iN7kOHN2yMSwfANdAmysqDaEHBmHa6uXDWbCvU3i7VnWC1qTpmhoNSArpfP2+YEHNRnslE4qmHKPOP7bU7cYqyKDfii1eWUYiPYOlS8HZsUdadLi9QrthZ6Dy+Q5Q15R3isIEog+vFji/aLI91d/W3PO4UuP/dJQoXboukcIqybZ87RNky1193yhxun50ZRV9Rbo0vLFH+ilOuseOLfoOhf82fHDaIL8BgUBN9reGgMY4/Fw4SLTYsHGy5u2z/UvumzgVYJ0X5vlOUSc+Ub8/OlJ+lpM71aTrBHXPEc31+j2fKp0W5e6JvYpSclyl3PHKa89pzrUMZNpjoA8Ojexp9bFX+xDR6h42qkdZMk+Ax7U69bLbFF/csjugWZdIXZpyJWmjx3LL6Ys4qL63sgs6OLwxcTrfn6osatQijQ5tdc62DHjYAXDWt74w/cnhn0yeyC/AzOP/EGDYAfBdXe3dd1T+PAQMMGwC+i+u8u8SLLfzO1YJhAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8M8x9ZOpqzwLUlYel0HSr724DFNng+eQVCE/XVIGcfcB0yAvva+eFQAAWsnCl8r/kTP5+UdoC25SjV6OjRTGZWT2JwtfPv6TH9WCnx/DNLP0Uf6cuIzYUeozKjRJ9dIqSjPew1GemU1S5mvCXUXaw0DubTljc+qfus4AgEFzWVHWBJRrKBH5ueNEfn7UzGlcRi5ZDIvSo2lQyBaETXaaZVM0dTscT2tRTsogrs277EMWqlNzw55UmrbmmZcemdQeo6L5XV5asZ8zDQp5BS7i6wEAfxIvPTI/eGmnnGRKN6O8Ch2GkatwFhZVWDR65xblWtGENBPbIC89mhLs6FLV5tDD/Ki65OfHIK24+BIR0TSQVtpLj2FSK7h+DRVGuMG+2o+Kz9JyagDA8KhtrH5LXzy+qBsUEsaxnTLzlVJnnaJcq6pwsswvE3lpJYQ1TBpLK39gFooHQIsoK5X088rX65idT8ogVlnHNCg+xLFeetTyEJZgsA67GvwawqrrjzcAwHCQ97BTfL8jU87CJr1t2jdFOS7DNAuKj1GeNRLJdE2JZq3dcRmmpZ+XQdyEJFGaGfOHmtALTWT5Q2NXdVEOE82kaxqaVKP6MVNFRSOFfpKZ7aRH0UL9S1lkIXrlp5edJJwGhf2UBQBcPWeKsrzVNSPmLOw6Y2Mhk2rEpUo1KF/t/bQKWVgcqdxAFnpxFhQfo6L00+Moz7wk80gJHMtt61M7RFlV8OJGlO0pOBWGGMZWXMCoaKJkx6VIqjCpzyhFeerL9DkSj58TV+/cKw9RBmDYOOOLb0A4RKnFCkOUvbje0hTQPdFX7wryKlLzewnbZnSLcoMRX+g7my7FZcT99YlIVxdlXv5S+Xwi8WsgvgDgT/G9E318Ok5v2bn6wlRVW5RVUlyUQS6z2qL04jLKM321A1EtyroIni/K5pqQpBo1U4vNGa1FfvKx91L5phPP/PQyCzAw0QfA3+biS+Ka1owI1SHKTOxqOpyyrZVsaYTCS48yjjg7vmiaLUxRNgNud3/qMzZn4TifDQAA8I2o9XAa0j9q+puFziClbZ2yWtKgrxp2LogWYauyq6M883M50VdISdUm6GTH5DSj0TEvqcJCS4fdsbIbmfwW+FdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADgXN6I7i7W2GS9f98+Xqw5AMAVs9rRavzbnTjNM9GcaEn0/Ns96QkX5cF13sF4RYfNb3dCMpBBC8CnGMj4Hpyu/TVR3hyuaJwMZNCCQbHa0WZB4xXtVrQ50OFAuxXbPabdjlYbOrBd45X2VZS0Hn6oKzdj12pzIbfrj/BBCzrsSB202OgtM26IHojuiZ6InohuZLkqeWDVRInYNWONqF0zs3kDW9deiZZEb7r8zWUJL7xjhcv2wiXbq066lOd6sxKJJeuA2iVqPneLsvjrWzxu32v264ksnKz3oozFF5P1vvn+uJXbqio7nJW+bx+JJuv9fr9/f39/3263Vl2F2cNFY5OHMmhbLjIABot6MInhIoasGDkbYyy6hqxRs+3wZpsd5WiTiFymw2iqbWDfED0R3RIR0Yzo3qogCkU1InogmhHdSrEmonumxQ+yqd68So2bE71ae4Xmqppzub1k6mkUzi0n+6qLqXGipUumVc0TmfJqR4eDJiUMK0K2M2VZ8riVstrUacqM7fV6UtearPfv+/VE201kjk/eWzUkBjRoOy8y+Oepx4eeyvGcbrFhdwIfl+01TxYSH75Wm2YFSeOOF10xolJb0qWW9MIbueue6JZ95YcT0Yxoxkydon16i6vqm6sCd69La69deCc1Vxnkt84T2XGEUbPHRJ+0h4YImlrpmuirL5asx6s8bpl3tsR8v56oKvKre3zW6D50eIO25SKDf502UVYuQAsKxrTTH+/Omm2F2vudGotWm6pjZjwnb8LuF8AbJsRclGcykXjqIcr8Y3vtTl6Z6ikF5KEEl8VXK75wFoo2n+XGa/uJyBV3tNVsR9ML7Zl0UpR5cEFMXolpOi/Uq50hypryDnHQQpRBF3Z80WY6rPHd33S4U+D+41sULtwmReEUZds+d4iyZa6/7pRPetXuwmcptc8szehwyrYo93XK9pu1YXVPifJkvX/frpvyLzrlGju+6DcU+9f8yUGL+AKcgZroa43njJH0uXiOaLFh8VzL+LYdRO1cOpdAnRTl+05RJj1Tvr1Mpqxkca5LrYAHzc5CERPP5eFzWdiWKRui3DdTdl5zJqCP21NOWRU0e3pnyl2ibPXQnukdyqDFRB/4DN0T2WOr8icmsjuMTI00R5oEj2l36nWvLb64Z3FEtyiTvjDjTLpXXzy3ZBrKyXYUqg07/bBXX9i9sldf9EStvthulZQ2KzLYm4OZW7w3At1n9UUPUVbYM72DHrQAnKD1re1HDu9s+kR2cQW8nq964DycAwyDFvxlrnZ8X9W/b7UAUf4dMGjBX+Y6x7d4tbx6xwFR/h0waAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMA18D8cbTlCglpbiQAAAABJRU5ErkJggg==" alt="" />
#mysql –uroot –paixocm -h192.168.1.137 -P9006
(1) 先验证读。我们配置文件是用的是DR轮询,注意这个IP地址要写：amoeba的IP地址，不是master也不是slave ，是通过amoeba代理登陆。
Mysql->use test;
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAY8AAAD2CAIAAAChopwNAAAQEUlEQVR4nO3d7YGjIBCA4e3JdiyGXqiFUuzjfhiVjwFHjWbw3ufH3a4hMpowC5jI3x8AAAAAAAAAAAAAAMD/YHBhmgU3vKKiE5bYHo3s+AkZXJj8eHNYgHWjf6ipXqtocEH/7NErm/bof5gEHjvzwEu8KlsNLvhxyVaj33vGb7ssZCu8UgghTNM0ee/jAUT6fl9+2wYa8aPLVu/TRpLu41D7lSuqDXSEximW3DZ+Ahn9lGjHt5VulotiT+ofXAjO+WTzWnb9VX459gLKyuUnpHg1/RhXvh1OEiMJD8aEyY9/gwtTcEP8ro7f4J+3d5JvBufnh7eto58a2epPP5UjVxTvL019RUViyeSIXJLDlO1yyQ6KpCvk5sGF7NCL2D4bhJfjWG3SCVkfT8eo6VMHF5bDy/cZPQT8xtxSt3wUp6jPz/Hf4qL1xG/qsdW3yp7TavW7FWUpJqtILFnv2qlHgpMf55GgIotUslWyKTt1c5qqvRxtu2d+S1HZhFqZrSqvJtkKP1dvHunf+1k5wJITnPTrZi9b1SpKh21Jb0EeL0Yl6y3/lll2OVsVXc3s1B3MVsmB7pz5JUnls//1PwJMfsGaRvMYXAhulPsk61v5SN/qzEX9uKLa88psVZa82rc6SJmtrvStDvZq530WlyrJVuhHq3l8ssvyZt5mkOL3eH3eqj7I2CFXlDafuJNT7Fos2Zi3+v4IR5OtxHmrU9mqfeY/Rj95X3yuQp2tGAni55rNI3+HRkMPYWt+TfDQtHRKrqi2WahILFlcE8ye/cXGqMpW4jXBAyPBLW7VmR99skG6INoe15OsYNjBbgdjh/fitYVtR8dIvKMBPG8eJxzr+pOtAAAAAAAAAAAAALtu+f7JNQZD0us6eMA0g63LYEh6XQcPmGawdRkMSa/r4AGTyturLJ/wzL7DlhW/caPBkC4Gr3olAOgY7AsYDEmv6+AB0wy2LoMh6XUdPGCawdZlMCS9roMHAAAAAAAAAADAK+mvYdXvf/zle4d2fVmt6+AB077RushWm66DB0wjW31X18EDpqla1/oluGJx8mmSVrW7PaTBheCcz7++ty2Vt63TF8ISY/pNv3IN+6eCB3DK6Xmr+lrND4QULc8qTqd9Nkb/BTfEfcDox++u2Uy2Au5yNltVl35/JKTd2ueNtTWQ68uqPxE8gFMuZKvaWuQPhFSpPblty062Sn2tc0W2Au7Sbd+qzFZlSI1sdVdKIVsBd+l23qqZrT4h1bJVlmBHz7wVYJ+mdW2X2pJh06+vCZYjwTXQT0j1bJWMBr+Xq8hWwH0Mti6DIel1HTxgmsHWZTAkva6DBwAAAAAAAAAAAADgZwxecTcYkl7XwQOmGWxdBkPS6zp4wDSDrctgSHpdBw+YVN40Zfm23fpI3Oqe2GgwpIvBq14JADoG+wIGQ9LrOnjANIOty2BIel0HD5hmsHUZDEmv6+ABAAAAAAAAAADwSgavYRkMSa/r4AHTnmhd4ofBfxvSbdWQrYC7PNe61DWRrQAIOsxWgwshhGmalw2Mu2zbwofRDqJv8BXrDn6sCwpuZdMdBOd8+cClowRwUJ/ZavLj3+DCFNwgrmu/LducrDA9OJ8loeR50Z7ipw0u6BejJlsBd+kzW1VXYF4ky83Le8ufl+S1+NH0gYvBAzjrVdkquW3Lug9xeCdnK3GAeOgUka2Au7woW8V9IGl4mG0UspWuE3YpeABnvTNbjX5aR4I+7mNFI7pygJdks9FH81ZkK+D3Hmld6TW4vTmg8yPBtR7v0wlzueateHlNUJ7C2ke2Au5isHUZDEmv6+AB0wy2LoMh6XUdPAAAAAAAAAAAAAAAP2PwirvBkPS6Dh4wzWDrMhiSXtfBA6YZbF0GQ9LrOnjApPL+KMsX68S7qD+x0WBIF4NXvRIAdAz2BQyGpNd18IBpBluXwZD0ug4eMM1g6zIYkl7XwQMAAAAAAAAAAABfd2hh0aeYDEqh17iBfeJntF/p0McKiqUIt4+pK1bryUs+epL5+ATe7X94hx85xs+6X/Hv0QJgrd00Sj51kv+HFxP/Md0bfHAhOOenuJ8gfFUu21Orea/PzhbuWyrZCSr6Xp749b1la7qU4X73KA85SV7Nc9UqqTnJ2iNKN5ZLJJKu8FrqbDUV3YVPU1lbSN4t2Z9ISUsMLizNb+epycPbcsxjuuZpPBxTtuG83uyZ+RH+KUvuB3DkiOKUNLpi1MrcFd5Kn62qmWhpmdEiyvFiyurdZvtshDW4UD5c7GwtcShb5V2r4IY1jTaiapbUZSvdEbUT0v45B7p1YCQ4VDasLXPeODgf5v9391xPMLtDmnKEVN60Zdl1B30r/RE190XfCm92PlsVfav5J+e8G0bvR8Wf+QvZapXlSlX0ir1tvz80byXEID6tmZCYt8KbncxW8jTK3Bn4jIT2p7RPZ6ttYqc+fBx98jECbY9DfU0wmmXbKakbCeqPqD5vxTVBvFV6vazZnKVmIH2UaG1p4jxMte659iN9q2iQlI3cxONZq9tPWtrPWxXZSi6pPslHjqgeEskK+I/0OvfTa9wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAV8RF0Luu6IQltkcjO35CuIk78PfgmnbXKjq0QEy03NduTL9LAqwmCBzzqmw1uDAvjzj/e2zx6aeRrfBKIYQwTdPkvY8HEOn7ffktWtMuX/7zs4tsUXVphUENuaLaQEdonGLJYvU9aTHDuq303pKL8T7X+gcXgnM+2ZwtxTi4ysuxF1BWTlhoOn0116Uey/UJtxhJeDAmTH5clyitrDL8eXsn+WZdUzhZq7mRrf70UzlyRfla0MnCoukuxZK1lY31I8ElOyiSrpCbBxeyQy9i+2wQXo5jtUknZH08HaMWq2Qvh5fvU1jkFXjW3FK3fCQskhz/LRYXahaXP2+MR9bOWOW9v1tRlmKyisSS9a6deiQ4+XEeCSqySCVbFYs8R6duTlO1l6Nt98xvKSqbUCuzVeXVJFvh5+rNI/17PysHWI1V4E9nq1pF6bAt6S3I48WoZL3l3zLLLmeroquZnbqD2So50J0zvySpfPa//keAyS9Y02gegwvBjXKfZH0rH+lbnbmoH1dUe16ZrcqSV/tWBymz1ZW+1cFe7bzP4lIl2Qr9aDWPT3ZZ3szbDFL8Hq/PW9UHGTvkitLmE3dyil2LJRvzVt8f4WiylThvdSpbtc/8x+gn74vPVaizFSNB/FyzeeTv0GjoIWzNrwkempZOyRXVNgsViSWLa4LZs7/YGFXZSrwmeGAkuMWtOvOjTzZIF0Tb43qSFQw72O1g7PBevLaw7egYiXc0gOfN44RjXX+yFQAAAAAAAAAAAGDXLd8/ucZgSHpdBw+YZrB1GQxJr+vgAdMMti6DIel1HTxgUnl7leUTntl32LLiN240GNLF4FWvBAAdg30BgyHpdR08YJrB1mUwJL2ugwdMM9i6DIak13XwAAAAAAAAAAAAeCX9Naz6/Y+/fO/Qri+rdR08YNo3WhfZatN18IBpZKvv6jp4wDRV61q/BFcsTj5N0qp2t4c0uBCc8/nX97al8rZ1+kJYYky/6VeuYf9U8ABOOT1vVV+r+YGQouVZxem0z8bov+CGuA8Y/fjdNZvJVsBdzmar6tLvj4S0W/u8sbYGcn1Z9SeCB3DKhWxVW4v8gZAqtSe3bdnJVqmvda7IVsBduu1bldmqDKmRre5KKWQr4C7dzls1s9UnpFq2yhLs6Jm3AuzTtK7tUlsybPr1NcFyJLgG+gmpnq2S0eD3chXZCriPwdZlMCS9roMHTDPYugyGpNd18AAAAAAAAAAAAAAA/IzBK+4GQ9LrOnjANIOty2BIel0HD5hmsHUZDEmv6+ABk8qbpizftlsfiVvdExsNhnQxeNUrAUDHYF/AYEh6XQcPmGawdRkMSa/r4AHTDLYugyHpdR08AAAAAAAAAAAAXsngNSyDIel1HTxg2hOtS/ww+G9Duq0ashVwl+dal7omshUAQYfZanAhhDBN87KBcZdtW/gw2kH0Db5i3cGPdUHBrWy6g+CcLx+4dJQADuozW01+/BtcmIIbxHXtt2WbkxWmB+ezJJQ8L9pT/LTBBf1i1GQr4C59ZqvqCsyLZLl5eW/585K8Fj+aPnAxeABnvSpbJbdtWfchDu/kbCUOEA+dIrIVcJcXZau4DyQND7ONQrbSdcIuBQ/grHdmq9FP60jQx32saERXDvCSbDb6aN6KbAX83iOtK70GtzcHdH4kuNbjfTphLte8FS+vCcpTWPvIVsBdDLYugyHpdR08YJrB1mUwJL2ugwcAAAAAADDE4DzLyZAqHwJ9mMHzCbzEo3eM2f/0wvWQxM+FPodsBdzl/tY1uBB/P3i/NrIVAMHDrevzic4mVUjCfWDWGooNRcG00BbU9dEk2Qq4y7OtS9XxUYRUvw9Mo4rse4Tr89efK3eMOYRsBdzlydY1etXElTJbVco0EmL80Jaulp+qd4w5hGwF3OWx1qWbs/qUVBSsDdqKbCXfRmZNUmvaqt4x5hCyFXCXZ1qXPlX9HQ4pS0/Zr/XbyMxpKpmz+sKZIFsBd3mgdR1KVX/KkWDtPjCN+8Jst5H5W373Pp71r9wx5hCyFXCX+1tXdcmGSyE1PsO1VBglqeI2MtsjybMPfjLsbPAATjDYugyGpNd18IBpBluXwZD0ug4eAAAAAAAAAAAAAICfMXjF3WBIel0HD5hmsHUZDEmv6+AB0wy2LoMh6XUdPGBSeX+U5Tt06yP5rQzu3mgwpIvBq14JADoG+wIGQ9LrOnjANIOty2BIel0HD5hmsHUZDEmv6+ABAAAAAAAAAACAZ5xeJ/lOJoNS6DVuIHF9gZeuHfqsQWNN1b1zJ5QUPx1/Fz5Tge4NLiyt5+iCf+9wpBWPPk1KUfJqrGS/U/KpNEK6wqvkrbEwuBCc81PcJRC+Kpe1ik/7jDpxO81mLblFk9SsfXrlO33L1qNLHOZ5JjldzWTQKqnJItojSjdmx7OTUIGe7L+dBxemomfwaRXrs/OcNxdJZk6iRZabdSVNfGl+O3MwlYqig8tKaLscwnLQ+ZrPlaiaJfcDOHJE8Ws4umLU+j+O9fFCo9dNvgiZaN2BH/+25rc0nHn74XFmma2iihp7EisqdraWOJSt8q5VcMOaRhtRNUvqspXuiNoJabfrDPRAmUuKlhVvWBvhvHFwPsz/L0XEgUszJDnB7PYBy4rKO7lEs3XW+1b6I2rui74VXkDf7ZGyVdG3mn9yzrth9H4UWrFqBuVCtiorqjfjA5PPv5u3EmIQn9ZMSMxboXeHRmhlExFnTOa/+59Bz7SMD9epKt0f+bPZqlJR8qTRJx8j0PY41NcEo1m2nZK6kaD+iOrzVlwTRO+OXReT3vHSp4bWRhXnQvUHu6SYjvStKhXV6l+r209a2s9bFdlKLpke6M6VA+0R1UMiWQH/kV7nfnqNGwAAAAAA/D/+ARUjpmdBBF3LAAAAAElFTkSuQmCC" alt="" />
测试轮询成功。主和从各查询一次。
(2) 验证写，正常来说。如果只有全部写到主里面，两边的数据才会以致。如果其中有一个
不一致的话。那么说明写到从里面去了。因为主不会同步从的数据。都是单向数据传输。
先关闭从服务器136的同步功能
#stop slave;
然后通过客户端138插入一条数据
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXwAAAApCAIAAAC5sQVtAAAFzElEQVR4nO2c28GkMAiF7cl2Uoy9pBZLsY99cDS3AwFv4+x/vpfd8VeCgITExGEghBBCCCGEEEIIIYQQQgghhBBCCCGE/DbjNC8r8zSeExPDdWpdwHdU8tvzdj0vcrEi/WWeN/Grev9HhHhLRF7NOM2Xq3mHzDfa8x6Vaqkpw1laA7Y/6Q7hcnT4FscTOy98SBBMOse5RaUQi3IhxNSEpZT4atJh1rEwz/O8LMsSY8x7kjKatl+4y9mOxliGYCnDVXruDaUrxmmepynWrQu9ICz/CxHLPI1h+/9St3ZcJUnmfn0vJpOA6sz6CW98FIPLdELjQKZVpfyJK/4E3CGWL2oiMzzT5Smii20qaRGCdXlh1/A65iWGYZzmZZ7G3GC57T6xV6SNcYrrn9PREMv4acy/OdXolDJNjdO8+Tz9AauUt5yfMU4zaNzTNxlUwjILKx26f3BlXhKU5YFVzxZZpkElIekAdwiO62kYot4zCLQu9qpkzyNA/8z+ZBiGYTVnSisgaPI+FD2yuz2DVulU1/QKiwE9OU1DXZWKe8LxfC7p4HuvZVZnGgOwa88kqhJq1RM3imUaVILxA90BHdfIyG/AEjESmjsOqiSDUzWTToaYdLaoqTqAuiYVK+obkg5sCKpU1sSbFBw8p5KOcO8gyiUrwTZ2OvbMxj+FMa16IoBMq0pi0kHuEF6AdSudA4MXlHR8Kp2qdEiFnHTWXwHbEPZjvaRzdnilPzm5Sp4e66GkY6x0nJXjKqwReSbpNDLtKklJxzOP1NHQXidmaH2AQSVX0uGcTh8l6WxJIvV3+zg3i0N5Tkeu8W0YnhysUun4ELMOGycds2KOpCOVHp2gzK7U7bnf3RJjZ+7FmXRqmQ6VijE5nB/8uENw3N58yH5Vdk0/zcOW1nIulZwRgkeHrH4SWtJprJWVpeBo/fYqzf17DY7eGQhPDlYJH5Z6rL05RU+HSljmrpGh0Fgc9gyxOODVU1ahePCtKqXZl+JM4A7BcUDHYjBU37p9eqy63qWSJUI2EbAGZ84x46xOWFmSS7DF3fvCDev9Pj3fjHdEROsSQg6zFpS+opBJhxBCCCGEEELII8CVSs7lS+cwDoF/dYnbr+r9B0nvWb/hsKb1YqFG/frWgvn19MPAlW2Hlrtt+FboD9akI67rNL00brxZcWuQuS1CvoBrZ84jrRfbf44r9Lrwg93wub75nqRT50G8ebMjHp75gE9e53bSIG1+w8vJ4O6Usf5kRBVwSqDC1tNSxVMp0BZ9rfJtpdRK0p691LXD1XGgmepsych6BaFskNMWcOIbqBc69ldYms507DvDywM1g1gbIV+n3fkSg5R0qpXAxUrOZqFqLkDbwde2HuISp5MZZ3AkHXHL4a6dvqFSE10vk+5XOtDIhT0nbVsQulzeqmJUu/WRdKV2Zs9qxd87HyqRDGJohnwde9IRN/QgLxe7cOQQkJLOFaN/e9IRH41N901UOwBUAev5e0lHKjyF9tDGFfVyQxlQy1wv2bfEKBL0M7vJAJa2ToN81GDSeTW+pAMremnDST885EonDKf3rDiGV6NwoNoqPU5xXv/VJBd2OpJ0GiPL7cHdctrltqRzR6VjGvW0AymnQYD+5HXY53RET+M/jMqXMfTWy4nkw/FzPOk0lc7wGfLFaQwxBq0rVcoKY9KB06/2Ske/3LjL/PI5HW8m0KNOlcY5nfeTF7X5JEYaHeEXEr1PRmx9lB5qqPUsdPdSfcC/O6KPJB08cbDezGfQoKmQPQ/1BIp7TicZWZnTqUSiy31zOo63V407pDNNOcfzoRJ5TsfmdvJtwPuWvartfqNAdrMxQ+jrdEohxtKnfLPTm0iA8wj14KiYlVWjOkgfgrAlHdnI8HaC5aMN+zHT2yv7Oh3gYXimtfiAd+4zCHPOb3FqVQzg+sE1K+eH+NV5kV/V+y9zaTfBACCEPMaRL2MQQgghhBBCCCGEEEIIIYSQP8o/MNna7uhyNYQAAAAASUVORK5CYII=" alt="" />
再到主服务器上来查询，可以看到刚刚插入的数据
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAa8AAAB5CAIAAAABGTnQAAAKL0lEQVR4nO3dz8skRx3H8fobNLIYUdCDoJeATS6CFw/5ofhzTTSmo66/QhJREIWYU/8Rye4+u8/+MB0UCQT0IogXkYJNWETIrokS98kmtoEkJiIeQmLAQ+9MV09XVXfNdHd9u+b9uuw+3dNV35rp/jzVPTP9qEdPHbznpmMKAPYcaQgASpGGAFAjDQFAKdIQAGqkIQAoRRoCQI00BAClSEMAqJGGAKDUgDTMy0oX2Wz1WGWFrm4o8znbzwo9TY+m8Gc4Lyd8MlzWT9L4vU79+o5vXXHUY2Pr522W/XqBetJQQhauTf0adtufZ68J7iXeq5KXEwbWco5RUYfFgp436fxpOO2r7jq0jF95rd6XnobuKAl8nh0PHyuqPO0sIg3Di8wKHbKBsPgRVs6CPXrSk4YT/wq07rV52WRgVmizgHTTMLAf0tAroMis0LrIVmmYl8O2ExY/wspZMF8aOp7lvKx0UZSbVyzy9ZL2RrblxuyvvWpzR24d9/Z6XP0aKzozTNtydxrmnbF6+rUudo7X3bVPJw297QeU31vn8KBxviyOepRvfxv6+vbWbxF08a3TgfE6BBwXWaErrXVVVVVZ1E32TjtC9lvPcbMux9zCt5+vuhZ0aWAyvjT0TEE6K4zDpDWjcy3fWNdZUr8yuix1ex/a3GF9/RoHSdHsDE0Jm/3b07C9X1v+b/bbesry0jW6jh3T0N3+yHUOTUNn+779YYzXN6RIo9uBYegpNOi4WP03K3S9uvcsLGy/bTVoWb25yL2fN6tJQ9dB11ncXtb85Fq++rH7rJe5sWa9t7RXh/brsvEoexoGjat1kFq6mzsNx64zIA0H7Du9z/92r2/YmXKli6w+Ux68nTMNhx4X5o6uiyz0mlT/82bryzMA536+Z7Y9U858j3S9EkPTsNms1UDvdT3vHmB0aj/T2b59c1zuE5oIadg9c9yxzuFBY23fU49yz827j/c/XZHeRdnmuBiehkH7rdGZdaUtDd3H6f7Y4l2UaeeGq52jPUlcr95x7tDuctDc0LqXeMflGJ3nKJ3sXZS8/32BkDq3CJr2Jt567K+v9fFjzQ23M//cMHC/bR6VW9eRhnbeNHQe5t5jf/B1w84C49E3fhVqrdt7geey/pDrSp1ZnP9CpnsvcV0PKp1Xd2zjtTQ8hOPhtvY3f52sptzb1Tk0aNzt2+txt+56vOP17at/HMPT0LmfhKdhyH7bLLZfDg1NQ++FlYT403D1CYQWz7Foe0vK955dM/13JaZjA+Mxzvabxu2P1kXRGclG+769xN6v5wTUNt71NkFzGeexY22//3kYWKcKmHb1nIi7era8vs7He9px1j+OgDS07yfhZ8ph+6251HUwmjWRhrWeNJx/1tx+42QfhD/Dq31/1qcp/K1XJGLySw9S9KZhDL7ZA4BZ2U4Q0yQyDQFgdtzRCwCUIg0BoEYaAoBSSj1GGgKAIg0BoPbY6TPR7vY6nqXUGSrVcQESkYaSpTouQKKTpKFgqY4LkOjkwdluGna/zSjzC1lLqTNUquMCRDtlS8M129ykOVTbq2ItX0qdY40LwDROHRxypixWquMCJDp9hjSUK9VxARKdPnuOzxsCgDogDQFAKXVweJ40BADSEACUUkqdObxAGgKAOnOONAQApc560zD0Ex49f/1tsg+MpPpJlFTHBUh09vyYadiDNAyU6rgAiQ7PXyQNxUp1XIBEpKFkqY4LkGi0NFz/DeTN64brFbooYqdhfV2z+XPNZq3GjWPWbWWFrrTWVVVVZVGvb/qxNzMq0hCYz7hzw+67KHm5Dous0FP9ufiQNGzCy6hN5WU75urlWaErXWT1dmVudLQxrokyizQE5jNxGrYbiH6mvBFcrs3Wy9fjWS3Z/Des+2CkITCfwwtTpuHGz9FTw1NPc95rnCy70rB7O1bSEFi6adNQ2hzKmYbmSfPAueEc96ImDYH5TJyGAq8butKw9dZJXxq24zMr9DTZSBoC8xkpDbunjmZUCHtP2bZZ6x3londueGPrSU+TFWkIzGncuWEsS6kzVKrjAiQiDSVLdVyARP40BIB9QRoCgFJ9n74GgH1BGgKAUqQhANRIQwBQaub7G05mKXWGSnVcgESkoWSpjguQiDSULNVxARJZ07D7reMpb/C8vaXUGSrVcQGihc8Nm0O1vSrW8qXUOda4AEzj8MLP3/s+zpSFSnVcgETnLj5+07H3u9Yu5WhcSp2hUh0XINHFx39x7OYPxq4CAGJ74pdPfuBDH4ldBQDE9qunfvPhj348dhUAENuvf/v7j91ya+wqACC23/3h0ic++enYVQBAbH+8fPVTt30hdhUAENvlv1y/7UvObzks5RMeS6kzVKrjAiS6cvTa579+v2vtUo7GpdQZKtVxARL99Z//+cqJH7nWzn80+r6n5hYnNVp/YX6qHkhDYCZ/f/Wtr33/J6610Y7GwI5JQwC7OvrXO/c+8LBrbWppmBW60lpXVVWVRT0LXW9n3DjGbCsvLXeR6d5kxkjFZot2VOZlpYvCsXK3cQHY3fU3/5c/9DPX2iTTsMjqNCtzY8O8bBow5nythvOyE2+dTDOWrTozVwU+naQhMJ+X3nz3vh884lqbYhqWubGBfcNmaV56AsyShu32fD8NQhoC8yENjdwz9J1ArzZpp2H3DJo0BJaCNFz9awSbtblu9tnnhs7rgaQhINp10nDzjDkr9GpOlxWl7Wqi0Zp3vpgVuv3uCmkIyCUuDV1nrH0b7Xim3DohLprmPCfKrWKt7ym3tyANAdHEpeFWllJnqFTHBUhEGkqW6rgAifxpCAD7gjQEAKVIQwCocd1QslTHBUhEGkqW6rgAieSloevjej3bBNQ51p24uKMXkBJhaWh+eyMgbEhDALsSloZb9h7yXZTA+xKG399wRKQhMB/BaTjr3NBxX8Lg+xuOizQE5iMwDVcTr4Cg2TkNXXciDL2/4chIQ2A+AtPQ6HzsM+Wm4cH3JQy6v+HYSENgPoLTMKD7MeaGfbk26P6GIyMNgfnISkPzfoLNHy/pF1bn8PsSht/fcFykITAfWWm4cc46eOIVWufw+xJucX/DEZGGwHykpeF2llJnqFTHBUhEGkqW6rgAiV584938Ie5hA2DvHb3xTv6g86/LA8C+uPb62/c+8HDsKgAgthdefeue+38auwoAiO1vr/z37u/+OHYVABDbcy//+/iJH8auAgBie/botS/e96Br7VI+4bGUOkOlOi5Aoj+/8Mrn7vmea+1Sjsal1Bkq1XEBEv3p+X985u5vu9Yu5WhcSp2hUh0XINHl5166865vbSzs3uBqsm/i7mQpdYZKdVyAaM9cffGO4990rbXNTZpDtb0q1vKl1DnWuABM4+krR7cf/4Zr7VKOxqXUGSrVcQESPf3stdu/TBoKleq4AIkuedMQAPYFaQgASil16cq1O9zXDQFgXzxz9fqdd52IXQUAxHb5+Zc/+9XvxK4CACL7P++UmYtfsUawAAAAAElFTkSuQmCC" alt="" />
最后到从服务器上来查询，并没有看到插入的数据，也就是说数据只写入到了主服务器中，你可以开启从服务器的复制功能，start slave;再次查询你就可以看到从服务器同步的数据了，不信你试试！！
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAaEAAACICAIAAADBHsPfAAAKF0lEQVR4nO3d26GjIBCA4fRkOxZDL9RCKfaxD9koyICM0chw/u9l93iBQWWCmujrBQAAAAAAAAAAAADQm/0S3PRsDJMLy39+/mX5kwv31BjTb+HZ37gxStaNdH2td+/f660RP9o3Tm+3nxzXVvSQ4VZ375m8/N8cC+pantsrs78xDdnpeV11C0PbrUf37stSh4k+npLaree4coJQbufC4lcloEo5JnKcPsjJBc0KnSWVzsKx5eaPK/FYnP2W2SYX4gDGzXHKeshxVYogJxeCmz45bvZt63WWVDoLx5TCtpv9Epzz+ysB8zolXUmaHo3U0ln7wzPpzXI8pXqjGdloUJpeznFz1tZKveLkYnvLVddkOa5aviL8wzjb00dxtxTiedWOt9b9exi/QHVRK6sg2g+KfjG5sIQQlmVZvHsXeTiY0By3lX6zhhOvUTvOP1V3dHJ+ocpwIZsRHfzJ6Ks0fTcvm/Le3sH7kB4Z+8OwVm906LttF28h7OuXc1x6tAr/j+tNNtnsS63LfJnjyuVfHGdrjiuWXzserti/miCjahtTXCVQVb/4/Hdy4T378IxJd9wmBQqz95PKx/k2+6/luGxyOm37qzT982e+Lf0czVmPgXS2tt7GBso5TtWupOsJ1f06x10dpyLHNRw7h9v/3P7VnasuwU3vc9Xm9Yo5rrVfxAd6cJP2qtDxdpPqqjSgeJwPr3auOtWWLG3f1hy3rZYUcHi9rLpfo0rlc43z5cftKp9SPJDj8nO3L+NsTx9i+ZV4XuVxdL58fXM9dM/hTL9oz3Gq4zaqTJwp5bhyPx2a3NZ7x3GfXZ4O6NbZX37Op1U2jePEfV9tV6F1lb532z2H+fgquibOE+kjXaUaj7x/xeWvGsed8/txnPK43ZaaxXnkuE2p81Z7dPP1uGxCtPT/j60QQrpvKxfBW67XZCOu+gXC8r4vXWfxxasmUnuFglsUFpfK339IfIbH5+JsTR/l8uV4yqWXli/s36P4r9Ge44rHiT7HaY7bbbJ8mVGb46qXNqz7f289Uelh0m2Z2n2rbQBeyoOFFaJliuVvhctLB+eyluzKr+17ud7KKaDU3nUd1bij2CPE8o+3Q2OcL8UQ6eBUuFSzsH+Ly1fKKcZ/DUWOk48T/bmq7riNp5Y6YxzTn85xvx+3prcZ/gL9Fv4c0T/dTPrbjxjE7Sf/f1Dtkx7AT0kncwAAAAAAAAAAAACAv8LKjzqsxKk1aruAXljpY1bi1Bq1XUAvrPQxK3Fqjdou4GH5r9r6/AmPlTi1Rm0X0B1pHLF1wHTWU9OtxHlVuwBcx0ofsxKn1qjtAnphpY9ZiVNr1HYBAAAAAAAAAAAAAAAbtN9dOHjD1G1fhRj1OxajtgvoxcV9jBynNGq7gF6Q4541aruAXpDjnjVqu4BeKPrY+k7U/fW4dYb0fu8fx/m+Xlh+W/3+x/GTC0sIYVmWxbv3/K2em1/G/r8Kchxwo+/vOUSv2J5cuOul0Joct6Wk+PXfs0+T13v65MIS3PRez89RRbt23ZSJyHHAvb7OcWkBj5+r7tJRabV1+tqez5T9v7rq1chxwL2+zXG7vx/PBZV4tjPP6HS1lOPyh1iS4wCLRhzHiTkuPm1tHMf94rm85DjgXiNejyvluORGw1GOS5Pi5MI9GY8cB9yruY/lJ29xAujsvqq0WnJX1R2O4/6vfeuJ6oscB9zNSh+zEqfWqO0CemGlj1mJU2vUdgEAAAAAAAAAAAAAABusfHfBSpxao7YL6IWVPmYlTq1R2wX0wkofsxKn1qjtAh6W//r0zofdnmclTq1R2wV0RxpHbB0wnfXUdCtxXtUuANex0sesxKk1aruAXljpY1bi1Bq1XQAAAAAAAAAAAAAAwAYr312wEqfWqO0CemGlj1mJU2vUdgG9+H0fq/2yqeyZXJC8R/quGshxwI0e62PKislxAM4YLcdNLiwhhGVZFu/eI8Z1vehhH3FZsxee/JE/GCTKddsaaQKc/RKcK8z8rl0Azhkyx7npnaP8HK04+62AaHyWFDz7LGllmSqa9qksnqXcnOQ44F4j5jg/RyvIK25TZ19JS0KOS8ur/dWEHAfc6w/luOictOUU9rNKmuPyc1hyHNCzP5Pj0nQlFpdnNHkcV7zORo4DuvOXclw6cnv/NTkvXaWLSquO7SYX0nsR5DigLw/0sdI549FKX56rJqekbiuucqqaBCveV03XIMcB3bHSx6zEqTVqu4BeWOljVuLUGrVdAAAAAAAAkFm5HvRlnNHN077eRm9l+wNWWelj18S5frOkG1a2P2DVs9+Pa8835DgAZ/y6j8U/DFifDdKAHAfgjGf7WHvtijgr40Q5x4m/dEgq3K1Xen7cCeQ44F6P9jHFsKo5zurz4KQKC8+ViwtKVqs8P+4Echxwrwf7mOpB4pocV17yMKnG1SS/dI1T3HdPUypXCOB6T/WxaiqSl29dvPIjezHHFZ8R8L/OZKXq8+NOIMcB93qkj2kT3OtcnPKzkvLnwRWfKzf7Jbg5uxZ35V0Lchxwr9/3sRMJ7qV5tlLteXDyYzCl58pti+/vLFSeH3cCOQ641wPfHTl1qtceZ/15cOuZqfyoc7erZvbSzdPS8+NOIMcB97LSx6zEqTVqu4BeWOljVuLUGrVdAAAAAAAAAAAAAADABivfXbASp9ao7QJ6YaWPWYlTa9R2Ab2w0sesxKk1aruAh+WPCOrujVWv18tOnFqjtgvojjSO2DpgOuup6VbivKpdAK5jpY9ZiVNr1HYBvbDSx6zEqTVquwAAAAAAAAAAAAAAAK50+Ib7foz3dZDxWgTgrCHzgaFPGGCzvSWU47dAeAv18RrNvzkrOfObsLsNmboxtPgF75MLpDmROscJqSAqo6m40vLacq7FSA62NX5Kz/79Kvnd6C8fEAo9YpukHT+uy8dLv4ubs1haysmWForJHwzSEqvQ7mTTNmSK0vLacpTt3U3PjwaSHCxrPX5nLxz+0aBicuH/7DxpfqYkc2bf2m32Ib5zUJxlNbkjrleMP5/XJG/2Lu7DD5PS8tpy9O2dfbRvJ+d2zSbHwa72jiz1rHTa+tfs32V+JkwurDPOXNmRcpxUby12cZFC/NtKl+S42b8z8mGBpeW15ajbe7QFyXEwSpVyhH5wMO6YfQghuCleLDoNbE92Uo5TjWsK9ebnpN/kuDwRPDaOU7b3MIWR42CRdkylGMd9rt0FN80+OOeFDqLJIBfkOLneWYrsTISFOJ67HhcXedzegy1IioM9J04axX5Qub4Tgn9fgnsP5t6L+Ogq0e9yXLne5K/4dvO+QU3EJFe+Hzq5sN8L19xX1be3fj2O747Amuycpfm+ar5YVFbU87ZvpKTfTVGeqhZucOrHcZV6K/cTVXdu/1cjnc8Xihdy3FXfjzvR3uJ2YBQHYDXekGe8FgEAAAAAAAAAAAAA8Df9A12GSScbJyupAAAAAElFTkSuQmCC" alt="" />
常见配置：
八:常用配置写法.
(1)如果负载多个库,软件会根据你用户授权来决定对哪些库有权限.
grant all privileges on *.* to amoeba@’%’ identified by ‘amoeba123’; 这里写的是all 那么就是对所有的库有权限(会自动负载所有的库).
上面配置文件的库名test.根据这个语句来决定.如果是all.那么直接用写test来测试.方便一点.
(2)一主一从的负载写法一:
主只写.<property name=”poolNames”>server1</property>(主的均衡负载配置)
从只读.<property name=”poolNames”>server2</property>(从的均衡负载配置)
(3)一主一从的负载写法:
主负写:<property name=”poolNames”>server1</property>
主也负责读,从也负责读.比例1:1 第一读.从.第二次读住.循环 写的话,只能写主.<property name=”poolNames”>server1,server2</property>
(4)一主多从的负载写法:
比如.一台主.3台从.在最上面定义了.server1(master) server2(slave1) server3(slave2) server4(slave3)
1主只写:<property name=”poolNames”>server1</property>
3从负载读 <property name=”poolNames”>server2,server3,server4</property>
权重:1:1 3台轮询各一次.持续循环
(5)比如我想要.slave1 权重高一点.其它的.2台从.每次读一次.slave1读.2次.
<property name=”poolNames”>server2,server2,server3,server4</property>
