濡備綍鎺掓煡 AWS DMS 浠诲姟澶辫触骞舵樉绀衡€滃閿害鏉熷啿绐佲€濋敊璇殑闂锛?/h1>

涓婃鏇存柊鏃堕棿锛?019 骞?10 鏈?2 鏃?/i>

鎴戞湁涓€涓?AWS Database Migration Service (AWS DMS) 鐨勪换鍔″け璐ワ紝骞舵樉绀衡€滃閿害鏉熷啿绐佲€濋敊璇€備负浠€涔堜細鏀跺埌姝ら敊璇紝鍙堣濡備綍瑙ｅ喅姝ら棶棰橈紵

绠€鐭弿杩?/h2>

榛樿鎯呭喌涓嬶紝AWS DMS 浠诲姟浼氬湪瀹屾暣鍔犺浇闃舵涓€娆℃€у姞杞藉叓涓〃銆傞櫎闈炴偍涓轰换鍔￠厤缃簡鍔犺浇椤哄簭锛屽惁鍒欒繖浜涜〃灏嗛粯璁ゆ寜瀛楁瘝椤哄簭鍔犺浇銆傛湁鍏虫洿澶氫俊鎭紝璇峰弬闃?AWS Database Migration Service 閫氳繃澧炲姞骞惰瀹屾暣鍔犺浇鏀寔鍜屾柊鐨?LOB 杩佺Щ鏈哄埗鎻愰珮杩佺Щ閫熷害涓€鏂囦腑鐨?b>瀹屾暣鍔犺浇鏈熼棿鐨勮〃鍔犺浇椤哄簭閮ㄥ垎銆?/p>

濡傛灉鏈皢鍔犺浇椤哄簭閰嶇疆涓洪鍏堝姞杞界埗琛紝鍒欏彲鑳戒細鍦ㄧ埗琛ㄤ箣鍓嶅姞杞藉瓙琛ㄣ€傝繖灏嗕細瀵艰嚧浠诲姟澶辫触骞舵樉绀?b>澶栭敭绾︽潫鍐茬獊閿欒浠ュ強涓庝互涓嬬被浼肩殑鏃ュ織鏉＄洰锛?br />

娑堟伅
E: RetCode: SQL_ERROR SqlState: 0A000 NativeError: 1 Message: ERROR: cannot truncate a table referenced in a foreign key constraint; Error while executing the query (ar_odbc_stmt.c:4622)
E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 1217 Message: Cannot delete or update a parent row: a foreign key constraint fails (ar_odbc_stmt.c:4615)

鎸佺画澶嶅埗浣跨敤浜嬪姟搴旂敤妯″紡锛岃繖灏嗕細鎸夌収涓庢簮鐩稿悓鐨勬彁浜ら『搴忔墽琛屼簨鍔°€傚鏋滀换鍔″浜庢寔缁鍒堕樁娈碉紝鎮ㄥ彲浠ュ湪鐩爣涓婂惎鐢ㄥ閿害鏉熴€傚鏋滄寔缁鍒朵娇鐢?b>鎵归噺搴旂敤妯″紡锛屽垯蹇呴』绂佺敤澶栭敭锛屽嵆浣垮湪鏇存敼鏁版嵁鎹曡幏 (CDC) 闃舵涔熷繀闇€绂佺敤銆?/p>

瑙ｅ喅鏂规硶

瑕佽В鍐虫閿欒锛岃鎵ц浠ヤ笅浠讳綍涓€绉嶆搷浣滄柟娉曪細

绂佺敤澶栭敭绾︽潫 浣跨敤鍒犻櫎鐩爣涓婄殑琛?/b>妯″紡

绂佺敤澶栭敭绾︽潫

濡傛灉鐩爣鏄吋瀹?MySQL 鐨勬暟鎹簱锛屽垯鍙互浣跨敤棰濆鐨勮繛鎺ュ睘鎬?/a>鏉ョ鐢ㄥ閿害鏉燂細

initstmt=SET FOREIGN_KEY_CHECKS=0

濡傛灉鐩爣鏄吋瀹?PostgreSQL 鐨勬暟鎹簱锛屽垯鎮ㄥ彲鑳戒細鍦?CDC 闃舵鐪嬪埌澶栭敭鍐茬獊閿欒銆傝瑙ｅ喅姝ら敊璇紝璇峰皢 session_replication_role 鍙傛暟璁剧疆涓?b>澶嶅埗銆?/p>

瀵逛簬鍏朵粬鏁版嵁搴撳紩鎿庯紝璇锋墜鍔ㄧ鐢ㄦ垨鈥滃垹闄も€濆閿害鏉熴€?/p>

浣跨敤鈥滃垹闄ょ洰鏍囦笂鐨勮〃鈥濇ā寮?/b>

浣跨敤鍒犻櫎鐩爣涓婄殑琛?/b>妯″紡锛?a href="https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.FullLoad.html" target="_blank">DROP_AND_CREATE 鐩爣 璁剧疆锛夋椂锛孉WS DMS 灏嗕粎鍒涘缓鍦ㄧ洰鏍囦笂鎴愬姛鎵ц瀹屾暣鍔犺浇闇€瑕佺殑瀵硅薄銆備絾濡傛灉鎮ㄤ娇鐢?b>鍒犻櫎鐩爣涓婄殑琛?/b>妯″紡锛屽垯蹇呴』鎵嬪姩鍒涘缓 AWS DMS 鏈垱寤虹殑鍏朵粬瀵硅薄锛屼緥濡備簩绾х储寮曘€佹暟鎹粯璁ゅ€煎拰瑙﹀彂鏉′欢銆?/p>