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"

ERROR 1040 (HY000): Too many connections

errno: 24 - Too many open files

How to create CentOS VM using Vagrant

How to Prepare for MySQL Certification Exam

How to properly shutdown MySQL before any maintenance activity

Quickly configure replication using DBdeployer [SandBox]

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

GTID Replication (Skip Transaction using empty transaction)