实验环境
mysql5.6
mycat1.6
第一步:配置数据库和表
新建数据库db4
新建数据库db5
在db4和db5中新建用户表
CREATE TABLE `t_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NULL,
PRIMARY KEY (`id`)
);
第二步:配置mycat的server.xml
配置mycat的逻辑数据库名和账号密码
第三步:配置mycat的schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="MyCatDB" checkSQLschema="false" sqlMaxLimit="100">
<table name="t_user" primaryKey="ID" dataNode="dn4,dn5" autoIncrement="false" rule="mod-long" />
</schema>
<dataNode name="dn4" dataHost="localhost1" database="db4" />
<dataNode name="dn5" dataHost="localhost2" database="db5" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="3"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="你的db4数据库ip和端口" user="root"
password="root">
</writeHost>
</dataHost>
<dataHost name="localhost2" maxCon="1000" minCon="10" balance="3"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="你的db5数据库ip和端口" user="root"
password="root">
</writeHost>
</dataHost>
</mycat:schema>
第四步:启动mycat验证
启动mycat
用navicate连接mycat
然后往mycat的逻辑库MyCatDB的t_user表插入两条记录
INSERT INTO `t_user` (`id`, `name`) VALUES (1, "ddd");
INSERT INTO `t_user` (`id`, `name`) VALUES (2, "ddd");
实验结果:db4和db5的t_user表各一条数据,验证完毕。