MHA高可用部署
1.先把server1、server2、server3上的mysql都停掉(为了做新的配置)
[root@server1 data]# /etc/init.d/mysqld stop
Shutting down MySQL........... SUCCESS!
2.删除三个节点上的/usr/local/mysql/data中的文件、更改/etc/my.cnf文件,重新初始化、安装
[root@server1 data]# rm -rf *
[root@server1 data]# vim /etc/my.cnf
[root@server1 ~]# cat /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
symbolic-links=0
server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW
[root@server1 data]# mysqld --initialize --user=mysql
[root@server1 data]# /etc/init.d/mysqld start
[root@server1 data]# mysql_secure_installation