ITPub博客

首页 > > > mycat配置文件解析错误

mycat配置文件解析错误

作者:yesye 时间:2019-09-27 11:57:55 0 删除 编辑

mycat配置文件是这样的,启动mycat的时候总是xml解析异常。请问怎么写才对呀?谢谢!

Caused by: org.xml.sax.SAXParseException; lineNumber: 14; columnNumber: 29; 元素类型 "dataHost" 必须后跟属性规范 ">" 或 "/>"

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">

    <schema name="e3mall" checkSQLschema="false" sqlMaxLimit="100">
        <!-- auto sharding by id (long) -->
        <table name="tb_item" dataNode="dn1,dn2" rule="auto-sharding-long" />
    </schema>
    
    <dataNode name="dn1" dataHost="localhost1" database="db1" />
    <dataNode name="dn2" dataHost="localhost2" database="db2" />


    <dataHost name="localhost1"maxCon="1000"minCon="10"balance="1"
        writeType="0"dbType="mysql"dbDriver="native"switchType="2"slaveThreshold="100">
        <heartbeat>show slave status</heartbeat>
        
        <writeHost host="hostM1" url="192.168.1.20:3306" user="root" password="520520.">
            <readHost host="hostS"url="192.168.1.20:3308" user="root" password="520520." />
        </writeHost>
    </dataHost>

    <dataHost name="localhost2" maxCon="1000" minCon="10" balance="0"
        writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <!-- can have multi write hosts -->
        <writeHost host="hostM1" url="192.168.1.20:3307" user="root"
            password="520520.">
            <!-- can have multi read hosts -->
        </writeHost>
    </dataHost>
</mycat:schema>


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2041/viewspace-3168285/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: .net 问题
请登录后发表评论 登录
全部评论

注册时间:2019-09-06

  • 博文量
    139
  • 访问量
    9684