Mysql主从配置

0.关闭主从机器的防火墙。

1.安装

wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm

rpm -Uvh mysql57-community-release-el7-10.noarch.rpm

yum install  -y  mysql-community-server

2.获取密码并且更改

/usr/local/mysql5.7/bin/mysqld --initialize  --basedir=/usr/local/mysql5.7/ --datadir=/usr/local/mysql5.7/data

或者  grep "password" /var/log/mysqld.log

然后就可以得到默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123+';

FLUSH PRIVILEGES;

开启远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'  

3.配置两台机器时间同步

4.配置主Mysql

在/etc/my.cnf添加

server_id=1   
log_bin=master-bin
log_bin_index=master-bin.index

重启service mysqld restart

配置从服务器

server_id=2
log_bin=mysql-bin

 

5.查看主日志

SHOW MASTER STATUS;

6.执行从命令

change master to master_host='XXX.XXX.XX',master_user='root',master_password='Root123+',master_log_file='master-bin.000001',master_log_pos=2740708;

7.查看效果

 show slave status\G;

两项都是yes代表成功。