MySQL5主库断电后主从的恢复
问题,主库异常断电后,重启主库机器,主从同步不能启动:
Slave_IO_Running: No
Slave_SQL_Running: Yes
解决办法:
(1)重启主库后找到主库的最后一条日志的数字
mysqlbinlog mysql-bin.000008 > 1.txt
tail -n 100000 1.txt > 2.txt
然后打开2.txt文件,跳到最后:
# at 753870260
#080724 16:21:25 server id 2 end_log_pos 753870665 Query thread_id=185 exec_time=0 error_code=0
找到数字为:753870260
(2)以下在从库上运行一次
CHANGE MASTER TO MASTER_HOST='主库连接IP',
MASTER_USER='masteruser',
MASTER_PASSWORD='masterpass',
MASTER_LOG_FILE='mysql-bin.000008',
MASTER_LOG_POS=753870260;
(3)然后不断的运行以下,直到两个都是“YES”
slave stop;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
slave start;
show slave status\G
(4)见到以下状态,OK了!
Slave_IO_Running: No
Slave_SQL_Running: Yes