Mysql5.7双主安装与使用
一. 两台服务器IP:192.168.0.1,192.168.0.2
二. 分别在两台服务器安装mysql5.7
1. 查看是否已经默认安装mysql软件:
rpm -qa|grep mysql
如果存在的话,继续删除即可
yum remove mysql *
2.安装mysql5.7
vi /etc/yum.repos.d/mysql-community.repo
写入:
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
3. sudo yum install mysql-community-server
4.在192.168.0.1编辑/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
user=mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
log-bin=mysql-bin
gtid-mode=on
enforce-gtid-consistency=true
ma