Mycat_V1.6.0权威指南.pdf

需积分: 9 258 浏览量更新于2023-05-23 评论收藏 10.87MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

 
1 
 
目录 
入门篇 .............................................................................................................................................................................................. 12 
MYCAT 开源宣言 .............................................................................................................................................................................. 12 
第一章 概述...................................................................................................................................................................................... 15 
1.1
 
数据库切分概述
 ..................................................................................................................................................................... 15 
1.2
 
垂直切分
 ................................................................................................................................................................................. 18 
1.3
 
水平切分
 ................................................................................................................................................................................. 19 
第二章 MYCAT 前世今生 ................................................................................................................................................................. 22 
2.1
 
序章
 ......................................................................................................................................................................................... 22 
2.2
 
Mycat 闪耀登场
 .................................................................................................................................................................... 29 
2.3
 
Mycat 概述
............................................................................................................................................................................ 32 
第三章 MYCAT 中的概念 ................................................................................................................................................................. 36 
3.1
 
数据库中间件
 ......................................................................................................................................................................... 36 
3.2
 
逻辑库(schema)
 ................................................................................................................................................................... 36 
3.3
 
逻辑表（table）
 ................................................................................................................................................................... 37 
3.4
 
分片节点(dataNode)
 .......................................................................................................................................................... 38 
3.5
 
节点主机(dataHost)
............................................................................................................................................................ 38 
3.6
 
分片规则(rule)
 ...................................................................................................................................................................... 38 
3.7
 
全局序列号(sequence)
 ....................................................................................................................................................... 39 
3.8
 
多租户
 ..................................................................................................................................................................................... 39 
第四章快速入门............................................................................................................................................................................... 40 
4.1
 
10 分钟入门
 ........................................................................................................................................................................... 40 
4.2
 
快速镜像方式体验 MyCAT
.................................................................................................................................................. 42 
4.3
 
服务安装与配置
 ..................................................................................................................................................................... 42 
4.4
 
服务启动与启动设置
 ............................................................................................................................................................. 45 
4.5
 
基于 zk 的启动
....................................................................................................................................................................... 46 
4.6
 
demo 使用
 ............................................................................................................................................................................ 53 
第五章日志分析............................................................................................................................................................................... 54 

 
2 
 
5.1
 
warpper 日志：
 ................................................................................................................................................................... 55 
5.2
 
mycat 日志
 ............................................................................................................................................................................ 56 
5.3
 
debug 模式下分析 sql 执行。
............................................................................................................................................ 59 
5.4
 
异常日志
 ................................................................................................................................................................................. 63 
第六章 MYCAT 防火墙配置 ............................................................................................................................................................. 65 
第七章 MYCAT 的配置 ..................................................................................................................................................................... 70 
6.1
 
搞定 schema.xml
 ................................................................................................................................................................ 70 
6.2
 
schema 标签
 ......................................................................................................................................................................... 70 
6.3
 
table 标签
 .............................................................................................................................................................................. 73 
6.4
 
childTable 标签
 ................................................................................................................................................................... 75 
6.5
 
dataNode 标签
 .................................................................................................................................................................... 76 
6.6
 
dataHost 标签
...................................................................................................................................................................... 77 
6.7
 
heartbeat 标签
..................................................................................................................................................................... 79 
6.8
 
server.xml
 ............................................................................................................................................................................ 81 
6.9
 
system 标签
 .......................................................................................................................................................................... 82 
6.10
 
rule.xml
................................................................................................................................................................................. 95 
6.11
 
tableRule 标签
 ..................................................................................................................................................................... 95 
6.12
 
function 标签
 ....................................................................................................................................................................... 95 
第八章 MYCAT 的分片 JOIN ............................................................................................................................................................ 97 
7.1
 
join 概述
 ................................................................................................................................................................................ 97 
7.2
 
全局表
 ..................................................................................................................................................................................... 99 
7.3
 
ER Join
 ................................................................................................................................................................................ 100 
7.4
 
Share join
 ........................................................................................................................................................................... 101 
7.5
 
catlet（人工智能）
 ............................................................................................................................................................ 104 
7.6
 
Spark/Storm 对 join 扩展
 ............................................................................................................................................... 106 
第九章 全局序列号........................................................................................................................................................................ 107 
8.1
 
全局序列号介绍
 ................................................................................................................................................................... 107 
8.2
 
本地文件方式
 ....................................................................................................................................................................... 107 
8.3
 
数据库方式
 ........................................................................................................................................................................... 107 

 
3 
 
8.4
 
本地时间戳方式
 ................................................................................................................................................................... 110 
8.5
 
分布式 ZK ID 生成器
 .......................................................................................................................................................... 111 
8.6
 
Zk 递增方式
 ......................................................................................................................................................................... 111 
8.7
 
其他方式
 ............................................................................................................................................................................... 112 
8.8
 
自增长主键
 ........................................................................................................................................................................... 112 
第十章 MYCAT 分片规则 ................................................................................................................................................................. 115 
9.1
 
分片规则概述
 ....................................................................................................................................................................... 115 
9.2
 
Mycat 全局表
...................................................................................................................................................................... 115 
9.3
 
ER 分片表
 ............................................................................................................................................................................. 115 
9.4
 
多对多关联
 ........................................................................................................................................................................... 116 
9.5
 
Mycat 常用的分片规则
 ...................................................................................................................................................... 117 
9.6
 
权限控制
 ............................................................................................................................................................................... 129 
9.7
 
多租户支持
 ........................................................................................................................................................................... 130 
第十一章 常见问题与解决方案 .................................................................................................................................................... 130 
10.1
 
Mycat 目前有哪些功能与特性？
 ...................................................................................................................................... 130 
10.2
 
Mycat 除了 Mysql 还支持哪些数据库？
 ........................................................................................................................ 131 
10.3
 
Mycat 目前有生产案例了么？
 .......................................................................................................................................... 131 
10.4
 
Mycat 稳定性与 Cobar 如何？
 ........................................................................................................................................ 131 
10.5
 
Mycat 支持集群么？
 .......................................................................................................................................................... 131 
10.6
 
Mycat 多主切换需要人工处理么？
 .................................................................................................................................. 132 
10.7
 
Mycat 目前有多少人开发？
 .............................................................................................................................................. 132 
10.8
 
Mycat 目前有哪些项目？
 .................................................................................................................................................. 132 
10.9
 
Mycat 最新的稳定版本是哪个到哪里下载？
 .................................................................................................................. 132 
10.10
 .................................................................................................................................................................................. 
Mycat 如何配置字符集?
 ............................................................................................................................................................................................... 132 
10.11
 .................................................................................................................................................................. 
Mycat 后台管理监控如何使用？
 ............................................................................................................................................................................................... 132 
10.12
 ............................................................................................................................................................. 
Mycat 主键插入后应用如何获取？
 ............................................................................................................................................................................................... 133 

 
4 
 
10.13
 ...................................................................................................................................................................... 
Mycat 如何启动与加入服务？
 ............................................................................................................................................................................................... 133 
10.14
 ..................................................................................................................................
Mycat 运行 sql 时经常阻塞或卡死是什么原因？
 ............................................................................................................................................................................................... 133 
10.15
 ................................................................................................................................... 
Mycat 中，旧系统数据如何迁移到 Mycat 中？
 ............................................................................................................................................................................................... 133 
10.16
 ............................................................................................................... 
Mycat 如何对旧分片数据迁移或扩容，支持自动扩容么？
 ............................................................................................................................................................................................... 133 
10.17
 ................................................................................................................................................................................
Mycat 支持批量插入吗？
 ............................................................................................................................................................................................... 133 
10.18
 ............................................................................................................................................................................. 
Mycat 支持多表 Join 吗？
 ............................................................................................................................................................................................... 134 
10.19
 ............................................................................................................................................................... 
Mycat 启动报主机不存在的问题?
 ............................................................................................................................................................................................... 134 
10.20
 .................................................................................................................. 
Mycat 连接会报无效数据源（Invalid datasource）？
 ............................................................................................................................................................................................... 134 
10.21
 ............................................................................................................................................................ 
Mycat 使用中如何提需求或 bug？
 ............................................................................................................................................................................................... 134 
10.22
 ............................................................................................................................................................. 
Mycat 如何建表与创建存储过程？
 ............................................................................................................................................................................................... 134 
10.23
 ........................................................................................................................................................................... 
Mycat 目前有多少人维护？
 ............................................................................................................................................................................................... 134 
10.24
 ............................................................................................................................................... 
Mycat 支持的或者不支持的语句有哪些？
 ............................................................................................................................................................................................... 135 
10.25
 ........................................................................................................................ 
MycatJDBC 连接报 PacketTooBigException 异常
 ............................................................................................................................................................................................... 135 
10.26
 .................................................................................................................................................................................... 
Mycat 中文乱码的问题
 ............................................................................................................................................................................................... 135 
10.27
 ................................................................................................................................................................ 
Mycat 无法登陆 Access denied
 ............................................................................................................................................................................................... 135 
10.28
 .................................................................................................... 
Mycat 的分片数据插入报异常 IndexOutofBoundException
 ............................................................................................................................................................................................... 136 
10.29
 ............................................................................................................................................................... 
Mycat ER 分片子表数据插入报错
 ............................................................................................................................................................................................... 136 