mycat分表分库示例

最新推荐文章于 2025-07-01 18:03:55 发布

原创最新推荐文章于 2025-07-01 18:03:55 发布 · 265 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

3 篇文章

订阅专栏

接着之前的文档深入讲解分表分库原理
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>