包邮分布式数据库架构及企业实践-基于Mycat中间件

第 1 章 数据库中间件与分布式数据库的实现..............................................................1
1.1 什么是分布式系统.......................................................................................................1
1.2 为什么需要分布式数据库...........................................................................................2
1.3 分布式数据库的实现原理 ........................................................................................ 3
1.4 Mycat 数据库中间件简介 ......................................................................................... 5
1.4.1 Mycat 的历史与未来规划 ...................................................................................... 5
1.4.2 Mycat 与其他中间件的区别 .................................................................................. 8
1.4.3 Mycat 的优势 ..........................................................................................................10
1.4.4 Mycat 的适用场合 ..................................................................................................11
第 2 章 Mycat 入门……………………………………………………………………………………………………..13
2.1 环境搭建 ....................................................................................................................13
2.1.1 Windows 环境搭建 ..................................................................................................13
2.1.2 Linux 环境搭建 ........................................................................................................ 15
2.2 Mycat 核心概念详解 .................................................................................................. 16
2.2.1 逻辑库（schema） ................................................................................................. 16
2.2.2 逻辑表（table） ..................................................................................................... 16
2.2.3 分片节点（dataNode） ......................................................................................... 17
2.2.4 节点主机（dataHost） ........................................................................................... 17
2.3 Mycat 原理介绍 .......................................................................................................... 18
2.4 参与 Mycat 源码开发 ............................................................................................... 19
2.4.1 Mycat 源码环境搭建 ............................................................................................... 19
2.4.2 Mycat 源码调试 ....................................................................................................... 19
第 3 章 Mycat 进阶 ……………………………………………………………………………………………………..22
3.1 Mycat 配置详解 ...........................................................................................................22
3.1.1 Mycat 支持的两种配置方式 ....................................................................................22
3.1.2 server.xml 配置文件 ................................................................................................. 23
3.1.3 schema.xml 配置文件 ............................................................................................... 28
3.1.4 sequence 配置文件 ...................................................................................................37
3.1.5 zk-create.yaml 配置文件 ........................................................................................... 41
3.1.6 其他配置文件 ........................................................................................................... 44
3.2 Mycat 分片规则详解 ................................................................................................... 46
3.2.1 分片表与非分片表 .................................................................................................... 46
3.2.2 ER 关系分片表 ........................................................................................................... 46
3.2.3 分片规则 rule.xml 文件详解 ................................................................................... 46
3.2.4 取模分片 .................................................................................................................... 47
3.2.5 枚举分片 .....................................................................................................................48
3.2.6 范围分片 .................................................................................................................... 49
3.2.7 范围求模算法 .............................................................................................................49
3.2.8 固定分片 hash 算法 ................................................................................................. 50
3.2.9 取模范围算法 ............................................................................................................. 52
3.2.10 字符串 hash 求模范围算法 ................................................................................... 53
3.2.11 应用指定的算法 ....................................................................................................... 54
3.2.12 字符串 hash 解析算法 ............................................................................................ 54
3.2.13 一致性 hash 算法 .................................................................................................... 55
3.2.14 按日期（天）分片算法 ............................................................................................ 56
3.2.15 按单月小时算法 ........................................................................................................ 57
3.2.16 自然月分片算法 ........................................................................................................ 58
3.2.17 日期范围 hash 算法 ................................................................................................ 58
3.3 Mycat 管理命令详解 ...................................................................................................... 59
3.3.1 Reload 命令 .................................................................................................................. 61
3.3.2 Show 命令 .................................................................................................................... 62
第 4 章 Mycat 高级技术实战………………………………………………………………………………………….. 68
4.1 用 Mycat 搭建读写分离 ............................................................................................... 68
4.1.1 MySQL 读写分离 .......................................................................................................... 69
4.1.2 MySQL Galera Cluster 读写分离 .................................................................................. 73
4.1.3 SQL Server 读写分离 ................................................................................................... 83
4.2 Mycat 故障切换 ............................................................................................................. 86
4.2.1 Mycat 主从切换 ...........................................................................................................86
4.2.2 MySQL Galera 节点切换 .............................................................................................. 99
4.3 Mycat Percona HAProxy Keepalived .............................................................................. 113
4.3.1 Mycat ............................................................................................................................. 113
4.3.2 Percona 集群 ....................................................................................................... ……..124
4.3.3 HAProxy ...........................................