当 show slave status \G;遇到如下问题时:
Slave_IO_Running: Yes
Slave_SQL_Running: No
解决方法一:
mysql> start slave;
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
解决方法二:
主库中 show master status;找到 master_log_file ,master_log_pos
从库:
mysql> stop slave;
mysql> change master to master_host='ip', master_port=3306,master_user='user',master_password='pwd',master_log_file='master-bin.000007',master_log_pos=1995;