MySQL Manual
4 Database Administration
- 4.10 Replication in MySQL
- 4.10.7 SQL Commands Related to Replication
- 4.10.7.1
START SLAVE(slave) - 4.10.7.2
STOP SLAVE(slave) - 4.10.7.3
SET SQL_LOG_BIN=0|1(master) - 4.10.7.4
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=n(slave) - 4.10.7.5
RESET MASTER(master) - 4.10.7.6
RESET SLAVE(slave) - 4.10.7.7
LOAD TABLE tblname FROM MASTER(slave) - 4.10.7.8
LOAD DATA FROM MASTER(slave) - 4.10.7.9
CHANGE MASTER TO master_def_list(slave) - 4.10.7.10
MASTER_POS_WAIT()(slave) - 4.10.7.11
SHOW MASTER STATUS(master) - 4.10.7.12
SHOW SLAVE HOSTS(master) - 4.10.7.13
SHOW SLAVE STATUS(slave) - 4.10.7.14
SHOW MASTER LOGS(master) - 4.10.7.15
SHOW BINLOG EVENTS(master) - 4.10.7.16
PURGE MASTER LOGS(master)
- 4.10.7.1
4.10.7.4 SET GLOBAL SQL_SLAVE_SKIP_COUNTER=n (slave)
Skip the next n events from the master. Only valid when
the slave thread is not running, otherwise, gives an error. Useful for
recovering from replication stops caused by a statement.
