查看当前的mysql从属状态:
show slave status \G;
搭建失败,两个YES没凑够的情况:
①第一个不是yes,是connecting
Slave_IO_Running: Yes
Slave_SQL_Running: connecting
是因为从机使用你配置的主机信息没有登陆到主机里面!
修改(从机里面)
stop slave;
change master to master_host="192.168.149.128",master_port=3307,master_user="rep",master_password="123456",master_log_file="master.000001",master_log_pos=745;
start slave;