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

最近工作不是很忙,把以前整理的mysql數(shù)據(jù)庫(kù)的主從配置過(guò)程記錄一下,有不足之處,請(qǐng)各位多多糾正指教

#環(huán)境配置#

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

1.在兩臺(tái)機(jī)器,分別安裝mysql數(shù)據(jù)庫(kù),分別添加遠(yuǎn)程連接權(quán)限

2.配置主數(shù)據(jù)庫(kù)?

1. #編輯mysql的配置文件,增加以下內(nèi)容#?
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. 創(chuàng)建一個(gè)復(fù)制用戶,具有replication?slave?權(quán)限?
13. grant?replication?slave?on?*.*?to?'user3'@'192.168.46.138'?identified?by?'user3';?
14. 用戶名:user3??密碼:user3?
15. flush?privileges;?
16. #查看主庫(kù)狀態(tài)#?
17. show?master?status;?
18. ???
19. 
20. ?
21. 記住FileSet和Position參數(shù)值,后面步驟會(huì)用到?

?MYSQL學(xué)習(xí)

1. #編輯從數(shù)據(jù)庫(kù)配置文件,添加以下內(nèi)容#?
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. 注意:兩個(gè)數(shù)據(jù)庫(kù)配置文件里的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. #啟動(dòng)slave線程#?
16. start?slave;?
17. #?查看slave狀態(tài),注意G后面沒(méi)有分號(hào)#?
18. show?slave?status\G?
19. 
20. ???? 紅色箭頭所指兩個(gè)參數(shù),如果都為Yes,說(shuō)明配置成功,如果Slave_IO_Running為connecting,請(qǐng)檢查防火墻,端口是否開(kāi)放,FIle,Position參數(shù)是否一致,網(wǎng)絡(luò)是否暢通等?
21. 到此,mysql主從配置完成,可以新增數(shù)據(jù)查看是否同步了?

?MYSQL學(xué)習(xí)

轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/5594.html