涓€銆佷簯鏈嶅姟鐜鍑嗗
閫夋嫨浜戞湇鍔″晢鏃堕渶璇勪及璁＄畻璧勬簮銆佸瓨鍌ㄧ被鍨嬪拰缃戠粶鎬ц兘锛屼富娴佸钩鍙板闃块噷浜戙€丄WS鍧囨彁渚涗笓灞炴暟鎹簱瀹炰緥绫诲瀷銆傚缓璁牴鎹笟鍔¤妯￠€夋嫨4鏍?G浠ヤ笂閰嶇疆锛屽苟鍚敤SSD浜戠洏淇濋殰IO鎬ц兘銆?/p>
浜屻€佹暟鎹簱閮ㄧ讲涓庡畨鍏ㄩ厤缃?/h2>
閫氳繃yum/apt-get瀹夎MySQL 8.0鎴朠ostgreSQL 14绛夋柊鐗堟暟鎹簱锛屽缓璁噰鐢ㄥ畼鏂逛粨搴撹幏鍙栨渶鏂板畨鍏ㄨˉ涓併€傚畬鎴愬熀纭€瀹夎鍚庨渶鎵ц浠ヤ笅鍏抽敭閰嶇疆锛?/p>
- 淇敼榛樿鐩戝惉鍦板潃涓哄唴缃慖P
- 鍒涘缓鐙珛鏁版嵁搴撹处鎴峰苟璁剧疆寮哄瘑鐮佺瓥鐣?/li>
- 鍚敤SSL鍔犲瘑浼犺緭鍗忚
GRANT SELECT,INSERT ON dbname.* TO \'appuser\'@\'192.168.1.%\';
涓夈€丼QL鎬ц兘浼樺寲绛栫暐
閫氳繃EXPLAIN鍒嗘瀽鎵ц璁″垝锛岃瘑鍒叏琛ㄦ壂鎻忕瓑浣庢晥鎿嶄綔銆傚缓绔嬪鍚堢储寮曟椂搴旈伒寰渶宸﹀墠缂€鍘熷垯锛屽畾鏈熶娇鐢∣PTIMIZE TABLE鏁寸悊琛ㄧ鐗囥€?/p>
鍥涖€侀珮鍙敤鏋舵瀯璁捐
閲囩敤涓讳粠澶嶅埗鏋舵瀯瀹炵幇璇诲啓鍒嗙锛岄€氳繃ProxySQL涓棿浠惰嚜鍔ㄨ矾鐢辨煡璇㈣姹傘€傚浜嶵B绾ф暟鎹噺寤鸿閲囩敤鍒嗗簱鍒嗚〃鏂规锛屾寜涓氬姟缁村害杩涜姘村钩鎷嗗垎銆?/p>
浜斻€佺洃鎺т笌缁存姢鏈哄埗
閮ㄧ讲Prometheus+Granfana鐩戞帶浣撶郴锛岄噸鐐硅窡韪猀PS銆佽繛鎺ユ睜浣跨敤鐜囥€佹參鏌ヨ鍗犳瘮绛夋寚鏍囥€傚埗瀹氭瘡鏃ュ浠界瓥鐣ュ苟瀹氭湡楠岃瘉鎭㈠娴佺▼锛屾帹鑽愰噰鐢▁trabackup瀹炵幇鐑浠姐€?/p>
- 璁剧疆鎱㈡煡璇㈤槇鍊硷紙>500ms锛?/li>
- 姣忓懆鎵цANALYZE TABLE鏇存柊缁熻淇℃伅
- 鎸夋湀杞浆浜岃繘鍒舵棩蹇?/li>
閫氳繃鍩虹璁炬柦浼樺寲銆佸畨鍏ㄥ姞鍥恒€佹煡璇㈣皟浼樺拰鏋舵瀯鎵╁睍鐨勫缁村害瀹炶返锛屽彲鏋勫缓鍑烘敮鎾戠櫨涓囩骇骞跺彂鐨勯珮鎬ц兘浜戞暟鎹簱浣撶郴銆傚缓璁粨鍚堜笟鍔＄壒寰佹寔缁繘琛屽帇鍔涙祴璇曪紝鍔ㄦ€佽皟鏁磋祫婧愰厤缃柟妗堛€?/p>
