- <?xml version="1.0"?>
- <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
- <mycat:schema xmlns:mycat="http://org.opencloudb/">
- <!-- 起一个名字, 作为 mycat 的数据库名 -->
- <schema name="mycat001" checkSQLschema="false" sqlMaxLimit="100">
- <!-- 一个表的名字, 以 id 为分片依据, 数据节点: d1,d2,d3,rule 拆分规定 // 此处为默认 -->
- <table name="mycat_test" primaryKey="id" dataNode="d1,d2,d3" rule="auto-sharding-long" />
- </schema>
- <!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"
- /> -->
- <!-- 配置数据节点, name 和上面的对照, datahost 和下面的对照, database 为数据节点中的数据库中的真实名字 -->
- <dataNode name="d1" dataHost="centos_1" database="db1" />
- <dataNode name="d2" dataHost="centos_2" database="db2" />
- <dataNode name="d3" dataHost="centos_3" database="db3" />
- <!-- 配置 datahost 的信息, 连接数据库的配置, name 和上面的对照, 因为 db1 和 db2 在一台机器上, 可以配置一成台 datahost-->
- <dataHost name="centos_1" maxCon="1000" minCon="10" balance="0"
- writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
- <heartbeat>show slave status</heartbeat><!-- 配置心跳, 保持状态 -->
- <!-- can have multi write hosts --><!-- 配置服务器 ip 和数据库端口, 用户名和密码 -->
- <writeHost host="hostM1" url="192.168.80.11:3306" user="root" password="123456">
- <!-- can have multi read hosts --><!-- 上面的 writehost 是写 -->
- </writeHost>
- <!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
- </dataHost>
- <dataHost name="centos_2" 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.80.11:3306" user="root" password="123456">
- <!-- can have multi read hosts -->
- </writeHost>
- <!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
- </dataHost>
- <dataHost name="centos_3" 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="hostM3" url="192.168.80.4:3306" user="root" password="123456">
- <!-- can have multi read hosts -->
- </writeHost>
- <!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
- </dataHost>
- </mycat:schema>
来源: http://www.linuxidc.com/Linux/2018-09/154057.htm