-> MASTER_USER=’replication_user_name’,
-> MASTER_PASSWORD=’replication_password’,
-> MASTER_LOG_FILE=’recorded_log_file_name’,
-> MASTER_LOG_POS=recorded_log_position;
## Note:slave’s file and pos must be the same with with master’s ##
8、master
mysql >unlock tables;
9、slave
mysql >show slave status \G
## Note: Seconds_behind_master=0
## Slave_IO_Running=YES,Slave_SQL_Running=YES
10、checking the slave’s database updated real-time whether or not
本文出自 “迈小步、不停步！” 博客