MYSQL synchronization Slave_IO_Running: No or Slave_ SQL _Running: No solution [tested]

When testing whether mysql is synchronized today, check the database and find that a MySQL Slave is not synchronized with the host. Check the Slave status:
Mysql> show slave status \ G
Slave_IO_Running: Yes
Slave_ SQL _Running: No
Last_errno.: 1062
....
Seconds_Behind_Master: NULL
Cause:
1. The program may write on slave.
2. It may also be caused by transaction rollback after the Server Load balancer instance restarts.

Solution I:
1. stop the Slave service first: slave stop

2. Check the host status on the master server:
Record the value corresponding to File and Position.
Mysql> show master status;
+ ------------------ + ----------- + -------------- + ------------------ +
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+ ------------------ + ----------- + -------------- + ------------------ +
| Mysql-bin.000020 | 135617781 |
+ ------------------ + ----------- + -------------- + ------------------ +
1 row in set (0.00 sec)

3. Execute manual synchronization on the slave server:Copy codeThe Code is as follows: mysql> change master
> Master_host = 'master _ ip ',
> Master_user = 'user ',
> Master_password = 'pwd ',
> Master_port = 3307,
> Master_log_file = 'mysql-bin.20.20 ',
> Master_log_pos = 135617781;

1 row in set (0.00 sec)
Mysql> slave start;
1 row in set (0.00 sec)
View the slave status again and find:
Slave_IO_Running: Yes
Slave_ SQL _Running: Yes
...
Seconds_Behind_Master: 0

Solution II:
Mysql> slave stop;
Mysql> set GLOBAL SQL _SLAVE_SKIP_COUNTER = 1;
Mysql> slave start;

Your own experience: the first method is to force synchronization from a certain point, there will be some non-synchronous data loss, there will be some errors in the subsequent deletion records synchronization on the master server, will not affect the use. method 2 may not be effective.