{"id":27127,"date":"2018-10-02T20:12:48","date_gmt":"2018-10-02T11:12:48","guid":{"rendered":"https:\/\/jirak.net\/wp\/amazon-aurora%ec%9d%98-%eb%b3%91%eb%a0%ac-%ec%bf%bc%eb%a6%ac-%ea%b8%b0%eb%8a%a5-%ec%b6%9c%ec%8b%9c\/"},"modified":"2018-10-24T20:34:48","modified_gmt":"2018-10-24T11:34:48","slug":"amazon-aurora%ec%9d%98-%eb%b3%91%eb%a0%ac-%ec%bf%bc%eb%a6%ac-%ea%b8%b0%eb%8a%a5-%ec%b6%9c%ec%8b%9c","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/amazon-aurora%ec%9d%98-%eb%b3%91%eb%a0%ac-%ec%bf%bc%eb%a6%ac-%ea%b8%b0%eb%8a%a5-%ec%b6%9c%ec%8b%9c\/","title":{"rendered":"Amazon Aurora\uc758 \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5 \ucd9c\uc2dc"},"content":{"rendered":"<p>Amazon Aurora\uc758 \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5 \ucd9c\uc2dc<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jirak.net\/wp\/wp-content\/uploads\/2018\/10\/aurora_model_1.png\" width=\"845\" height=\"562\"><\/p>\n<p><a title=\"\" href=\"https:\/\/aws.amazon.com\/rds\/aurora\/\">Amazon Aurora<\/a>\ub294 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ud48d\ubd80\ud55c \ub124\ud2b8\uc6cc\ud0b9, \ucc98\ub9ac \ubc0f \uc2a4\ud1a0\ub9ac\uc9c0 \ub9ac\uc18c\uc2a4\ub97c \ud65c\uc6a9\ud558\ub3c4\ub85d \uc124\uacc4\ub41c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. Aurora\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790\uc758 MySQL \ubc0f PostgreSQL\uacfc \ud638\ud658\uc131\uc744 \uc720\uc9c0\ud558\uba74\uc11c \ucd5c\uc2e0\uc758 \ud2b9\ubcc4\ud788 \uc124\uacc4\ub41c \ubd84\uc0b0 \uc2a4\ud1a0\ub9ac\uc9c0 \uc2dc\uc2a4\ud15c\uc744 \uc740\ubc00\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uace0\uc18d SSD \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc788\ub294 3\uac1c\uc758 \uac1c\ubcc4 AWS \uac00\uc6a9 \uc601\uc5ed\uc5d0 \ubd84\uc0b0\ub41c \uc218\ubc31 \uac1c\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \ub178\ub4dc\uc5d0 \ub370\uc774\ud130\uac00 \uc2a4\ud2b8\ub77c\uc774\ud504\ub418\uace0, \uc601\uc5ed\ub2f9 2\uac1c\uc758 \ubcf5\uc0ac\ubcf8\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4. \uadf8\ub9bc\uc73c\ub85c \uc124\uba85\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4(<a href=\"https:\/\/www.slideshare.net\/AmazonWebServices\/aws-reinvent-2016-getting-started-with-amazon-aurora-dat203-70508626\">Amazon Aurora \uc2dc\uc791\ud558\uae30<\/a>\uc5d0\uc11c \ubc1c\ucdcc).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/media.amazonwebservices.com\/blog\/2018\/aurora_model_1.png\" width=\"845\" height=\"562\" \/><\/p>\n<p><span style=\"text-decoration: underline\"><strong>\uc0c8\ub85c\uc6b4 \ubcd1\ub82c \ucffc\ub9ac<\/strong><\/span><br \/> AWS\ub294 Aurora\ub97c \ucd9c\uc2dc\ud560 \ub54c \ub3d9\uc77c\ud55c \uc2a4\ucf00\uc77c\uc544\uc6c3 \uc124\uacc4 \uc6d0\uce59\uc744 \ub2e4\ub978 \uacc4\uce35\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0dd\uc5d0 \uc801\uc6a9\ud560 \uacc4\ud68d\uc784\uc744 \uc554\uc2dc\ud588\uc2b5\ub2c8\ub2e4. \uc624\ub298\uc740 AWS\uc758 \ub2e4\uc74c \ub2e8\uacc4\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc54c\ub824 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc704\uc758 \uadf8\ub9bc\uc5d0 \ub098\uc628 \uc2a4\ud1a0\ub9ac\uc9c0 \uacc4\uce35\uc758 \uac01 \ub178\ub4dc\uc5d0\ub294 \ub2e4\ub7c9\uc758 \ucc98\ub9ac \uc131\ub2a5\ub3c4 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uc774\uc81c Aurora\uc5d0\uc11c \ubd84\uc11d \ucffc\ub9ac(\uc8fc\ub85c \uc801\uc815 \ud06c\uae30\uc758 \ud14c\uc774\ube14 \uc804\uccb4 \ub610\ub294 \ub2e4\uc218\ub97c \ucc98\ub9ac\ud558\ub294 \ubd84\uc11d \ucffc\ub9ac)\ub97c \uac00\uc838\uc640 \uc218\ubc31 \ub610\ub294 \uc218\ucc9c \uac1c\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \ub178\ub4dc\uc5d0\uc11c \ub450 \uc790\ub9bf\uc218\uc5d0 \uac00\uae4c\uc6b4 \uc18d\ub3c4\ub85c \ubcd1\ub82c \uc2e4\ud589\ud558\uc5ec \uc774 \ucc98\ub9ac \uc131\ub2a5\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc0c8\ub85c\uc6b4 \ubaa8\ub378\uc5d0\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c, CPU \ubc0f \ubc84\ud37c \ud480 \uacbd\ud569\uc774 \uac10\uc18c\ud558\ubbc0\ub85c \ud63c\ud569\ub41c \ubd84\uc11d \ubc0f \ud2b8\ub79c\uc7ad\uc158 \ucffc\ub9ac\ub97c \ub3d9\uc77c\ud55c \ud14c\uc774\ube14\uc5d0\uc11c \ub3d9\uc2dc\uc5d0 \uc2e4\ud589\ud558\uace0 \ub450 \uc720\ud615\uc758 \ucffc\ub9ac\uc5d0 \ub300\ud55c \ucc98\ub9ac\ub7c9\uc744 \ub192\uc740 \uc218\uc900\uc73c\ub85c \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc9c0\uc815\ub41c \uc2dc\uac04\uc5d0 \ud65c\uc131 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ub420 \uc218 \uc788\ub294 \ubcd1\ub82c \ucffc\ub9ac \uc218\ub294 \uc778\uc2a4\ud134\uc2a4 \ud074\ub798\uc2a4\uc5d0 \ub530\ub77c \uacb0\uc815\ub429\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>db.r*.large<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 1\uac1c<\/li>\n<li><strong>db.r*.xlarge<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 2\uac1c<\/li>\n<li><strong>db.r*.2xlarge<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 4\uac1c<\/li>\n<li><strong>db.r*.4xlarge<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 8\uac1c<\/li>\n<li><strong>db.r*.8xlarge<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 16\uac1c<\/li>\n<li><strong>db.r4.16xlarge<\/strong> \u2013 \ub3d9\uc2dc \ubcd1\ub82c \ucffc\ub9ac \uc138\uc158 16\uac1c<\/li>\n<\/ul>\n<p><code>aurora_pq<\/code> \ud30c\ub77c\ubbf8\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae00\ub85c\ubc8c \uc218\uc900 \ubc0f \uc138\uc158 \uc218\uc900\uc5d0\uc11c \ubcd1\ub82c \ucffc\ub9ac \uc0ac\uc6a9\uc744 \ud65c\uc131\ud654 \ubc0f \ube44\ud65c\uc131\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ubcd1\ub82c \ucffc\ub9ac\ub294 200\uac1c\uac00 \ub118\ub294 \uc720\ud615\uc758 \ub2e8\uc77c \ud14c\uc774\ube14 \uc608\uce21 \ubc0f \ud574\uc2dc \uc870\uc778\uc5d0 \ub300\ud55c \uc131\ub2a5\uc744 \uac1c\uc120\ud569\ub2c8\ub2e4. Aurora \ucffc\ub9ac Optimizer\ub294 \ud14c\uc774\ube14\uc758 \ud06c\uae30\uc640 \uba54\ubaa8\ub9ac\uc5d0 \uc774\ubbf8 \uc788\ub294 \ud14c\uc774\ube14 \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \ubcd1\ub82c \ucffc\ub9ac \uc0ac\uc6a9 \uc5ec\ubd80\ub97c \uc790\ub3d9\uc73c\ub85c \uacb0\uc815\ud569\ub2c8\ub2e4. \ub610\ud55c \uc0ac\uc6a9\uc790\ub294 <code>aurora_pq_force<\/code> \uc138\uc158 \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc2a4\ud2b8 \ubaa9\uc801\uc73c\ub85c Optimizer\ub97c \uc7ac\uc815\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><span style=\"text-decoration: underline\"><strong>\ubcd1\ub82c \ucffc\ub9ac\uc758 \uc791\ub3d9 \uc6d0\ub9ac<\/strong><\/span><br \/> \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \uc0c8 \ud074\ub7ec\uc2a4\ud130\ub97c \uc0dd\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. \ucc98\uc74c\ubd80\ud130 \ub2e4\uc2dc \uc0dd\uc131\ud558\uac70\ub098 \uc2a4\ub0c5\uc0f7\uc744 \ubcf5\uc6d0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ubcd1\ub82c \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud558\ub294 \ud074\ub7ec\uc2a4\ud130\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574 [<strong>Capacity type<\/strong>]\uc73c\ub85c [<strong>Provisioned with Aurora parallel query enabled<\/strong>]\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/media.amazonwebservices.com\/blog\/2018\/pq_create_cluster_1.png\" width=\"710\" height=\"755\" \/><\/p>\n<p>\uc800\ub294 CLI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc2a4\ud2b8\uc5d0 \uc0ac\uc6a9\ud560 100GB \uc2a4\ub0c5\uc0f7\uc744 \ubcf5\uc6d0\ud55c \ub2e4\uc74c TPC-H \ubca4\uce58\ub9c8\ud06c\uc5d0\uc11c \ucffc\ub9ac \uc911 \ud558\ub098\ub97c \ud0d0\uc0c9\ud588\uc2b5\ub2c8\ub2e4. \uae30\ubcf8 \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">SELECT\n  l_orderkey,\n  SUM(l_extendedprice * (1-l_discount)) AS revenue,\n  o_orderdate,\n  o_shippriority\n\nFROM customer, orders, lineitem\n\nWHERE\n  c_mktsegment='AUTOMOBILE'\n  AND c_custkey = o_custkey\n  AND l_orderkey = o_orderkey\n  AND o_orderdate &lt; date '1995-03-13'\n  AND l_shipdate &gt; date '1995-03-13'\n\nGROUP BY\n  l_orderkey,\n  o_orderdate,\n  o_shippriority\n\nORDER BY\n  revenue DESC,\n  o_orderdate LIMIT 15;\n<\/code><\/pre>\n<\/div>\n<p>EXPLAIN \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uba74 \ubcd1\ub82c \ucffc\ub9ac \uc0ac\uc6a9\uc744 \ud3ec\ud568\ud558\uc5ec \ucffc\ub9ac \uacc4\ud68d\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">+----+-------------+----------+------+-------------------------------+------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------+\n| id | select_type | table    | type | possible_keys                 | key  | key_len | ref  | rows      | Extra                                                                                                                          |\n+----+-------------+----------+------+-------------------------------+------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------+\n|  1 | SIMPLE      | customer | ALL  | PRIMARY                       | NULL | NULL    | NULL |  14354602 | Using where; Using temporary; Using filesort                                                                                   |\n|  1 | SIMPLE      | orders   | ALL  | PRIMARY,o_custkey,o_orderdate | NULL | NULL    | NULL | 154545408 | Using where; Using join buffer (Hash Join Outer table orders); Using parallel query (4 columns, 1 filters, 1 exprs; 0 extra)   |\n|  1 | SIMPLE      | lineitem | ALL  | PRIMARY,l_shipdate            | NULL | NULL    | NULL | 606119300 | Using where; Using join buffer (Hash Join Outer table lineitem); Using parallel query (4 columns, 1 filters, 1 exprs; 0 extra) |\n+----+-------------+----------+------+-------------------------------+------+---------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------+\n3 rows in set (0.01 sec)\n<\/code><\/pre>\n<\/div>\n<p><strong>Extras<\/strong> \uc5f4\uc5d0\uc11c \uad00\ub828\ub41c \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">Using parallel query (4 columns, 1 filters, 1 exprs; 0 extra)\n<\/code><\/pre>\n<\/div>\n<p>\ubcd1\ub82c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 2\ubd84\uc774 \ub418\uae30 \uc804\uc5d0 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub429\ub2c8\ub2e4.<code class=\"lang-sql\"><\/code><\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">+------------+-------------+-------------+----------------+\n| l_orderkey | revenue     | o_orderdate | o_shippriority |\n+------------+-------------+-------------+----------------+\n|   92511430 | 514726.4896 | 1995-03-06  |              0 |\n|  593851010 | 475390.6058 | 1994-12-21  |              0 |\n|  188390981 | 458617.4703 | 1995-03-11  |              0 |\n|  241099140 | 457910.6038 | 1995-03-12  |              0 |\n|  520521156 | 457157.6905 | 1995-03-07  |              0 |\n|  160196293 | 456996.1155 | 1995-02-13  |              0 |\n|  324814597 | 456802.9011 | 1995-03-12  |              0 |\n|   81011334 | 455300.0146 | 1995-03-07  |              0 |\n|   88281862 | 454961.1142 | 1995-03-03  |              0 |\n|   28840519 | 454748.2485 | 1995-03-08  |              0 |\n|  113920609 | 453897.2223 | 1995-02-06  |              0 |\n|  377389669 | 453438.2989 | 1995-03-07  |              0 |\n|  367200517 | 453067.7130 | 1995-02-26  |              0 |\n|  232404000 | 452010.6506 | 1995-03-08  |              0 |\n|   16384100 | 450935.1906 | 1995-03-02  |              0 |\n+------------+-------------+-------------+----------------+\n15 rows in set (1 min 53.36 sec)\n<\/code><\/pre>\n<\/div>\n<p>\uc138\uc158\uc5d0 \ub300\ud55c \ubcd1\ub82c \ucffc\ub9ac\ub97c \ube44\ud65c\uc131\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. RDS \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud074\ub7ec\uc2a4\ud130 \ud30c\ub77c\ubbf8\ud130 \uadf8\ub8f9\uc744 \uc0ac\uc6a9\ud558\uba74 \ud6a8\uacfc\ub97c \uc7a5\uae30\uac04 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">set SESSION aurora_pq=OFF;<\/code><\/pre>\n<\/div>\n<p>\ubcd1\ub82c \ucffc\ub9ac\uac00 \uc5c6\uc73c\ub2c8 \ucffc\ub9ac\uac00 \uc0c1\ub2f9\ud788 \ub290\ub9ac\uac8c \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">+------------+-------------+-------------+----------------+\n| l_orderkey | o_orderdate | revenue     | o_shippriority |\n+------------+-------------+-------------+----------------+\n|   92511430 | 1995-03-06  | 514726.4896 |              0 |\n...\n|   16384100 | 1995-03-02  | 450935.1906 |              0 |\n+------------+-------------+-------------+----------------+\n15 rows in set (1 hour 25 min 51.89 sec)\n<\/code><\/pre>\n<\/div>\n<p>\uc774 \uc791\uc5c5\uc740 <strong>db.r4.2xlarge<\/strong> \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \uc218\ud589\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \uc778\uc2a4\ud134\uc2a4 \ud06c\uae30, \ub370\uc774\ud130 \uc138\ud2b8, \uc561\uc138\uc2a4 \ud328\ud134 \ubc0f \ucffc\ub9ac\ub294 \ub2e4\ub974\uac8c \uc218\ud589\ub429\ub2c8\ub2e4. \ucffc\ub9ac Optimizer\ub97c \uc7ac\uc815\uc758\ud558\uace0 \ubcd1\ub82c \ucffc\ub9ac\ub97c \ud14c\uc2a4\ud2b8 \ubaa9\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"hide-language\">\n<pre class=\"unlimited-height-code\"><code class=\"lang-sql\">set SESSION aurora_pq_force=ON;<\/code><\/pre>\n<\/div>\n<p><span style=\"text-decoration: underline\"><strong>\uc8fc\uc694 \uc0ac\ud56d<\/strong><\/span><br \/> \ub2e4\uc74c\uc740 Amazon Aurora \ubcd1\ub82c \ucffc\ub9ac\uc5d0 \ub300\ud55c \ud0d0\uc0c9\uc744 \uc2dc\uc791\ud560 \ub54c \uc54c\uc544\uc57c \ud560 \uba87 \uac00\uc9c0 \uc815\ubcf4\uc785\ub2c8\ub2e4.<\/p>\n<p><strong>\uc5d4\uc9c4 \uc9c0\uc6d0<\/strong> \u2013 MySQL 5.6\uc5d0 \ub300\ud55c \uc9c0\uc6d0\uc774 \ucd9c\uc2dc\ub429\ub2c8\ub2e4. \ud604\uc7ac MySQL 5.7 \ubc0f PostgreSQL\uc5d0 \ub300\ud55c \uc9c0\uc6d0\uc744 \uc791\uc5c5 \uc911\uc785\ub2c8\ub2e4.<\/p>\n<p><strong>\ud14c\uc774\ube14 \ud615\uc2dd<\/strong> \u2013 \ud14c\uc774\ube14 \ud589 \ud615\uc2dd\uc740 COMPACT\uc5ec\uc57c \ud558\uba70 \ud30c\ud2f0\uc154\ub2dd\ub41c \ud14c\uc774\ube14\uc740 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\ub370\uc774\ud130 \uc720\ud615<\/strong> \u2013 TEXT, BLOB \ubc0f GEOMETRY \ub370\uc774\ud130 \uc720\ud615\uc740 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>DDL<\/strong> \u2013 \ud14c\uc774\ube14\uc5d0\ub294 \ubcf4\ub958 \uc911\uc778 \uace0\uc18d \uc628\ub77c\uc778 DDL \uc791\uc5c5\uc774 \uc5c6\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\uc694\uae08<\/strong> \u2013 \ubcd1\ub82c \ucffc\ub9ac\ub294 \ucd94\uac00 \uc694\uae08 \uc5c6\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ubcd1\ub82c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc9c1\uc811 \uc561\uc138\uc2a4\ud574\uc57c \ud558\ubbc0\ub85c IO \ube44\uc6a9\uc774 \uc99d\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><span style=\"text-decoration: underline\"><strong>\uc9c0\uae08 \uc0ac\uc6a9 \uc2dc\uc791<\/strong><\/span><br \/> \uc9c0\uae08 \ubc14\ub85c \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70 \uc624\ub298\ubd80\ud130 \uc0ac\uc6a9\uc744 \uc2dc\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\u2014 <a href=\"https:\/\/twitter.com\/jeffbarr\">Jeff<\/a>;<\/p>\n<p>&nbsp;<\/p>\n<p>Source: <a href=\"https:\/\/aws.amazon.com\/ko\/blogs\/korea\/new-parallel-query-for-amazon-aurora\/\" target=\"_blank\">Amazon Aurora\uc758 \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5 \ucd9c\uc2dc<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Amazon Aurora\uc758 \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5 \ucd9c\uc2dc Amazon Aurora\ub294 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ud48d\ubd80\ud55c \ub124\ud2b8\uc6cc\ud0b9, \ucc98\ub9ac \ubc0f \uc2a4\ud1a0\ub9ac\uc9c0 \ub9ac\uc18c\uc2a4\ub97c \ud65c\uc6a9\ud558\ub3c4\ub85d \uc124\uacc4\ub41c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. Aurora\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790\uc758 MySQL \ubc0f PostgreSQL\uacfc \ud638\ud658\uc131\uc744 \uc720\uc9c0\ud558\uba74\uc11c \ucd5c\uc2e0\uc758 \ud2b9\ubcc4\ud788 \uc124\uacc4\ub41c \ubd84\uc0b0 \uc2a4\ud1a0\ub9ac\uc9c0 \uc2dc\uc2a4\ud15c\uc744 \uc740\ubc00\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uace0\uc18d SSD \uc2a4\ud1a0\ub9ac\uc9c0\uc5d0 \uc788\ub294 3\uac1c\uc758 \uac1c\ubcc4 AWS \uac00\uc6a9 \uc601\uc5ed\uc5d0 \ubd84\uc0b0\ub41c \uc218\ubc31 \uac1c\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \ub178\ub4dc\uc5d0 \ub370\uc774\ud130\uac00 \uc2a4\ud2b8\ub77c\uc774\ud504\ub418\uace0, \uc601\uc5ed\ub2f9 2\uac1c\uc758 \ubcf5\uc0ac\ubcf8\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4. \uadf8\ub9bc\uc73c\ub85c \uc124\uba85\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4(Amazon Aurora \uc2dc\uc791\ud558\uae30\uc5d0\uc11c \ubc1c\ucdcc). \uc0c8\ub85c\uc6b4 \ubcd1\ub82c \ucffc\ub9ac AWS\ub294 Aurora\ub97c \ucd9c\uc2dc\ud560 \ub54c \ub3d9\uc77c\ud55c \uc2a4\ucf00\uc77c\uc544\uc6c3 \uc124\uacc4 \uc6d0\uce59\uc744 \ub2e4\ub978 \uacc4\uce35\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0dd\uc5d0 \uc801\uc6a9\ud560 \uacc4\ud68d\uc784\uc744 \uc554\uc2dc\ud588\uc2b5\ub2c8\ub2e4. \uc624\ub298\uc740 AWS\uc758 \ub2e4\uc74c \ub2e8\uacc4\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc54c\ub824 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc704\uc758 \uadf8\ub9bc\uc5d0 \ub098\uc628 \uc2a4\ud1a0\ub9ac\uc9c0 \uacc4\uce35\uc758 \uac01 \ub178\ub4dc\uc5d0\ub294 \ub2e4\ub7c9\uc758 \ucc98\ub9ac \uc131\ub2a5\ub3c4 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uc774\uc81c Aurora\uc5d0\uc11c \ubd84\uc11d \ucffc\ub9ac(\uc8fc\ub85c \uc801\uc815 \ud06c\uae30\uc758 \ud14c\uc774\ube14 \uc804\uccb4 \ub610\ub294 \ub2e4\uc218\ub97c \ucc98\ub9ac\ud558\ub294 \ubd84\uc11d \ucffc\ub9ac)\ub97c \uac00\uc838\uc640 \uc218\ubc31 \ub610\ub294 \uc218\ucc9c \uac1c\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \ub178\ub4dc\uc5d0\uc11c \ub450 \uc790\ub9bf\uc218\uc5d0 \uac00\uae4c\uc6b4 \uc18d\ub3c4\ub85c \ubcd1\ub82c \uc2e4\ud589\ud558\uc5ec \uc774 \ucc98\ub9ac \uc131\ub2a5\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc0c8\ub85c\uc6b4 \ubaa8\ub378\uc5d0\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c, CPU \ubc0f \ubc84\ud37c \ud480 <a class=\"mh-excerpt-more\" href=\"https:\/\/jirak.net\/wp\/amazon-aurora%ec%9d%98-%eb%b3%91%eb%a0%ac-%ec%bf%bc%eb%a6%ac-%ea%b8%b0%eb%8a%a5-%ec%b6%9c%ec%8b%9c\/\" title=\"Amazon Aurora\uc758 \ubcd1\ub82c \ucffc\ub9ac \uae30\ub2a5 \ucd9c\uc2dc\">[ more&#8230; ]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":27128,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[169],"tags":[656],"class_list":["post-27127","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\/27127","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=27127"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/27127\/revisions"}],"predecessor-version":[{"id":27129,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/27127\/revisions\/27129"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/27128"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=27127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=27127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=27127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}