五、mysql集群-mycat

kingforce

select * from test　　
tail -f /application/mycat/logs/wrapper.log
　　
[root@mycat logs]# cat  wrapper.log  | grep "select read source 105_S1"
　　
INFO   | jvm 1    | 2018/05/29 22:46:13 | 2018-05-29 22:46:13,624 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:34 | 2018-05-29 22:46:34,026 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:34 | 2018-05-29 22:46:34,550 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:34 | 2018-05-29 22:46:34,914 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:35 | 2018-05-29 22:46:35,225 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:35 | 2018-05-29 22:46:35,546 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:35 | 2018-05-29 22:46:35,877 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:36 | 2018-05-29 22:46:36,237 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:36 | 2018-05-29 22:46:36,559 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:36 | 2018-05-29 22:46:36,892 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:37 | 2018-05-29 22:46:37,199 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:37 | 2018-05-29 22:46:37,523 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:37 | 2018-05-29 22:46:37,840 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:38 | 2018-05-29 22:46:38,153 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:38 | 2018-05-29 22:46:38,477 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:38 | 2018-05-29 22:46:38,831 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
INFO   | jvm 1    | 2018/05/29 22:46:39 | 2018-05-29 22:46:39,193 [DEBUG][$_NIOREACTOR-0-RW] select read source 105_S1 for dataHost:dn85  (io.mycat.backend.datasource.PhysicalDBPool:PhysicalDBPool.java:456)
　　
[root@mycat logs]# cat  wrapper.log  | grep "select read source 105_S1" | wc -l
　　
17
　　
进行了17查询结果证明读写分离配置成功