mycat

mycat start

scheme.xml example:

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


<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
<table name="group_user_io" dataNode="3307"></table>
<table name="group_user_relation" dataNode="3307"></table>
<table name="groups" dataNode="3307"></table>
<table name="organization_user_io" dataNode="3307"></table>
<table name="organization_user_relation" dataNode="3307"></table>
<table name="organization_user_relation_tag" dataNode="3307"></table>
<table name="organizations" dataNode="3307"></table>
<table name="tags" dataNode="3307"></table>
<table name="user_meta" dataNode="3307"></table>

<!-- auto sharding 用于分库 非单库分表 -->
<table name="users" dataNode="3307,3307,3307" rule="auto-sharding-long"></table>
<table name="users_login_log" dataNode="3307"></table>


<table name="ebk_students" dataNode="111"></table>

<!-- 以下为单库分表 3取模  -->
<table name="niggers" subTables="niggers$1-3" dataNode="test" rule="mod-long"></table>

</schema>

<!-- data node -->
<dataNode name="3307" dataHost="host3307" database="passport"></dataNode>
<dataNode name="111" dataHost="host111" database="ebkxxx"></dataNode>
<dataNode name="test" dataHost="host3307" database="cats"></dataNode>


<dataHost name="host3307" maxCon="1000" minCon="10" balance="0"
 writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
<heartbeat>select 1</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="localhost:3307" user="root"
  password="root">
<!-- can have multi read hosts -->
<readHost host="hostS2" url="localhost:3307" user="root" password="root" />
</writeHost>
<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
</dataHost>
<dataHost name="host111" maxCon="1000" minCon="10" balance="0"
 writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
<heartbeat>select 1</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM2" url="192.168.2.111:3306" user="test" password="test"/>
</dataHost>
</mycat:schema>