鏁版嵁搴搒harding锛坰cale up to scale out锛
鏁版嵁搴搒harding锛坰cale up to scale out锛?
sharding鏄皢涓€涓ぇ鏁版嵁搴撴寜鐓т竴瀹氳鍒欐媶鍒嗘垚澶氫釜灏忔暟鎹簱鐨勪竴闂ㄦ妧鏈?
褰撴垜浠殑搴旂敤鏁版嵁閲忚秺鏉ヨ秺澶氾紝璁块棶閲忚秺鏉ヨ秺澶х殑鏃跺€欙紝鎴戜滑浼氫綔浣曢€夋嫨锛熺户缁彁鍗囨暟鎹簱鏈嶅姟鍣ㄧ殑鎬ц兘杩樻槸閲囩敤涓€椤规妧鏈鏁版嵁搴撳钩婊戞墿灞曪紵铏界劧浼撮殢鐫€鏈嶅姟鍣ㄧ殑鏇存柊鎹唬锛屾€ц兘瓒婃潵瓒婂ソ锛屾洿鎹㈡洿鍔犺豹鍗庣殑鏈嶅姟鍣ㄨ兘鏆傛椂瑙ｅ喅杩欎釜闂锛屼絾鏄棤璁烘槸浠庤姳璐瑰拰鍙帶閮芥棤娉曡浜烘弧鎰忋€傝繖鏃舵暟鎹簱sharding鏄竴涓洿鍔犲彲琛岀殑鏂规銆?
甯哥敤鐨剆harding鏂规鏈変互涓嬪嚑绉嶏紝
1銆傛寜鍔熻兘鍒掑垎锛堝瀭鐩村垏鍒嗭級
灏嗕笉鍚屽姛鑳界浉鍏崇殑琛ㄦ斁鍒颁笉鍚岀殑鏁版嵁搴撲腑锛岃濡傚皢鐢ㄦ埛绠＄悊鐩稿叧琛ㄦ斁鍒皊hard 1涓婏紝灏哹log鐩稿叧琛ㄦ斁鍒皊hard 2涓娿€傘€傘€傝繖鏍峰仛鐨勫ソ澶勬槸闈炲父鐩磋锛屽綋闇€瑕佺敤鎴峰垪琛ㄦ椂锛屾垜灏卞埌shard 1涓婅幏鍙栥€傘€傘€傘€傝繖鏍蜂篃鏈変竴涓棶棰橈紝褰撴煇涓€閮ㄥ垎鐨勫姛鑳藉叾鏁版嵁閲忔垨鎬ц兘瑕佹眰瓒呭嚭浜嗗彲鎺х殑鑼冨洿锛屾垜浠氨闇€瑕佺户缁鍏惰繘琛屾繁鍏ョ殑sharding銆?
2銆傛寜琛ㄤ腑鏌愪竴瀛楁鍊肩殑鑼冨洿鍒掑垎锛堟按骞冲垏鍒嗭級
褰撲即闅忕潃鏌愪竴涓〃鐨勬暟鎹噺瓒婃潵瓒婂ぇ锛屼互鑷充簬涓嶈兘鎵垮彈鐨勬椂鍊欙紝灏遍渶瑕佸濂硅繘琛岃繘涓€姝ョ殑鍒囧垎銆備竴绉嶉€夋嫨鏄牴鎹甼ey鐨勮寖鍥存潵鍋氬垏鍒嗭紝璀userID涓?-10000鐨勬斁鍒皊hard 10涓婏紝userID涓?0000鍒?0000鐨勬斁鍒皊hanrd 11涓娿€傘€傘€傝繖鏍风殑鎵╁睍灏辨槸鍙瑙佺殑銆傚彟涓€绉嶆槸鏍规嵁鏌愪竴瀛楁鍊煎緱鏉ュ垝鍒嗭紝璀鏍规嵁鐢ㄦ埛鍚嶇殑棣栧瓧姣嶏紝濡傛灉鏄痑-d锛屽氨灞炰簬shard 20锛宔-h灏卞睘浜巗hard 21銆傘€傘€傝繖鏍峰仛涔熷瓨鍦ㄤ笉鍧囪 鎬э紝褰撴煇涓寖鍥磋秴鍑轰簡shard鎵€鑳芥壙鍙楃殑鑼冨洿灏遍渶瑕佺户缁垏鍒嗐€傝繕鏈夋寜鏃ユ湡鍒囧垎绛夌瓑锛?
3銆傚熀浜巋ash鐨勫垏鍒?
绫讳技浜巑emcached鐨刱ey hash绠楁硶锛屼竴寮€濮嬬‘瀹氬垏鍒嗘暟鎹簱鐨勪釜鏁帮紝閫氳繃hash鍙栨ā鏉ュ喅瀹氫娇鐢ㄥ摢鍙皊hard銆傝繖绉嶆柟娉曡兘澶熷钩鍧囩殑鏉ュ垎閰嶆暟鎹紝浣嗘槸浼撮殢鐫€鏁版嵁閲忕殑澧炲ぇ锛岄渶瑕佽繘琛屾墿灞曠殑鏃跺€欙紝杩欑鏂瑰紡鏃犳硶鍋氬埌鍦ㄧ嚎鎵╁銆傛瘡澧炲姞鑺傜偣鐨勬椂鍊欙紝灏遍渶瑕佸hash绠楁硶閲嶆柊杩愮畻锛屾暟鎹渶瑕侀噸鏂板壊鎺ャ€?
4銆傚熀浜庤矾鐢辫〃鐨勫垏鍒?
鍓嶉潰鐨勫嚑绉嶆柟寮忛兘鏄窡鎹簲鐢ㄧ殑鏁版嵁鏉ュ喅瀹氭搷浣滅殑shard锛屽熀浜庤矾鐢辫〃鐨勫垏鍒嗘槸涓€绉嶆洿鍔犳澗鏁ｇ殑鏂规硶銆傚畠鍗曠嫭缁存姢涓€寮犺矾鐢辫〃锛屾牴鎹敤鎴风殑鏌愪竴灞炴€ф潵鏌ユ壘璺敱琛ㄥ喅瀹氫娇鐢ㄥ摢涓猻hard锛岃繖绉嶆柟寮忔槸涓€绉嶆洿鍔犻€氱敤鐨勬柟妗堛€傝濡傛垜浠湪绯荤粺涓淮鎶や竴寮犺〃-锛堢敤鎴锋墍灞炵渷-銆塻hard锛夛紝杩欐牱姣忎釜鐢ㄦ埛鎴戜滑鐭ラ亾鏄摢涓渷鐨勶紝鍘昏矾鐢辫〃鏌ユ壘锛屽氨鐭ラ亾瀹冩墍鍦ㄧ殑shard銆傚洜涓烘瘡娆℃暟鎹搷浣滅殑鏃跺€欓兘闇€瑕佽繘琛岃矾鐢辩殑鏌ユ壘锛屾墍浠ュ皢杩欎簺鍐呭瀛樺偍鍒颁竴鍙扮嫭绔媍ache涓婃槸涓€涓潪甯稿ソ鐨勬柟寮忥紝璀memcached銆傝繖绉嶅垏鍒嗙殑鏂瑰紡鍚屾椂涔熷甫鏉ヤ簡鍙︿竴涓ソ澶勶紝褰撻渶瑕佸鍔爏hard鐨勬椂鍊欙紝鍙互鍦ㄤ笉褰卞搷鍦ㄧ嚎搴旂敤鐨勬儏鍐典笅鏉ユ墽琛岋紝褰撶劧杩欎篃璺熷簲鐢ㄧ▼搴忕殑鏋舵瀯璁捐鐩稿叧锛屼綘鐨勮璁″繀椤婚€傜敤杩欑澧炲姞銆?
铏界劧搴旂敤sharding浼氬甫鏉ユ樉鑰屾槗瑙佺殑濂藉锛屼絾鏄畠涔熸湁涓€浜涘浐鏈夌殑闂闇€瑕佹垜浠簡瑙ｏ紝杩欎簺闂澶ц嚧鍒嗘垚浠ヤ笅鍑犵被锛?
1銆俿hard鐨勬墿瀹?
褰撳綋鍓嶇殑shard宸茬粡涓嶈兘閫傜敤褰撳墠鐨勫簲鐢ㄩ渶姹傛椂锛屽氨闇€瑕佸shard鏁版嵁搴撹繘琛屾墿瀹癸紝澧炲姞shard鎰忓懗鐫€闇€瑕佸鍘熸湁鐨剆hard鏁版嵁杩涜杩佺Щ锛岃繖涓繃绋嬫槸闈炲父澶嶆潅锛岃€屼笖鍙兘浼氬鑷存暟鎹殑涓嶄竴鑷达紙涓€杈瑰啓銆佷竴杈硅縼绉伙級鎴栬€呭叾浠栧簲鐢ㄩ棶棰橈紝鍥犳鎵╁涓€鑸€夋嫨鍦ㄥ噷鏅ㄧ瓑鏃堕棿杩涜銆?
2銆傝仈鍚堝涓猻hard鐨勮〃鏁版嵁鏌ヨ
杩欎釜鏄痵hard鍥烘湁鐨勯棶棰橈紝褰撻亣鍒拌繖鏍风殑闂鏃讹紝浣犻渶瑕佽幏鍙栧悇涓猻hard鐨勬暟鎹紝鐒跺悗瀵硅繖浜涙暟鎹繘琛屾眹鎬伙紝寰堝鏃跺€欏洜涓虹幇鍦ㄧ殑缃戠粶閫熷害姣旇緝鍙戣揪杩欎釜闂鍙互鍑犱箮琚拷鐣ユ帀銆備絾鏄鏋滆杩涜鏁版嵁鐨勫垎鏋愭垨鎸栨帢锛宻hard灏变細瀛樺湪闂锛岄€氬父闈㈠杩欑瀵逛簬鏁版嵁瑕佹眰涓嶆槸閭ｄ箞瀹炴椂鐨勬儏鍐典笅锛屽彲浠ラ噰鐢ㄥ皢shard鏁版嵁鍚屾鍒版眹鎬绘暟鎹簱鐨勬柟妗堬紝olap鍙互鍦ㄨ繖鍙版眹鎬绘暟鎹簱涓婅繘琛岋紝杩欏氨闇€瑕佸湪姣忓彴shard涓婅繘琛屾暟鎹殑瀹氭椂鍚屾锛岃繖澧炲姞浜嗙▼搴忕殑澶嶆潅鎬э紱濡傛灉瑕佹眰瀹炴椂鐨勬儏鍐典笅锛岄噰鐢╯harding鏂规浼氭槸涓€涓瘉鐏€ф墦鍑汇€?
3銆傚叾浠?
鎴戜滑鐜板湪鍋氱殑绯荤粺灏辨槸閲囩敤鐨勬寜鐓ц矾鐢辫〃鍒囧垎鐨剆harding鏂规锛岃€屼笖鎴戜滑闇€瑕佽姹備笉鏄偅涔堝疄鏃剁殑姹囨€绘暟鎹互鎻愪緵鏁版嵁鐨勫垎鏋愬拰鎸栨帢锛屽悓鏃舵垜浠殑鍩虹鏁版嵁閮芥槸鍦ㄦ眹鎬绘暟鎹簱涓繘琛岀鐞嗭紝閫氳繃oracle鐨勯珮绾у鍒跺埌shard鑺傜偣涓娿€傚湪shard鏁版嵁搴撳悜姹囨€绘暟鎹簱鍚屾鏁版嵁鐨勬椂鍊欙紝鎴戜滑鏄€氳繃oracle鏁版嵁搴撶殑瀛樺偍杩囩▼瀹炵幇鐨勶紝杩欑鏋舵瀯鏂瑰紡瀵艰嚧浜嗘暟鎹簱闈炲父鐨勫鏉傦紝鍚屾椂杩樺瓨鍦ㄤ簡涓€浜涘叾浠栭棶棰橈紝璀鍚屾浼氭棤缂樻棤鏁呯殑鏂帀銆傘€傘€傝繖灏遍渶瑕侀噰鐢ㄤ竴浜涘叾浠栨墜娈垫潵缁存寔鏁版嵁鐨勫欢杩熶竴鑷存€с€?
鎴戜滑鐨剆harding杩樺湪鏀硅繘锛屾垜浠殑shard杩樺湪澧炲姞锛屾垜浠繕闇€瑕佷笉鏂姫鍔涗娇鎴戜滑鐨勫簲鐢ㄦ洿鍔犻珮鏁堛€?
鏈夋椂鍊欒寰楁垜浠殑绀句細灏卞儚涓€涓法澶х殑澶氬眰sharding鏂规锛屼腑澶€佺渷锛堣嚜娌诲尯锛夈€佸競銆傘€傘€?
-------------------------------------------------------------
杩樻湁涓€绉嶆暟鎹簱鏂规鏄痬aster-slave锛屼竴鍙癿aster涓昏璐熻矗鏁版嵁鐨勬洿鏂帮紝鐒跺悗閫氳繃楂樼骇澶嶅埗绛夋墜娈靛皢鏁版嵁澶嶅埗鍒板悇涓猻lave鑺傜偣锛宻lave鑺傜偣璐熻矗鏌ヨ銆傝繖绉嶇粨鏋勬槸涓嶇master鍜宻lave閮芥嫢鏈夊叏閮ㄧ殑鏁版嵁锛宮aster鍒皊lave鐨勬暟鎹瓨鍦ㄤ竴瀹氱殑寤惰繜銆傚彲浠ヨ窡sharding鏂规缁撳悎浣跨敤銆?
sharding鏄皢涓€涓ぇ鏁版嵁搴撴寜鐓т竴瀹氳鍒欐媶鍒嗘垚澶氫釜灏忔暟鎹簱鐨勪竴闂ㄦ妧鏈?
褰撴垜浠殑搴旂敤鏁版嵁閲忚秺鏉ヨ秺澶氾紝璁块棶閲忚秺鏉ヨ秺澶х殑鏃跺€欙紝鎴戜滑浼氫綔浣曢€夋嫨锛熺户缁彁鍗囨暟鎹簱鏈嶅姟鍣ㄧ殑鎬ц兘杩樻槸閲囩敤涓€椤规妧鏈鏁版嵁搴撳钩婊戞墿灞曪紵铏界劧浼撮殢鐫€鏈嶅姟鍣ㄧ殑鏇存柊鎹唬锛屾€ц兘瓒婃潵瓒婂ソ锛屾洿鎹㈡洿鍔犺豹鍗庣殑鏈嶅姟鍣ㄨ兘鏆傛椂瑙ｅ喅杩欎釜闂锛屼絾鏄棤璁烘槸浠庤姳璐瑰拰鍙帶閮芥棤娉曡浜烘弧鎰忋€傝繖鏃舵暟鎹簱sharding鏄竴涓洿鍔犲彲琛岀殑鏂规銆?
甯哥敤鐨剆harding鏂规鏈変互涓嬪嚑绉嶏紝
1銆傛寜鍔熻兘鍒掑垎锛堝瀭鐩村垏鍒嗭級
灏嗕笉鍚屽姛鑳界浉鍏崇殑琛ㄦ斁鍒颁笉鍚岀殑鏁版嵁搴撲腑锛岃濡傚皢鐢ㄦ埛绠＄悊鐩稿叧琛ㄦ斁鍒皊hard 1涓婏紝灏哹log鐩稿叧琛ㄦ斁鍒皊hard 2涓娿€傘€傘€傝繖鏍峰仛鐨勫ソ澶勬槸闈炲父鐩磋锛屽綋闇€瑕佺敤鎴峰垪琛ㄦ椂锛屾垜灏卞埌shard 1涓婅幏鍙栥€傘€傘€傘€傝繖鏍蜂篃鏈変竴涓棶棰橈紝褰撴煇涓€閮ㄥ垎鐨勫姛鑳藉叾鏁版嵁閲忔垨鎬ц兘瑕佹眰瓒呭嚭浜嗗彲鎺х殑鑼冨洿锛屾垜浠氨闇€瑕佺户缁鍏惰繘琛屾繁鍏ョ殑sharding銆?
2銆傛寜琛ㄤ腑鏌愪竴瀛楁鍊肩殑鑼冨洿鍒掑垎锛堟按骞冲垏鍒嗭級
褰撲即闅忕潃鏌愪竴涓〃鐨勬暟鎹噺瓒婃潵瓒婂ぇ锛屼互鑷充簬涓嶈兘鎵垮彈鐨勬椂鍊欙紝灏遍渶瑕佸濂硅繘琛岃繘涓€姝ョ殑鍒囧垎銆備竴绉嶉€夋嫨鏄牴鎹甼ey鐨勮寖鍥存潵鍋氬垏鍒嗭紝璀userID涓?-10000鐨勬斁鍒皊hard 10涓婏紝userID涓?0000鍒?0000鐨勬斁鍒皊hanrd 11涓娿€傘€傘€傝繖鏍风殑鎵╁睍灏辨槸鍙瑙佺殑銆傚彟涓€绉嶆槸鏍规嵁鏌愪竴瀛楁鍊煎緱鏉ュ垝鍒嗭紝璀鏍规嵁鐢ㄦ埛鍚嶇殑棣栧瓧姣嶏紝濡傛灉鏄痑-d锛屽氨灞炰簬shard 20锛宔-h灏卞睘浜巗hard 21銆傘€傘€傝繖鏍峰仛涔熷瓨鍦ㄤ笉鍧囪 鎬э紝褰撴煇涓寖鍥磋秴鍑轰簡shard鎵€鑳芥壙鍙楃殑鑼冨洿灏遍渶瑕佺户缁垏鍒嗐€傝繕鏈夋寜鏃ユ湡鍒囧垎绛夌瓑锛?
3銆傚熀浜巋ash鐨勫垏鍒?
绫讳技浜巑emcached鐨刱ey hash绠楁硶锛屼竴寮€濮嬬‘瀹氬垏鍒嗘暟鎹簱鐨勪釜鏁帮紝閫氳繃hash鍙栨ā鏉ュ喅瀹氫娇鐢ㄥ摢鍙皊hard銆傝繖绉嶆柟娉曡兘澶熷钩鍧囩殑鏉ュ垎閰嶆暟鎹紝浣嗘槸浼撮殢鐫€鏁版嵁閲忕殑澧炲ぇ锛岄渶瑕佽繘琛屾墿灞曠殑鏃跺€欙紝杩欑鏂瑰紡鏃犳硶鍋氬埌鍦ㄧ嚎鎵╁銆傛瘡澧炲姞鑺傜偣鐨勬椂鍊欙紝灏遍渶瑕佸hash绠楁硶閲嶆柊杩愮畻锛屾暟鎹渶瑕侀噸鏂板壊鎺ャ€?
4銆傚熀浜庤矾鐢辫〃鐨勫垏鍒?
鍓嶉潰鐨勫嚑绉嶆柟寮忛兘鏄窡鎹簲鐢ㄧ殑鏁版嵁鏉ュ喅瀹氭搷浣滅殑shard锛屽熀浜庤矾鐢辫〃鐨勫垏鍒嗘槸涓€绉嶆洿鍔犳澗鏁ｇ殑鏂规硶銆傚畠鍗曠嫭缁存姢涓€寮犺矾鐢辫〃锛屾牴鎹敤鎴风殑鏌愪竴灞炴€ф潵鏌ユ壘璺敱琛ㄥ喅瀹氫娇鐢ㄥ摢涓猻hard锛岃繖绉嶆柟寮忔槸涓€绉嶆洿鍔犻€氱敤鐨勬柟妗堛€傝濡傛垜浠湪绯荤粺涓淮鎶や竴寮犺〃-锛堢敤鎴锋墍灞炵渷-銆塻hard锛夛紝杩欐牱姣忎釜鐢ㄦ埛鎴戜滑鐭ラ亾鏄摢涓渷鐨勶紝鍘昏矾鐢辫〃鏌ユ壘锛屽氨鐭ラ亾瀹冩墍鍦ㄧ殑shard銆傚洜涓烘瘡娆℃暟鎹搷浣滅殑鏃跺€欓兘闇€瑕佽繘琛岃矾鐢辩殑鏌ユ壘锛屾墍浠ュ皢杩欎簺鍐呭瀛樺偍鍒颁竴鍙扮嫭绔媍ache涓婃槸涓€涓潪甯稿ソ鐨勬柟寮忥紝璀memcached銆傝繖绉嶅垏鍒嗙殑鏂瑰紡鍚屾椂涔熷甫鏉ヤ簡鍙︿竴涓ソ澶勶紝褰撻渶瑕佸鍔爏hard鐨勬椂鍊欙紝鍙互鍦ㄤ笉褰卞搷鍦ㄧ嚎搴旂敤鐨勬儏鍐典笅鏉ユ墽琛岋紝褰撶劧杩欎篃璺熷簲鐢ㄧ▼搴忕殑鏋舵瀯璁捐鐩稿叧锛屼綘鐨勮璁″繀椤婚€傜敤杩欑澧炲姞銆?
铏界劧搴旂敤sharding浼氬甫鏉ユ樉鑰屾槗瑙佺殑濂藉锛屼絾鏄畠涔熸湁涓€浜涘浐鏈夌殑闂闇€瑕佹垜浠簡瑙ｏ紝杩欎簺闂澶ц嚧鍒嗘垚浠ヤ笅鍑犵被锛?
1銆俿hard鐨勬墿瀹?
褰撳綋鍓嶇殑shard宸茬粡涓嶈兘閫傜敤褰撳墠鐨勫簲鐢ㄩ渶姹傛椂锛屽氨闇€瑕佸shard鏁版嵁搴撹繘琛屾墿瀹癸紝澧炲姞shard鎰忓懗鐫€闇€瑕佸鍘熸湁鐨剆hard鏁版嵁杩涜杩佺Щ锛岃繖涓繃绋嬫槸闈炲父澶嶆潅锛岃€屼笖鍙兘浼氬鑷存暟鎹殑涓嶄竴鑷达紙涓€杈瑰啓銆佷竴杈硅縼绉伙級鎴栬€呭叾浠栧簲鐢ㄩ棶棰橈紝鍥犳鎵╁涓€鑸€夋嫨鍦ㄥ噷鏅ㄧ瓑鏃堕棿杩涜銆?
2銆傝仈鍚堝涓猻hard鐨勮〃鏁版嵁鏌ヨ
杩欎釜鏄痵hard鍥烘湁鐨勯棶棰橈紝褰撻亣鍒拌繖鏍风殑闂鏃讹紝浣犻渶瑕佽幏鍙栧悇涓猻hard鐨勬暟鎹紝鐒跺悗瀵硅繖浜涙暟鎹繘琛屾眹鎬伙紝寰堝鏃跺€欏洜涓虹幇鍦ㄧ殑缃戠粶閫熷害姣旇緝鍙戣揪杩欎釜闂鍙互鍑犱箮琚拷鐣ユ帀銆備絾鏄鏋滆杩涜鏁版嵁鐨勫垎鏋愭垨鎸栨帢锛宻hard灏变細瀛樺湪闂锛岄€氬父闈㈠杩欑瀵逛簬鏁版嵁瑕佹眰涓嶆槸閭ｄ箞瀹炴椂鐨勬儏鍐典笅锛屽彲浠ラ噰鐢ㄥ皢shard鏁版嵁鍚屾鍒版眹鎬绘暟鎹簱鐨勬柟妗堬紝olap鍙互鍦ㄨ繖鍙版眹鎬绘暟鎹簱涓婅繘琛岋紝杩欏氨闇€瑕佸湪姣忓彴shard涓婅繘琛屾暟鎹殑瀹氭椂鍚屾锛岃繖澧炲姞浜嗙▼搴忕殑澶嶆潅鎬э紱濡傛灉瑕佹眰瀹炴椂鐨勬儏鍐典笅锛岄噰鐢╯harding鏂规浼氭槸涓€涓瘉鐏€ф墦鍑汇€?
3銆傚叾浠?
鎴戜滑鐜板湪鍋氱殑绯荤粺灏辨槸閲囩敤鐨勬寜鐓ц矾鐢辫〃鍒囧垎鐨剆harding鏂规锛岃€屼笖鎴戜滑闇€瑕佽姹備笉鏄偅涔堝疄鏃剁殑姹囨€绘暟鎹互鎻愪緵鏁版嵁鐨勫垎鏋愬拰鎸栨帢锛屽悓鏃舵垜浠殑鍩虹鏁版嵁閮芥槸鍦ㄦ眹鎬绘暟鎹簱涓繘琛岀鐞嗭紝閫氳繃oracle鐨勯珮绾у鍒跺埌shard鑺傜偣涓娿€傚湪shard鏁版嵁搴撳悜姹囨€绘暟鎹簱鍚屾鏁版嵁鐨勬椂鍊欙紝鎴戜滑鏄€氳繃oracle鏁版嵁搴撶殑瀛樺偍杩囩▼瀹炵幇鐨勶紝杩欑鏋舵瀯鏂瑰紡瀵艰嚧浜嗘暟鎹簱闈炲父鐨勫鏉傦紝鍚屾椂杩樺瓨鍦ㄤ簡涓€浜涘叾浠栭棶棰橈紝璀鍚屾浼氭棤缂樻棤鏁呯殑鏂帀銆傘€傘€傝繖灏遍渶瑕侀噰鐢ㄤ竴浜涘叾浠栨墜娈垫潵缁存寔鏁版嵁鐨勫欢杩熶竴鑷存€с€?
鎴戜滑鐨剆harding杩樺湪鏀硅繘锛屾垜浠殑shard杩樺湪澧炲姞锛屾垜浠繕闇€瑕佷笉鏂姫鍔涗娇鎴戜滑鐨勫簲鐢ㄦ洿鍔犻珮鏁堛€?
鏈夋椂鍊欒寰楁垜浠殑绀句細灏卞儚涓€涓法澶х殑澶氬眰sharding鏂规锛屼腑澶€佺渷锛堣嚜娌诲尯锛夈€佸競銆傘€傘€?
-------------------------------------------------------------
杩樻湁涓€绉嶆暟鎹簱鏂规鏄痬aster-slave锛屼竴鍙癿aster涓昏璐熻矗鏁版嵁鐨勬洿鏂帮紝鐒跺悗閫氳繃楂樼骇澶嶅埗绛夋墜娈靛皢鏁版嵁澶嶅埗鍒板悇涓猻lave鑺傜偣锛宻lave鑺傜偣璐熻矗鏌ヨ銆傝繖绉嶇粨鏋勬槸涓嶇master鍜宻lave閮芥嫢鏈夊叏閮ㄧ殑鏁版嵁锛宮aster鍒皊lave鐨勬暟鎹瓨鍦ㄤ竴瀹氱殑寤惰繜銆傚彲浠ヨ窡sharding鏂规缁撳悎浣跨敤銆?