global
#log 127.0.0.1 local0
log 127.0.0.1 local3 info
#log loghost local0 info
maxconn 4096
chroot /usr/local/haproxy
uid nobody
gid nobody
daemon
debug
#quiet
defaults
log global
mode tcp
#option httplog
option dontlognull
retries 3
option redispatch
maxconn 2000
contimeout 5000
clitimeout 50000
srvtimeout 50000
frontend mysql
bind 192.168.0.107:3306
maxconn 3000
default_backend mysql_slave
backend mysql_slave
#cookie SERVERID rewrite
mode tcp
balance roundrobin
#balance source
#balance leastconn
contimeout 10s
timeout check 2s
option httpchk OPTIONS * HTTP/1.1\r\nHost:\ www
server mysql_192_168_0_104_3306 192.168.0.104:3306 weight 1 check port 9300 inter 5s rise 2 fall 3
server mysql_192_168_0_104_3307 192.168.0.104:3307 weight 1 check port 9301
mysql 从读负载
最新推荐文章于 2022-11-04 16:20:18 发布
该博客详细介绍了如何通过HAProxy配置MySQL的读负载均衡,包括设置log、最大连接数、权限、默认参数、前端和后端服务器的定义,以及健康检查和轮询策略,以确保数据库的高可用性和读取性能。
摘要由CSDN通过智能技术生成