mycat连接postgresql做读写分离和主从切换

云霄527 2017-11-29 10:55:39

mycat连接postgresql数据库，做读写分离和主从切换，读写分离可以，主从切换把主机停机，但是mycat日志里面一直报连接主机拒绝，求大神们解答，下面是mycat的schema.xml文件配置

<?xml version="1.0"?>  

<!DOCTYPE mycat:schema SYSTEM "schema.dtd">  

<mycat:schema xmlns:mycat="http://io.mycat/">  

    <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">    

    </schema>  

    <dataNode name="dn1" dataHost="localhost1" database="sunftdb" />  

    <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1" writeType="1"  

             dbType="postgresql" dbDriver="jdbc" switchType="1"  slaveThreshold="100">  

        <heartbeat>select 1</heartbeat>  

        <!-- can have multi write hosts -->  

        <writeHost host="hostM1" url="jdbc:postgresql://100.10.1.1:5432/sunftdb" user="root"  password="123456">  

            <!-- can have multi read hosts -->  

            <readHost host="hostS1" url="jdbc:postgresql://100.10.1.2:5432/sunftdb" user="root" password="123456" />  

        </writeHost> 

        <writeHost host="hostM2" url="jdbc:postgresql://100.10.1.2:5432/sunftdb" user="root"   password="123456"/> 

    </dataHost>  

</mycat:schema>

mycat日志一直报连接100.10.1.1这个主机的错误，这个主机已经被停机，想让读写都用100.10.1.2

...全文