mysql主从同步不一致后的解决方法

查看master的运行情况:

[root@master] mysql -uroot -p************
[root@master] mysql> show master status \G;
    *************************** 1. row ***************************
             File: mysql-bin.000014     //这个信息点要记住，下面用
         Position: 170017372            //这个信息点要记住，下面用
         Binlog_Do_DB: ipharmacare_admin
     Binlog_Ignore_DB: mysql,information_schema,performance_schema
    Executed_Gtid_Set: 
    1 row in set (0.00 sec)

查看slave的运行情况:

[root@slave] mysql -uroot -p************
[root@slave] mysql> show slave status \G;
    *************************** 1. row ***************************
               Slave_IO_State: 
              Master_Host: master.mysql.ipharmacare.org
              Master_User: slave
              Master_Port: 3306
            Connect_Retry: 60
              Master_Log_File: mysql-bin.000013
          Read_Master_Log_Pos: 1003623481