mycat权威手册，学习和查找资料必备助手资源-CSDN文库

共1个文件

pdf：1个

mycat

mysql扩展

数据库扩展

需积分: 5 37 浏览量 2023-01-10 11:27:34 上传评论收藏 9.38MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

mycat-权威手册.zip （1个子文件）

mycat-definitive-guide.pdf 11.98MB

入门篇

.................................................................................................................................................................................................

MYCAT 开源宣言

................................................................................................................................................................................

第 1 章概述

.......................................................................................................................................................................................

1.1 数据库切分概述

..........................................................................................................................................................................

1.2 垂直切分

......................................................................................................................................................................................

1.3 水平切分

......................................................................................................................................................................................

第 2 章 MYCAT 前世今生

...................................................................................................................................................................

2.1 序章

..............................................................................................................................................................................................

2.2 Mycat 闪耀登场

.........................................................................................................................................................................

2.3 Mycat 概述

.................................................................................................................................................................................

第 3 章 MYCAT 中的概念

...................................................................................................................................................................

3.1 数据库中间件

..............................................................................................................................................................................

3.2 逻辑库(schema)

.........................................................................................................................................................................

3.3 逻辑表（table）

........................................................................................................................................................................

3.4 分片节点(dataNode)

................................................................................................................................................................

3.5 节点主机(dataHost)

..................................................................................................................................................................

3.6 分片规则(rule)

............................................................................................................................................................................

3.7 全局序列号(sequence)

.............................................................................................................................................................

3.8 多租户

..........................................................................................................................................................................................

第 4 章快速入门

.................................................................................................................................................................................

4.1 10 分钟入门

................................................................................................................................................................................

4.2 快速镜像方式体验 MyCAT

.......................................................................................................................................................

4.3 服务安装与配置

..........................................................................................................................................................................

4.4 服务启动与启动设置

..................................................................................................................................................................

4.5 基于 zk 的启动

............................................................................................................................................................................

4.6 demo 使用

..................................................................................................................................................................................

第 5 章日志分析

.................................................................................................................................................................................

5.1 warpper 日志：

.........................................................................................................................................................................

5.2 mycat 日志

.................................................................................................................................................................................

5.3 debug 模式下分析 sql 执行。

.................................................................................................................................................

5.4 异常日志

......................................................................................................................................................................................

第 6 章 MYCAT 防火墙配置

...............................................................................................................................................................

第 7 章 MYCAT 的配置

.......................................................................................................................................................................

7.1 搞定 schema.xml

.......................................................................................................................................................................

7.2 schema 标签

..............................................................................................................................................................................

7.3 table 标签

...................................................................................................................................................................................

7.4 childTable 标签

.........................................................................................................................................................................

7.5 dataNode 标签

..........................................................................................................................................................................

7.6 dataHost 标签

............................................................................................................................................................................

7.7 heartbeat 标签

...........................................................................................................................................................................

7.8 server.xml

...................................................................................................................................................................................

7.9 system 标签

................................................................................................................................................................................

7.10 rule.xml

....................................................................................................................................................................................

7.11 tableRule 标签

.........................................................................................................................................................................

7.12 function 标签

...........................................................................................................................................................................

第 8 章 MYCAT 的分片 JOIN

..............................................................................................................................................................

8.1 join 概述

......................................................................................................................................................................................

8.2 全局表

..........................................................................................................................................................................................

8.3 ER Join

........................................................................................................................................................................................

8.4 Share join

.................................................................................................................................................................................

100

8.5 catlet（人工智能）

.................................................................................................................................................................

103

8.6 Spark/Storm 对 join 扩展

......................................................................................................................................................

105

8.7 两个表标准 JOIN 的支持

...........................................................................................................................................................

105

第 9 章全局序列号

.........................................................................................................................................................................

109

9.1 全局序列号介绍

........................................................................................................................................................................

109

9.2 本地文件方式

............................................................................................................................................................................

110

9.3 数据库方式

................................................................................................................................................................................

110

9.4 本地时间戳方式

........................................................................................................................................................................

113

9.5 分布式 ZK ID 生成器

................................................................................................................................................................

114

9.6 Zk 递增方式

..............................................................................................................................................................................

114

9.7 其他方式

....................................................................................................................................................................................

115

9.8 自增长主键

................................................................................................................................................................................

115

第 10 章 MYCAT 分片规则

..............................................................................................................................................................

118

10.1 分片规则概述

..........................................................................................................................................................................

118

10.2 Mycat 全局表

.........................................................................................................................................................................

118

10.3 ER 分片表

................................................................................................................................................................................

118

10.4 多对多关联

..............................................................................................................................................................................

119

10.5 Mycat 常用的分片规则

.........................................................................................................................................................

120

10.6 权限控制

..................................................................................................................................................................................

136

10.7 多租户支持

..............................................................................................................................................................................

136

第 11 章常见问题与解决方案

.......................................................................................................................................................

137

11.1 Mycat 目前有哪些功能与特性？

.........................................................................................................................................

137

11.2 Mycat 除了 Mysql 还支持哪些数据库？

...........................................................................................................................

138

11.3 Mycat 目前有生产案例了么？

.............................................................................................................................................

138

11.4 Mycat 稳定性与 Cobar 如何？

...........................................................................................................................................

138

11.5 Mycat 支持集群么？

.............................................................................................................................................................

138

11.6 Mycat 多主切换需要人工处理么？

.....................................................................................................................................

138

11.7 Mycat 目前有多少人开发？

.................................................................................................................................................

138

11.8 Mycat 目前有哪些项目？

.....................................................................................................................................................

138

11.9 Mycat 最新的稳定版本是哪个到哪里下载？

.....................................................................................................................

139

11.10 Mycat 如何配置字符集?

.....................................................................................................................................................

139

11.11 Mycat 后台管理监控如何使用？

.......................................................................................................................................

139

11.12 Mycat 主键插入后应用如何获取？

...................................................................................................................................

139

11.13 Mycat 如何启动与加入服务？

...........................................................................................................................................

139

11.14 Mycat 运行 sql 时经常阻塞或卡死是什么原因？

...........................................................................................................

140

11.15 Mycat 中，旧系统数据如何迁移到 Mycat 中？

.............................................................................................................

140

11.16 Mycat 如何对旧分片数据迁移或扩容，支持自动扩容么？

...........................................................................................

140

11.17 Mycat 支持批量插入吗？

...................................................................................................................................................

140

11.18 Mycat 支持多表 Join 吗？

.................................................................................................................................................

140

11.19 Mycat 启动报主机不存在的问题?

....................................................................................................................................

140

11.20 Mycat 连接会报无效数据源（Invalid datasource）？

................................................................................................

140

11.21 Mycat 使用中如何提需求或 bug？

..................................................................................................................................

141

11.22 Mycat 如何建表与创建存储过程？

...................................................................................................................................

141

11.23 Mycat 目前有多少人维护？

...............................................................................................................................................

141

11.24 Mycat 支持的或者不支持的语句有哪些？

.......................................................................................................................

141

11.25 MycatJDBC 连接报 PacketTooBigException 异常

......................................................................................................

141

11.26 Mycat 中文乱码的问题

.......................................................................................................................................................

142

11.27 Mycat 无法登陆 Access denied

......................................................................................................................................

142

11.28 Mycat 的分片数据插入报异常 IndexOutofBoundException

.....................................................................................

143

11.29 Mycat ER 分片子表数据插入报错

.....................................................................................................................................

143

11.30 Mycat 最大内存无法调整至 4G 以上

...............................................................................................................................

143

11.31 Mycat 使用过程中报错怎么办

...........................................................................................................................................

143

第 12 章 MYCAT 性能测试指南

......................................................................................................................................................

143

高级进阶篇

.......................................................................................................................................................................................

149

第

章读写分离

...............................................................................................................................................................................

149

1.1 MySQL 主从复制的几种方案

.................................................................................................................................................

149

1.2 MySQL 主从复制的几个问题

.................................................................................................................................................

152

1.3 Mycat 支持的读写分离

...........................................................................................................................................................

154

第 2 章高可用与集群

.....................................................................................................................................................................

157

2.1 MySQL 高可用的几种方案

.....................................................................................................................................................

157

首先我们看看 MySQL 高可用的几种方案：

...............................................................................................................................

157

2.2 Mycat 高可用方案

...................................................................................................................................................................

161

2.3 Galary Cluster 配置

................................................................................................................................................................

164

第 3 章事务支持

.............................................................................................................................................................................

165

3.1 Mycat 里的数据库事务

...........................................................................................................................................................

165

3.2 XA 事务原理

..............................................................................................................................................................................

165

3.3 XA 事务的问题和 MySQL 的局限

..........................................................................................................................................

168

3.4 XA 事务使用指南

......................................................................................................................................................................

169

3.5 保证 repeatable read

.............................................................................................................................................................

170

第 4 章 MYCAT SQL 拦截机制

.......................................................................................................................................................

171

第 5 章 MYCAT 注解

........................................................................................................................................................................

173

5.1 注解原理

....................................................................................................................................................................................

173

5.2 注解使用示例

............................................................................................................................................................................

175

第 6 章 MYCAT 支持的 CATLET 实现

.............................................................................................................................................

178

第 7 章 JDBC 多数据库支持

.............................................................................................................................................................

178

7.1 JDBC 概述

.................................................................................................................................................................................

178

7.2 JDBC 体系结构

.........................................................................................................................................................................

179

7.3 JDBC API

...................................................................................................................................................................................

180

7.4 JDBC 4.0

...................................................................................................................................................................................

181

7.5 Mycat 对 JDBC 的支持

...........................................................................................................................................................

182

7.6 NoSQL 支持(MongoDB)

.......................................................................................................................................................

182

7.7 MongoDB

................................................................................................................................................................................

183

7.7.1 配置支持 Mongodb

.............................................................................................................................................................

184

7.8 Oracle

........................................................................................................................................................................................

191

7.8.1 配置支持 Oracle

...................................................................................................................................................................

191

7.8.2 三层嵌套分页

.........................................................................................................................................................................

192

7.8.3 rownum 控制最大条数

........................................................................................................................................................

193

7.9 SQL Server

...............................................................................................................................................................................

193

7.9.1 配置支持 SQL Server

...........................................................................................................................................................

193

7.9.2 row_number 分页

................................................................................................................................................................

194

7.9.3 row_number 与 top 结合分页

...........................................................................................................................................

194

7.9.4 top 限制最大条数

.................................................................................................................................................................

194

7.10 DB2

..........................................................................................................................................................................................

194