mycat+mysql实现按照⽉份数据分表
1. ⾸先下载 ：（ “选择win版本 第6个⽂件就是”）
2. 下载完毕，解压mycat之后配置环境变量
3. ok，环境变量配置完毕，解压后的mycat⼀⼤堆⽂件，⾸先我们要到这⼏个：
4. 依次打开这⼏个⽂件，我们就按照⽉份分⽚配置好mycat
<?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 -- /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="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>
<!--默认是6553564K ⽤于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>
mysql下载starting the server<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>
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM"schema.dtd">
<mycat:schema xmlns:mycat="io.mycat/">
<!-- name="TESTDB"是在l中配置<property name="schemas">TESTDB</property>-->
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
<table name="sensor_data" subTables="january,february,march,april,may,june,july,august,september,october,november,december" primaryKey="id" au toIncrement="true" dataNode="dn1" rule="sharding-by-month"></table>
</schema>
<!--配置mysql数据库testdb2 mycat逻辑库名为 dn1-->
<dataNode name="dn1" dataHost="localhost1" database="testdb2"/>
<!--配置数据类型 balance="0"读写不分离-->
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThres hold="100">
<!--⼼跳包-->
<heartbeat>select user()</heartbeat>
<!--配置mysql数据账户密码-->
<writeHost host="hostM1" url="localhost:3306" user="root" password="root"/>
</dataHost>
</mycat:schema>
<?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 -- /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="io.mycat/">
<tableRule name="sharding-by-month">
<rule>
<!--按照创建时间分表-->
<!--属性指定对应表中⽤于分⽚的列名-->
<columns>create_time</columns>
<!--属性对应function中指定的算法的名称-->
<algorithm>sharding-by-month</algorithm>
</rule>
</tableRule>
<function name="sharding-by-month"class="ute.function.PartitionByMonth"> <!--按⽉分⽚-->
<property name="dateFormat">yyyy-MM-dd HH:mm:ss</property>
<!--开始时间，插⼊数据只能是这个年份的数据-->
<property name="sBeginDate">2020-01-0100:00:00</property>
</function>
</mycat:rule>
#********************************************************************
# Wrapper Properties
#********************************************************************
# Java Application
wrapper.javamand=C:\Program Files\Java\jdk1.8.0_131\
wrapper.working.dir=..
# Java Main class. This class must implement the WrapperListener interface
# or guarantee that the WrapperManager class is initialized. Helper
# classes are provided to do this for you. See the Integration section
# of the documentation for details.
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperSimpleApp
set.default.REPO_DIR=lib
set.APP_BASE=.
# Java Classpath(include wrapper.jar) Add class path elements as
# needed starting from1
wrapper.java.classpath.1=lib/wrapper.jar
wrapper.java.classpath.2=conf
wrapper.java.classpath.3=%REPO_DIR%/*
# Java Library Path (location of Wrapper.DLL or libwrapper.so)
wrapper.java.library.path.1=lib
# Java Additional Parameters
#wrapper.java.additional.1=
wrapper.java.additional.1=-DMYCAT_HOME=.
wrapper.java.additional.2=-server
wrapper.java.additional.3=-XX:MaxPermSize=64M
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论