{"id":21457,"date":"2017-12-26T20:53:13","date_gmt":"2017-12-26T11:53:13","guid":{"rendered":"https:\/\/jirak.net\/wp\/amazon-aurora-%eb%82%b4%eb%b6%80-%eb%93%a4%ec%97%ac%eb%8b%a4%eb%b3%b4%ea%b8%b05-fast-ddl\/"},"modified":"2017-12-26T21:35:34","modified_gmt":"2017-12-26T12:35:34","slug":"amazon-aurora-%eb%82%b4%eb%b6%80-%eb%93%a4%ec%97%ac%eb%8b%a4%eb%b3%b4%ea%b8%b05-fast-ddl","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/amazon-aurora-%eb%82%b4%eb%b6%80-%eb%93%a4%ec%97%ac%eb%8b%a4%eb%b3%b4%ea%b8%b05-fast-ddl\/","title":{"rendered":"Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL"},"content":{"rendered":"<p>Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jirak.net\/wp\/wp-content\/uploads\/2017\/12\/TableComparison.png\" width=\"1572\" height=\"642\"><\/p>\n<p><i>\uc774 \uae00\uc740 AWS Database Blog\uc758 <a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/database\/amazon-aurora-under-the-hood-fast-ddl\/\">Amazon Aurora Under the Hood: Fast DDL<\/a> \uc758 \ud55c\uad6d\uc5b4 \ubc88\uc5ed\uc73c\ub85c AWS\ucf54\ub9ac\uc544\uc758 \uc548\ud6a8\ube48 \uc194\ub8e8\uc158\uc988 \uc544\ud0a4\ud14d\ud2b8\uac00 \ubc88\uc5ed\ud574 \uc8fc\uc168\uc2b5\ub2c8\ub2e4.<\/i><\/p>\n<p><a href=\"https:\/\/aws.amazon.com\/rds\/aurora\/\">Amazon Aurora<\/a>\ub294 MySQL\uacfc \ud638\ud658\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uace0\uc131\ub2a5 \uc0c1\uc6a9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc18d\ub3c4\uc640 \uac00\uc6a9\uc131\uc744 \uc624\ud508 \uc18c\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub2e8\uc21c\uc131, \ube44\uc6a9 \ud6a8\uc728\uc131\uacfc \uacb0\ud569\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \uc5b4\ub5bb\uac8c Amazon Aurora\uac00 MySQL\uc5d0\uc11c \uba87 \uc2dc\uac04\uc774 \uac78\ub9ac\ub358 \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL)\ubb38\uc744 \uc989\uac01\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \ud604\uc7ac Lab mode\uc5d0\uc11c \uac00\ub2a5\ud558\uba70 Aurora \ubc84\uc804 1.12 \uc774\uc0c1\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<p><b><u>\ube60\ub978<\/u><u> DDL<\/u><u>\uc774\ub780<\/u><u> <\/u><u>\ubb34\uc5c7\uc774\uba70<\/u><u>, <\/u><u>\uc774\uac83\uc774<\/u><u> <\/u><u>\uc65c<\/u><u> <\/u><u>\uc911\uc694\ud569\ub2c8\uae4c<\/u><u>?<\/u><\/b><br \/> \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubcc0\uacbd\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \ucffc\ub9ac \uc6cc\ud06c\ub85c\ub4dc \ubcc0\uacbd\uc5d0 \ub530\ub77c \uc778\ub371\uc2a4\ub97c \ucd94\uac00 \ud639\uc740 \uc0ad\uc81c(drop)\ud574\uc57c \ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ud615\uc2dd(format) \ubcc0\uacbd\uc5d0 \ub530\ub77c \uae30\uc874 \uc5f4(column)\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubcc0\uacbd\uc740 \uc790\uc8fc \uc77c\uc5b4\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Ruby on Rails \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc9c0\uc6d0\ud558\ub294 \uc77c\ubd80 DBA\ub294 \ub9e4\uc8fc \uc218\uc2ed \uac1c\uc758 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud55c\ub2e4\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<p>\ubaa8\ub4e0 MySQL DBA\uac00 \uc54c\uace0 \uc788\ub4ef\uc774 \uc774\ub7ec\ud55c \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc740 \uc6b4\uc601 \uc2dc\uc2a4\ud15c\uc744 \ubc29\ud574\ud558\uac8c \ub418\uace0 \uba87 \uc2dc\uac04\uc5d0\uc11c \uba70\uce60\uc774 \uac78\ub9b4 \uc815\ub3c4\ub85c \ub290\ub9bd\ub2c8\ub2e4. \uac8c\ub2e4\uac00 \uc2dc\uc2a4\ud15c \uc790\uc6d0(resource)\uc744 \uc18c\ubaa8\ud558\uace0, \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc2e4\uc81c \ucc98\ub9ac\ub7c9\uc740 \uac10\uc18c\ud569\ub2c8\ub2e4. \uc7a5\uc2dc\uac04 \uc2e4\ud589\ub418\ub294 \uc791\uc5c5\uc740 \ubcf5\uad6c \uc2dc\uac04\uc744 \uc9c0\uc5f0 \uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4 . DDL \uc791\uc5c5 \uc77c\ubd80\ub294 \uc4f0\uae30 \uc7a0\uae08\uc774 \ud544\uc694\ud558\ubbc0\ub85c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc77c\ubd80\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \ubb38\uc81c\ub3c4 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc784\uc2dc \uacf5\uac04\uc774 \ub9ce\uc774 \ud544\uc694\ud558\uac8c \ub418\uc5b4 \uc791\uc740 \uc778\uc2a4\ud134\uc2a4\uc758 \uacbd\uc6b0\ub294 \ub514\uc2a4\ud06c\uac00 \ubd80\uc871\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc6b0\ub9ac\ub294 \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 DDL \uc791\uc5c5\ubd80\ud130 \uc2dc\uc791\ud569\ub2c8\ub2e4: \ud14c\uc774\ube14 \ub9c8\uc9c0\ub9c9\uc5d0 null \ud5c8\uc6a9(nullable) \uc5f4(column)\uc744 \ucd94\uac00\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p><b><u>\uc65c<\/u><u> <\/u><u>\ud604\uc7ac\uc758<\/u><u> <\/u><u>\uc811\uadfc<\/u><u> <\/u><u>\ubc29\ubc95\uc774<\/u><u> <\/u><u>\uc5b4\ub824\uc6b4\uac00<\/u><u>?<\/u><\/b><br \/> MySQL\uc774 \ud14c\uc774\ube14 \ub9c8\uc9c0\ub9c9\uc5d0 null \ud5c8\uc6a9 \uc5f4\uc744 \ucd94\uac00\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br \/> \ub2e4\uc74c\uc740 MySQL\uc758 \uc791\uc5c5 \uc21c\uc11c\uc785\ub2c8\ub2e4:<\/p>\n<ol>\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud2b8\ub79c\uc7ad\uc158 \uc900\ube44 \ub2e8\uacc4\uc5d0\uc11c \uae30\uc874 \ud14c\uc774\ube14\uc5d0 \ub300\ud558\uc5ec exclusive lock\uc744 \uc124\uc815\ud569\ub2c8\ub2e4 .<\/li>\n<li>\uc6d0\ud558\ub294 \uc2a4\ud0a4\ub9c8\ub85c \ube48 \ud14c\uc774\ube14 \uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc778\ub371\uc2a4\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\uba74\uc11c \ud55c \ubc88\uc5d0 \ud55c \ud589(row)\uc529 \ubcf5\uc0ac\ud569\ub2c8\ub2e4. \uc774 \uc2dc\uac04 \ub3d9\uc548 \ubc1c\uc0dd\ud558\ub294 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4(Concurrent DML)\ubb38\uc740 \uc784\uc2dc \ud30c\uc77c\uc5d0 \uae30\ub85d\ub429\ub2c8\ub2e4.<\/li>\n<li>\uc2e0\uaddc \ud14c\uc774\ube14\uc5d0 exclusive lock\uc744 \uc124\uc815\ud55c \ub4a4 \uc784\uc2dc \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud55c DML\uc791\uc5c5\uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4. \ub9cc\uc57d \uc801\uc6a9 \ud560 \uc791\uc5c5\uc774 \ub9ce\uc740 \uacbd\uc6b0 \ud504\ub85c\uc138\uc2a4\uc5d0 \ub2e4\uc18c \uc2dc\uac04\uc774 \uac78\ub9bd\ub2c8\ub2e4.<\/li>\n<li>\uadf8\ub7f0 \ub2e4\uc74c \uc6d0\ubcf8 \ud14c\uc774\ube14\uc744 \uc0ad\uc81c\ud558\uace0 \uc0c8 \ud14c\uc774\ube14\uc744 \uc6d0\ub798 \ud14c\uc774\ube14\uba85\uc73c\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc5ec\uae30\uc5d0\ub294 lock\uacfc \ub370\uc774\ud130 \ubcf5\uc81c\uc640 \uc778\ub371\uc2a4 \uad6c\uc131\uc5d0 \ub530\ub978 \uc624\ubc84\ud5e4\ub4dc, I\/O \ubc0f \ud65c\uc131 \ud14c\uc774\ube14\uc758 \uc784\uc2dc \uacf5\uac04 \ub4f1\uc774 \ub9ce\uc774 \uc18c\ubaa8\ub429\ub2c8\ub2e4.<\/p>\n<p><b><u>\ub354<\/u><u> <\/u><u>\ub098\uc740<\/u><u> <\/u><u>\ubc29\ubc95\uc774<\/u><u> <\/u><u>\uc788\uc744\uae4c<\/u><u>?<\/u><\/b><br \/> \uc774\ub7ec\ud55c \ubb38\uc81c\uc5d0 \ub300\ud574 \ud560 \uc218 \uc788\ub294\uac8c \uac70\uc758 \uc5c6\ub2e4\uace0 \uc0dd\uac01\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uad6d\uc5d0\ub294 \ubaa8\ub4e0 \ud589\ub9c8\ub2e4 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \ubcc0\uacbd\ud574\uc57c \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud14c\uc774\ube14\uc5d0\uc11c \uc218\ud589\ub418\ub294 \ub2e4\ub978 DML(\uadf8\ub9ac\uace0 \uc5f0\uad00\ub41c I\/O) \uc791\uc5c5 \uacfc\uc815\uacfc \ud568\uaed8 \ub9ce\uc740 \ub2e4\ub978 \uc791\uc5c5\uc744 \ucd94\uac00\ub85c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ube14\ub85c\uadf8\uc5d0\uc11c \uc804\uccb4\ub97c \ubaa8\ub450 \ub2e4\ub8e8\uae30\uc5d0\ub294 \ub108\ubb34 \ubcf5\uc7a1\ud558\uae30 \ub54c\ubb38\uc5d0 \uac04\ub2e8\ud788 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Aurora\uc5d0\uc11c \uc0ac\uc6a9\uc790\uac00 DDL \ubb38\uc744 \uc218\ud589\ud560 \ub54c:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 INFORMATION_SCHEMA \uc2dc\uc2a4\ud15c \ud14c\uc774\ube14\uc744 \uc0c8 \uc2a4\ud0a4\ub9c8\ub85c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4. \ucd94\uac00\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc791\uc5c5\uc744 \ud0c0\uc784 \uc2a4\ud0ec\ud504 \ucc98\ub9ac\ud558\uace0, \uc774\uc804 \uc2a4\ud0a4\ub9c8\ub97c \uc0c8 \uc2dc\uc2a4\ud15c \ud14c\uc774\ube14(\uc2a4\ud0a4\ub9c8 \ubc84\uc804 \ud14c\uc774\ube14)\uc5d0 \uae30\ub85d\ud55c \ub4a4 \uc774\ub7ec\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc77d\uae30 \ubcf5\uc81c\ubcf8\uc5d0 \uc804\ud30c\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>DDL \uc791\uc5c5 \uc911 \ub2e4\ub978 \uc138\uc158\uc758 \ub300\uae30\uac00 \ud544\uc694\ud55c \ubd80\ubd84\uc740 \uc5ec\uae30\uae4c\uc9c0\uc785\ub2c8\ub2e4.<\/p>\n<p>\uadf8 \ub4a4 \ud6c4\uc18d DML \uc791\uc5c5\uc758 \uc601\ud5a5\uc744 \ubc1b\ub294 \ub370\uc774\ud130 \ud398\uc774\uc9c0\uc5d0 \ubcf4\ub958 \uc911\uc778 \uc2a4\ud0a4\ub9c8 \uc791\uc5c5\uc774 \uc788\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. \uc774\ub294 \ud398\uc774\uc9c0\uc758 \ub85c\uadf8 \uc2dc\ud000\uc2a4 \ub118\ubc84(LSN) \ud0c0\uc784 \uc2a4\ud0ec\ud504\uc640 \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc758 LSN \ud0c0\uc784 \uc2a4\ud0ec\ud504\ub97c \ube44\uad50\ud558\uc5ec \uc27d\uac8c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud544\uc694\ud55c \uacbd\uc6b0 DML \ubb38\uc744 \uc801\uc6a9\ud558\uae30 \uc804\uc5d0 \ud398\uc774\uc9c0\ub97c \uc0c8\ub85c\uc6b4 \uc2a4\ud0a4\ub9c8\ub85c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \ub2e4\ub978 \ubaa8\ub4e0 \uc791\uc5c5\uacfc \ub3d9\uc77c\ud558\uac8c redo-undo \ub808\ucf54\ub4dc \ud398\uc774\uc9c0\uc758 \uc5c5\uadf8\ub808\uc774\ub4dc \ud504\ub85c\uc138\uc2a4\ub97c \ub530\ub985\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubaa8\ub4e0 I\/O\ub294 \uc0ac\uc6a9\uc790 \ud65c\ub3d9\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4.<\/p>\n<p>\uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uc218\ud589\ud558\uba74 \ud398\uc774\uc9c0 \ubd84\ud560\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c DML \uc791\uc5c5\uc5d0 \ub300\ud55c \ud398\uc774\uc9c0\ub9cc \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uc218\ud589\ud558\ub3c4\ub85d \uc8fc\uc758\ud574\uc57c\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ubcc0\uacbd\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\ub294 Aurora \ubcf5\uc81c\ubcf8\uc5d0\uc11c\ub3c4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \ubc18\uc601\ud574\uc57c \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SELECT\ubb38 \uc218\ud589\uc744 \uc704\ud574 MySQL\ub85c \ub2e4\uc2dc \uc804\ub2ec\ub418\ub294 \ubc84\ud37c \ub0b4 \uba54\ubaa8\ub9ac \uc774\ubbf8\uc9c0\ub97c \uac31\uc2e0\ud558\uc5ec, \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc774\uc804 \ubc0f \uc2e0\uaddc \uc2a4\ud0a4\ub9c8 \ud615\uc2dd\uc774 \ud63c\ud569\ub418\uc5b4 \uc788\ub354\ub77c\ub3c4 \ud56d\uc0c1 \ucd5c\uc2e0 \uc2a4\ud0a4\ub9c8\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Aurora\uac00 \uc2a4\ud1a0\ub9ac\uc9c0\ub85c\ubd80\ud130 \ubcc0\uacbd\uc0ac\ud56d\uc744 \uc2a4\ud1a0\ub9ac\uc9c0 \ub0b4 \uc77d\uae30 \ucffc\ub7fc\uc5d0 \ubc18\uc601\ud558\ub294 \ubc29\ubc95\uc5d0 \uad00\ud574 \uc54c\uace0 \uc788\ub2e4\uba74 \uc774\uc640 \uc720\uc0ac\ud55c \ubc29\ubc95\uc774\ub780 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc, \uc774 \ubc29\ubc95\uc740 \uc2e4\ud589 \ub85c\uadf8\uac00 \uc544\ub2cc \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc218\ud589 \ud560 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uae30\ub85d\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \uc131\ub2a5 \ube44\uad50\uc785\ub2c8\ub2e4 \u2013 Aurora\ub294 \uc2a4\ud0a4\ub9c8 \ubc84\uc804 \ud14c\uc774\ube14\ub9cc\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\ubbc0\ub85c \uc77c\uc815\ud55c \uc2dc\uac04\uc774 \uc18c\uc694\ub418\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ub300\ub85c \uc77c\ubc18 MySQL\uc740 \ud14c\uc774\ube14 \ud06c\uae30\uc5d0 \ub530\ub77c \uac70\uc758 \uc120\ud615\uc801\uc73c\ub85c DDL \uc791\uc5c5 \uc2dc\uac04\uc774 \uae38\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-842\" style=\"width: 80%\" src=\"https:\/\/d2908q01vomqb2.cloudfront.net\/887309d048beef83ad3eabf2a79a64a389ab1c9f\/2017\/04\/04\/TableComparison.png\" alt=\"\" width=\"1572\" height=\"642\" \/><\/p>\n<p>\uc6b0\ub9ac\uac00 \uac1c\uc120\ud574\uc57c \ud560 \ub9ce\uc740 DDL \uc791\uc5c5\uc774 \uc788\uc9c0\ub9cc \ub300\ubd80\ubd84\uc758 \uc791\uc5c5\uc744 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \ud574\uacb0\ud560 \uc218 \uc788\ub2e4\uace0 \ud655\uc2e0\ud569\ub2c8\ub2e4. \uc774\uac83\uc740 \uc911\uc694\ud55c \uc0ac\uc548\uc785\ub2c8\ub2e4 \u2013 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc0c1\uc801\uc778 \uac00\uc6a9\uc131 \ubc94\uc704 \ub0b4\uc5d0\uc11c \uc6b4\uc601\ub418\uace0 \uc788\ub354\ub77c\ub3c4, \uc7a5\uc2dc\uac04 \uc218\ud589\ub418\ub294 DDL \uc791\uc5c5\ub4e4\ub85c \uc778\ud574 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc815\uc0c1 \uc218\ud589\ub420 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ubcd1\ub82c, \ubc31\uadf8\ub77c\uc6b4\ub4dc \ubc0f \ube44\ub3d9\uae30 \ubc29\uc2dd \uc2e4\ud589\uc774 \ucc28\ubcc4\uc810\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc9c8\ubb38\uc774\ub098 \ube14\ub85c\uadf8\uc5d0\uc11c \ub2e4\ub904\uc9c0\uae38 \ubc14\ub77c\ub294 \uc8fc\uc81c\uac00 \uc788\uc73c\uba74 <a href=\"mailto:aurora-pm@amazon.com\">aurora-pm@amazon.com<\/a>\ub85c \uc5f0\ub77d\uc744 \uc8fc\uc2ed\uc2dc\uc624.<\/p>\n<p>\u2013 Anurag Gupta;<\/p>\n<p><strong>\uc804\uccb4 \ubaa9\ub85d<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-quorum-and-correlated-failure\/\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(1) \u2013 \ucffc\ub7fc \ubc0f \uc0c1\uad00 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95<\/a><\/li>\n<li><a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-quorum-reads-and-mutating-state\/\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(2) \u2013 \ucffc\ub7fc \uc77d\uae30 \ubc0f \uc0c1\ud0dc \ubcc0\uacbd<\/a><\/li>\n<li><a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-reducing-costs-using-quorum-sets\/\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(3) \u2013 \ucffc\ub7fc \uc9d1\ud569\uc744 \uc774\uc6a9\ud55c \ube44\uc6a9 \uc808\uac10 \ubc29\ubc95<\/a><\/li>\n<li><a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-quorum-membership\/\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(4) \u2013 \ucffc\ub7fc \uad6c\uc131\uc6d0<\/a><\/li>\n<li><a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-fast-ddl\/\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL<\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Source: <a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-under-the-hood-fast-ddl\/\" target=\"_blank\">Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL \uc774 \uae00\uc740 AWS Database Blog\uc758 Amazon Aurora Under the Hood: Fast DDL \uc758 \ud55c\uad6d\uc5b4 \ubc88\uc5ed\uc73c\ub85c AWS\ucf54\ub9ac\uc544\uc758 \uc548\ud6a8\ube48 \uc194\ub8e8\uc158\uc988 \uc544\ud0a4\ud14d\ud2b8\uac00 \ubc88\uc5ed\ud574 \uc8fc\uc168\uc2b5\ub2c8\ub2e4. Amazon Aurora\ub294 MySQL\uacfc \ud638\ud658\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uace0\uc131\ub2a5 \uc0c1\uc6a9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc18d\ub3c4\uc640 \uac00\uc6a9\uc131\uc744 \uc624\ud508 \uc18c\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub2e8\uc21c\uc131, \ube44\uc6a9 \ud6a8\uc728\uc131\uacfc \uacb0\ud569\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \uc5b4\ub5bb\uac8c Amazon Aurora\uac00 MySQL\uc5d0\uc11c \uba87 \uc2dc\uac04\uc774 \uac78\ub9ac\ub358 \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL)\ubb38\uc744 \uc989\uac01\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \ud604\uc7ac Lab mode\uc5d0\uc11c \uac00\ub2a5\ud558\uba70 Aurora \ubc84\uc804 1.12 \uc774\uc0c1\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ube60\ub978 DDL\uc774\ub780 \ubb34\uc5c7\uc774\uba70, \uc774\uac83\uc774 \uc65c \uc911\uc694\ud569\ub2c8\uae4c? \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubcc0\uacbd\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \ucffc\ub9ac \uc6cc\ud06c\ub85c\ub4dc \ubcc0\uacbd\uc5d0 \ub530\ub77c \uc778\ub371\uc2a4\ub97c \ucd94\uac00 \ud639\uc740 \uc0ad\uc81c(drop)\ud574\uc57c \ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ud615\uc2dd(format) \ubcc0\uacbd\uc5d0 \ub530\ub77c \uae30\uc874 \uc5f4(column)\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubcc0\uacbd\uc740 \uc790\uc8fc \uc77c\uc5b4\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Ruby on Rails \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc9c0\uc6d0\ud558\ub294 \uc77c\ubd80 DBA\ub294 \ub9e4\uc8fc \uc218\uc2ed \uac1c\uc758 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud55c\ub2e4\uace0 \ud569\ub2c8\ub2e4. \ubaa8\ub4e0 MySQL DBA\uac00 \uc54c\uace0 \uc788\ub4ef\uc774 \uc774\ub7ec\ud55c \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc740 \uc6b4\uc601 \uc2dc\uc2a4\ud15c\uc744 \ubc29\ud574\ud558\uac8c \ub418\uace0 \uba87 \uc2dc\uac04\uc5d0\uc11c \uba70\uce60\uc774 \uac78\ub9b4 <a class=\"mh-excerpt-more\" href=\"https:\/\/jirak.net\/wp\/amazon-aurora-%eb%82%b4%eb%b6%80-%eb%93%a4%ec%97%ac%eb%8b%a4%eb%b3%b4%ea%b8%b05-fast-ddl\/\" title=\"Amazon Aurora \ub0b4\ubd80 \ub4e4\uc5ec\ub2e4\ubcf4\uae30(5) \u2013 Fast DDL\">[ more&#8230; ]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":21458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[169],"tags":[656],"class_list":["post-21457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-aws"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/21457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/comments?post=21457"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/21457\/revisions"}],"predecessor-version":[{"id":21459,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/21457\/revisions\/21459"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/21458"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=21457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=21457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=21457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}