问题:
mysql> show slave status\G
Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_Errno: 1008
Last_Error: Error 'Can't drop database 'test1'; database doesn't exist' on query. Default database: 'test1'. Query: 'drop database test1'
解决办法:
mysql> slave stop;
#将binglog指针下移一个位置
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
mysql> slave start;
验证:
mysql> show slave status\G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error: