Sunday, March 3, 2024

Mysql Slave_SQL_Running no

 Mysql Slave_SQL_Running no

Environment is Centos8 with MySQL 8.0 and its a MySQL master slave replication. When I checked the "SHOW SLAVE STATUS\G" I am seeing status no for "Slave_SQL_Running".

Fix the issue :

Login to Slave Server.

STOP SLAVE;

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 

START SLAVE;

This will fix my issue.


No comments:

Post a Comment