摘要:

mysql的主從復制, 當從庫執(zhí)行binlog出錯后, 會中止主從復制.

此時需要重置主從連接, 以重建主從關系.

主庫操作:

一. 清理同步的數(shù)據(jù)庫

drop database test;

二. 重置主庫狀態(tài)

reset master;reset slave all;

三. 檢測主庫狀態(tài)

show master status;

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |      157 | test         | mysql            |                   |
+------------------+----------+--------------+------------------+-