{"id":10441,"date":"2016-09-09T15:00:04","date_gmt":"2016-09-09T06:00:04","guid":{"rendered":"https:\/\/jirak.net\/wp\/amazon-aurora-%ea%b8%b0%eb%8a%a5-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8-%eb%b3%91%eb%a0%ac-%eb%af%b8%eb%a6%ac-%ec%9d%bd%ea%b8%b0-%ea%b3%a0%ec%86%8d-%ec%9d%b8%eb%8d%b1%ec%8b%b1-numa\/"},"modified":"2016-09-19T15:36:07","modified_gmt":"2016-09-19T06:36:07","slug":"amazon-aurora-%ea%b8%b0%eb%8a%a5-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8-%eb%b3%91%eb%a0%ac-%eb%af%b8%eb%a6%ac-%ec%9d%bd%ea%b8%b0-%ea%b3%a0%ec%86%8d-%ec%9d%b8%eb%8d%b1%ec%8b%b1-numa","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/amazon-aurora-%ea%b8%b0%eb%8a%a5-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8-%eb%b3%91%eb%a0%ac-%eb%af%b8%eb%a6%ac-%ec%9d%bd%ea%b8%b0-%ea%b3%a0%ec%86%8d-%ec%9d%b8%eb%8d%b1%ec%8b%b1-numa\/","title":{"rendered":"Amazon Aurora \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8 \u2013 \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30, \uace0\uc18d \uc778\ub371\uc2f1 , NUMA \uc778\uc2dd \ub4f1"},"content":{"rendered":"<p>Amazon Aurora \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8 \u2013 \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30, \uace0\uc18d \uc778\ub371\uc2f1 , NUMA \uc778\uc2dd \ub4f1<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jirak.net\/wp\/wp-content\/uploads\/2016\/09\/rds_aurora_set_lab_mode_1.png\" width=\"839\" height=\"328\"><\/p>\n<p><a title=\"\" href=\"https:\/\/aws.amazon.com\/rds\/aurora\/\">Amazon Aurora<\/a>\ub294 \ud604\uc7ac \uac00\uc7a5 \ube60\ub974\uac8c \uc131\uc7a5\ud558\uace0 \uc788\ub294 AWS \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc\uc5d0 \ucd5c\uc801\ud654\ub41c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc73c\ub85c\uc11c <a href=\"https:\/\/aws.amazon.com\/blogs\/aws\/highly-scalable-mysql-compat-rds-db-engine\/\">Amazon Aurora \u2013 New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS<\/a>\ub294 \ub192\uc740 \uc131\ub2a5 \ud5a5\uc0c1\uacfc \ucd5c\ub300 64TB\uae4c\uc9c0 \uc6d0\ud65c\ud558\uac8c \uc2a4\ud1a0\ub9ac\uc9c0 \ud655\uc7a5 \ubc0f \uacac\uace0\uc131\uacfc \uac00\uc6a9\uc131 \ud5a5\uc0c1\uc744 \uc2e4\ud604\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Aurora\uc744 MySQL \ud638\ud658 \uc5d4\uc9c4\uc73c\ub85c \ub514\uc790\uc778\ud568\uc73c\ub85c\uc368 \uace0\uac1d\uc740 \uae30\uc874 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\uac70\ub098 \uc0c8\ub85c\uc6b4 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \uad6c\ucd95\ud560 \ub54c \ub354\uc6b1 \uac04\ub2e8\ud558\uac8c \uc811\uadfc\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc624\ub298 \ucd94\uac00\ub85c \uc138 \uac00\uc9c0 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc744 Aurora\uc5d0 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 \uae30\ub2a5\uc740 AWS\ub97c \ub9ce\uc774 \uc774\uc6a9\ud558\ub294 \uace0\uac1d\uc758 \uc77c\ubc18\uc801\uc778 \uc6cc\ud06c\ub85c\ub4dc\uc5d0\uc11c Aurora \uc131\ub2a5\uc744 \ucd5c\ub300\ub85c \uac1c\uc120\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30(Parallel Read Ahead)<\/strong> \u2013 \uad6c\uac04 \uc120\ud0dd, \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94, \ud14c\uc774\ube14 \ubcc0\uacbd, \uc778\ub371\uc2a4 \uc0dd\uc131\uc744 \ucd5c\ub300 5\ubc30 \ube60\ub974\uac8c \uc131\ub2a5 \uac1c\uc120<\/li>\n<li><strong>\ube60\ub978 \uc778\ub371\uc2f1(Faster Index Build)<\/strong> \u2013 \uc778\ub371\uc2a4 \uc0dd\uc131 \uc2dc\uac04\uc744 \uc57d 75% \ub2e8\ucd95<\/li>\n<li><strong>NUMA \uc778\uc2dd \uc2a4\ucf00\uc904\ub9c1(NUMA-Aware Scheduling)<\/strong> \u2013 \ub450 \uac1c \uc774\uc0c1\uc758 CPU\uac00 \ud0d1\uc7ac \ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0, \ucffc\ub9ac \uce90\uc2dc\uc5d0\uc11c \ubc0f \ubc84\ud37c \uce90\uc2dc\uc5d0\uc11c \uc77d\uae30 \uc131\ub2a5 \ud5a5\uc0c1 \ubc0f \uc804\uccb4 \ucc98\ub9ac\ub7c9\uc774 \ucd5c\ub300 10 % \ud5a5\uc0c1<\/li>\n<\/ul>\n<p>\ud55c \uac00\uc9c0\uc529 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30<\/strong><br \/> MySQL\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 InnoDB \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc740 \ud14c\uc774\ube14 \ud589\uc774\ub098 \uc778\ub371\uc2a4 \ud0a4(index key)\ub97c \uc774\uc6a9\ud558\ub294 \uc2a4\ud1a0\ub9ac\uc9c0(\ub514\uc2a4\ud06c \ud398\uc774\uc9c0)\ub97c \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub294 \ud14c\uc774\ube14\uc758 \uc21c\ucc28 \uc2a4\uce94 \uc18d\ub3c4\uc640 \uc0c8\ub85c \uc0dd\uc131 \ub41c \ud14c\uc774\ube14\uc5d0 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \ud14c\uc774\ube14 \ud589\uc774 \uc5c5\ub370\uc774\ud2b8 \ud639\uc740 \uc0dd\uc131 \ubc0f \uc0ad\uc81c\ub418\uba74, \ub370\uc774\ud130\uac00 \ud30c\ud3b8\ud654\ub428\uc73c\ub85c\uc368 \ubb3c\ub9ac\uc801\uc73c\ub85c \ub354 \uc774\uc0c1 \uc21c\ucc28\uc801\uc774\uc9c0 \uc54a\uace0, \uc2a4\uce94 \uc131\ub2a5\uc774 \ud06c\uac8c \uc800\ud558\ub429\ub2c8\ub2e4. InnoDB\uc758 \uc120\ud615 \ubbf8\ub9ac \uc77d\uae30(Linear Read Ahead) \uae30\ub2a5\uc740 \ud398\uc774\uc9c0\uac00 \uc2e4\uc81c\ub85c \uc0ac\uc6a9\ud560 \ub54c\uae4c\uc9c0 \uba54\ubaa8\ub9ac\uc5d0\uc11c 64 \ud398\uc774\uc9c0\uae4c\uc9c0 \uc815\ub9ac\ud558\uc5ec \ub370\uc774\ud130 \ud30c\ud3b8\ud654\uc5d0 \ub300\ucc98\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \uc77c\ubc18\uc801\uc73c\ub85c \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uaddc\ubaa8\uc758 \uc6cc\ud06c\ub85c\ub4dc\uc5d0\uc11c\ub294 \uc774 \uae30\ub2a5\uc774 \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uc81c\uacf5\ud558\uc9c0 \uc54a\ub294\ub2e4\uace0 \uc54c\ub824\uc838\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ubc88 \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8\uc5d0\uc11c\ub294 Aurora\uac00 \ub9ce\uc740 \uc0c1\ud669\uc5d0\uc11c \ud604\uba85\ud558\uac8c \uc774\ub7ec\ud55c \uc0c1\ud669\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. Aurora\uc758 \ud14c\uc774\ube14\uc744 \uc2a4\uce94 \ud560 \ub54c, \ub17c\ub9ac\uc801\uc73c\ub85c \ud310\ub2e8\ud558\uace0 \ubcd1\ub82c\ub85c \ud398\uc774\uc9c0\ub97c \ubbf8\ub9ac \ucd94\uac00\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubbf8\ub9ac \ucd94\uac00(pre-fetch)\uae30\ub2a5\uc740 Aurora\uc758 \ubcf5\uc81c \uc2a4\ud1a0\ub9ac\uc9c0 (3\uac1c \uac00\uc6a9 \uc601\uc5ed\uc5d0 \uac01\uac01 2 \uac1c\uc529 \ubcf5\uc0ac)\uc5d0\uc11c \uc6b0\uc704\ub97c \ubc1c\ud718\ud558\uc5ec, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uce90\uc2dc\uc911\uc778 \ud398\uc774\uc9c0\uac00 \uc2a4\uce94 \uc791\uc5c5\uacfc \uad00\ub828 \uc788\ub294\uc9c0\ub97c \ud310\ub2e8\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uacb0\uacfc\uc801\uc73c\ub85c, \uad6c\uac04 \uac80\uc0c9, \uc804\uccb4 \ud14c\uc774\ube14 \uac80\uc0c9, ALTER TABLE \uadf8\ub9ac\uace0 index \uc0dd\uc131\uc744 \uc774\uc804 \ubc84\uc804\uc5d0 \ube44\ud574 \ucd5c\ub300 5 \ubc30 \ube60\ub974\uac8c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Aurora 1.7\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uba74 \ubc14\ub85c \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uacbd\ud5d8\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\ube60\ub978 \uc778\ub371\uc2f1<\/strong><br \/> \ud2b9\uc815 \ud14c\uc774\ube14\uc5d0 \uae30\ubcf8(Primary) \ubc0f \ubcf4\uc870(Secondary) \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \ub54c, \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc740 \uc0c8\ub85c\uc6b4 \ud0a4\ub97c \ud3ec\ud568\ud574\uc11c \ud2b8\ub9ac \uad6c\uc870\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \ud1b5\ud574 \ub9ce\uc740 \ud558\ud5a5\uc2dd \ud2b8\ub9ac \uac80\uc0c9 \ubc0f \ud0a4\uc758 \uc99d\uac00\uc5d0 \ub300\uc751\ud558\uae30 \uc704\ud574 \ud2b8\ub9ac \uc7ac\uad6c\ucd95\uc744 \ud1b5\ud574 \ud398\uc774\uc9c0 \ubd84\ud560\uc744 \ud558\uac8c\ub429\ub2c8\ub2e4.<\/p>\n<p>Aurora\ub294 \uc0c1\ud5a5\uc2dd(bottom-up) \ud2b8\ub9ac \uad6c\uc870\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. \ub9ac\ud504(leaves)\ub97c \uba3c\uc800 \ub9cc\ub4e4\uace0 \ud544\uc694\ud55c \ub9cc\ud07c \ubd80\ubaa8 \ud398\uc774\uc9c0\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc2a4\ud1a0\ub9ac\uc9c0 \uc774\ub3d9\uc744 \uc904\uc774\uace0, \uac01 \ud398\uc774\uc9c0\uac00 \uc77c\ub2e8 \ubaa8\ub450 \uba54\uc6cc\uc9c0\ub3c4\ub85d \ud558\uc5ec \ud398\uc774\uc9c0\ub97c \ubd84\ud560 \ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub97c \ud1b5\ud574 \ud14c\uc774\ube14\u200b \uc2a4\ud0a4\ub9c8\uc5d0 \ub530\ub77c \ub2e4\ub974\uc9c0\ub9cc, \uc778\ub371\uc2a4 \ucd94\uac00 \ub610\ub294 \ud14c\uc774\ube14 \uc7ac\uad6c\uc131\uc774 \ucd5c\ub300 4\ubc30 \ube68\ub77c\uc9d1\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Aurora \ud300\uc774 \ub2e4\uc74c\uacfc \uac19\uc740 \uc2a4\ud0a4\ub9c8\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0 1\uc5b5 \ud589\uc744 \ucd94\uac00\ud558\uc5ec 5GB\uc758 \uc0ac\uc774\uc988 \ud14c\uc774\ube14\uc744 \uc81c\uc791\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"prism-show-language\">\n<div class=\"prism-show-language-label\">\n  SQL\n <\/div>\n<\/div>\n<pre class=\" language-sql\"><code class=\" language-sql\"><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> test01 <span class=\"token punctuation\">(<\/span>id <span class=\"token keyword\">int<\/span> <span class=\"token operator\">not<\/span> <span class=\"token boolean\">null<\/span> auto_increment <span class=\"token keyword\">primary<\/span> <span class=\"token keyword\">key<\/span><span class=\"token punctuation\">,<\/span> i <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">,<\/span> j <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">,<\/span> k <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<p>\uadf8\ub9ac\uace0 4\uac1c\uc758 index\ub97c \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"prism-show-language\">\n<div class=\"prism-show-language-label\">\n  SQL\n <\/div>\n<\/div>\n<pre class=\" language-sql\"><code class=\" language-sql\"><span class=\"token keyword\">alter<\/span> <span class=\"token keyword\">table<\/span> test01 <span class=\"token keyword\">add<\/span> <span class=\"token keyword\">index<\/span> <span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">add<\/span> <span class=\"token keyword\">index<\/span> <span class=\"token punctuation\">(<\/span>j<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">add<\/span> <span class=\"token keyword\">index<\/span> <span class=\"token punctuation\">(<\/span>k<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">add<\/span> <span class=\"token keyword\">index<\/span> comp_idx<span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">,<\/span> j<span class=\"token punctuation\">,<\/span> k<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<\/code><\/pre>\n<p>db.r3.large \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \ucffc\ub9ac \uc2e4\ud589 \uc2dc\uac04\uc774 67\ubd84\uc5d0\uc11c 25\ubd84\uc73c\ub85c \uc904\uc5c8\uace0, db.r3.8xlarge\uc5d0\uc11c\ub294 29\ubd84\uc5d0\uc11c 11.5\ubd84\uc73c\ub85c \ub2e8\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ubcf8 \uc2e0\uaddc \uae30\ub2a5\uc740 \uc6b0\uc120 \uc815\uc2dd \uc11c\ube44\uc2a4 \ud658\uacbd\uc774 \uc544\ub2cc \ud14c\uc2a4\ud2b8\ub97c \uba3c\uc800 \ud558\uc2dc\uae38 \uad8c\uc7a5\ud569\ub2c8\ub2e4. Aurora 1.7\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \ud558\uc2e0 \ud6c4, DB \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc5d0\uc11c <code>aurora_lab_mode<\/code>\ub97c <code>1<\/code>\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. (\ub354 \uc790\uc138\ud55c \uc0ac\ud56d\uc740 <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/Aurora.Appendix.ParameterGroups.html\">DB Cluster and DB Instance Parameters<\/a> \ub97c \ucc38\uace0\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/media.amazonwebservices.com\/blog\/2016\/rds_aurora_set_lab_mode_1.png\" alt=\"\" width=\"839\" height=\"328\" \/><\/p>\n<p>\ubcf8 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc9c8\ubb38 \ubc0f \ud53c\ub4dc\ubc31\uc740 <a href=\"https:\/\/forums.aws.amazon.com\/forum.jspa?forumID=60&amp;start=0\">Amazon RDS Forum<\/a>\uc744 \ud1b5\ud574 \ubcf4\ub0b4\uc8fc\uc2dc\uba74 \uac10\uc0ac\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>NUMA \uae30\ubc18 \uc2a4\ucf00\uc904\ub9c1<\/strong><br \/> \uac00\uc7a5 \ud070 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4( db.r3.8xlarge )\ub294 2\uac1c\uc758 CPU\ub97c \ud0d1\uc7ac\ud558\uace0 \uc788\uace0, <a href=\"https:\/\/ko.wikipedia.org\/wiki\/%EB%B6%88%EA%B7%A0%EC%9D%BC_%EA%B8%B0%EC%96%B5_%EC%9E%A5%EC%B9%98_%EC%A0%91%EA%B7%BC\">\ubd88\uade0\uc77c \uae30\uc5b5 \uc7a5\uce58 \uc811\uadfc(Non-Uniform Memory Access, NUMA)<\/a>\ub77c\ub294 \uae30\ub2a5\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uc720\ud615\uc758 \uc2dc\uc2a4\ud15c\uc740 \uba54\uc778 \uba54\ubaa8\ub9ac \ud30c\ud2f0\uc158\uc744 \uac01 CPU\uc5d0\uc11c \uc9c1\uc811 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub098\uba38\uc9c0 \uba54\ubaa8\ub9ac\ub294 \uc870\uae08 \ube44\ud6a8\uc728\uc801 CPU \uac04\uc758 \uc811\uadfc \uacbd\ub85c\ub97c \ud1b5\ud574 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>Aurora\ub294\uc774 \uace0\ub974\uc9c0 \ubabb\ud55c \uc811\uadfc \uc2dc\uac04\uc744 \ud65c\uc6a9\ud558\uae30 \uc704\ud574 \uc2a4\ucf00\uc904\ub9c1 \uc2a4\ub808\ub4dc\uc758 \uc791\uc5c5\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac \ud560 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc2a4\ucf00\uc904\ub9c1 \uc2a4\ub808\ub4dc\ub294 \ub2e4\ub978 CPU\uc5d0 \uc5f0\uacb0\ub418\uc5b4 \uc788\ub294 \ube44\ud6a8\uc728\uc801\uc778 \uba54\ubaa8\ub9ac \uc811\uadfc\uc744 \uace0\ub824\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c, \ucffc\ub9ac \uce90\uc2dc\uc640 \ubc84\ud37c \uce90\uc2dc\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uac19\uc740 CPU \ubc14\uc6b4\ub4dc \uc791\uc5c5\uc5d0\uc11c \ucd5c\ub300 10%\uae4c\uc9c0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4\uc5d0 \uc218\ubc31 \ub610\ub294 \uc218\ucc9c\uac1c\uc758 \ub3d9\uc2dc \uc5f0\uacb0\uc774 \ub418\uc5b4 \uc788\uc744 \ub54c, \ud604\uc800\ud558\uac8c \uc131\ub2a5\uc774 \ub192\uc544\uc9d1\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Sysbench <a href=\"https:\/\/github.com\/akopytov\/sysbench\/blob\/0.5\/sysbench\/tests\/db\/oltp.lua\">oltp.lua<\/a> \ubca4\uce58 \ub9c8\ud06c\uc5d0\uc11c 570,000 reads\/second\uc5d0\uc11c 625,000 reads\/second\ub85c \ud5a5\uc0c1\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ud14c\uc2a4\ud2b8\uc5d0\uc11c\ub294 db.r3.8xlarge DB \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \ub2e4\uc74c \ub9e4\uac1c \ubcc0\uc218\ub97c \uc774\uc6a9\ud558\uc5ec \ud14c\uc2a4\ud2b8\ub9b4 \uc9c4\ud589\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><code>oltp_table_count = 25<\/code><\/li>\n<li><code>oltp_table_size = 10000<\/code><\/li>\n<li><code>num-threads = 1500 <\/code><\/li>\n<\/ul>\n<p>Aurora 1.7\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uba74 \ubc14\ub85c \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uacbd\ud5d8\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>Aurora 1.7 \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uae30<\/strong><br \/> DB \uc778\uc2a4\ud134\uc2a4\ub97c \uc0c8\ub85c \ub9cc\ub4dc\ub294 \uacbd\uc6b0, Aurora 1.7\ub85c \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ud569\ub2c8\ub2e4. \uc774\ubbf8 \uc2e4\ud589\uc911\uc778 DB \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \ubc14\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\uac70\ub098 \ub2e4\uc74c \ubc88\uc5d0 \uc5c5\ub370\uc774\ud2b8\ub97c \uc120\ud0dd\ud558\uc5ec \uc124\uce58\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc544\ub798 \ucffc\ub9ac\ub97c \ud1b5\ud574 Aurora 1.7\uc774 \uc801\uc6a9\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"prism-show-language\">\n<div class=\"prism-show-language-label\">\n  SQL\n <\/div>\n<\/div>\n<pre class=\" language-sql\"><code class=\" language-sql\">mysql<span class=\"token operator\">&gt;<\/span> <span class=\"token keyword\">show<\/span> <span class=\"token keyword\">global<\/span> variables <span class=\"token operator\">like<\/span> <span class=\"token string\">&quot;aurora_version&quot;<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token operator\">+<\/span><span class=\"token comment\">----------------+-------+<\/span>\n<span class=\"token operator\">|<\/span> Variable_name  <span class=\"token operator\">|<\/span> <span class=\"token keyword\">Value<\/span> <span class=\"token operator\">|<\/span>\n<span class=\"token operator\">+<\/span><span class=\"token comment\">----------------+-------+<\/span>\n<span class=\"token operator\">|<\/span> aurora_version <span class=\"token operator\">|<\/span> <span class=\"token number\">1.7<\/span>   <span class=\"token operator\">|<\/span>\n<span class=\"token operator\">+<\/span><span class=\"token comment\">----------------+-------+ <\/span>\n<\/code><\/pre>\n<p>\u2014 <a href=\"https:\/\/twitter.com\/jeffbarr\">Jeff<\/a>;<\/p>\n<p><em>\uc774 \uae00\uc740 <a href=\"https:\/\/aws.amazon.com\/blogs\/aws\/amazon-aurora-update-parallel-read-ahead-faster-indexing-numa-awareness\/\">Amazon Aurora Update \u2013 Parallel Read Ahead, Faster Indexing, NUMA Awareness<\/a>\uc758 \ud55c\uad6d\uc5b4 \ubc88\uc5ed\uc785\ub2c8\ub2e4.<\/em><\/p>\n<p>Source: <a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/amazon-aurora-update-parallel-read-ahead-faster-indexing-numa-awareness\/\" target=\"_blank\">Amazon Aurora \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8 \u2013 \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30, \uace0\uc18d \uc778\ub371\uc2f1 , NUMA \uc778\uc2dd \ub4f1<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Amazon Aurora \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8 \u2013 \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30, \uace0\uc18d \uc778\ub371\uc2f1 , NUMA \uc778\uc2dd \ub4f1 Amazon Aurora\ub294 \ud604\uc7ac \uac00\uc7a5 \ube60\ub974\uac8c \uc131\uc7a5\ud558\uace0 \uc788\ub294 AWS \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc\uc5d0 \ucd5c\uc801\ud654\ub41c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc73c\ub85c\uc11c Amazon Aurora \u2013 New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS\ub294 \ub192\uc740 \uc131\ub2a5 \ud5a5\uc0c1\uacfc \ucd5c\ub300 64TB\uae4c\uc9c0 \uc6d0\ud65c\ud558\uac8c \uc2a4\ud1a0\ub9ac\uc9c0 \ud655\uc7a5 \ubc0f \uacac\uace0\uc131\uacfc \uac00\uc6a9\uc131 \ud5a5\uc0c1\uc744 \uc2e4\ud604\ud558\uc600\uc2b5\ub2c8\ub2e4. Aurora\uc744 MySQL \ud638\ud658 \uc5d4\uc9c4\uc73c\ub85c \ub514\uc790\uc778\ud568\uc73c\ub85c\uc368 \uace0\uac1d\uc740 \uae30\uc874 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\uac70\ub098 \uc0c8\ub85c\uc6b4 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \uad6c\ucd95\ud560 \ub54c \ub354\uc6b1 \uac04\ub2e8\ud558\uac8c \uc811\uadfc\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc624\ub298 \ucd94\uac00\ub85c \uc138 \uac00\uc9c0 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc744 Aurora\uc5d0 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 \uae30\ub2a5\uc740 AWS\ub97c \ub9ce\uc774 \uc774\uc6a9\ud558\ub294 \uace0\uac1d\uc758 \uc77c\ubc18\uc801\uc778 \uc6cc\ud06c\ub85c\ub4dc\uc5d0\uc11c Aurora \uc131\ub2a5\uc744 \ucd5c\ub300\ub85c \uac1c\uc120\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30(Parallel Read Ahead) \u2013 \uad6c\uac04 \uc120\ud0dd, \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94, \ud14c\uc774\ube14 \ubcc0\uacbd, \uc778\ub371\uc2a4 \uc0dd\uc131\uc744 \ucd5c\ub300 5\ubc30 \ube60\ub974\uac8c \uc131\ub2a5 \uac1c\uc120 \ube60\ub978 \uc778\ub371\uc2f1(Faster Index Build) \u2013 \uc778\ub371\uc2a4 \uc0dd\uc131 \uc2dc\uac04\uc744 \uc57d 75% \ub2e8\ucd95 NUMA \uc778\uc2dd \uc2a4\ucf00\uc904\ub9c1(NUMA-Aware Scheduling) \u2013 \ub450 \uac1c \uc774\uc0c1\uc758 CPU\uac00 \ud0d1\uc7ac \ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0, \ucffc\ub9ac <a class=\"mh-excerpt-more\" href=\"https:\/\/jirak.net\/wp\/amazon-aurora-%ea%b8%b0%eb%8a%a5-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8-%eb%b3%91%eb%a0%ac-%eb%af%b8%eb%a6%ac-%ec%9d%bd%ea%b8%b0-%ea%b3%a0%ec%86%8d-%ec%9d%b8%eb%8d%b1%ec%8b%b1-numa\/\" title=\"Amazon Aurora \uae30\ub2a5 \uc5c5\ub370\uc774\ud2b8 \u2013 \ubcd1\ub82c \ubbf8\ub9ac \uc77d\uae30, \uace0\uc18d \uc778\ub371\uc2f1 , NUMA \uc778\uc2dd \ub4f1\">[ more&#8230; ]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10442,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[169],"tags":[656],"class_list":["post-10441","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\/10441","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=10441"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/10441\/revisions"}],"predecessor-version":[{"id":10443,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/10441\/revisions\/10443"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/10442"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=10441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=10441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=10441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}