mycat 分库分表集成

第一步：修改server.xml

<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE mycat:server SYSTEM "server.dtd">  
<mycat:server xmlns:mycat="http://io.mycat/">  
     <system> 
             <property name="defaultSqlParser">druidparser</property>  
             <property name="mutiNodeLimitType">1</property>  
       <property name="sequnceHandlerType">1</property>       
             <!-- mycat服务的端口号  -->  
             <property name="serverPort">8066</property>  
             <!-- mycat管理的端口号  -->
             <property name="managerPort">9066</property>   
     </system>

     <!-- 配置连接Mycat的用户名, 密码, 逻辑数据库名称  -->  
     <user name="root">  
             <property name="password">123456</property>  
             <property name="schemas">hikari_cloud</property>  
     </user>  

     <user name="guest">  
             <property name="password">123456</property>  
             <property name="schemas">hikari_cloud</property>  
             <property name="readOnly">true</property>  
     </user>  
</mycat:server>

第二部：修改schema.xml

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

    <schema name="hikari_cloud" checkSQLschema="false" sqlMaxLimit="100">
        <table name="tb_admin" dataNode="dataNode1,dataNode2,dataNode3" rule="mod-long"/>   
    </schema>  
    



    <dataNode name="dataNode1" dataHost="dataHost1" database="hikari_cloud1" />
    <dataNode name="dataNode2" dataHost="dataHost2" database="hikari_cloud2" />
    <dataNode name="dataNode3" dataHost="dataHost3" database="hikari_cloud3" />
 
    <dataHost name="dataHost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">  
        <heartbeat>select user()</heartbeat>  
        <writeHost host="hostMaster" url="localhost:3306" user="root" password="123" />
    </dataHost>
    <dataHost name="dataHost2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">  
        <heartbeat>select user()</heartbeat>  
        <writeHost host="hostMaster" url="localhost:3306" user="root" password="123" />
    </dataHost>
    <dataHost name="dataHost3" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">  
        <heartbeat>select user()</heartbeat>  
        <writeHost host="hostMaster" url="localhost:3306" user="root" password="123" />
    </dataHost>
    <!--<dataHost name="dataHost2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">  
        <heartbeat>select user()</heartbeat>  
        <writeHost host="hostMaster" url="172.16.128.153:3306" user="root" password="root123" />
    </dataHost>
    <dataHost name="dataHost3" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">  
        <heartbeat>select user()</heartbeat>  
        <writeHost host="hostMaster" url="172.16.128.148:3306" user="root" password="root123" />
    </dataHost>  
    -->
</mycat:schema>

第三步：修改rule.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:rule SYSTEM "rule.dtd">
<mycat:rule xmlns:mycat="http://io.mycat/">
  <tableRule name="mod-long">
     <rule>
       <columns>id</columns>
       <algorithm>mod-long</algorithm>
     </rule>
  </tableRule>
  <function name="mod-long" class="io.mycat.route.function.PartitionByMod">
     <!-- dataNode数量(根据实际情况进行修改此配置) -->
     <property name="count">3</property>
  </function>
</mycat:rule>