ef mysql5.7_MySql5.7主從配置

記錄

環境：ubuntu16.04，mysql5.7

主機：192.168.1.240,192.168.1.241；241為Salve

1.安裝mysql

sudo apt-get install mysql-server

2.為master增加slave用戶

進入mysql

grant replication slave on *.* to 'slave'@'192.168.1.241' identified by 'password';

3.編輯配置文件

master：

vim /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 192.168.1.240 #這個一定要配，否則Slave連不上

server-id = 1

log_bin = /var/log/mysql/mysql-bin.log

expire_logs_days = 10

max_binlog_size = 100M

relay-log=mysql-relay-bin

log_slave_updates=on

auto_increment_increment=2

auto_increment_offset=1

slave：

server-id = 2

auto_increment_increment=2

auto_increment_offset=2

4.在Master和Slave上創建相同的庫與表

5.開啟Slave

(1)240查詢Master日志Position

show master status;

(2)在241設置Slave並啟動

change master to master_host='192.168.1.240',master_user='slave',master_password='password',master_port=3306,MASTER_LOG_FILE='mysql-bin.000007', MASTER_LOG_POS=1068;

start slave;

查詢slave狀態

show slave status\G;

進行數據驗證