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 Prepare for MySQL Certification Exam

How to properly shutdown MySQL before any maintenance activity

How to create CentOS VM using Vagrant

Quickly configure replication using DBdeployer [SandBox]

MySQL 8.0 : Error Logging

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