mysql半同步 主主双活 haproxy keepalived
来源:互联网 发布:java爬虫验证码 编辑:程序博客网 时间:2024/06/16 03:28
mysql5.7安装
测试环境 centos6.6
文档链接http://blog.csdn.net/qq_16177481/article/details/70269774
mysql双主+半同步配置
文档链接http://blog.csdn.net/qq_16177481/article/details/70332004
keepalived+haproxy负载高可用 参考 http://blog.csdn.net/qq_16177481/article/details/70241439 配置
只需修改/etc/haproxy/haproxy.c
如果是mysql和haproxy在同一个机器上注意下端口抢占 frontend main *:3307//这里端口号不和mysql不冲突就行
下面两个ip 设置成mysql 所在的ip:port
经测试两台服务器 其中一个mysql挂掉的时候 vip不漂移 需要检测之后kill掉keepalived进程
在mysql 所在的两台服务keepalived.conf最下面加入
virtual_server 192.168.19.150 3306 {
delay_loop 2
lb_algo rr
lb_kind DR
persistence_timeout 60
protocol TCP
real_server 192.168.19.79 3306 { #//本机ip 另一个就是192.168.19.66
weight 1
notify_down /usr/local/keepalived/kill.sh
TCP_CHECK {
connect_port 3306
connect_timeout 3
nb_get_retry 2
delay_before_retry 1
}
}
}
kill脚本
#!/bin/bash
pkill keepalived
- mysql半同步 主主双活 haproxy keepalived
- MySQL半同步+MHA+Keepalived部署指导
- Mysql半同步复制+MHA+Keepalived部署
- haproxy+keepalived+mycat+mysql (读写分离)
- haproxy+keepalived
- HAProxy+Keepalived
- haproxy+keepalived
- HAproxy+keepalived
- haproxy+keepalived
- haproxy+keepalived
- MySQL 5.5 keepalived + haproxy + MHA 自动容灾
- MySQL 5.5 keepalived + haproxy + MHA 自动容灾
- HAproxy+keepalived+mysql高可用性Linux系统集群
- keepalived+haproxy实现nginx与mysql负载均衡
- HAproxy+keepalived+mysql高可用性Linux系统集群
- Haproxy+Keepalived+MySQL高可用均衡负载部署
- Nginx/HAProxy/keepalived 方案
- Haproxy+KeepAlived 负载均衡
- react native Navigator 隐藏、自定义
- STM32F103定时器详解
- java之反射的应用
- com.android.ddmlib.InstallException: Failed to establish session
- C++虚函数原理和简单工厂模式
- mysql半同步 主主双活 haproxy keepalived
- StringUtils方法全集
- Java Web 文章管理系统(Jsp+Ajax+JDBC+MySql实现)
- Spring Boot 学习8--使用Jpa
- jsp乱码
- 8种基本类型的包装类和常量池简单介绍
- spring 的jar各包作用
- 希尔排序
- ntpd、ntpdate的区别