Troubleshoot MySQL slave synchronization issues

Workaround:
1. First stop slave service: Slave stop;
2. View the host status on the primary server:

Records 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. Perform a manual synchronization on the slave server:
Mysql> Change Master to
> master_host= ' master_ip ',
> master_user= ' user ',
> master_password= ' pwd ',
> master_port=3307,
> master_log_file= ' mysql-bin.000020 ',
> master_log_pos=135617781;

4. Start slave

Slave start;

5. View slave status

show slave status \g;

This article from "Do not abandon!" Do not give up "blog, be sure to keep this source http://thedream.blog.51cto.com/6427769/1705320

Troubleshoot MySQL slave synchronization issues