1 [root@amoeba mnt]# cd /usr/local/amoeba/conf/
 2 [root@amoeba conf]# vim amoeba.xml     \'//编辑amoeba主配置文件\'
 3 \'//此段设置的是客户端通过amoeba用户和123456密码访问amoeba服务器\'
 4 <property name="user">amoeba</property>    \'//第30行开始修改用户名\'
 5     
 6 <property name="password">123456</property>    \'//使用123456密码访问amoeba服务器\'
 7 
 8 \'//移动到117行，开启读写功能池设定\'
 9 <property name="defaultPool">master</property>    \'//115行修改\'
10 <!-- -->    \'//117行取消注释\'
11 <property name="writePool">master</property>  \'//118行修改\'
12 <property name="readPool">slaves</property>    \'//119行修改\'
13 \'//120行删除-->注释符号\'
14     
15 [root@amoeba conf]# vim dbServers.xml     \'//编辑数据库配置文件\'
16 <property name="schema">mysql</property>    \'//23行test修改为mysql\'
17 
18 \'//设置amoeba访问mysql数据库的用户和密码\'
19 <property name="user">test</property>    \'//26行修改用户名\'
20     
21 <!--  mysql password-->    \'//28行-30行取消注释\'
22 <property name="password">123.com</property>    \'//29行修改密码\'
23 
24 <dbServer name="master"  parent="abstractServer">    \'//45行主mysql服务器名称修改为master\'
25  <property name="ipAddress">192.168.79.135</property>    \'48行//修改主服务器IP\'
26 
27 <dbServer name="slave1"  parent="abstractServer">    \'//52行修改从服务器名称\'
28 <property name="ipAddress">192.168.79.135</property>    \'//55行修改从服务器IP\'
29     \'//第一个从服务器段后插入第二个从服务器配置\'
30 <dbServer name="slave2"  parent="abstractServer">
31         <factoryConfig>
32                 <!-- mysql ip -->
33         <propertyname="ipAddress">192.168.79.136</property>
34       </factoryConfig>
35 </dbServer>
36 \'//修改数据库从服务器池\'
37 <dbServer name="slaves" virtual="true">    \'//66行修改服务器吃名称为slaves\'
38 <property name="poolNames">slave1,slave2</property>    \'//72行添加两个从服务器名称slave1,slave2\'

1 [root@amoeba conf]# /usr/local/amoeba/bin/amoeba start &
2 [1] 63847
3 [root@amoeba conf]# log4j:WARN log4j config load completed from file:/usr/local/amoeba/conf/log4j.xml
4 2020-01-08 23:38:40,817 INFO  context.MysqlRuntimeContext - Amoeba for Mysql current versoin=5.1.45-mysql-amoeba-proxy-2.2.0
5 log4j:WARN ip access config load completed from file:/usr/local/amoeba/conf/access_list.conf
6 2020-01-08 23:38:41,113 INFO  net.ServerableConnectionManager - Amoeba for Mysql listening on 0.0.0.0/0.0.0.0:8066.
7 2020-01-08 23:38:41,122 INFO  net.ServerableConnectionManager - Amoeba Monitor Server listening on /127.0.0.1:23097.
8 \'//此时处于持续监控状态，无法输入命令\'

mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G;
...省略内容
             Slave_IO_Running: No    \'//发现功能已被关闭\'
            Slave_SQL_Running: No
...省略内容

 1 MySQL [(none)]> create database siku;    \'//客户端创建库\'
 2 \'//会发现主服务器有，但是从服务器没有，说明主从复制功能已经关闭\'
 3 \'//slave1从服务器设置：都有erku的库，所以各自在erku创建yibiao并插入不同数据\'
 4 mysql> use erku;    
 5 Database changed
 6 mysql> create table yibiao (id int not null,name char(10));
 7 Query OK, 0 rows affected (0.01 sec)
 8 
 9 mysql> insert into yibiao values(1,\'zhangsan\');    \'//添加zhangsan记录\'
10 Query OK, 1 row affected (0.02 sec)
11 
12 mysql> select * from yibiao;
13 +----+----------+
14 | id | name     |
15 +----+----------+
16 |  1 | zhangsan |
17 +----+----------+
18 1 row in set (0.00 sec)
19 
20 \'//slave1从服务器设置：\'
21 mysql> use erku;
22 Database changed
23 mysql> create table yibiao(id int not null,name char(10));
24 Query OK, 0 rows affected (0.01 sec)
25 
26 mysql> insert into yibiao values(2,\'lisi\');    \'//添加lisi记录\'
27 Query OK, 1 row affected (0.02 sec)
28 
29 mysql> select * from yibiao;
30 +----+------+
31 | id | name |
32 +----+------+
33 |  2 | lisi |
34 +----+------+
35 1 row in set (0.00 sec)

 1 MySQL [(none)]> use erku;    \'//进入库\'
 2 Database changed
 3 MySQL [erku]> select * from yibiao;
 4 +----+------+
 5 | id | name |
 6 +----+------+
 7 |  2 | lisi |
 8 +----+------+
 9 1 row in set (0.01 sec)
10 
11 MySQL [erku]> select * from yibiao;
12 +----+----------+
13 | id | name     |
14 +----+----------+
15 |  1 | zhangsan |
16 +----+----------+
17 1 row in set (0.01 sec)
18 \'//发现每一次查询都会轮询在slave1和slave2上查询数据，如果开启主从复制，则数据都会相同\'
19 \'//读写分离试验成功\'