How do I get the status of my slaves in replication?
SHOW SLAVE HOSTS
Run on the master
SHOW STATUS
SHOW SLAVE STATUS
Run on each slave
SHOW PROCESSLIST
Look for "Command: Binlog Dump"
From the Checking Replication Status page
How do I get the status of my slaves in replication?
SHOW SLAVE HOSTS
Run on the master
SHOW STATUS
SHOW SLAVE STATUS
Run on each slave
SHOW PROCESSLIST
Look for "Command: Binlog Dump"
From the Checking Replication Status page
No comments:
Post a Comment