《mysql主從配置詳解(圖文)Mysql必讀》要點：
本文介紹了mysql主從配置詳解(圖文)Mysql必讀，希望對您有用。如果有疑問，可以聯系我們。

最近工作不是很忙,把以前整理的mysql數據庫的主從配置過程記錄一下,有不足之處,請各位多多糾正指教

#環境配置#

master IP:192.168.46.137? slave IP:192.168.46.138? database:v1

1.在兩臺機器,分別安裝mysql數據庫,分別添加遠程連接權限

2.配置主數據庫?

1. #編輯mysql的配置文件,增加以下內容#?
2. vim?etc/my.cnf?
3. server-id=1?
4. binlog-do-db=v1?
5. relay-log=/var/lib/mysql/mysql-relay-bin?
6. relay-log-index=/var/lib/mysql/mysql-relay-bin.index?
7. log-error=/var/lib/mysql/mysql.err?
8. master-info-file=/var/lib/mysql/mysql-master.info?
9. relay-log-info-file=/var/lib/mysql/mysql-relay-log.info?
10. log-bin=/var/lib/mysql/mysql-bin?
11. 編輯完成后,重啟mysql,systemctl?restart?mysqld.service(centos7?直接使用systemctl命令)?
12. 創建一個復制用戶,具有replication?slave?權限?
13. grant?replication?slave?on?*.*?to?'user3'@'192.168.46.138'?identified?by?'user3';?
14. 用戶名:user3??密碼:user3?
15. flush?privileges;?
16. #查看主庫狀態#?
17. show?master?status;?
18. ???
19. 
20. ?
21. 記住FileSet和Position參數值,后面步驟會用到?

?MYSQL學習

1. #編輯從數據庫配置文件,添加以下內容#?
2. vim?etc/my.cnf?
3. server-id=2?
4. replicate-do-db=v1?
5. relay-log=/var/lib/mysql/mysql-relay-bin?
6. relay-log-index=/var/lib/mysql/mysql-relay-bin.index?
7. log-error=/var/lib/mysql/mysql.err?
8. master-info-file=/var/lib/mysql/mysql-master.info?
9. relay-log-info-file=/var/lib/mysql/mysql-relay-log.info?
10. log-bin=/var/lib/mysql/mysql-bin?
11. 注意:兩個數據庫配置文件里的server-id不能相同?
12. 重啟mysql?
13. mysql?-u?root?-pxxx?
14. change?master?to?master_host='192.168.46.137',master_user='user3',master_password='user3',master_log_file='mysql-bin.000003',master_log_pos=120;?
15. #啟動slave線程#?
16. start?slave;?
17. #?查看slave狀態,注意G后面沒有分號#?
18. show?slave?status\G?
19. 
20. ???? 紅色箭頭所指兩個參數,如果都為Yes,說明配置成功,如果Slave_IO_Running為connecting,請檢查防火墻,端口是否開放,FIle,Position參數是否一致,網絡是否暢通等?
21. 到此,mysql主從配置完成,可以新增數據查看是否同步了?

?MYSQL學習

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/5594.html