MyCat分库分表

1. 装备 3 台机器

2.1 台上安装 JDK 另外 2 台上安装 MySQL

3. 安装 JDK 机器上上传 MyCat

下载地址： http://www.mycat.org.cn/

解压 tar -zxf Mycat-server-1.6.7.4-test-20191022170541-linux.tar.gz

修改 server.xml\schema.xml\rule.xml 配置文件

<!-- 修改 mycat/conf/server.xml-->

<property name = "useZKSwitch" > true </property> <!-- 此处要注释调保留 false-->

<user name = "root" defaultAccount = "true" > <!-- 逻辑数据库用户 -->

<property name = "password" > ok </property> <!-- 逻辑数据库密码 -->

<property name = "schemas" > TESTDB </property> <!-- 逻辑数据库名 -->

</user>

<!-- 另外 1 个 user 可以注释掉 -->

 

 

 

 

<!--修改mycat/conf/schema.xml-->

<mycat:schema xmlns:mycat = "http://io.mycat/" >

<schema name = "TESTDB" checkSQLschema = "true" sqlMaxLimit = "100" > <!-- 这里的

name 要和 server.xml 文件中逻辑数据库名一致 -->

<!-- 这里有一张表就配置一个 table-->

<!-- 这里的 rule 是 rule.xml 中的 tableRule 名字根据需要配置 -->

<table name = "userinfos" dataNode = "mc01,mc02" rule = "mod-long"

/>

</schema>

<!-- 这里 dataHost 是下面两个 dataHost 的名字 database 是真实 Mysql 数据库中的数据

库名 -->

<dataNode name = "mc01" dataHost = "mc01" database = "db1" />

<dataNode name = "mc02" dataHost = "mc02" database = "db2" />

<dataHost name = "mc01" maxCon = "1000" minCon = "10" balance = "0"

writeType = "0" dbType = "mysql" dbDriver = "native" switchType = "1"

slaveThreshold = "100" >

<heartbeat> select user() </heartbeat>

<writeHost host = "hostM1" url = "192.168.126.130:3306"

user = "root" password = "ok" ></writeHost>

</dataHost>

<dataHost name = "mc02" maxCon = "1000" minCon = "10" balance = "0"

writeType = "0" dbType = "mysql" dbDriver = "native" switchType = "1"

slaveThreshold = "100" >

<heartbeat> select user() </heartbeat>

<writeHost host = "hostM1" url = "192.168.126.131:3306"

user = "root" password = "ok" ></writeHost>

</dataHost>

 

 

</mycat:schema><!--修改mycat/conf/rule.xml-->

<tableRule name = "mod-long" >

<rule>

<columns> userid </columns> <!-- 这里是按表中某列进行分割数据 -->

<algorithm> mod-long </algorithm>

</rule>

</tableRule>

<function name = "mod-long" class = "io.mycat.route.function.PartitionByMod" >

<!-- 根据 mysql 节点的数量配置 count -->

<property name = "count" > 2 </property>

</function>

 

 

 

 

最后启动 mycat

mycat/bin/mycat console( 如果不看启动情况可以使用 mycat/bin/mycat start )