主从同步常用指令

CHANGE MASTER TO  

MASTER_HOST='192.168.59.130', 

MASTER_USER='repl',
MASTER_PASSWORD='repl',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql_bin.000004',
MASTER_LOG_POS=154;

show master status

show slave status

start slave

stop slave

mysqlbinlog --start-position=154 /var/lib/mysql/mysql-bin.000003

bin-log