清理日志
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr }
RESET MASTER
RESET SLAVE
復(fù)制監(jiān)控
SHOW MASTER STATUS
SHOW BINLOGS EVENTS
SHOW BINARY LOGS
SHOW SLAVE STATUS
SHOW PROCESSLIST
從服務(wù)器是否落后于主服務(wù)器
Seconds_Behind_Master:0
如何確定主從節(jié)點(diǎn)數(shù)據(jù)是否一致
percona-tools
數(shù)據(jù)不一致如何修復(fù)
刪除從數(shù)據(jù)庫，重新復(fù)制
