replication slave skip query
Posted on February 23, 2012
run the following commands to skip a query in the replication.
SHOW SLAVE STATUS G
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
START SLAVE
Jan Walraven
DevOps
DevOps
Categories:
Arduino (2)
CSS (3)
Docker (11)
ESXi (1)
Git (4)
Google Cloud (3)
Javascript (6)
Kubernetes (4)
Linux (36)
Mac (7)
Magento (4)
Mysql (14)
PHP (9)
Zend framework 2 (9)