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

How to properly shutdown MySQL before any maintenance activity

How to Prepare for MySQL Certification Exam

errno: 24 - Too many open files

MySQL 8.0 : Error Logging

Install MySQL on CentOS using DBdeployer