| 澶辨晥閾炬帴澶勭悊 |
|
娣卞叆MySql瀹炴垬 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1pdjtckdjivEF2k6GI6SWQw
鎻愬彇鐮侊細mc94
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
錛堜竴錛塎GR鏄粈涔?/div>
錛堜竴錛塎GR鎻掍歡緇勬垚
錛堜簩錛夊崟涓繪ā寮?/div>
錛堜簩錛夌ず渚?/div>
1. MGR鐨勫畾涔?/div>
MGR鏄叿澶囧己澶х殑鍒嗗竷寮忓崗璋冭兘鍔涳紝鍙敤浜庡垱寤哄脊鎬с€侀珮鍙敤鎬с€侀珮瀹歸敊鐨勫鍒舵嫇鎵戠殑涓€涓狹ySQL鎻掍歡銆?/div>
2. 閫氳鍗忚
鍩轟簬Paxos綆楁硶鐨凣CS鍘熷瓙騫挎挱鍗忚錛屼繚璇佷簡涓€鏉′簨鍔″湪闆嗙兢鍐呰涔堝湪鍏ㄩ儴鑺傜偣涓婃彁浜わ紝瑕佷箞鍏ㄩ儴鍥炴粴銆?/div>
3. 緇勬垚鍛樿祫鏍?/div>
MGR鍐呴儴鎻愪緵涓€涓鍥炬湇鍔★紝闆嗙兢鑺傜偣涔嬮棿鐩鎬簰浜ゆ崲鍚勮嚜鐨勮鍥句俊鎭紝 浠庤€屼笖瀹炵幇闆嗙兢鏁翠綋鐨勭ǔ鎬併€?/div>
4. 鏁版嵁涓€鑷存€?/div>
MGR鍐呴儴瀹炵幇浜嗕竴濂椾笉鍚屼簨鍔′箣闂翠慨鏀規(guī)暟鎹殑鍐茬獊璁よ瘉媯€嫻嬫満鍒躲€傚湪闆嗙兢鐨勬墍鏈夎妭鐐瑰綋涓繘琛屼竴涓啿紿佽璇佹嫻嬶紝鍙?/div>
涔嬶紝閫氳繃鍐茬獊璁よ瘉媯€嫻嬬殑浜嬪姟鍗沖彲鎻愪氦鎴愬姛銆?/div>
褰撲竴涓簨鍔″彂璧鋒彁浜ゅ悗錛屽畠浼氶€氳繃鍘熷瓙騫挎挱鍗忚鍒嗗彂鍒伴泦緹ゅ叾浠朣econdary鑺傜偣銆傞泦緹ょ殑Secondary鑺傜偣閫氳繃鍐茬獊媯€嫻嬩箣
鍚庯紝浜嬪姟鎻愪氦鎴愬姛銆傚湪澶у鏁扮殑Secondary鑺傜偣鎻愪氦鎴愬姛涔嬪悗錛屼細鍦≒rimary鑺傜偣榪涜鎻愪氦銆?/div>
鍙嶄箣錛屽鏋滃湪鍐茬獊璁よ瘉媯€嫻嬪け璐ワ紝Secondary鑺傜偣浼氫涪寮冭繖孌典簨鍔″搴旂殑Binlog錛孭rimary鑺傜偣鍥炴粴璇ヤ簨鍔°€?/div>
涓婂浘鏄竴涓笁鑺傜偣鐨凪GR瀹炰緥闆嗙兢錛孧ember1浠ｈ〃Primary鑺傜偣錛孧ember2銆丮ember3浠ｈ〃Secondary鑺傜偣銆?/div>
濡備笂鍥炬墍紺猴紝MGR鎻掍歡浣跨敤 MySQL Server 涓?API 鎺ュ彛灞備互鍙婅嫢騫茬粍浠訛紝鏈€鍚庣敱GCS錛圙roup Communication System錛?/div>
鍗忚灝佽鑰屾垚銆?/div>
MySQL Server璋冪敤MGR鎻掍歡鏄熀浜嶮ySQL鐜版湁鐨勪富浠庡鍒訛紝鍒╃敤Row鏍煎紡鐨凚inlog鍜孏tid絳夊姛鑳藉疄鐜扮殑闆嗙兢鏋舵瀯銆?/div>
API鎺ュ彛灞傚鍒跺熀浜嶮ySQL Server浜や簰鐨勬帴鍙ｉ泦錛屽湪閫昏緫涓婂皢MySQL鍐呮牳涓嶮GR鎻掍歡闅旂粷寮€鏉ャ€傚叾浠栫粍浠朵緥濡侰apture
緇勪歡錛屽畠鏄礋璐ｄ簨鍔＄姸鎬佸湪闆嗙兢鍐呮彁浜ゆ垨鏄洖婊氾紝浠ュ強閫氳繃Binlog event騫挎挱鍒板叾浠栬妭鐐逛笂榪涜鐨勫啿紿佽璇佹嫻嬭繘琛屽埌鍝釜
闃舵銆侫pply緇勪歡浠ｈ〃MGR闆嗙兢Secondary鑺傜偣Binlog鍥炴斁錛孯ecovery緇勪歡浠ｈ〃榪涜宕╂簝鎭㈠鎴栭泦緹ゆ墿瀹規(guī)椂澧為噺鏁版嵁鐨?/div>
搴旂敤銆?/div>
ON琛ㄧず鍗曚富妯″紡錛屼篃鏄粯璁ゆā寮忥紝OFF琛ㄧず澶氫富妯″紡銆?/div>
濡備笅鍥炬墍紺猴紝鍦ㄥ崟涓繪ā寮忎笅錛坓roup_replication_single_primary_mode = ON錛?
1錛庤鍙橀噺鍦ㄦ墍鏈夌粍鎴愬憳涓繀欏昏緗負鐩稿悓鐨勫€鹼紝鍚屼竴涓粍涓紝涓嶈兘灝嗘垚鍛橀儴緗插湪涓嶅悓妯″紡涓€備緥濡傦紝涓€涓垚鍛橀厤緗負鍗曚富
妯″紡錛屽彟涓€涓垚鍛橀厤緗負澶氫富妯″紡銆?/div>
2錛庤闆嗙兢鍏鋒湁涓€涓緗負璇誨啓妯″紡鐨勪富鑺傜偣錛岀粍涓殑鎵€鏈夊叾浠栨垚鍛橀兘璁劇疆涓哄彧璇繪ā寮忥紙superread-only = ON錛夛紱
MGR鏋舵瀯鍒嗕負鍗曚富妯″紡鍜屽涓繪ā寮忋€?/div>
M
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
