schema配置文件如下:
[root@edu-mycat-01 conf]# cat schema.xml.bak
<?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="edu-mycat-01" database="tree" />
<dataHost name="edu-mycat-01" maxCon="1000" minCon="10" balance="1"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>show slave status</heartbeat>
<writeHost host="192.168.1.3" url="192.168.1.3:3306" user="root"
password="123456">
<readHost host="192.168.1.4" url="192.168.1.4:3306" user="root" password="123456" />
</writeHost>
<writeHost host="192.168.1.4" url="192.168.1.4:3316" user="root"
password="123456" />
</dataHost>
</mycat:schema>
server.xml配置文件默认