环境说明:
,,,本系统对数据安全性不高,TPS操作很低,主要是查询的环境。本方案架构图如下:,,,应用服务器对只读的应用程序连接虚拟IP地址,连接到haproxy,然后通过haproxy将TCP协议转移到下面的三个数据库服务器中.Haproxy在此做4层的TCP交换服务.keepalived为了防止haproxy单点故障又是;,,,为什么不用lv ?,,我们的环境服务器少,haproxy和lv相比性能差不多,且haproxy自带有mysql检查,不需要额外的写mysql侦测脚本。
![haproxy + keepalive + mysql实现读均衡负载“> <br> <h3> </h3>下载地址:http://www.haproxy.org/download/1.5/src/haproxy-1.5.5.tar.gz <br>依赖包安装:# yum安装gcc gcc-c + +使zlib-devel bzip2-devel openssl-devel <br> <br>安装pcre,自带的pcre 3.1.el6——7.8。x86_64貌似版本低了,导致无法安装代理<br> <br> # cd pcre - 8.34 #。/configure——prefix=/usr \——docdir=/usr/share/doc/pcre - 8.34 \——enable-utf enable-unicode-properties \——enable-pcregrep-libz enable-pcregrep-libbz2 #让#让检查# make install <br> <p>/etc/keepalive/check_haproxy脚本”。sh”间隔2重量2 <br> <br> global_defs {router_id LVS_DEVEL} <br> vrrp_instance VI_1{国家MASTER 界面bond0virtual_router_id 51优先级150,advert_int 1认证{auth_type PASSauth_pass 1111},track_script {chk_http_port},virtual_ipaddress {192.168.231.18 }}} <br>配置侦测haproxy状态脚本:# vi/etc/keepalived/check_haproxy.sh # !haproxy/bin/bashA=' ps - c——没有标题| wc - l伊夫堡[$ eq 0]; then /usr/local/sbin/haproxy - f/etc/haproxy/haproxy.confsleep 3 <br>如果[' ps - c haproxy——没有标题| wc - l的eq 0]; then /etc/init.d/keepalive stopfifi <br>启动keepalive服务:#/etc/init.d/keepalive开始<br> <br>添加新的协议地址:# ip添加(root@mss-dn03 ~) # ip add1:瞧:& lt;环回,,LOWER_UP>mtu 16436 qdisc UNKNOWN noqueue状态;,,链接/回环00:00:00:00:00:00 brd 00:00:00:00:00:00 ,inet 127.0.0.1/8主机lo 范围;,inet6: 1/128 host 范围,,,永远,valid_lft preferred_lft forever2: eth0: & lt;没有载波讯号,广播、多播,UP>mtu 1500 qdisc mq状态qlen 1000,,链接/醚90:e2: ba: 23:87:04 brd ff: ff: ff: ff: ff: ff3: eth2: & lt;没有载波讯号,广播、多播,UP>mtu 1500 qdisc mq状态qlen 1000,,链接/醚90:e2: ba: 23:87:05 brd ff: ff: ff: ff: ff: ff <br> 9: bond0: & lt;广播、多播,主人,,LOWER_UP>mtu 1500 qdisc UP noqueue状态;,,链接/醚6 c: ae: 8 b: 26:52:3b brd ff: ff: ff: ff: ff: ff ,全球bond0 inet 192.168.231.7/24 brd 192.168.231.255范围;,inet6 fe80::: 6实验性自身免疫性脑脊髓炎8 bff: fe26:523b/64链接暂时dadfailed 范围,,,永远永远,valid_lft preferred_lft <br>设置开启自启动:# chkconfig,——级别0123456 keepalive # chkconfig列表keepalive <br> <br>测试过程中发现,主人宕机后,贵宾需要几十秒才能ping通,切换很慢:arp - bond0 5 - c - s VIP网关#,<br> <br> <br>开始使用HAProxy和MySQL复制(能实现读写路由):<br> http://blog.yannickjaquier.com/linux/getting-started-with-haproxy-and-mysql-replication.html HAProxy配置日志:,,http://www.linuxidc.com/Linux/2012-06/63585.htm <br/> <br/>来自为知笔记(奇才)<br/> <br/><h2 class=](/zixun/d/file/jishu/2021-06-01/cada7a864f0760f81e77fd49a7e5aa78.png )
Haproxy + keepalive + MySQL实现读均衡负载
