我配置cobar的集群,但是两个cobar中,执行show cobar_cluster;命令,一个节点显示两个节点,另外一个只能显示自身节点
server.xml配置如下:
<cluster>
<node name="cobar1">
<property name="host">192.168.0.59</property>
<property name="weight">1</property>
</node>
<node name="cobar2">
<property name="host">192.9.99.101</property>
<property name="weight">2</property>
</node>
<group name="group12">
<property name="nodeList">cobar1,cobar2</property>
</group>
</cluster>192.9.99.101上执行show cobar_cluster结果如下:
shell>mysql -h192.9.99.101 -utest -pdbtest -P8066 -Ddbtest
mysql> show cobar_cluster;
+--------------+--------+
| HOST | WEIGHT |
+--------------+--------+
| 192.9.99.101 | 2 |
| 192.168.0.59 | 1 |
+--------------+--------+
192.168.0.59上show cobar_cluster结果如下:
shell>mysql -h192.168.0.59 -utest -pdbtest -P8066 -Ddbtest
mysql> show cobar_cluster;
+--------------+--------+
| HOST | WEIGHT |
+--------------+--------+
| 192.168.0.59 | 1 |
+--------------+--------+
1 row in set (0.00 sec)
server.xml配置如下:
<cluster>
<node name="cobar1">
<property name="host">192.168.0.59</property>
<property name="weight">1</property>
</node>
<node name="cobar2">
<property name="host">192.9.99.101</property>
<property name="weight">2</property>
</node>
<group name="group12">
<property name="nodeList">cobar1,cobar2</property>
</group>
</cluster>192.9.99.101上执行show cobar_cluster结果如下:
shell>mysql -h192.9.99.101 -utest -pdbtest -P8066 -Ddbtest
mysql> show cobar_cluster;
+--------------+--------+
| HOST | WEIGHT |
+--------------+--------+
| 192.9.99.101 | 2 |
| 192.168.0.59 | 1 |
+--------------+--------+
192.168.0.59上show cobar_cluster结果如下:
shell>mysql -h192.168.0.59 -utest -pdbtest -P8066 -Ddbtest
mysql> show cobar_cluster;
+--------------+--------+
| HOST | WEIGHT |
+--------------+--------+
| 192.168.0.59 | 1 |
+--------------+--------+
1 row in set (0.00 sec)
我的配置有什么问题吗
log中报错如下:
09:16:28,784 WARN com.alibaba.cobar.heartbeat.CobarDetector@43ab91e
java.net.NoRouteToHostException: No route to host
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:739)
at com.alibaba.cobar.net.BackendConnection.finishConnect(BackendConnection.java:100)
at com.alibaba.cobar.net.NIOConnector.finishConnect(NIOConnector.java:104)
at com.alibaba.cobar.net.NIOConnector.run(NIOConnector.java:76)
09:16:28,784 ERROR #!Cobar#[name=cobar2,host=192.9.99.101,port=8066,reason=ERROR]