没有合适的资源?快使用搜索试试~ 我知道了~
首页MySQL数据库集群+负载均衡(LVS)
资源详情
资源评论
资源推荐
MySQL 负载均衡群集(LVS)
liyingke112@126.com 学习资料,请勿商用!
MySQL 负载均衡群集(LVS)
目 录
一、概述 ......................................................................................................................................... 7
(一)、LVS ............................................................................................................................. 7
1、概述 .................................................................................................................................. 7
2、负载均衡器的三种模式 ................................................................................................. 8
(1)、 NAT ................................................................................................................... 8
(2)、 TUN .................................................................................................................. 9
(3)、 DR ..................................................................................................................... 9
3、负载均衡调度算法 ....................................................................................................... 10
(1)、 rr ...................................................................................................................... 10
(2)、 wrr .................................................................................................................. 10
(3)、 lc ...................................................................................................................... 11
(4)、 wlc .................................................................................................................. 11
(5)、 lblc .................................................................................................................. 11
(6)、 lblcr ................................................................................................................ 11
(7)、 dh .................................................................................................................... 12
(8)、 sh .................................................................................................................... 12
4、IPVS ............................................................................................................................... 12
(二)、Keepalived ............................................................................................................. 13
1、描述 ................................................................................................................................ 13
2、keepalived 体系结构 ................................................................................................ 14
(1)、WatchDog .................................................................................................. 15
(2)、Checkers ..................................................................................................... 15
(3)、VRRP Stack ................................................................................................ 15
(4)、IPVS wrapper ............................................................................................ 15
(5)、Netlink Reflector ..................................................................................... 15
(三)、MySQL Cluster ..................................................................................................... 15
1、概述 ................................................................................................................................ 15
(1)、优点 ................................................................................................................. 17
(2)、缺点: ............................................................................................................ 17
2、MySQL Cluster 基本概念 ........................................................................................ 17
(1)、 管理(MGM)节点 .......................................................................................... 18
(2)、数据节点 ...................................................................................................... 18
(3)、SQL 节点 ...................................................................................................... 18
3、注意事项 ........................................................................................................................ 19
(四)、测试环境说明 .......................................................................................................... 20
1、测试说明 ........................................................................................................................ 20
2、服务器分布 .................................................................................................................... 20
3、网络拓扑图 .................................................................................................................... 20
MySQL 负载均衡群集(LVS)
liyingke112@126.com 学习资料,请勿商用!
4、各个节点图 .................................................................................................................... 21
二、LVS ........................................................................................................................................ 22
(一)、LVS 核心-IPVS ....................................................................................................... 22
1、安装 IPVS ...................................................................................................................... 22
(1)、下载 ................................................................................................................. 22
(2)、创建一个连接文件 ........................................................................................ 22
(3)、解包 ................................................................................................................. 22
(4)、编译和安装 .................................................................................................... 23
3、检验安装是否正确 ....................................................................................................... 23
4、配置 ipbsadm 启动文件 ............................................................................................ 23
5、配置自动启动 ............................................................................................................... 26
(二)、LVS 客户端配置 ........................................................................................................... 26
1、配置脚本 ........................................................................................................................ 26
2、添加权限 ........................................................................................................................ 28
3、自动执行 ........................................................................................................................ 28
4、说明 ................................................................................................................................ 28
三、故障隔离、失败切换框架 keepalived ........................................................................... 29
(一)、安装 keepalived .................................................................................................... 29
1、下载 ................................................................................................................................ 29
2、解包 ................................................................................................................................ 29
3、切换目录 ........................................................................................................................ 29
4、编译和安装 .................................................................................................................... 29
(二)、调整为系统服务 ..................................................................................................... 30
(三)、配置文件 keepalived.conf .................................................................................. 30
1、配置说明 ........................................................................................................................ 30
(1)、全局定义块 .................................................................................................... 30
(2)、 VRRP 定义块 ................................................................................................. 30
2、配置文件 ........................................................................................................................ 33
四、MySQL Cluster .................................................................................................................. 36
(一)、mysql 集群安装 ..................................................................................................... 36
1、下载 ................................................................................................................................ 36
2、建立 mysql 账号 .......................................................................................................... 36
3、安装和配置管理节点 ................................................................................................... 36
(1)、安装 ................................................................................................................. 36
(2)、配置/usr/local/mysql/config.ini ............................................................ 37
(3)、启动 ndb_mgmd ............................................................................................ 38
(4)、加入系统启动文件 ........................................................................................... 38
4、安装和配置 192.168.4.15 .......................................................................................... 39
(1)、安装 ................................................................................................................. 39
MySQL 负载均衡群集(LVS)
liyingke112@126.com 学习资料,请勿商用!
(2)、配置/usr/local/mysql/my.cnf ................................................................. 39
(3)、启动 ndbd ..................................................................................................... 42
(4)、启动 mysql .................................................................................................... 43
(5)、加入系统启动文件中 ................................................................................... 43
5、安装和配置 192.168.4.16 .......................................................................................... 43
(1)、安装 ................................................................................................................. 43
(2)、启动 mysql .................................................................................................... 44
(3)、加入系统启动文件中 ................................................................................... 44
(4)、升级 ................................................................................................................. 44
6、其他命令 ........................................................................................................................ 44
7、注意事项 ........................................................................................................................ 45
(二)、维护 cluster ............................................................................................................ 46
1、初始化和安全关闭 ....................................................................................................... 46
2、备份恢复步骤 ............................................................................................................... 46
3、ndb_mgm 操作 ........................................................................................................... 47
(三)、简单测试 .................................................................................................................. 49
(四)、基本优化思路 .......................................................................................................... 49
(五)、NDB 优化思路 ........................................................................................................ 50
1、判断性能 ........................................................................................................................ 50
2、优化点 ............................................................................................................................ 51
(六)、小结 .......................................................................................................................... 52
(七)、集群采用磁盘存储表 ............................................................................................. 52
五、升级现有的数据库 .............................................................................................................. 55
(一)、mysql_convert_table_format ........................................................................... 55
1、安装 perl 组件 .............................................................................................................. 55
2、命令 ................................................................................................................................ 55
3、测试 ................................................................................................................................ 55
(二)、alter .......................................................................................................................... 56
1、命令 ................................................................................................................................ 56
2、注意 ................................................................................................................................ 56
3、分析 ................................................................................................................................ 56
4、替代命令 ........................................................................................................................ 57
(三)、导出数据 .................................................................................................................. 57
六、配置文档说明 ...................................................................................................................... 58
(一)、管理节点相关配置 ................................................................................................. 58
1、[NDB_MGMD DEFAULT]中管理节点共用配置项 ............................................... 58
(1)、 PortNumber ................................................................................................ 58
(2)、 LogDestination: ...................................................................................... 58
(3)、 Datadir .......................................................................................................... 59
MySQL 负载均衡群集(LVS)
liyingke112@126.com 学习资料,请勿商用!
(4)、 ArbitrationRank ......................................................................................... 59
2、[NDB_MGMD] ............................................................................................................ 59
(1)、 Id: ................................................................................................................. 60
(2)、 Hostname .................................................................................................... 60
(3)、 ExecuteOnComputer ................................................................................ 60
(4)、 ArbitrationDelay ........................................................................................ 60
(二)、NDB 节点相关配置 ............................................................................................... 60
1、[NDBD DEFAULT]中的配置项 ................................................................................. 61
(1)、 NoOfReplicas .............................................................................................. 61
(2)、 DataDir .......................................................................................................... 62
(3)、 DataMemory ............................................................................................... 62
(5)、 IndexMemory ............................................................................................. 64
(6)、 FileSystemPath ........................................................................................... 66
(7)、事务参数 ........................................................................................................ 66
MaxNoOfConcurrentTransactions ........................................................... 66
MaxNoOfConcurrentOperations .............................................................. 66
MaxNoOfLocalOperations .......................................................................... 67
MaxNoOfConcurrentIndexOperations ................................................... 67
MaxNoOfFiredTriggers ................................................................................ 68
TransactionBufferMemory .......................................................................... 68
MaxNoOfConcurrentScans ......................................................................... 68
MaxNoOfLocalScans ..................................................................................... 69
LongMessageBuffer ...................................................................................... 69
MaxNoOfConcurrentTransactions ........................................................... 69
MaxNoOfConcurrentOperations .............................................................. 70
MaxNoOfLocalOperations .......................................................................... 71
MaxNoOfConcurrentIndexOperations ................................................... 71
MaxNoOfFiredTriggers ................................................................................ 71
TransactionBufferMemory .......................................................................... 72
MaxNoOfConcurrentScans ......................................................................... 73
MaxNoOfLocalScans ..................................................................................... 73
BatchSizePerLocalScan ................................................................................ 73
LongMessageBuffer ...................................................................................... 73
(8)、日志和 Checkpointing .................................................................................. 74
NoOfFragmentLogFiles ............................................................................... 74
MaxNoOfSavedMessages ........................................................................... 74
MaxNoOfAttributes ...................................................................................... 75
MaxNoOfTables .............................................................................................. 75
MaxNoOfOrderedIndexes .......................................................................... 76
MaxNoOfUniqueHashIndexes .................................................................. 76
MaxNoOfTriggers .......................................................................................... 76
MaxNoOfIndexes ........................................................................................... 76
LockPagesInMainMemory .......................................................................... 77
StopOnError ..................................................................................................... 77
Diskless .............................................................................................................. 77
RestartOnErrorInsert .................................................................................... 78
TimeBetweenWatchDogCheck .................................................................. 78
StartPartialTimeout ....................................................................................... 78
StartPartitionedTimeout .............................................................................. 79
StartFailureTimeout ....................................................................................... 79
HeartbeatIntervalDbDb ............................................................................... 79
HeartbeatIntervalDbApi .............................................................................. 79
TimeBetweenLocalCheckpoints ................................................................ 80
TimeBetweenGlobalCheckpoints ............................................................. 80
TimeBetweenInactiveTransactionAbortCheck ..................................... 81
MySQL 负载均衡群集(LVS)
liyingke112@126.com 学习资料,请勿商用!
TransactionInactiveTimeout ....................................................................... 81
TransactionDeadlockDetectionTimeout ................................................ 81
NoOfDiskPagesToDiskAfterRestartTUP ................................................. 82
NoOfDiskPagesToDiskAfterRestartACC ................................................. 82
NoOfDiskPagesToDiskDuringRestartTUP .............................................. 83
NoOfDiskPagesToDiskDuringRestartACC ............................................. 83
ArbitrationTimeout ....................................................................................... 83
(9)、缓冲和日志功能 ............................................................................................... 83
UndoIndexBuffer............................................................................................ 84
UndoDataBuffer ............................................................................................. 84
RedoBuffer ....................................................................................................... 85
LogLevelStartup ............................................................................................. 85
LogLevelShutdown ........................................................................................ 86
LogLevelStatistic ............................................................................................ 86
LogLevelCheckpoint ..................................................................................... 86
LogLevelNodeRestart ................................................................................... 86
LogLevelConnection ..................................................................................... 86
LogLevelError .................................................................................................. 87
LogLevelInfo .................................................................................................... 87
(10)、备份参数 ......................................................................................................... 87
BackupDataBufferSize .................................................................................. 87
BackupLogBufferSize .................................................................................... 87
BackupMemory .............................................................................................. 88
BackupWriteSize ............................................................................................ 88
(三)、SQL 节点相关配置说明 ........................................................................................ 88
1、ArbitrationRank ......................................................................................................... 88
2、ArbitrationDelay ........................................................................................................ 89
3、BatchByteSize ............................................................................................................. 89
4、BatchSize ..................................................................................................................... 89
5、MaxScanBatchSize .................................................................................................... 89
七、MySQL 集群方案相关问题 ............................................................................................. 90
1、使用集群和复制的区别是什么? ................................................................................ 90
2、是否需要特定的网络结构才能使用集群呢?集群中的计算机是如何通信的? ... 90
3、集群中需要多少台计算机呢?为什么? ...................................................................... 90
4、需要多大的内存呢?能否完全使用磁盘呢? .............................................................. 91
5、配置集群的时候,正在加载的进程非正常中断了,并且报错信息如下,为什么会这
样? ......................................................................................................................................... 92
6、MySQL 集群使用 TCP/IP 协议,这是否可以跨越 Internet 网,把某些节点放在远
程,来使用集群呢? ............................................................................................................... 93
7、使用 MySQL 集群的时候,我怎么知道某些警告/错误信息是什么意思呢? ....... 93
8、MySQL 集群是事务安全的吗?它支持什么样的事务隔离级别? ......................... 94
9、What storage engines are supported by MySQL Cluster? ......................... 94
10、哪个 MySQL 版本才支持集群?是否需要从源代码中编译? .............................. 94
11、在发生灾难性事故时 - 比如说,所有的节点全部掉电,那么我是否会丢失所有的
数据呢? ................................................................................................................................. 95
12、集群中是否能用 FULLTEXT 索引? ....................................................................... 95
剩余137页未读,继续阅读
jerrymy6321
- 粉丝: 0
- 资源: 15
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 2022年中国足球球迷营销价值报告.pdf
- 房地产培训 -营销总每天在干嘛.pptx
- 黄色简约实用介绍_汇报PPT模板.pptx
- 嵌入式系统原理及应用:第三章 ARM编程简介_3.pdf
- 多媒体应用系统.pptx
- 黄灰配色简约设计精美大气商务汇报PPT模板.pptx
- 用matlab绘制差分方程Z变换-反变换-zplane-residuez-tf2zp-zp2tf-tf2sos-sos2tf-幅相频谱等等.docx
- 网络营销策略-网络营销团队的建立.docx
- 电子商务示范企业申请报告.doc
- 淡雅灰低面风背景完整框架创业商业计划书PPT模板.pptx
- 计算模型与算法技术:10-Iterative Improvement.ppt
- 计算模型与算法技术:9-Greedy Technique.ppt
- 计算模型与算法技术:6-Transform-and-Conquer.ppt
- 云服务安全风险分析研究.pdf
- 软件工程笔记(完整版).doc
- 电子商务网项目实例规划书.doc
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论3