{"id":442,"date":"2023-08-28T16:37:12","date_gmt":"2023-08-28T07:37:12","guid":{"rendered":"https:\/\/www.dkdk.info\/wpb\/?p=442"},"modified":"2023-11-01T12:11:22","modified_gmt":"2023-11-01T03:11:22","slug":"aws-amazon-rds-cross-region-read-replica-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"https:\/\/www.dkdk.info\/wpb\/?p=442","title":{"rendered":"[AWS] Amazon RDS cross-Region read replica \uc0dd\uc131"},"content":{"rendered":"

\uac1c\uc694<\/strong><\/span><\/h2>\n
\n

Amazon RDS \uc5d0\uc11c\ub294 cross-Region read replica \ub77c\ub294 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud55c\ub2e4.<\/span><\/p>\n

\ud574\ub2f9 \uae30\ub2a5\uc740 master \uc5d0\uc11c \ub2e4\ub978 \ub9ac\uc804\uc5d0 read replica \ub97c \uc0dd\uc131\ud558\uc5ec \ub9ac\uc804 \uac04\uc758 DB \ub97c \uacf5\uc720\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc784.<\/span><\/p>\n

https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-global-database.html<\/a><\/span><\/p>\n

https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/AuroraMySQL.Replication.CrossRegion.html<\/a><\/span><\/p>\n

https:\/\/aws.amazon.com\/ko\/blogs\/database\/read-scalability-with-amazon-aurora-serverless-v2\/<\/a><\/span><\/p>\n

https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-serverless-v2.html<\/a><\/span><\/p>\n

\uae30\uc874\uc5d0 MySQL \ubc0f Aurora MySQL \uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud558\ub358 \uae30\ub2a5\uc774\uc5c8\uc73c\ub098, \uc774\ubc88\uc5d0 Serverless v2 \uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud55c\ub2e4\ub294 \ub0b4\uc6a9\uc774 \ucd94\uac00\ub418\uc5b4 \ud300\ub0b4 \uc790\uc6d0\uc5d0 \ucd94\uac00\ud558\uc600\ub2e4.<\/span><\/p>\n

\ud558\uc9c0\ub9cc \uc2e4\uc81c \uc801\uc6a9 \uacfc\uc815\uc5d0\uc11c \uc0dd\uac01\ubcf4\ub2e4 \uc81c\uc57d\uc0ac\ud56d \ubc0f \uc0ac\uc804 \uc124\uc815\uc774 \ud544\uc694\ud558\uc5ec, \ud574\ub2f9 \ub0b4\uc6a9\ub4e4\uc744 \ubb38\uc11c\uc5d0 \uc815\ub9ac\ud558\uc5ec \uae30\ub85d\ud558\uc600\ub2e4.<\/span><\/p>\n

\uae30\ub2a5 \uc0c1\uc138<\/strong><\/span><\/h2>\n
\n

Amazon Aurora \uae00\ub85c\ubc8c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub77c\ub294 \uae30\ub2a5\uc774\uba70, \ub2e4\uc74c\uacfc \uac19\uc740 \ud2b9\uc9d5\uc744 \uac00\uc9d0<\/span><\/p>\n

    \n
  • \ub85c\uceec \uc9c0\uc5f0 \uc2dc\uac04\uc73c\ub85c \ub2e4\ub978 \ub9ac\uc804\uc5d0 \ubc30\ud3ec<\/span><\/li>\n
  • \ub9ac\uc804 \uc804\uccb4 \uc7a5\uc560 \uc2dc, \ub2e4\ub978 \ub9ac\uc804\uc5d0\uc11c \uac00\uc6a9 \uc0c1\ud0dc\ub85c \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li>\n
  • DB \ud074\ub7ec\uc2a4\ud130\uc758 \uc791\uc5c5\uacfc \uc77d\uae30\/\uc4f0\uae30 \uc778\uc2a4\ud134\uc2a4\uc758 \uc6cc\ud06c\ub85c\ub4dc\uac00 \ubd84\ub9ac\ub418\uc5b4 \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\uc74c<\/span><\/li>\n<\/ul>\n

    \ub2e4\uc74c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\uc804\uc744 \uc9c0\uc6d0\ud558\uba70<\/span><\/p>\n

      \n
    • MySQL 8.0\uacfc \ud638\ud658\ub418\ub294 Aurora MySQL, \ubc84\uc804 3.01.0 \uc774\uc0c1<\/span><\/li>\n
    • MySQL 5.7\uacfc \ud638\ud658\ub418\ub294 Aurora MySQL, \ubc84\uc804 2.09.1 \uc774\uc0c1<\/span><\/li>\n
    • Aurora PostgreSQL \ubc84\uc804 13.3 \uc774\uc0c1, 12.4 \uc774\uc0c1, 11.9 \uc774\uc0c1, 10.14 \uc774\uc0c1<\/span><\/li>\n<\/ul>\n

      \ub2e4\uc74c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud615\ud0dc\ub85c \uc0dd\uc131\ud574\uc57c \ud568.<\/span><\/p>\n

        \n
      • Instance \ud0c0\uc785\uc744 \uc9c0\uc6d0\ud568<\/strong><\/u><\/span><\/li>\n
      • Serverless v1 \uc740 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc74c<\/span><\/li>\n
      • Serverless v2(Region Cluster) \ub85c \uc0dd\uc131\ud560 \uacbd\uc6b0, Serverless \uc778\uc2a4\ud134\uc2a4 \ud074\ub798\uc2a4\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc74c<\/strong><\/span><\/del><\/li>\n
      • Serverless v2 \uc778\uc2a4\ud134\uc2a4\ub97c \uc9c0\uc6d0\ud568 (2023-10-31 \ud655\uc778 \uc644\ub8cc)<\/span><\/strong>\n
          \n
        • Read Replica \uc0dd\uc131, \uae30\uc874 \uc778\uc2a4\ud134\uc2a4 Modify \ubaa8\ub450 \uac00\ub2a5\ud568<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          Parameter Group \uc5d0\uc11c replication \ubcf5\uc81c\ub97c \uc704\ud55c \uae30\ub2a5\uc744 \ud65c\uc131\ud654 \ud574\uc57c\ud568.<\/span><\/p>\n

            \n
          • binlog_format \uc758 \uac12\uc744 ROW \ub098 MIXED \ub85c \uc124\uc815\ud574\uc57c\ud568<\/strong><\/u><\/span><\/li>\n<\/ul>\n

            \uc0dd\uc131 \ubc29\ubc95<\/strong><\/span><\/h2>\n
            \n

            \ud300\ub0b4 DB \uc778\ud504\ub77c\ub294 \ubaa8\ub450 MySQL \uc744 \uc0ac\uc6a9\ud558\ubbc0\ub85c, MySQL \ud638\ud658 Aurora \ub85c \uc120\ud0dd\ud568.<\/span><\/p>\n

            \uadf8\ub9ac\uace0 \uc5d4\uc9c4 \ubc84\uc804\uc740 Serverless v2 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc120\ud0dd\ud568.<\/span><\/p>\n

            \"\"<\/p>\n

            DB \uc778\uc2a4\ud134\uc2a4 \ud074\ub798\uc2a4\ub294 \ubc18\ub4dc\uc2dc \uc778\uc2a4\ud134\uc2a4 \ud0c0\uc785\uc73c\ub85c \uc120\ud0dd\ud568<\/span><\/del><\/p>\n

            \bt class, r class, Serverless v2 \uc911\uc5d0\uc11c \uc6d0\ud558\ub294 \ud0c0\uc785\uc73c\ub85c \uc120\ud0dd\ud568<\/span><\/p>\n

            \"\"<\/p>\n

            read replica \uc5d0\uc11c \uc4f0\uae30\ub294 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\ub294 \ud3b8\uc774 \uc88b\uc73c\ubbc0\ub85c \uc120\ud0dd\ud558\uc9c0 \uc54a\uc74c.<\/span><\/p>\n

            \"\"<\/p>\n

            \uc0ac\uc804\uc5d0 Parameter Group \ub97c \uc0dd\uc131\ud574\uc11c binlog_format \uac12\uc744 \ubcc0\uacbd\ud55c\ub2e4.<\/span><\/p>\n

            \uadf8\ub9ac\uace0 \ud574\ub2f9 Parameter Group \uc744 \uc801\uc6a9\ud55c\ub2e4.<\/span><\/p>\n

            Encryption \uc740 \ud574\uc81c\ud558\uc5ec \uc0dd\uc131\ud568.<\/span><\/p>\n

              \n
            • \ubbfc\uac10\ud55c \ub370\uc774\ud130\uac00 \uc544\ub2cc \uacbd\uc6b0\uc5d0\ub294, \uc554\ud638\ud654\uc5d0 \ub530\ub978 \uc624\ubc84\ud5e4\ub4dc\uac00 \ub354 \ub9ac\uc2a4\ud06c\uac00 \ud074 \uac83\uc73c\ub85c \uc608\uc0c1\ud568<\/span><\/li>\n<\/ul>\n

              \"\"<\/p>\n

              \"\"<\/p>\n

              <\/h2>\n

              \uc774\uc288 \ud574\uacb0<\/strong><\/span><\/h2>\n
              \n

              binlog \ubcf5\uc81c\uac00 \uc548\ub418\ub294 \ud604\uc0c1<\/span><\/h3>\n

              Amazon RDS \uc758 read replica \uae30\ub2a5\uc740 MySQL \uc758 binlog \ubcf5\uc81c \uae30\ub2a5\uc744 \uc774\uc6a9\ud558\ub294 \uac83\uc774\ubbc0\ub85c, \uc544\ub798\uc640 \uac19\uc740 \uba85\ub839\uc5b4\ub85c binlog \uc758 \ubcf5\uc81c \uc0c1\ud0dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc74c.<\/span><\/p>\n

              \"\"<\/p>\n

              \"\"<\/p>\n

              \uadf8\ub7f0\ub370 binlog \ubcf5\uc81c\uac00 \uc9c0\uc5f0\ub418\uac70\ub098, \ub3d9\uc791\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0, Slave_IO_Running \uc0c1\ud0dc\uac00 \ube44\uc815\uc0c1\uc778 \uacbd\uc6b0\uac00 \uc788\uc74c.<\/span><\/p>\n

              \uc544\ub798\uc640 \uac19\uc774 Slave_IO_Running \ubc0f Slave_IO_State \uac00 Conneting \uc0c1\ud0dc\uc5d0 \uba38\ubb3c\ub7ec \uc788\ub294 \uacbd\uc6b0, master DB \uc5d0 \uc5f0\uacb0\uc774 \ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc774\ub2e4.<\/span><\/p>\n

              \"\"<\/p>\n

              \uc77c\ubc18\uc801\uc778 MySQL \ud658\uacbd\uc5d0\uc11c\ub294 \uc544\ub798\uc640 \uac19\uc740 \uc774\uc720\ub85c \ubc1c\uc0dd\ud568.<\/span><\/p>\n

              1. master DB \uc758 \ubc29\ud654\ubcbd \ubc0f Inbound \uc694\uccad\uc774 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud0dc<\/span><\/p>\n

              2. master DB \uc5d0\uc11c \uc5f0\uacb0 \ud5c8\uc6a9\ub41c \ud638\uc2a4\ud2b8 \ud639\uc740 \uc720\uc800\uac00 \uc544\ub2d0 \uacbd\uc6b0<\/span><\/p>\n

              \ud558\uc9c0\ub9cc Amazon RDS \ub294 Amazon \uad00\ub9ac\ud615 \uc11c\ube44\uc2a4\uc774\ubbc0\ub85c, \ub514\ud3f4\ud2b8 \uc0c1\ud0dc\uc5d0\uc11c \uc5f0\uacb0\uc131 \ubc0f \ubcf4\uc548 \uc124\uc815\uc740 \uc801\uc6a9\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba70, Master \uc640 Slave \uac04\uc758 Security Group \uc124\uc815\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc74c.<\/span><\/p>\n

              RDS \ub97c \uc124\uc815\ud558\ub294 \uacfc\uc815\uc5d0\uc11c \ubc1c\uacac\ud55c \uac83\uc740, RDS \uc778\uc2a4\ud134\uc2a4 \uc811\uc18d\uc744 \uc704\ud55c CA \uc778\uc99d\uc11c\ub97c \uc0c8\ub85c\uc6b4 rds-ca-rsa2048-g1 \ub85c \uc0ac\uc6a9\ud558\uba74 Slave_IO_Running \uc0c1\ud0dc\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4\ub294 \uac83\uc784.<\/span><\/p>\n

              \uc774\ub97c \uae30\uc874\uc5d0 \uc0ac\uc6a9\ud558\ub358 rds-ca-2019 \uc778\uc99d\uc11c\ub97c \uc0ac\uc6a9\ud558\uba74 Slave_IO_Running \ubb38\uc81c\uac00 \ud574\uacb0\uc774 \ub418\uc5c8\ub2e4.<\/span><\/p>\n

              \"\"<\/p>\n

              \ud574\ub2f9 \uc778\uc99d\uc11c\ub294 2024-08-23 \uc5d0 \ub9cc\ub8cc\ub418\ub294 \uc778\uc99d\uc11c\uc774\ubbc0\ub85c, \uadf8 \uc804\uc5d0 \uc644\ubcbd\ud558\uac8c \ub3d9\uc791\ud558\ub294 \ud658\uacbd\uc5d0 \ub300\ud574 \ud14c\uc2a4\ud2b8\uac00 \ud544\uc694\ud560 \uac83\uc73c\ub85c \ubcf4\uc784.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

              \uac1c\uc694 Amazon RDS \uc5d0\uc11c\ub294 cross-Region read replica \ub77c\ub294 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud55c\ub2e4. \ud574\ub2f9 \uae30\ub2a5\uc740 master \uc5d0\uc11c \ub2e4\ub978 \ub9ac\uc804\uc5d0 read replica \ub97c \uc0dd\uc131\ud558\uc5ec \ub9ac\uc804 \uac04\uc758 DB \ub97c \uacf5\uc720\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc784. https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-global-database.html https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/AuroraMySQL.Replication.CrossRegion.html https:\/\/aws.amazon.com\/ko\/blogs\/database\/read-scalability-with-amazon-aurora-serverless-v2\/ https:\/\/docs.aws.amazon.com\/ko_kr\/AmazonRDS\/latest\/AuroraUserGuide\/aurora-serverless-v2.html \uae30\uc874\uc5d0 MySQL \ubc0f Aurora MySQL \uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud558\ub358 \uae30\ub2a5\uc774\uc5c8\uc73c\ub098, \uc774\ubc88\uc5d0 Serverless v2 \uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud55c\ub2e4\ub294 \ub0b4\uc6a9\uc774 \ucd94\uac00\ub418\uc5b4 \ud300\ub0b4 \uc790\uc6d0\uc5d0 \ucd94\uac00\ud558\uc600\ub2e4. \ud558\uc9c0\ub9cc \uc2e4\uc81c \uc801\uc6a9 \uacfc\uc815\uc5d0\uc11c \uc0dd\uac01\ubcf4\ub2e4 […]<\/p>\n","protected":false},"author":1,"featured_media":444,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[7,28],"class_list":["post-442","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it","tag-aws","tag-rds"],"_links":{"self":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/442"}],"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=442"}],"version-history":[{"count":3,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"predecessor-version":[{"id":455,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions\/455"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=\/wp\/v2\/media\/444"}],"wp:attachment":[{"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dkdk.info\/wpb\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}