1、下载mycathttp://dl.mycat.io/1.6-RELEASE/
2、修改部分配置文件
server.xml，rule.xml，schema.xml
server.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. -->
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/"><system><property name="useSqlStat">0</property> <!-- 1为开启实时统计、0为关闭 --><property name="useGlobleTableCheck">0</property> <!-- 1为开启全加班一致性检测、0为关闭 --><property name="sequnceHandlerType">2</property><!-- <property name="useCompression">1</property>--> <!--1为开启mysql压缩协议--><!-- <property name="fakeMySQLVersion">5.6.20</property>--> <!--设置模拟的MySQL版本号--><!-- <property name="processorBufferChunk">40960</property> --><!-- <property name="processors">1</property> <property name="processorExecutor">32</property> --><!--默认为type 0: DirectByteBufferPool | type 1 ByteBufferArena--><property name="processorBufferPoolType">0</property><!--默认是65535 64K 用于sql解析时最大文本长度 --><!--<property name="maxStringLiteralLength">65535</property>--><!--<property name="sequnceHandlerType">0</property>--><!--<property name="backSocketNoDelay">1</property>--><!--<property name="frontSocketNoDelay">1</property>--><!--<property name="processorExecutor">16</property>--><!--<property name="serverPort">8066</property> <property name="managerPort">9066</property> <property name="idleTimeout">300000</property> <property name="bindIp">0.0.0.0</property> <property name="frontWriteQueueSize">4096</property> <property name="processors">32</property> --><!--分布式事务开关，0为不过滤分布式事务，1为过滤分布式事务（如果分布式事务内只涉及全局表，则不过滤），2为不过滤分布式事务,但是记录分布式事务日志--><property name="handleDistributedTransactions">0</property><!--off heap for merge/order/group/limit 1开启 0关闭--><property name="useOffHeapForMerge">1</property><!--单位为m--><property name="memoryPageSize">1m</property><!--单位为k--><property name="spillsFileBufferSize">1k</property><property name="useStreamOutput">0</property><!--单位为m--><property name="systemReserveMemorySize">384m</property><!--是否采用zookeeper协调切换 --><property name="useZKSwitch">false</property></system><!-- 全局SQL防火墙设置 --><!-- <firewall> <whitehost><host host="127.0.0.1" user="mycat"/><host host="127.0.0.2" user="mycat"/></whitehost><blacklist check="false"></blacklist></firewall>--><!--mycat 用户名--><user name="root"><!--mycat 密码--><property name="password">root</property><property name="schemas">TESTDB</property><!--是否只读--><property name="readOnly">false</property><!-- 表级 DML 权限设置 <privileges check="false"><schema name="TESTDB" dml="0110" ><table name="dn1" dml="1111"></table></schema></privileges> --></user><user name="user"><property name="password">user</property><property name="schemas">TESTDB</property><property name="readOnly">true</property></user></mycat:server>schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/"><!-- name="TESTDB"是在server.xml中配置<property name="schemas">TESTDB</property>--><schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" > <!-- 与mysql数据库中的表名对应 subTables="fishlog_2018_11_$06-09"是配置分表的 对应mysql 中的fishlog_2018_11_06 fishlog_2018_11_07 fishlog_2018_11_08 fishlog_2018_11_09primaryKey="id" 是主键id--><table name="fishlog" primaryKey="ID" autoIncrement="true" subTables="fishlog_2018_11_$06-09" dataNode="dn1" rule="sharding-by-date" ><!-- 这里的rule跟rule.xml中配置的name相同--></table><table name="fishentityitemlog" primaryKey="ID" autoIncrement="true" dataNode="dn1" /> </schema> <!--配置mysql数据库fishlog mycat逻辑库名为 dn1--><dataNode name="dn1" dataHost="localhost1" database="fishlog" /> <!--配置数据类型 balance="0"读写不分离 --><dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <!--心跳包 --><heartbeat>select user()</heartbeat> <!--配置mysql数据 账户密码 --><writeHost host="hostM1" url="127.0.0.1:3306" user="root" password="123456" /> </dataHost>
</mycat:schema>rule.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. -->
<!DOCTYPE mycat:rule SYSTEM "rule.dtd">
<mycat:rule xmlns:mycat="http://io.mycat/"><tableRule name="sharding-by-date"><rule><columns>LogTime</columns><algorithm>sharding-by-date</algorithm></rule>
</tableRule><function name="sharding-by-date" class="io.mycat.route.function.PartitionByDate"><property name="dateFormat">yyyy-MM-dd</property> <!--日期格式--><property name="sBeginDate">2018-11-06</property> <!--开始日期--><property name="sPartionDay">1</property> <!--每分片天数-->
</function> </mycat:rule>然后在本地数据库中建立4张表
CREATE TABLE `fishcartableinfo_2018_11_6` (`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,`BrandUserID` int(10) unsigned NOT NULL,`AreaGlobel` varchar(1024) NOT NULL,`ResultIndex` tinyint(3) unsigned NOT NULL,`BrandGlobel` bigint(20) unsigned NOT NULL,`SystemGlobel` bigint(20) unsigned NOT NULL,`RoleSum` int(10) unsigned NOT NULL,`LogTime` datetime NOT NULL,PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8;
CREATE TABLE `fishcartableinfo_2018_11_7` (`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,`BrandUserID` int(10) unsigned NOT NULL,`AreaGlobel` varchar(1024) NOT NULL,`ResultIndex` tinyint(3) unsigned NOT NULL,`BrandGlobel` bigint(20) unsigned NOT NULL,`SystemGlobel` bigint(20) unsigned NOT NULL,`RoleSum` int(10) unsigned NOT NULL,`LogTime` datetime NOT NULL,PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8;
CREATE TABLE `fishcartableinfo_2018_11_8` (`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,`BrandUserID` int(10) unsigned NOT NULL,`AreaGlobel` varchar(1024) NOT NULL,`ResultIndex` tinyint(3) unsigned NOT NULL,`BrandGlobel` bigint(20) unsigned NOT NULL,`SystemGlobel` bigint(20) unsigned NOT NULL,`RoleSum` int(10) unsigned NOT NULL,`LogTime` datetime NOT NULL,PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8;
CREATE TABLE `fishcartableinfo_2018_11_9` (`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,`BrandUserID` int(10) unsigned NOT NULL,`AreaGlobel` varchar(1024) NOT NULL,`ResultIndex` tinyint(3) unsigned NOT NULL,`BrandGlobel` bigint(20) unsigned NOT NULL,`SystemGlobel` bigint(20) unsigned NOT NULL,`RoleSum` int(10) unsigned NOT NULL,`LogTime` datetime NOT NULL,PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8;然后插入一些数据
最后将mycat启动，
在bin目录下，按住shift 右键，选择在当前目录打开命令行 执行命令startup_nowrap.bat
出现successfull即为成功
这个时候可以使用Navicat工具来链接
localhost
8806
root
root
如果连接未成功：替换lib目录下的Mycat-server-1.6-RELEASE.jar
为Mycat-server-1.6.5-DEV.jar
链接成功之后，本地的mysql的四张表的数据会同步到这一张表里面，这样就可以像mysql中查询数据的方式查询多表
linux中安装和配置
1、yum安装mycat
2、开放端口8066
3、修改相关的配置文件如上所示
4、linux中的启动方式
进入安装的bin目录下
执行 ./mycat console 命令
如果出现successfull即为成功，然后再Navicat中测试连接即可
注意：linux中启动需要配置的有jdk mysql环境，否则启动不成功
mycat1.6中貌似没有按日期分片的规则，需要重构代码，
源码如下mycat1.6jar包反编译的源码-Java代码类资源-CSDN下载