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 如何配置)

         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基础知识、基本配置  ****可以看看

 三、mysql主从复制

_____________________________________________________________________________________________________________________________________________________________________

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实现高可用的分库分表集群方案

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

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基础知识、基本配置  ****可以看看

 三、mysql主从复制

原文地址:https://www.cnblogs.com/kelelipeng/p/13094786.html