mysql_replication
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| mysql_replication [2016/05/16 11:55] – created luke7858 | mysql_replication [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| Slave_IO_Running: | Slave_IO_Running: | ||
| Slave_SQL_Running: | Slave_SQL_Running: | ||
| + | </ | ||
| + | The following means that the master and slave are communicating. The master is sending over the IO commands and the slave is receiving them | ||
| + | <sxh bash> | ||
| + | Slave_IO_Running: | ||
| + | </ | ||
| + | The Slave is NOT running the IO commands sent from the Master | ||
| + | <sxh bash> | ||
| + | Slave_SQL_Running: | ||
| + | </ | ||
| + | \\ | ||
| + | == Slave Behind Master? == | ||
| + | <sxh bash> | ||
| + | mysql -e 'show slave status\G' | ||
| + | </ | ||
| + | == Slave SQL/IO Running? == | ||
| + | <sxh bash> | ||
| + | mysql -e 'SHOW SLAVE STATUS\G;' | ||
| </ | </ | ||
mysql_replication.1463399751.txt.gz · Last modified: 2024/05/23 07:26 (external edit)