下载mycat完成环境变量配置:
name:MYCAT_HOME
value:D:\user\mycat
加入系统路径
name:path
value:;%MYCAT_HOME%\bin;
server,rule的xml文件为默认mycat配置和分片规则,主要配置schamal:
<?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="h" primaryKey="ID" dataNode="ddn1,ddn2,ddn3,ddn4,ddn5,ddn6,ddn7,ddn8" rule="mod-long" />
</schema>
<dataNode name="dn1" dataHost="localhost1" database="db1" />
<dataNode name="dn2" dataHost="localhost1" database="db2" />
<dataNode name="dn3" dataHost="localhost2" database="db3" />
<dataNode name="dn4" dataHost="localhost2" database="db2" />
<dataNode name="ddn1" dataHost="localhost1" database="db1" />
<dataNode name="ddn2" dataHost="localhost1" database="db2" />
<dataNode name="ddn3" dataHost="localhost1" database="db3" />
<dataNode name="ddn4" dataHost="localhost1" database="db4" />
<dataNode name="ddn5" dataHost="localhost2" database="db1" />
<dataNode name="ddn6" dataHost="localhost2" database="db2" />
<dataNode name="ddn7" dataHost="localhost2" database="db3" />
<dataNode name="ddn8" dataHost="localhost2" database="db4" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM1" url="localhost:3306" user="root"
password="19941101">
<readHost host="hostS2" url="localhost:3306" user="root" password="1101" />
</writeHost>
</dataHost>
<dataHost name="localhost2" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM2" url="19.168.172.128:3306" user="root"
password="19941101">
<readHost host="hostS2" url="19.168.172.128:3306" user="root" password="1101" />
</writeHost>
</dataHost>
</mycat:schema>
一个虚拟表可以对应多个节点,并指明分片方法和主键,一个node对应一个数据库,在host中配置具体的数据库,并在具体库中建立相应表,完成和实际表的映射。
rule规则:
<tableRule name="mod-long">
<rule>
<columns>ID</columns>
<algorithm>mod-long</algorithm>
</rule>
</tableRule>
<function name="mod-long" class="io.mycat.route.function.PartitionByMod">
<!-- how many data nodes -->
<property name="count">3</property>
</function>
在mycat插入数据时,ID为必须插入的字段,这是插入哪个数据库具体表的依据。
配置完成后打开mycat bin目录:
mycat start
启动服务
mycat端口为8066
INSERT INTO h(ID,task) values (6,'hg');
mycat会取模以后插入具体库和表
得到一个汇集所有表的虚拟表以及可以将数据插入任意表,完成基本操作