mycat分库分表

分库:

**111机 **

**112机 **

**配置schema.xml （/conf/schema.xml） **

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

        <schema name="mycat_112db" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn2">
                <table name="student" dataNode="dn1"></table>
                <table name="goods" dataNode="dn2"></table>
        </schema>

        <dataNode name="dn1" dataHost="h111" database="mycat_111" />
        <dataNode name="dn2" dataHost="h112" database="mycat_112" />


        <dataHost name="h112" 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 -->
                <writeHost host="hostM1" url="192.168.31.112:3306" user="root"   password="xjy123456">
                        <readHost host="hostS2" url="192.168.31.112:3306" user="root" password="xjy123456" />
                </writeHost>

        </dataHost>


        <dataHost name="h111" 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 -->
                <writeHost host="hostM2" url="192.168.31.111:3306" user="root"   password="xjy123456">
                        <readHost host="hostS3" url="192.168.31.111:3306" user="root" password="xjy123456" />
                </writeHost>

        </dataHost>

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

        <schema name="mycat_112db" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn2">
                <table name="student" dataNode="dn1"></table>
                <table name="goods" dataNode="dn2"></table>
        </schema>

        <dataNode name="dn1" dataHost="h111" database="mycat_111" />
        <dataNode name="dn2" dataHost="h112" database="mycat_112" />


        <dataHost name="h112" 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 -->
                <writeHost host="hostM1" url="192.168.31.112:3306" user="root"   password="xjy123456">
                        <readHost host="hostS2" url="192.168.31.112:3306" user="root" password="xjy123456" />
                </writeHost>

        </dataHost>


        <dataHost name="h111" 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 -->
                <writeHost host="hostM2" url="192.168.31.111:3306" user="root"   password="xjy123456">
                        <readHost host="hostS3" url="192.168.31.111:3306" user="root" password="xjy123456" />
                </writeHost>

        </dataHost>

</mycat:schema>

启动mycat(./bin/mycat start)

登录mycat