MYSQL主从跳过操作

wshxgxiaoli

于 2014-01-17 09:46:56 发布

阅读量424

点赞数

分类专栏： MYSQL 文章标签： mysql 主从跳过操作

本文链接：https://blog.youkuaiyun.com/wshxgxiaoli/article/details/18400409

版权

MYSQL 专栏收录该内容

11 篇文章

订阅专栏

mysql> stop slave;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    84
Current database: test

Query OK, 0 rows affected (0.08 sec)

mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
Query OK, 0 rows affected (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)