亚洲AV无码乱码在线观看不卡|最新大伊香蕉精品视频在线|亚洲不卡av一区二区|国产美女无遮挡免费

-> MASTER_LOG_FILE='recorded_log_file_name', //主服務(wù)器二進(jìn)制日志的文件名(前面要求記住的參數(shù))

-> MASTER_LOG_POS=recorded_log_position; //日志文件的開始位置(前面要求記住的參數(shù))

e.啟動(dòng)同步數(shù)據(jù)庫(kù)的線程

mysql> slave start;

查看數(shù)據(jù)庫(kù)的同步情況吧。成功同步！

查看主從服務(wù)器的狀態(tài)

mysql> SHOW PROCESSLIST\G //可以查看mysql的進(jìn)程看看是否有監(jiān)聽的進(jìn)程

如果日志太大清除日志的步驟如下:

1.鎖定主數(shù)據(jù)庫(kù)

mysql> FLUSH TABLES WITH READ LOCK;

2.停掉從數(shù)據(jù)庫(kù)的slave

mysql> slave stop;

3.查看主數(shù)據(jù)庫(kù)的日志文件名和日志文件的position

show master status;

+---------------+----------+--------------+------------------+

| File | Position | Binlog_do_db | Binlog_ignore_db |

+---------------+----------+--------------+------------------+

| louis-bin.001 | 79 | | mysql |

+---------------+----------+--------------+------------------+

4.解開主數(shù)據(jù)庫(kù)的鎖

mysql> unlock tables;

5.更新從數(shù)據(jù)庫(kù)中主數(shù)據(jù)庫(kù)的信息

mysql> CHANGE MASTER TO

-> MASTER_HOST='master_host_name', //主服務(wù)器的IP地址

-> MASTER_USER='replication_user_name', //同步數(shù)據(jù)庫(kù)的用戶

-> MASTER_PASSWORD='replication_password', //同步數(shù)據(jù)庫(kù)的密碼

-> MASTER_LOG_FILE='recorded_log_file_name', //主服務(wù)器二進(jìn)制日志的文件名(前面要求記住的參數(shù))

-> MASTER_LOG_POS=recorded_log_position; //日志文件的開始位置(前面要求記住的參數(shù))

6.啟動(dòng)從數(shù)據(jù)庫(kù)的slave

mysql> slave start;