mysql_replication
show slave status \GImportant to look out for:
Slave_IO_Running: Yes Slave_SQL_Running: NoThe following means that the master and slave are communicating. The master is sending over the IO commands and the slave is receiving them
Slave_IO_Running: YesThe Slave is NOT running the IO commands sent from the Master
Slave_SQL_Running: No
Slave Behind Master?
mysql -e 'show slave status\G'|grep -i behind
Slave SQL/IO Running?
mysql -e 'SHOW SLAVE STATUS\G;' | grep -i slave*running
mysql_replication.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1