本地mysql分別部署有兩臺:192.168.79.130和192.168.79.131;服務正常啟動,連接正常
配置mycat的scheam.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">
<!-- schema 邏輯庫 name="邏輯庫名" -->
<schema name="MYCATDB" checkSQLschema="false" sqlMaxLimit="100">
<!-- auto sharding by id (long) -->
<!-- table 邏輯表 name=邏輯表名 dataNode=邏輯節點(分片) rule=分片規則 auto-sharding-long(按照id值劃分) 默認每500萬為一個分片-->
<table name="cat_test" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" />
</schema>
<!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"
/> -->
<!--邏輯節點配置 name節點名稱 dataHost節點主機(物理地址) database 節點資料庫(物理資料庫名) -->
<dataNode name="dn1" dataHost="itcast01" database="db1" />
<dataNode name="dn2" dataHost="itcast02" database="db2" />
<dataNode name="dn3" dataHost="itcast02" database="db3" />
<!--<dataNode name="dn4" dataHost="sequoiadb1" database="SAMPLE" />
<dataNode name="jdbc_dn1" dataHost="jdbchost" database="db1" />
<dataNode name="jdbc_dn2" dataHost="jdbchost" database="db2" />
<dataNode name="jdbc_dn3" dataHost="jdbchost" database="db3" /> -->
<dataHost name="itcast01" 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 -->
<!-- itcast-01 -->
<writeHost host="hostM1" url="192.168.79.130:3306" user="root"
password="root123">
<!-- can have multi read hosts -->
</writeHost>
<!--itcast-02 -->
<!--<writeHost host="hostS1" url="192.168.79.131:3316" user="root"
password="root123" /> -->
<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
</dataHost>
<dataHost name="itcast02" 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 -->
<!-- itcast-01 -->
<writeHost host="hostM1" url="192.168.79.131:3306" user="root"
password="root123">
<!-- can have multi read hosts -->
</writeHost>
<!--itcast-02 -->
<!--<writeHost host="hostS1" url="192.168.79.131:3316" user="root"
password="root123" /> -->
<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
</dataHost>
</mycat:schema>
問題:當連接mycat創建表報錯:1064 op table not in schema----'TB_TEST'
uj5u.com熱心網友回復：
建表陳述句:CREATE TABLE `NewTable` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`title` varchar(100) NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/64842.html
標籤：疑難問題
下一篇：然后將資料存盤到RFID卡中