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

 三、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主从复制

 

 

___________________________________________________________________________________________________________________

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

 

posted @ 2020-06-11 17:47  kelelipeng  阅读(532)  评论(0编辑  收藏  举报