{"id":499,"title":"navicate\u8fde\u63a5mycat\u62a51184\u9519\u8bef","good":20,"bad":13,"hit":7653,"created_at":"2020-07-03 19:20:17","content":"

\u914d\u7f6emycat\u540e\u7531\u4e8e\u4fee\u6539\u4e86\u8282\u70b9\u540d\u79f0,navicate\u8fde\u63a5\u65f6\u62a51184<\/p>

\u539f\u56e0\u662fschema.xml\u4e2drandomDataNode\u7684\u503c\u8981\u914d\u7f6e\u6210\u4f60\u8bbe\u7f6e\u7684node\u540d\u79f0\uff08\u5982\u679c\u4f60\u6539\u4e86node\u7684\u540d\u79f0\u7684\u8bdd\uff09<\/strong><\/p>

<\/p>

<schema name="mycat_ips" checkSQLschema="true" sqlMaxLimit="100" randomDataNode="node1"<\/strong>><\/p>

<\/span><table name="ip_001" primaryKey="id" dataNode="node1,node2" rule="auto-sharding-long" autoIncrement="true" fetchStoreNodeByJdbc="true"><\/p>

                <!--<childTable name="customer_addr" primaryKey="id" joinKey="customer_id" parentKey="id"> <\/childTable>--><\/p>

        <\/table><\/p>

<\/span><table name="ip_121" primaryKey="id" dataNode="node1,node2" rule="auto-sharding-long" autoIncrement="true" fetchStoreNodeByJdbc="true"><\/p>

<\/span><!--<childTable name="customer_addr" primaryKey="id" joinKey="customer_id" parentKey="id"> <\/childTable>--><\/p>

<\/span><\/table><\/p>

<\/schema><\/p>

<dataNode name="node1<\/strong><\/em>" dataHost="tencent" database="ip" \/><\/p>

<dataNode name="node2" dataHost="aliyun" database="ip" \/><\/p>

<\/p>"}