-> MASTER_LOG_FILE='recorded_log_file_name', //主服務器二進制日志的文件名(前面要求記住的參數(shù))
-> MASTER_LOG_POS=recorded_log_position; //日志文件的開始位置(前面要求記住的參數(shù))
e.啟動同步數(shù)據(jù)庫的線程
mysql> slave start;
查看數(shù)據(jù)庫的同步情況吧。成功同步！
查看主從服務器的狀態(tài)
mysql> SHOW PROCESSLIST\G //可以查看mysql的進程看看是否有監(jiān)聽的進程
如果日志太大清除日志的步驟如下:
1.鎖定主數(shù)據(jù)庫
mysql> FLUSH TABLES WITH READ LOCK;
2.停掉從數(shù)據(jù)庫的slave
mysql> slave stop;
3.查看主數(shù)據(jù)庫的日志文件名和日志文件的position
show master status;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+---------------+----------+--------------+------------------+
| louis-bin.001 | 79 | | mysql |
+---------------+----------+--------------+------------------+
4.解開主數(shù)據(jù)庫的鎖
mysql> unlock tables;
5.更新從數(shù)據(jù)庫中主數(shù)據(jù)庫的信息
mysql> CHANGE MASTER TO
-> MASTER_HOST='master_host_name', //主服務器的IP地址
-> MASTER_USER='replication_user_name', //同步數(shù)據(jù)庫的用戶
-> MASTER_PASSWORD='replication_password', //同步數(shù)據(jù)庫的密碼
-> MASTER_LOG_FILE='recorded_log_file_name', //主服務器二進制日志的文件名(前面要求記住的參數(shù))
-> MASTER_LOG_POS=recorded_log_position; //日志文件的開始位置(前面要求記住的參數(shù))
6.啟動從數(shù)據(jù)庫的slave
mysql> slave start;
