概述
随着互联网的发展,数据的量级也是撑指数的增长,从GB到TB到PB。对数据的各种操作也是愈加的困难,传统的关系型数据库已经无法满足快速查询与插入数据的需求。这个时候NoSQL的出现暂时解决了这一危机。它通过降低数据的安全性,减少对事务的支持,减少对复杂查询的支持,来获取性能上的提升。但是,在有些场合NoSQL一些折衷是无法满足使用场景的,就比如有些使用场景是绝对要有事务与安全指标的。这个时候NoSQL肯定是无法满足的,所以还是需要使用关系型数据库。如何使用关系型数据库解决海量存储的问题呢?此时就需要做数据库集群,为了提高查询性能将一个数据库的数据分散到不同的数据库中存储,为应对此问题就出现了——MyCat。
下面介绍下基于mycat+haproxy+keepalived搭建高可用负载均衡mysql集群中的keepalived和最终测试部分。
![cb58cbe70d6b84b577cb50c4dd3bf749.png](https://img-blog.csdnimg.cn/img_convert/cb58cbe70d6b84b577cb50c4dd3bf749.png)
一、keepalived安装
1、安装依赖
yum install -y openssl-devel openssl libnl libnl-devel libnfnetlink-devel
![a38a9f2a56b6e5c503077bee3ce21bf8.png](https://img-blog.csdnimg.cn/img_convert/a38a9f2a56b6e5c503077bee3ce21bf8.png)
2、keepalived编译安装
wget http://www.keepalived.org/software/keepalived-2.0.5.tar.gztar -xvf keepalived-2.0.5.tar.gzcd keepalived-2.0.5./configure --prefix=/usr/local/keepalivedmake && make installcp /usr/local/keepalived/sbin/keepalived /usr/sbin/cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/cp ./keepalived/etc/init.d/keepalived /etc/init.d/mkdir /etc/keepalivedcd /etc/keepalived/cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalivedmkdir -p /usr/local/keepalived/var/log
![895d300b44280e5d9004bccda1cc2be4.png](https://img-blog.csdnimg.cn/img_convert/895d300b44280e5d9004bccda1cc2be4.png)