接着之前的文档深入讲解分表分库原理
https://blog.youkuaiyun.com/huangfujin321/article/details/97647170
一、分库
二、分表
分表即把一个表拆分成多个库或节点存储
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="flase" sqlMaxLimit="100" >
<table name="user" primaryKey='id' type="global" dataNode="dn1,dn2,dn3" />
<table name="aorder" primaryKey="id" autoIncrement="true" dataNode="dn2,dn3" rule="mycat-rule" />
</schema>
<dataNode name="dn1" dataHost="db1" database="xing" />
<dataNode name="dn2" dataHost="db1" database="xing2" />
<dataNode name="dn3" dataHost="db1" database="xing3" />
<dataHost name="db1" maxCon="1000" minCon="5" balance="1" writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
<heartbeat>show slave status</heartbeat>
<writeHost host="hostMaster1" url="10.17.162.24:3306" user="root" password="321">
<readHost host="hostSlave1" url="10.17.162.23:3306" user="root" password="321" />
<readHost host="hostSlave2" url="10.17.162.21:3306" user="root" password="321" />
</writeHost>
<writeHost host="hostMaster2" url="10.17.162.23:3306" user="root" password="321">
</writeHost>
</dataHost>
</mycat:schema>