haproxy配置mysql原理_mysql利用haproxy实现负载均衡

mysql需要配置数据同步服务

一、配置主mysql

mysql5.7.20安装见

https://www.cnbugs.com/post-833.html

修改配置文件：

修改my.cnf配置文件添加如下配置文件

[root@lnmp-zabbix ~]# vim /etc/my.cnf

# 指定服务器ID

server-id=1

# 开启二进制日志

log-bin=mysql-bin

重启mysql服务

[root@lnmp-zabbix ~]# /etc/init.d/mysqld57 restart

Shutting down MySQL.. SUCCESS!

Starting MySQL. SUCCESS!

在Master服务器上创建MySQL用户(授权复制用户)

mysql> grant replication slave on *.* to 'slave'@'10.168.1.151' identified by 'Aa123456';

Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

18521137579

命令：grant replication slave on . to '用户名'@'slave IP地址' identified by '密码';

查看master状态

mysql> show master status;

二、配置备mysql

修改my.cnf配置文件添加如下参数

[root@keeplived_haproxy_mysql ~]# vim /etc/my.cnf

server-id = 2

log-bin=mysql-bin

重启mysq