mycat读写分离
mycat 下载
-
下载地址
-
安装
cd /usr/local/src wget http://dl.mycat.org.cn/1.6-RELEASE/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz tar -zxvf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz mv mycat /usr/local/ cd /usr/local/mycat/
-
目录
bin:命令文件
catlet:空的,扩展
conf:配置文件(server.xml,schema.xml,rule.xml等)
lib:依赖的jar包 -
启动
cd bin
./mycat console
-
注意
要关闭防火墙 不然连接不上
-
配置
schema.xml
<?xml version="1.0"?> <!DOCTYPE mycat:schema SYSTEM "schema.dtd"> <mycat:schema xmlns:mycat="http://io.mycat/"> <!--配置数据表--> <schema name="itcast" checkSQLschema="false" sqlMaxLimit="100"> <table name="tb_ad" dataNode="dn1" rule="mod-long" /> </schema> <!--配置分片关系--> <dataNode name="dn1" dataHost="cluster1" database="itcast" /> <!--配置连接信息--> <dataHost name="cluster1" maxCon="1000" minCon="10" balance="3" writeType="1" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <heartbeat>select user()</heartbeat> <writeHost host="W1" url="192.168.1.99:3306" user="root" password="root"> <readHost host="W1R1" url="192.168.1.99:3307" user="root" password="root" /> </writeHost> </dataHost> </mycat:schema>
如果想所有表读写分离 不指定表 去掉table
<?xml version="1.0"?> <!DOCTYPE mycat:schema SYSTEM "schema.dtd"> <mycat:schema xmlns:mycat="http://io.mycat/"> <!--配置数据表--> <schema name="itcast" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"> </schema> <!--配置分片关系--> <dataNode name="dn1" dataHost="cluster1" database="itcast" /> <!--配置连接信息--> <dataHost name="cluster1" maxCon="1000" minCon="10" balance="3" writeType="1" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <heartbeat>select user()</heartbeat> <writeHost host="W1" url="192.168.1.99:3306" user="root" password="root"> <readHost host="W1R1" url="192.168.1.99:3307" user="root" password="root" /> </writeHost> </dataHost> </mycat:schema>
server.xml
<?xml version="1.0"?> ● firewalld.service - firewalld - dynamic firewall daemon <mycat:server xmlns:mycat="http://io.mycat/"> <system> <property name="nonePasswordLogin">0</property> <property name="useHandshakeV10">1</property> <property name="useSqlStat">0</property> <property name="useGlobleTableCheck">0</property> <property name="sequnceHandlerType">2</property> <property name="subqueryRelationshipCheck">false</property> <property name="processorBufferPoolType">0</property> <property name="handleDistributedTransactions">0</property> <property name="useOffHeapForMerge">1</property> <property name="memoryPageSize">64k</property> <property name="spillsFileBufferSize">1k</property> <property name="useStreamOutput">0</property> <property name="systemReserveMemorySize">384m</property> <property name="useZKSwitch">false</property> </system> <!--这里是设置的itcast用户和虚拟逻辑库--> <user name="itcast"> <property name="password">root</property> <property name="schemas">itcast</property> </user> </mycat:server>
文档资料
[Mycat学习笔记 第一篇. MySql 读写分离与日志分析——主从单结点](https://www.cnblogs.com/kaye0110/p/5134588.html)