Replication 관련 mysql 명령어 list

0. START/STOP : 말그대로 start, stop 시킨다.

mysql> START SLAVE;
mysql> STOP SLAVE;

1. RESET Syntax : binary log를 리셋시킨다.

mysql> RESET MASTER;
mysql> RESET SLAVE;

2. SHOW Syntax : 여러가지 상태들을 보여준다.

mysql> SHOW MASTER STATUS;
mysql> SHOW SLAVE STATUS;

mysql> SHOW PROCESSLIST\G

*************************** 1. row ***************************
    Id: 35
  User: root
  Host: localhost
    db: NULL
Command: Query
  Time: 0
  State: NULL
  Info: show processlist
*************************** 2. row ***************************
    Id: 37
  User: repl
  Host: blog2.local:55297
    db: NULL
Command: Binlog Dump
  Time: 306
  State: Has sent all binlog to slave; waiting for binlog to be updated
  Info: NULL
2 rows in set (0.00 sec)

cf. \G는 vertical로 결과를 표시해준다.