mysql replication

Check the mysl log for error
ex:in error log
^IWHERE thread.threadid = aggregate.threadid', Error_code: 1146
ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.001079' position 203015142
server1


To resolve the problem login to mysql as a admin

mysql -u root -p
then check the status of slave using
mysql> SHOW SLAVE STATUS \G

Slave_IO_Running: Yes
Slave_SQL_Running: No

mysql> STOP SLAVE;

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

mysql> START SLAVE;


this should fix the problem