{"id":458,"date":"2024-06-13T11:12:43","date_gmt":"2024-06-13T02:12:43","guid":{"rendered":"https:\/\/www.dkdk.info\/wpb\/?p=458"},"modified":"2024-06-13T11:14:37","modified_gmt":"2024-06-13T02:14:37","slug":"aws-rds-mysql-to-aurora-serverless-migrate","status":"publish","type":"post","link":"https:\/\/www.dkdk.info\/wpb\/?p=458","title":{"rendered":"[AWS] RDS MySQL to Aurora Serverless Migrate"},"content":{"rendered":"<h2><span style=\"font-family: helvetica, arial, sans-serif;\"><strong>\uac1c\uc694<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">AWS \uc758 \uad00\ub9ac\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ube44\uc2a4\uc778 RDS \uc5d0\uc11c\ub294 MySQL Community \uc640 \uac19\uc740 \uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc744 \uadf8\ub300\ub85c \uc9c0\uc6d0\ud558\uae30\ub3c4 \ud558\uba70,<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">AWS \uc758 \uc790\uccb4 \uc5d4\uc9c4\uc778 Aurora \ub97c \ud1b5\ud574 \ud638\ud658 \ubc84\uc804\uc744 \uc81c\uacf5\ud558\uae30\ub3c4 \ud568.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\uc774\uc804\uc5d0\ub294 Aurora \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc5d0 \ud070 \uc774\uc810\uc774 \uc5c6\uc5c8\uc73c\ub098, \ucd5c\uadfc\uc5d0\ub294 \uc5ec\ub7ec \uc0c8\ub85c\uc6b4 \uae30\uc220\uc774\ub098 Serverless \ud615\ud0dc\uc758 \uc778\uc2a4\ud134\uc2a4\ub294 Aurora \uc5d0\uc11c\ub9cc \uc9c0\uc6d0\ud558\ubbc0\ub85c Aurora MySQL(PostgreSQL) \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc810\uc774 \ub9e4\uc6b0 \ucee4\uc84c\ub2e4\uace0 \ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif;\"><strong>\ubc30\uacbd<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">MySQL 5.7 \ubc84\uc804\uc740 2023-10-31 \uc744 \uae30\ud574 \uc5f0\uc7a5 \uc9c0\uc6d0\uae4c\uc9c0 \ubaa8\ub450 \uc885\ub8cc\ub418\uc5c8\uc74c.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\uc774\uc5d0 AWS RDS \uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 MySQL Community \ubc84\uc804\uc5d0 \ub300\ud574\uc11c\ub3c4 2024-02-29 \uc744 \uae30\ud574 \uc77c\ubc18 \uc9c0\uc6d0\uc740 \uc885\ub8cc\ub418\uba70, \uc5f0\uc7a5 \uc9c0\uc6d0 \ub300\uc0c1\uc73c\ub85c \uc804\ud658\ub428\uc744 \uacf5\uc9c0\ud558\uc600\uc74c.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\"><a href=\"https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/UserGuide\/extended-support.html\">https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/UserGuide\/extended-support.html<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\uc5f0\uc7a5 \uc9c0\uc6d0\uc73c\ub85c \uc790\uc6d0\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0, \uc801\uc9c0 \uc54a\uc740 \ucd94\uac00 \ube44\uc6a9(vCPU\/\uc2dc\uac04\ub2f9 0.12 USD)\uc774 \uccad\uad6c\ub418\uba70, \ubc84\uc804 \ud604\ud589\ud654 \ucc28\uc6d0\uc5d0\uc11c\ub3c4 5.7 \ubc84\uc804 \uc720\uc9c0\uac00 \uc6cc\ud06c\ub85c\ub4dc \uc0c1 \uc758\ubbf8\uac00 \uc5c6\ub2e4\uba74 \uc5c5\uadf8\ub808\uc774\ub4dc\uac00 \uad8c\uc7a5\ub428<\/span><\/p>\n<h2><span style=\"font-family: helvetica, arial, sans-serif;\"><strong>\uc720\uc758\uc0ac\ud56d<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\"><a href=\"https:\/\/repost.aws\/questions\/QUM2j4BPEQS5CBHVu4QbOLCA\/migrate-rds-mysql-8-0-28-to-aurora-mysql\">https:\/\/repost.aws\/questions\/QUM2j4BPEQS5CBHVu4QbOLCA\/migrate-rds-mysql-8-0-28-to-aurora-mysql<\/a><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">MySQL Community \ubc84\uc804\uc5d0\uc11c Aurora MySQL(Serverless) \ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ubc29\ubc95\uc740 \ud604\uc7ac \uc6d0\uc2a4\ud15d\uc73c\ub85c \uc9c0\uc6d0\ud558\ub294 \ubc29\ubc95\uc774 \uc5c6\uc74c.<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\ub530\ub77c\uc11c AWS \ud3ec\ub7fc\uc5d0\uc11c \uc81c\uc2dc\ud558\ub294 \ubc29\ubc95\uc740<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">1. Aurora read replica \ub97c \uc0dd\uc131\ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">2. Aurora MySQL (Replica cluster) \uc5d0\uc11c \uc2a4\ub0c5\uc0f7\uc744 \uc0dd\uc131\ud558\uc5ec Severless \uc778\uc2a4\ud134\uc2a4\ub85c Restore \ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\ud574\ub2f9 \ubc29\ubc95\uc5d0\ub294 \uba87\uac00\uc9c0 \uc81c\uc57d\uc0ac\ud56d\uc774 \uc788\uc74c<\/span><\/p>\n<ul>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">Serverless v2(aurora 3) \ub294 MySQL 8.0 \ubc84\uc804\uc5d0 \ub300\uc751\ub418\uba70, MySQL 5.7 \ubc84\uc804\uc5d0\ub294 Serverless v1(aurora 2) \uc774 \ub300\uc751\ub428<\/span><\/li>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">Serverless v2 \ub098 Aurora MySQL 8.0 \ubc84\uc804 \uc0dd\uc131\uc744 \uc704\ud574\uc11c\ub294 \uba3c\uc800 MySQL \ubc84\uc804\uc744 8.0 \uc774\uc0c1\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud574\uc57c \ud568.<\/span><\/li>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">MySQL Community \ubc84\uc804\uc5d0\uc11c \ubc14\ub85c Aurora MySQL \ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ub418\uc9c0 \uc54a\uc74c.<\/span><\/li>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">MySQL \uacfc Aurora MySQL(Serverless) \uc758 \ubc84\uc804\uc740 \uc11c\ub85c \uc77c\uce58\ud574\uc57c \ud568.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-family: helvetica, arial, sans-serif;\"><strong>\uc791\uc5c5 \ub0b4\uc6a9<\/strong><\/span><\/h2>\n<hr \/>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">\uc6b0\uc120 \ud3ec\ub7fc\uc5d0\uc11c \ucd94\ucc9c\ud558\ub294 \uc544\ub798\uc758 \ubc29\ubc95\ub300\ub85c \uc9c4\ud589\ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">1. &#8216;<strong>MySQL Community \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>&#8216;\uc758 \ubc84\uc804\uc744 <strong>&#8216;8.0.32&#8217;<\/strong> \ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud568<\/span><\/p>\n<ul>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">\ubb38\uc11c \uc791\uc131 \ub2f9\uc2dc \uae30\uc900\uc73c\ub85c 8.0.28 or 8.0.32 \ub85c \ub9de\ucdb0\uc57c \ud558\ub098, \uc5c5\uadf8\ub808\uc774\ub4dc\ub85c\ub294 8.0.32 \ub9cc \uc120\ud0dd \uac00\ub2a5\ud558\uc600\uc74c<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">2. <strong>8.0.32<\/strong> \ubc84\uc804\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ub41c <strong>MySQL Community \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/strong>\uc5d0\uc11c &#8216;<strong>Create Aurora Read Replica<\/strong>&#8216; \uc791\uc5c5\uc744 \uc2e4\ud589\ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">3. <strong>Serverless \uc778\uc2a4\ud134\uc2a4<\/strong>\ub97c \uc9c0\uc6d0\ud558\ub294 \ubc84\uc804\uc778 <strong>3.04.x \uc774\ub098 3.05.x<\/strong> \ub97c \uc120\ud0dd\ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">4. \uc0dd\uc131\ub41c &#8216;<strong>Replica Cluster<\/strong>&#8216; \uc5d0\uc11c &#8216;<strong>\uc2a4\ub0c5\uc0f7&#8217;<\/strong>\uc744 \uc0dd\uc131\ud568<\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\">5. \ud574\ub2f9 \uc2a4\ub0c5\uc0f7\uc73c\ub85c &#8216;<strong>Restore<\/strong>&#8216; \ub97c \uc9c4\ud589\ud568.<\/span><\/p>\n<ul>\n<li><span style=\"font-family: helvetica, arial, sans-serif;\">\uc778\uc2a4\ud134\uc2a4 \ud0c0\uc785\uc744 <strong>Serverless v2 <\/strong>\ub85c \uc120\ud0dd\ud558\uc5ec \uc0dd\uc131\ud558\uc600\uc74c.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-459\" src=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51.png\" alt=\"\" width=\"2916\" height=\"202\" srcset=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51.png 2916w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51-300x21.png 300w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51-1024x71.png 1024w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51-768x53.png 768w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51-1536x106.png 1536w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-2-51-2048x142.png 2048w\" sizes=\"(max-width: 2916px) 100vw, 2916px\" \/><\/span><\/p>\n<p><span style=\"font-family: helvetica, arial, sans-serif;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-460\" src=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37.png\" alt=\"\" width=\"2936\" height=\"200\" srcset=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37.png 2936w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37-300x20.png 300w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37-1024x70.png 1024w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37-768x52.png 768w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37-1536x105.png 1536w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_12-3-37-2048x140.png 2048w\" sizes=\"(max-width: 2936px) 100vw, 2936px\" \/><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-463 size-large\" src=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_10-48-10-1024x347.png\" alt=\"\" width=\"640\" height=\"217\" srcset=\"https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_10-48-10-1024x347.png 1024w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_10-48-10-300x102.png 300w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_10-48-10-768x261.png 768w, https:\/\/www.dkdk.info\/wpb\/wp-content\/uploads\/2024\/06\/image-2024-1-31_10-48-10.png 1444w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uac1c\uc694 AWS \uc758 \uad00\ub9ac\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ube44\uc2a4\uc778 RDS \uc5d0\uc11c\ub294 MySQL Community \uc640 \uac19\uc740 \uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc744 \uadf8\ub300\ub85c \uc9c0\uc6d0\ud558\uae30\ub3c4 \ud558\uba70, AWS \uc758 \uc790\uccb4 \uc5d4\uc9c4\uc778 Aurora \ub97c \ud1b5\ud574 \ud638\ud658 \ubc84\uc804\uc744 \uc81c\uacf5\ud558\uae30\ub3c4 \ud568. \uc774\uc804\uc5d0\ub294 Aurora \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc5d0 \ud070 \uc774\uc810\uc774 \uc5c6\uc5c8\uc73c\ub098, \ucd5c\uadfc\uc5d0\ub294 \uc5ec\ub7ec \uc0c8\ub85c\uc6b4 \uae30\uc220\uc774\ub098 Serverless \ud615\ud0dc\uc758 \uc778\uc2a4\ud134\uc2a4\ub294 Aurora \uc5d0\uc11c\ub9cc \uc9c0\uc6d0\ud558\ubbc0\ub85c Aurora MySQL(PostgreSQL) \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc810\uc774 \ub9e4\uc6b0 \ucee4\uc84c\ub2e4\uace0 \ud560 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":463,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/458"}],"collection":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=458"}],"version-history":[{"count":3,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions\/464"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/media\/463"}],"wp:attachment":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}