部署mysql高可用集群(第三方软件 + 主从同步)
mysql-mmm
集群:使用多台服务器提供相同的服务
根据多台服务器提供服务的方式,分为:
高可用集群:主 备(keepalived)
负载均衡集群:平均相应用户的连接请求(LVS haproxy
nginx)
配置主主结构(9/10)
9:
mysql> grant replication slave on *.* to plj@"%"
identified by "123456";
#vim /etc/my.cnf
server_id=9
log_bin=master9
binlog_format="mixed"
:wq
#systemctl stop mysqld
#systemctl start mysqld
10
mysql> grant replication slave on *.* to plj@"%"
identified by "123456";
#vim /etc/my.cnf
server_id=10
log_bin=master10
binlog_format="mixed"
log_slave_updates
:wq
#systemctl stop mysqld
#systemctl start mysqld
#mysql -uroot -p123456
mysql>mysql> change master to
master_host="192.168.4.9",master_user="plj",master_p
assword="123456",master_log_file="master9.000001",
master_log_pos=154;
mysql> start slave;
mysql>show slave status\G;
9
#mysql -uroot -p123456
mysql> change master t