锘??xml version="1.0" encoding="utf-8" standalone="yes"?> 錛?/span>1錛変粠緗戜笂涓嬭澆浜嗕竴涓潪瀹夎鐨勭増鏈?/span>mysql-5.0.51b錛岀劧鍚庡湪192.168.1.10鏈哄櫒涓婅В鍘嬪湪E:\mysql鐩綍涓嬨?/span> 錛?/span>2錛夊湪E:\mysql涓嬪垱寤轟竴涓?/span>my.ini鏂囦歡錛屽唴瀹規(guī)槸浠庤鐩綍涓嬮潰鐨勫叾浠?/span>ini澶嶅埗鑰屾潵錛岀劧鍚庝慨鏀歸噷闈㈢殑鍐呭錛屼富瑕佹槸璁劇疆璺緞銆傚洜涓?/span>mysql瀹夎鍦?/span>E:/mysql涓嬶紝鎵浠ヤ慨鏀瑰涓嬶細 [mysqld] basedir="E:/mysql/" datadir="E:/mysql/Data/" 錛?/span>3錛変慨鏀圭鍙?/span> 涓轟簡璁?/span>mysql浠ユ湇鍔$殑褰㈠紡鍦?/span>windows涓繍琛岋紝鍚屾椂涓嶅拰鍏朵粬宸插畨瑁呯殑mysql鍙戠敓鍐茬獊錛屾墍浠ヨ淇敼msyql鏈嶅姟榪愯鐨勭鍙o紝涓昏淇敼濡備笅錛?/span> [mysqld] port=5306 錛?/span>4錛夊畨瑁呮湇鍔?/span> windows閿?/span>+R錛岃緭鍏?#8220;cmd”錛屽洖杞︼紝榪涘叆window涓帶鍒跺彴紿楀彛錛岀劧鍚庡垏鎹㈠埌E:\mysql\bin鐩綍涓嬶紝榪愯mysqld-nt --install replDb錛岃繖鏍鋒湇鍔″畨瑁呭畬鎴愩?/span> 錛?/span>5錛夎緗?/span>master 璁劇疆master鐨勭洰鐨勪富瑕佽msyql鏁版嵁搴撶▼搴忚繍琛岃搗鏉ョ殑鏃跺欏湪鏈湴浜х敓bin-log錛屼互澶?/span>slave鍙互浠庤log涓鍙?/span>sql鎿嶄綔錛屼粠鑰屼繚鎸佸拰master鐨勬暟鎹悓姝ャ備富瑕佽緗涓嬶細 [mysqld] log-bin=mysql-bin server-id=1 log-bin璁劇疆鐨勬槸鏈湴浜х敓鐨?/span>bin-log鏂囦歡鐨勫悕瀛楋紝mysql榪樹細鑷姩浜х敓鎵╁睍鍚嶃?/span>server-id鐢ㄦ潵鏍囪瘑鏈暟鎹簱鏈嶅姟鍣ㄣ傚彧鎵浠ラ渶瑕侀厤緗?/span>server-id鏄負浜嗗尯鍒?/span>bin-log涓偅浜涙暟鎹殑鏉ユ簮銆傝繖鏍峰氨鍙互闃叉鍦ㄤ竴涓?/span>loop鐨勫浠界幆澧冧腑錛屾暟鎹寰幆澶嶅埗銆傛瘮濡傦細AàB, BàC, CàA銆傚亣濡傛病鏈夎繖涓?/span>server-id錛?/span>A鍦ㄤ粠C澶嶅埗鏁版嵁鐨勬椂鍊欙紝灝變笉鐭ラ亾榪欎簺鏁版嵁鏄?/span>C浜х敓鐨勶紝榪樻槸B浜х敓鐨勶紝榪樻槸A鑷繁浜х敓鐨勩傚鏋滄槸B鍜?/span>C浜х敓鐨勶紝A褰撶劧闇瑕佸鍒訛紝濡傛灉鏄?/span>A鑷繁浜х敓鐨勶紝褰撶劧灝變笉闇瑕佸啀澶嶅埗浜嗭紝涓嶇劧灝辨棤闄愬驚鐜笅鍘諱簡銆?/span> 淇濆瓨my.ini鏂囦歡錛岃繖涓椂鍊欒繍琛?/span> net start replDb銆傚氨浼氬彂鐜?/span>mysql鏁版嵁搴撶▼搴忚繍琛屼箣鍚庯紝浼氬湪E:/mysql/Data/鐩綍涓嬩駭鐢?/span>mysql-bin.xxxxxx鐨勬棩蹇楁枃浠訛紝浠ュslave璁塊棶銆?/span> 錛?/span>6錛夊垱寤?/span>slave甯愭埛鍜屾潈闄?/span> net start replDb 灝變細鍚姩replDb銆?/span> 鍦?/span>slave澶嶅埗bin-log鍐呭鐨勬椂鍊欙紝闇瑕佺浉搴旂殑甯愬彿鍜岃闂潈闄愶紝鍥犳濡備笅鍛戒護錛?/span> Mysql –uroot –port=5306 鐢變簬鍒濆娌℃湁瀵嗙爜錛屽洜姝よ鍛戒護鐩存帴鍙互璁塊棶鏁版嵁搴擄紝濡傛灉涓轟簡瀹夊叏璧瘋錛屽簲璇ヨ緗?/span>root瀵嗙爜錛屽涓嬶細 Grant all on *.* to ‘root’@’localhost’ identified by ‘root’錛?/span> 榪欐牱root鐢ㄦ埛鍙兘鍦ㄦ湰鏈轟互’root’瀵嗙爜璁塊棶銆傜劧鍚庡垱寤?/span>slave鍙互璁塊棶鐨勫笎鎴鳳紝榪愯濡備笅璇彞錛?/span> Grant replication slave on *.* to ‘repl’@’192.168.1.11’ identified by ‘slavepass’; 榪欐牱192.168.1.11榪欏彴鏈哄櫒涓婄殑mysql slave灝卞彲浠ヤ互repl鐢ㄦ埛鍚嶅拰’slavepass’瀵嗙爜鏉ュ鍒舵湰鏈猴紙192.168.1.10錛夌殑bin-log涓殑鍐呭浜嗐?/span> 錛?/span>7錛夊畨瑁?/span>slave 鍦?/span>192.168.1.11鏈哄櫒涓婇噸澶嶄笂闈㈢殑錛?/span>1錛夛紝錛?/span>2錛夛紝錛?/span>3錛夛紝錛?/span>4錛夛紝錛?/span>5錛夛紝錛?/span>6錛夋楠ゃ?/span> 浣嗘槸鍦ㄧ錛?/span>5錛夋涓?/span>server-id搴旇璁劇疆鎴愬拰192.168.1.10鏈哄櫒涓嶅悓鐨勫鹼紝濡備笅錛?/span> [mysqld] log-bin=mysql-bin server-id=2 鍚屾椂鍦ㄧ錛?/span>6錛夋鍒涘緩slave甯愭埛鐨勬椂鍊欙紝ip鏈夋墍鏀瑰彉錛屽涓嬶細 Grant replication slave on *.* to ‘repl’@’192.168.1.10’ identified by ‘slavepass’; 錛?/span>8錛夎緗?/span>slave閫夐」 鍦?/span>192.168.1.10鐨?/span>my.ini鏂囦歡涓紝鍔犲叆濡備笅鍐呭錛?/span> [mysqld] master-host=192.168.1.11 master-port=5306 master-user=repl master-password=slavepass 榪欎釜璁劇疆鏄憡璇?/span>192.168.1.10涓婄殑mysql鏈嶅姟鍣ㄦ妸192.168.1.11:5306浣滀負master錛屼互鐢ㄦ埛鍚?/span>repl鍜屽瘑鐮?/span>slavepass鍘昏闂傚悓鏍風(fēng)殑鍦?/span>192.168.1.11涓婂涓嬭緗細 [mysqld] master-host=192.168.1.10 master-port=5306 master-user=repl master-password=slavepass 鐒跺悗鍦?/span>192.168.1.10鍜?/span>192.168.1.11鏈哄櫒涓婇兘榪愯濡備笅鍛戒護 Net stop replDb Net start replDb 濡傛灉涓嶅嚭闂錛屼袱鍙版満鍣ㄤ笂鐨?/span>mysql鏁版嵁搴旇灝卞凡緇忓浜庣浉浜掑浠界殑鐘舵佷笅浜嗐?/span> 閭d箞濡備綍媯楠屾槸鍚﹁繛鎺ユ垚鍔熷憿錛屼富瑕侀氳繃浠ヤ笅鍛戒護錛?/span> 鍦?/span>192.168.1.10鏈哄櫒涓婅繍琛?/span> mysql –u root –p –port=5306錛岃緭鍏ュ瘑鐮?/span>’root’涔嬪悗錛岃繘鍏?/span>mysql鎿嶄綔鐣岄潰銆?/span> 鐒跺悗杈撳叆show slave status\G 璇彞 浼氳緭鍑哄涓嬶細 娉ㄦ剰鍏朵腑鐨?/span> Slave_IO_Running 鍜?/span> Slave_SQL_Running錛岃繖涓や釜鎸囨爣濡傛灉鏄?/span>yes琛ㄧずslave宸茬粡鍦ㄥ伐浣滀簡錛岀劧鍚庡啀鐪?/span>Last_Error錛屽鏋滄槸絀虹殑琛ㄧず涓鍒囨甯革紝榪樻湁鏈鍚庝竴涓?/span>Seconds_Behind_Master錛岃繖涓寚鏍囪〃紺?/span>slave璇葷殑閫熷害钀藉悗鍘熷鏁版嵁澶氬皯錛屾甯稿綋鐒舵槸瓚婂皬瓚婂ソ錛屽お澶у氨琛ㄧずslave鏉ヤ笉鍙婂鍒?/span>master鐨勬暟鎹簡銆?/span> 鍒版錛岃緗繍琛屽畬姣曪紝鍦ㄦ祴璇曠殑榪囩▼涓紝鎴戝彂鐜拌繕鍙互榪欐牱瀹夎錛屾瘮濡傚湪涓婇潰絎紙6錛夋緇撴潫涔嬪悗錛屽彲浠ヤ笉鐢ㄦ妸slave鐨勯厤緗啓鍒版枃浠朵腑錛岃屾槸鍙互鍦ㄤ笉閲嶆柊鍚姩mysql鏁版嵁搴撶殑鎯呭喌涓嬬洿鎺ラ氳繃榪愯璇彞鏉ュ畬鎴愶細 鍗沖厛change master錛岀劧鍚庤繍琛?/span>start slave銆?/span> 鐒跺悗鍐嶈繍琛?/span>show slave status\G錛屽簲璇ヤ篃鏄?/span>OK銆?/span> 鏈変竴鐐歸渶瑕佽鏄庣殑鏄紝榪欓噷瀹夎鐨勬椂鍊欐槸鐩存帴鐢ㄤ袱涓畬鍏ㄦ柊鐨勬暟鎹簱錛屽鏋滃湪宸茬粡鏈夋暟鎹湪鏁版嵁搴撲腑錛屽茍涓旇鏁版嵁搴撴槸master錛岃繖涓椂鍊欐兂涓嶅叧闂?/span>master鐨勬儏鍐典笅錛屽姞鍏ヤ竴涓?/span>slave榪涙潵鐨勮瘽錛屽氨闇瑕佸弬鑰?/span>mysql鐨?/span>replication涓绔犱腑鐨勫唴瀹癸紝鍏跺熀鏈繃紼嬫槸榪欐牱錛?/span> 錛?錛?span style="FONT: 7pt 'Times New Roman'">
]]>mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master1
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000004
Read_Master_Log_Pos: 931
Relay_Log_File: slave1-relay-bin.000056
Relay_Log_Pos: 950
Relay_Master_Log_File: mysql-bin.000004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 931
Relay_Log_Space: 1365
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.01 sec)
CHANGE MASTER TO
-> MASTER_HOST='192.168.1.10',
-> MASTER_USER='repl
'
,
-> MASTER_PASSWORD='
slavepass'
,
-> MASTER_PORT=5306;
mysql> FLUSH TABLES WITH READ LOCK;
錛?錛?span style="FONT: 7pt 'Times New Roman'"> 鐒跺悗鍐嶆暟鎹攣瀹氱殑鎯呭喌涓嬶紝鐢?/span>show master status鏌ョ湅bin-log鐨勪綅緗紝騫惰涓嬪弬鏁幫紝騫跺浠?/span>master涓殑鍐呭銆?/span>
錛?錛?span style="FONT: 7pt 'Times New Roman'"> 瑙i攣master鏁版嵁搴撱?/span>
錛?錛?span style="FONT: 7pt 'Times New Roman'"> 鎶婂浠藉ソ鐨勬暟鎹掑埌slave涓?/span>
錛?錛?span style="FONT: 7pt 'Times New Roman'"> 鍦?/span>slave鏁版嵁搴撲腑榪愯鐢?/span>change master璇彞錛岃璇彞闇瑕佸姞涓?/span>master_log_file鍜?/span>master_log_pos鍙傛暟銆傝繖涓や釜鍙傛暟灝辨槸鍦紙2錛変腑璁頒笅鐨?/span>bin-log鍙傛暟銆?/span>
錛?錛?span style="FONT: 7pt 'Times New Roman'"> 鍦?/span>slave 涓繍琛?/span> start slave銆傜劧鍚庡氨ok浜嗐?/span>
閫氳繃涓婇潰鐨勯槓榪板彲浠ュ彂鐜幫紝鏈変袱縐嶆柟寮忛厤緗浠斤紝涓涓槸閫氳繃my.ini錛岃繕鏈変竴涓槸閫氳繃change master璇彞銆傚叾瀹炲綋鏁版嵁搴撹繍琛岀殑鏃跺欙紝濡傛灉鍙戠幇my.ini涓湁master_host絳夊弬鏁幫紝鏁版嵁搴撳氨鎶婅繖浜涗俊鎭啓鍒?/span>data鐩綍涓嬬殑master.info鏂囦歡涓紝鐒跺悗slave鍚姩鐨勬椂鍊欏氨鐩存帴浠庤繖涓?/span>master.info鏂囦歡涓鍙?/span>master鐨勪俊鎭傝屽湪slave鏁版嵁搴撲腑榪愯change master璇彞鐨勬椂鍊欙紝鏁版嵁搴撶▼搴忔槸鎶婇偅浜涘弬鏁扮洿鎺ュ啓鍏?/span>master.info鏂囦歡涓?/span>
鍦?/span>mysql鏁版嵁搴撲腑錛屽鐞嗛昏緫鏄繖鏍風(fēng)殑錛屽綋mysql鏁版嵁搴撶▼搴忓惎鍔ㄧ殑鏃跺欙紝濡傛灉瀹冨彂鐜版湁master.info鏁版嵁鏂囦歡瀛樺湪錛岄偅涔堝畠涓嶄細鍘昏my.ini涓殑鐩稿叧閰嶇疆錛岃屾槸鐩存帴鐢?/span>master.info涓殑鍐呭銆傚鏋滄病鏈?/span>master.info瀛樺湪錛屽畠鎵嶅幓璇?/span>my.ini涓殑鐩稿叧閰嶇疆錛屽茍涓斾駭鐢熶竴涓?/span>master.info鏂囦歡銆傛墍浠ュ鏋滄兂閫氳繃my.ini鏉ユ洿鏀瑰凡鏈夌殑master淇℃伅錛屽繀欏誨厛鍏蟲帀mysql鏁版嵁搴擄紝鐒跺悗鍒犻櫎master.info鏂囦歡錛岀劧鍚庨噸鏂板惎鍔ㄣ?/span>