准备两台mysql服务器,master(192.168.43.64)、slave(192.168.84.129)
master配置:
log-bin=mysql-bin
binlog_format=mixed
server_id=1
binlog_checksum=none
slave配置:
然后给master授权并查看二进制文件名称和位置:
进入从服务器执行如下sql并开启slave、查看slave状态:
change master to master_host='192.168.43.64' ,master_user='root' ,master_password='123' ,master_log_file='mysql-bin.000032&