File/Pos Replication : Skip Slave's sql_thread error [COMMAND]

File/Pos Replication : Skip Slave's sql_thread error [COMMAND]



For binlog file & position based replication setup, To skip the slave's sql_thread error, run below command.


stop slave; 
set global sql_slave_skip_counter=1;
start slave;
select sleep(3);
show slave status\G

Comments

Popular

SLEEP thread causing "Waiting for table metadata lock"

MySQL Memory Calculator

How to properly shutdown MySQL before any maintenance activity

errno: 24 - Too many open files

ERROR 1040 (HY000): Too many connections

How to create CentOS VM using Vagrant

How to Prepare for MySQL Certification Exam

set --server-id to enable either a master or a slave

GTID Replication (Skip Transaction using empty transaction)

Master has purged binary logs containing GTIDs that the slave requires