Mycat学习实战-Mycat的 haproxy zookeeper集群模式 ----------------- zookeeper
HAProxy+Keepalived+ZK+Mycat高可用集群方案
1. 关于MyCat的分库分表部分这里就不说了主要讲(HAProxy+Keepalived+ZK的处理).
1.1 A MyCat配置说明
学会数据库读写分离、分表分库——用Mycat,这一篇就够了!
https://blog.csdn.net/pingdouble/article/details/79412004
Mycat实现MySQL的分库分表、读写分离、主从复制
https://blog.csdn.net/u011418530/article/details/88283945
mysql复制--主从复制配置
https://blog.csdn.net/daicooper/article/details/79905660
1.2 MyCat如何使用全局序列号
MyCAT全局序列号
https://www.cnblogs.com/ivictor/p/5235147.html
Mycat之数据库主键自增长(数据库增长的方式)-yellowcong
https://blog.csdn.net/yelllowcong/article/details/79073608
2. Mycat 的zookeeper集群模式
2.1 A Mycat的zookeeper集群
Mycat学习实战-Mycat的zookeeper集群模式
https://blog.csdn.net/ygqygq2/article/details/78292828
zookeeper 组件下载
https://mirrors.tuna.tsinghua.edu.cn/apache/zookeeper/zookeeper-3.4.14/
zookeeper 图形化客户端——ZooInspector组件下载
https://issues.apache.org/jira/secure/attachment/12436620/ZooInspector.zip
2.2 zookeeper集群及mycat配置搭建
https://blog.csdn.net/zefuzhang/article/details/78349636
参考:Zookeeper介绍 ***A
https://www.cnblogs.com/leeSmall/p/9563547.html
参考:使用zookeeper管理远程Mycat配置文件& MyCat监控
https://www.cnblogs.com/leeSmall/p/9551038.html
3. 搭建Mycat+Zookeeper+HAProxy+Keepalived+MySQL高可用架构
1. Mycat之——搭建Mycat+Zookeeper+HAProxy+Keepalived+MySQL高可用架构
https://blog.csdn.net/l1028386804/article/details/104889149/
2. Mycat+Mysql主从复制+haproxy+keepalived实现高可用的分库分表集群方案
https://blog.csdn.net/jhsfja/article/details/80586731?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase
参考内容:
****************************************************************
1 Mycat之——Mycat集群部署(基于HAProxy + Mycat)
https://blog.csdn.net/l1028386804/article/details/75331934
2 Mycat之——高可用负载均衡集群的实现(HAProxy + Keepalived + Mycat)
https://blog.csdn.net/l1028386804/article/details/76397064 (*****Keepalived 如何配置,***Keepalived无需配置虚拟IP其会自动切换****)
3 Mycat之——搭建Mycat+Zookeeper+HAProxy+Keepalived+MySQL高可用架构
https://blog.csdn.net/l1028386804/article/details/104889149/
****************************************************************
Linux下Keepalived安装与配置
https://blog.csdn.net/bbwangj/article/details/80346428
4. 碰到的问题:
A .Linux下安装glibc-2.14,解决“`GLIBC_2.14' not found”问题
https://blog.csdn.net/dream_gf/article/details/81181388
解决'GLIBC_2.14' not found问题时遇到的坑 ***
https://blog.csdn.net/clirus/article/details/62425498
升级glibc到glibc-2.14 解决version `GLIBC_2.14' not found 问题
https://blog.csdn.net/qq_34605594/article/details/73610126?utm_medium=distribute.pc_relevant_right.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase&depth_1-utm_source=distribute.pc_relevant_right.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase
B. SELS 11 SP3负载均衡_LVS+keepalived (无法启动 keepalived)
https://wenku.baidu.com/view/abc14d07ec3a87c24128c44b.html
二、mycat基础知识、基本配置 ****可以看看
_____________________________________________________________________________________________________________________________________________________________________
1 Mycat学习实战-Mycat的zookeeper集群模式 ***B
https://blog.csdn.net/ygqygq2/article/details/78292828
zookeeper
https://mirrors.tuna.tsinghua.edu.cn/apache/zookeeper/zookeeper-3.4.14/
zookeeper图形化客户端——ZooInspector
https://issues.apache.org/jira/secure/attachment/12436620/ZooInspector.zip
1.2
zookeeper集群及mycat配置搭建
https://blog.csdn.net/zefuzhang/article/details/78349636
参考:
Zookeeper介绍 ***A
https://www.cnblogs.com/leeSmall/p/9563547.html
使用zookeeper管理远程Mycat配置文件
https://www.cnblogs.com/leeSmall/p/9551038.html
2 Mycat之——搭建Mycat+Zookeeper+HAProxy+Keepalived+MySQL高可用架构 ***
https://blog.csdn.net/l1028386804/article/details/104889149/
2.2 Mycat+Mysql主从复制+haproxy+keepalived实现高可用的分库分表集群方案
****************************************************************
1 Mycat之——Mycat集群部署(基于HAProxy + Mycat)
https://blog.csdn.net/l1028386804/article/details/75331934
2 Mycat之——高可用负载均衡集群的实现(HAProxy + Keepalived + Mycat)
https://blog.csdn.net/l1028386804/article/details/76397064
3 Mycat之——搭建Mycat+Zookeeper+HAProxy+Keepalived+MySQL高可用架构
https://blog.csdn.net/l1028386804/article/details/104889149/
****************************************************************
Linux下Keepalived安装与配置
https://blog.csdn.net/bbwangj/article/details/80346428
碰到的问题:
A .Linux下安装glibc-2.14,解决“`GLIBC_2.14' not found”问题
https://blog.csdn.net/dream_gf/article/details/81181388
解决'GLIBC_2.14' not found问题时遇到的坑 ***
https://blog.csdn.net/clirus/article/details/62425498
升级glibc到glibc-2.14 解决version `GLIBC_2.14' not found 问题
https://blog.csdn.net/qq_34605594/article/details/73610126?utm_medium=distribute.pc_relevant_right.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase&depth_1-utm_source=distribute.pc_relevant_right.none-task-blog-BlogCommendFromMachineLearnPai2-4.nonecase
B. SELS 11 SP3负载均衡_LVS+keepalived (无法启动 keepalived)
https://wenku.baidu.com/view/abc14d07ec3a87c24128c44b.html
二、mycat基础知识、基本配置 ****可以看看
___________________________________________________________________________________________________________________
linux, configure --prefix=/”的作用是:编译bai的时候用来指du定程序zhi存放路径 。
1、不指定prefix,可执行dao文件默版认放在/usr /local/bin,库文件默认放在/usr/local/lib,配置权文件默认放在/usr/local/etc。其它的资源文件放在/usr /local/share。
2、指定prefix,直接删掉一个文件夹就够了。
扩展资料:
Configure是一个可执行脚本,它有很多选项,在待安装的源码路径下使用命令./configure–help输出详细的选项列表。
其中,prefix选项是配置安装的路径,如果不配置该选项,安装后可执行文件默认放在/usr/local/bin,库文件默认放在/usr/local/lib,配置文件默认放在/usr/local/etc,其它的资源文件放在/usr/local/share,比较凌乱。
如果配置prefix,如:
./configure --prefix=/usr/local/test可以把所有资源文件放在/usr/local/test的路径中,不会杂乱。
https://blog.csdn.net/dream_gf/article/details/81181388