{"id":350,"date":"2021-02-10T07:20:12","date_gmt":"2021-02-09T22:20:12","guid":{"rendered":"https:\/\/manvscloud.com\/?p=350"},"modified":"2021-02-27T08:25:47","modified_gmt":"2021-02-26T23:25:47","slug":"aws-rds-aurora-failover%ec%99%80-%ec%9a%b0%ec%84%a0-%ec%88%9c%ec%9c%84tier","status":"publish","type":"post","link":"https:\/\/manvscloud.com\/?p=350","title":{"rendered":"[AWS] RDS Aurora &#8211; FAILOVER\uc640 \uc6b0\uc120 \uc21c\uc704(tier)"},"content":{"rendered":"\n<p> \uc548\ub155\ud558\uc138\uc694. ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc624\ub298\uc740 \uae34 \uc2dc\uac04 \ubbf8\ub904\uc654\ub358 AWS AURORA\uc758 FAILOVER\uc5d0 \ub300\ud55c \ud3ec\uc2a4\ud305\uc744 \ud574\ubcf4\ub824\ud569\ub2c8\ub2e4.<br>\uc774 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131 \uacfc\uc815 \ubc0f \ubcf4\uc548\uadf8\ub8f9 \uc124\uc815\uacfc \uac19\uc740 \uac04\ub2e8\ud55c \uc791\uc5c5\uc740 \uc0dd\ub7b5\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>AWS \ucf58\uc194\uc5d0\uc11c [\uc7a5\uc560\uc870\uce58]\ub97c \ud558\uc5ec \uc7a5\uc560\uc870\uce58 \uacfc\uc815\uc744 1\ucd08\ub9c8\ub2e4 \ud655\uc778\ud560 \uc218 \uc788\ub3c4\ub85d \uc258 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud558\uc5ec EC2\uc5d0\uc11c \uc7a5\uc560\uc870\uce58\uc5d0 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uacfc \uc5b4\ub5bb\uac8c \ubcc0\ud654\uac00 \uc774\ub8e8\uc5b4 \uc9c0\ub294\uc9c0 \ud655\uc778\ud574\ubcfc \uac83\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uadf8\ub7fc DB \uc0dd\uc131\ubd80\ud130 \uc2dc\uc791\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"has-white-color has-pale-cyan-blue-background-color has-text-color has-background wp-block-heading\">    AURORA DB \uc0dd\uc131<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"736\" height=\"830\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10060742\/aurora1.png\" alt=\"\" class=\"wp-image-353\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10060742\/aurora1.png 736w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10060742\/aurora1-266x300.png 266w\" sizes=\"(max-width: 736px) 100vw, 736px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"856\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061020\/aurora2.png\" alt=\"\" class=\"wp-image-354\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061020\/aurora2.png 720w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061020\/aurora2-252x300.png 252w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>\ubc84\uc804\uc740 Aurora (MYSQL 5.7) 2.07.2\ub85c \ud558\uc600\uc73c\uba70 DB \uc0dd\uc131\uc740 \uc704\uc640 \uac19\uc774 \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"368\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-1024x368.png\" alt=\"\" class=\"wp-image-355\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-1024x368.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-300x108.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-768x276.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-1536x552.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3-1080x388.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061027\/aurora3.png 1892w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc0dd\uc131\ud558\ub294 \ubd80\ubd84\uc740 \uac04\ub2e8\ud558\ub2c8 \ucd94\uac00\uc801\uc778 \uc124\uba85\uc5c6\uc774 \uc774\ubbf8\uc9c0\ub9cc \ucca8\ubd80\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<br>\uc774\ubbf8\uc9c0\uac00 \uc798 \ubcf4\uc774\uc9c0\uc54a\uc744 \uacbd\uc6b0 \uc0c8 \ud0ed\uc744 \uc774\uc6a9\ud558\uc5ec \ud06c\uac8c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"has-white-color has-luminous-vivid-amber-background-color has-text-color has-background wp-block-heading\">    EC2 \uc0dd\uc131<\/h2>\n\n\n\n<p>AURORA DB \uc0dd\uc131 \ud6c4 \ud14c\uc2a4\ud2b8\uc6a9 EC2\ub97c \ucd94\uac00\ub85c \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<br>\ud574\ub2f9 EC2\ub85c FAILOVER\uac00 \ub418\ub294 \uacfc\uc815\uc744 \ud655\uc778\ud574\ubcf4\ub824 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"427\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-1024x427.png\" alt=\"\" class=\"wp-image-357\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-1024x427.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-300x125.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-768x320.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-1536x640.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2-1080x450.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061051\/aurora-ec2.png 1624w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>EC2 \uc0dd\uc131 \ud6c4 \ud574\ub2f9  EC2\ub85c \uc811\uadfc\ud558\uc5ec FAILOVER\ub97c \uc2a4\ud06c\ub9bd\ud2b8\ub85c \ud655\uc778\ud558\uae30 \uc704\ud574 date\ub97c \uad6d\ub0b4 \uc2dc\uac04\uc73c\ub85c \ub9de\ucdb0\uc8fc\uace0 mysql client\ub97c \uc124\uce58\ud574\uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"109\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061105\/aurora-ec2-2.png\" alt=\"\" class=\"wp-image-358\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061105\/aurora-ec2-2.png 570w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061105\/aurora-ec2-2-300x57.png 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"has-white-color has-vivid-red-background-color has-text-color has-background wp-block-heading\">    Shell Script \uc0dd\uc131\uacfc FAILOVER \ud14c\uc2a4\ud2b8<\/h2>\n\n\n\n<p>\uae30\ubcf8\uc801\uc778 \uc900\ube44\uac00 \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74 FAILOVER\uac00 \uc9c4\ud589\ub418\ub294 \uacfc\uc815\uc744 \ubcfc \uc218 \uc788\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-white-color has-black-background-color has-text-color has-background\">cd<br>vi failover.sh<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#!\/bin\/bash\n\nwhile true\ndo\n\nDATE=$(date +\"%Y\ub144%m\uc6d4%d\uc77c %H\uc2dc%M\ubd84%S\ucd08\")\nAZ2A=$(echo \"show variables like '%innodb_read_only%';\" | mysql -u'manvscloud' -p'PW' -h manvsaurora-instance-1.cewyawynarwh.ap-northeast-2.rds.amazonaws.com | grep read | awk '{print $2}')\nAZ2C=$(echo \"show variables like '%innodb_read_only%';\" | mysql -u'manvscloud' -p'PW' -h manvsaurora-instance-1-ap-northeast-2c.cewyawynarwh.ap-northeast-2.rds.amazonaws.com | grep read | awk '{print $2}')\n\nWRITE=$(echo OFF)\nREAD=$(echo ON)\n\necho \"#########$DATE#########\"\n\nif [ $AZ2A == $WRITE ]; then\n echo \"manvsaurora-instance-1_2A [\uc4f0\uae30]\"\n\nelif [ $AZ2A == $READ ]; then\n echo \"manvsaurora-instance-1_2A [\uc77d\uae30]\"\n\nelse\n echo \"FAILOVER \uc9c4\ud589\uc911\"\n\nfi\n\n\nif [ $AZ2C == $WRITE ]; then\n echo \"manvsaurora-instance-1-ap-northeast-2c_2C [\uc4f0\uae30]\"\n\nelif [ $AZ2C == $READ ]; then\n echo \"manvsaurora-instance-1-ap-northeast-2c_2C [\uc77d\uae30]\"\n\nelse\n echo \"FAILOVER \uc9c4\ud589\uc911\"\n\nfi\n\n\nsleep 1\n\ndone<\/pre>\n\n\n\n<p>FAILOVER\uac00 \ub418\ub294 \uacfc\uc815\uc744 \uc4f0\uae30\uc640 \uc77d\uae30\uac00 \ubc14\ub00c\ub294 \uac83\uc744 \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud574\ubcfc \uac83\uc785\ub2c8\ub2e4.<br>\uc544\ub798 \uc0ac\uc9c4\uacfc \uac19\uc774 show variables like &#8216;%innodb_read_only%&#8217;; \ub97c \uc774\uc6a9\ud558\uc5ec \uc778\uc2a4\ud134\uc2a4\uc758 \uc77d\uae30\/\uc4f0\uae30 \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4-1024x61.png\" alt=\"\" class=\"wp-image-360\" width=\"796\" height=\"47\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4-1024x61.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4-300x18.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4-768x46.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4-1080x65.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061117\/aurora-ec2-4.png 1537w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<p>\ub9cc\ub4e4\uc5b4\uc9c4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uad8c\ud55c\uc744 \ubcc0\uacbd\ud574\uc8fc\uace0 \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec FAILOVER\ub97c \uc9c4\ud589 \uc0c1\ud0dc\ub97c \ud655\uc778\ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-white-color has-black-background-color has-text-color has-background\">chmod 755 failover.sh<br>\/root\/failover.sh 2&gt; \/dev\/null<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"67\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061111\/aurora-ec2-3.png\" alt=\"\" class=\"wp-image-359\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061111\/aurora-ec2-3.png 540w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061111\/aurora-ec2-3-300x37.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/figure>\n\n\n\n<p>\ubc31\uadf8\ub77c\uc6b4\ub4dc\ub85c \uc2e4\ud589\ud558\uc5ec \ud14d\uc2a4\ud2b8\ud30c\uc77c\ub85c \uc800\uc7a5\ud558\uace0 \uc2f6\uc73c\uc2e0 \uacbd\uc6b0 \uc704 \uc0ac\uc9c4\ucc98\ub7fc <br>\/root\/failover.sh 2&gt; \/dev\/null &gt; failover.txt &amp; \ub97c \uc2e4\ud589\ud558\uba74 failover.txt \ud30c\uc77c\ub85c \uc0dd\uc131\ub418\uba70 \ub370\uc774\ud130\uac00 \uc313\uc774\uac8c\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub9cc \uc313\uc774\uac8c \ud558\ub824\uba74 \uc2e4\ud589\ub41c \ud504\ub85c\uc138\uc2a4\ub97c kill \ud558\uc2dc\uba74\ub429\ub2c8\ub2e4. \uc704 \uc0ac\uc9c4\uc744 \uc608\ub85c kill -9 9402 \uc785\ub2c8\ub2e4.<br>\ub610\ub294 ps \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec \uc2e4\ud589\ub418\uace0 \uc788\ub294 \ud504\ub85c\uc138\uc2a4 PID \ub97c \ud655\uc778\ud574\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"440\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-1024x440.png\" alt=\"\" class=\"wp-image-356\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-1024x440.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-300x129.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-768x330.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-1536x661.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4-1080x464.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061044\/aurora4.png 1858w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>AWS \ucf58\uc194\ub85c \ub3cc\uc544\uac00 AURORA DB \uc7a5\uc560\uc870\uce58\ub97c \uc2dc\uc791\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br>\uc4f0\uae30 \uc778\uc2a4\ud134\uc2a4\uc5d0 \uc7a5\uc560\uc870\uce58\ub97c \uc2e4\ud589\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"><strong>-. \ud604\uc7ac \uc0c1\ud0dc<\/strong><\/p>\n\n\n\n<p class=\"has-white-color has-luminous-vivid-orange-background-color has-text-color has-background\"> ap-northeast-2a : [\uc4f0\uae30]<br> ap-northeast-2c : [\uc77d\uae30]<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"602\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061125\/aurora-ec2-5.png\" alt=\"\" class=\"wp-image-361\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061125\/aurora-ec2-5.png 411w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10061125\/aurora-ec2-5-205x300.png 205w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<p>1\ucd08\ub9c8\ub2e4 \uc778\uc2a4\ud134\uc2a4\uc758 \uc77d\uae30\/\uc4f0\uae30 \uc0c1\ud0dc\uac00 \ub098\uc624\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><strong>[\uc7a5\uc560\uc870\uce58]<\/strong>\ub97c \uc2e4\ud589\ud558\uace0 \uc5bc\ub9c8\uc9c0\ub098\uc9c0\uc54a\uc544 <strong><span class=\"has-inline-color has-luminous-vivid-amber-color\">&#8216;FAILOVER \uc9c4\ud589\uc911&#8217;<\/span><\/strong> \uc0c1\ud0dc\ub85c \ubcc0\ud558\uac8c\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub450 \uc778\uc2a4\ud134\uc2a4 \ubaa8\ub450 \uc815\uc0c1\uc73c\ub85c \ub3cc\uc544\uc624\uae30\uae4c\uc9c0 \uc57d 7~8\ucd08\uac00 \uc18c\uc694\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<br>\ub610\ud55c \uc0ac\uc9c4\uc744 \ubcf4\uc2dc\ub2e4\uc2dc\ud53c 2C \uac00\uc6a9 \uc601\uc5ed\uc758 \uc778\uc2a4\ud134\uc2a4\uac00 FAILOVER\uac00 \uc9c4\ud589\ub418\uace0 \uc5bc\ub9c8 \uc9c0\ub098\uc9c0 \uc54a\uc544  [\uc4f0\uae30] \uc0c1\ud0dc\ub85c \ubcc0\ud558\uace0 2A \uac00\uc6a9 \uc601\uc5ed\uc758 \uc778\uc2a4\ud134\uc2a4\uac00 FAILOVER \uc0c1\ud0dc\uac00 \ub418\uba70 [\uc77d\uae30] \uc0c1\ud0dc\ub85c \ubcc0\ud558\uac8c \ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"has-white-color has-vivid-cyan-blue-background-color has-text-color has-background wp-block-heading\">  \uc6b0\uc120 \uc21c\uc704<\/h2>\n\n\n\n<p>AURORA DB\uac00 FAILOVER \ub420 \ub54c \uba3c\uc800 FAILOVER \ub418\ub294 \uc6b0\uc120 \uc21c\uc704\uac00 \uc788\uc2b5\ub2c8\ub2e4.<br>\uc7a5\uc560 \ubcf5\uad6c \uc2dc \uac00\uc7a5 \uc6b0\uc120 \uc21c\uc704\uc758 \ud2f0\uc5b4\ub97c \uc6b0\uc120\uc801\uc73c\ub85c \uc7a5\uc560 \ubcf5\uad6c\ub97c \uc2dc\uc791\ud558\uace0<br>2\uac1c \uc774\uc0c1\uc758 \uc77d\uae30 \ubcf5\uc81c\ubcf8\uc774 \uac19\uc740 \uc6b0\uc120 \uc21c\uc704\uc77c\ub54c\ub294 \uc774\uc804 \uae30\ubcf8 \uc778\uc2a4\ud134\uc2a4\uc640 \uac19\uc740 \uc6a9\ub7c9\uc744 \uc6b0\uc120 \uc120\ud0dd\ud558\uc5ec \uc7a5\uc560 \ubcf5\uad6c\ub429\ub2c8\ub2e4.<br>(\ub3d9\uc77c\ud55c \ud06c\uae30\uc758 \uc778\uc2a4\ud134\uc2a4\ub97c FAILOVER \ud558\ub294 \uac83\uc774 \uc7a5\uc560 \ubcf5\uad6c \uc9c0\uc5f0 \uc2dc\uac04\uc744 \ucd5c\uc18c\ud654 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>\ub610\ud55c \ub458 \uc774\uc0c1\uc758 Aurora \ubcf5\uc81c\ubcf8\uc774 \ub3d9\uc77c\ud55c \uc6b0\uc120 \uc21c\uc704\uc640 \ud06c\uae30\ub97c \uacf5\uc720\ud558\uace0 \uc788\uc744 \uacbd\uc6b0 \ub3d9\uc77c\ud55c \ud504\ub85c\ubaa8\uc158 \uacc4\uce35\uc5d0\uc11c \uc784\uc758\uc758 \ubcf5\uc81c\ubcf8\uc744 \uc7a5\uc560 \ubcf5\uad6c\ud558\uba70, \ub458 \uc774\uc0c1\uc758 Aurora \ubcf5\uc81c\ubcf8\uc774 \ub3d9\uc77c\ud55c \uc6b0\uc120 \uc21c\uc704\ub97c \uacf5\uc720\ud558\ub294 \uacbd\uc6b0 \ud06c\uae30\uac00 \uac00\uc7a5 \ud070 \ubcf5\uc81c\ubcf8\uc744 \uc6b0\uc120 \uc7a5\uc560 \ubcf5\uad6c\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub807\ub2e4\uba74 \uc7a5\uc560 \uc870\uce58 \uc6b0\uc120 \uc21c\uc704\ub294 \uc5b4\ub5bb\uac8c \uc124\uc815\ud558\ub294\uac00?<\/p>\n\n\n\n<p>\uc6b0\uc120 \uc21c\uc704\ub97c \ubcc0\uacbd\ud560 \uc778\uc2a4\ud134\uc2a4\ub97c \ud074\ub9ad \ud6c4 <strong>[\uc218\uc815]<\/strong>\uc744 \uc120\ud0dd\ud558\uc5ec \uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc774<br>\uc7a5\uc560 \uc870\uce58 \uc6b0\uc120 \uc21c\uc704\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070030\/%EC%9A%B0%EC%84%A0.png\" alt=\"\" class=\"wp-image-362\"\/><\/figure>\n\n\n\n<p>\uc778\uc2a4\ud134\uc2a4\uac00 \uc5ec\ub7ec\uac1c\uc77c \uacbd\uc6b0 \uc6b0\uc120 \uc21c\uc704 \uc124\uc815\uc744 \uc774\uc6a9\ud558\uc5ec \uc6b0\uc120 \uc7a5\uc560\uc870\uce58 \uc21c\uc704\ub97c \uc124\uc815\ud558\ub3c4\ub85d \ud569\uc2dc\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"176\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-1024x176.png\" alt=\"\" class=\"wp-image-363\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-1024x176.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-300x52.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-768x132.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-1536x264.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1-1080x186.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070310\/aurora-proxy1.png 1842w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ucd94\uac00\ub85c RDS Proxy\ub97c \uc774\uc6a9\ud558\uba74 \uc7a5\uc560 \uc870\uce58 \uc2dc\uac04\uc744&nbsp;Aurora DB\uc758 \uacbd\uc6b0 \ucd5c\ub300 79% \uc77c\ubc18 RDS \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ucd5c\ub300 32%\uae4c\uc9c0 \ub2e8\ucd95\ud560 \uc218 \uc788\ub2e4\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-1024x462.png\" alt=\"\" class=\"wp-image-364\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-1024x462.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-300x135.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-768x347.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-1536x693.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy-1080x487.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/02\/10070833\/proxy.png 1629w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc774\uac83 \uc5ed\uc2dc \ud14c\uc2a4\ud2b8 \ud574\ubd24\ub294\ub370 &nbsp;\uc0dd\uc131\uc740 \uc798 \ub410\ub294\ub370 \uc544\ub798\uc640 \uac19\uc774 \ud578\ub4dc\uc250\uc774\ud06c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uba70 \uc811\uc18d\uc774 \ub418\uc9c0\uc54a\uc544 \ud3ec\uae30\ud588\uc2b5\ub2c8\ub2f9&#8230;<\/p>\n\n\n\n<p class=\"has-white-color has-black-background-color has-text-color has-background\">ERROR 2013 (HY000): Lost connection to MySQL server at &#8216;handshake: reading initial communication packet&#8217;, system error: 11<\/p>\n\n\n\n<p>\ud504\ub85d\uc2dc \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub85c \ubd99\uc9c0\uc54a\ub124\uc694&#8230;<br>\uc774\uac74 \ub2e4\uc74c\uc5d0 \uc2dc\uac04\ub098\uba74 \ucd94\uac00 \ud14c\uc2a4\ud2b8\ub97c \uc9c4\ud589\ud574\ubcf4\uc544\uc57c\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc0c1 AWS Aurora\uc758 FAILOVER \uc640 \uc6b0\uc120 \uc21c\uc704\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uae34 \uae00 \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694. ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4. \uc624\ub298\uc740 \uae34 \uc2dc\uac04 \ubbf8\ub904\uc654\ub358 AWS AURORA\uc758 FAILOVER\uc5d0 \ub300\ud55c \ud3ec\uc2a4\ud305\uc744 \ud574\ubcf4\ub824\ud569\ub2c8\ub2e4.\uc774 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131 \uacfc\uc815 \ubc0f \ubcf4\uc548\uadf8\ub8f9 \uc124\uc815\uacfc \uac19\uc740 \uac04\ub2e8\ud55c \uc791\uc5c5\uc740 \uc0dd\ub7b5\ud558\uc600\uc2b5\ub2c8\ub2e4. AWS \ucf58\uc194\uc5d0\uc11c [\uc7a5\uc560\uc870\uce58]\ub97c \ud558\uc5ec \uc7a5\uc560\uc870\uce58 \uacfc\uc815\uc744 1\ucd08\ub9c8\ub2e4 \ud655\uc778\ud560 \uc218 \uc788\ub3c4\ub85d \uc258 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud558\uc5ec EC2\uc5d0\uc11c \uc7a5\uc560\uc870\uce58\uc5d0 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uacfc \uc5b4\ub5bb\uac8c \ubcc0\ud654\uac00 \uc774\ub8e8\uc5b4 \uc9c0\ub294\uc9c0 \ud655\uc778\ud574\ubcfc \uac83\uc785\ub2c8\ub2e4. \uadf8\ub7fc DB \uc0dd\uc131\ubd80\ud130 \uc2dc\uc791\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. AURORA DB \uc0dd\uc131 \ubc84\uc804\uc740 Aurora (MYSQL 5.7) 2.07.2\ub85c \ud558\uc600\uc73c\uba70 DB \uc0dd\uc131\uc740 \uc704\uc640 \uac19\uc774 \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc0dd\uc131\ud558\ub294 \ubd80\ubd84\uc740 \uac04\ub2e8\ud558\ub2c8 \ucd94\uac00\uc801\uc778 \uc124\uba85\uc5c6\uc774 \uc774\ubbf8\uc9c0\ub9cc \ucca8\ubd80\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.\uc774\ubbf8\uc9c0\uac00 \uc798 \ubcf4\uc774\uc9c0\uc54a\uc744 \uacbd\uc6b0 \uc0c8 \ud0ed\uc744 \uc774\uc6a9\ud558\uc5ec \ud06c\uac8c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. EC2 \uc0dd\uc131 AURORA DB \uc0dd\uc131 \ud6c4 \ud14c\uc2a4\ud2b8\uc6a9 EC2\ub97c \ucd94\uac00\ub85c \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.\ud574\ub2f9 EC2\ub85c FAILOVER\uac00 \ub418\ub294 \uacfc\uc815\uc744 \ud655\uc778\ud574\ubcf4\ub824 \ud569\ub2c8\ub2e4. EC2 \uc0dd\uc131 \ud6c4 \ud574\ub2f9 EC2\ub85c \uc811\uadfc\ud558\uc5ec FAILOVER\ub97c \uc2a4\ud06c\ub9bd\ud2b8\ub85c \ud655\uc778\ud558\uae30 \uc704\ud574 date\ub97c \uad6d\ub0b4 \uc2dc\uac04\uc73c\ub85c \ub9de\ucdb0\uc8fc\uace0 mysql client\ub97c \uc124\uce58\ud574\uc8fc\uc5c8\uc2b5\ub2c8\ub2e4. Shell Script \uc0dd\uc131\uacfc FAILOVER \ud14c\uc2a4\ud2b8 \uae30\ubcf8\uc801\uc778 \uc900\ube44\uac00 \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74 FAILOVER\uac00 \uc9c4\ud589\ub418\ub294 \uacfc\uc815\uc744 \ubcfc \uc218 \uc788\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. cdvi failover.sh FAILOVER\uac00 \ub418\ub294 \uacfc\uc815\uc744 \uc4f0\uae30\uc640 \uc77d\uae30\uac00 \ubc14\ub00c\ub294 \uac83\uc744 \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud574\ubcfc \uac83\uc785\ub2c8\ub2e4.\uc544\ub798 \uc0ac\uc9c4\uacfc \uac19\uc774 show variables like &#8216;%innodb_read_only%&#8217;; \ub97c \uc774\uc6a9\ud558\uc5ec \uc778\uc2a4\ud134\uc2a4\uc758 \uc77d\uae30\/\uc4f0\uae30 \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. \ub9cc\ub4e4\uc5b4\uc9c4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uad8c\ud55c\uc744 \ubcc0\uacbd\ud574\uc8fc\uace0 \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec FAILOVER\ub97c \uc9c4\ud589 \uc0c1\ud0dc\ub97c \ud655\uc778\ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. chmod 755 failover.sh\/root\/failover.sh 2&gt; \/dev\/null \ubc31\uadf8\ub77c\uc6b4\ub4dc\ub85c \uc2e4\ud589\ud558\uc5ec \ud14d\uc2a4\ud2b8\ud30c\uc77c\ub85c \uc800\uc7a5\ud558\uace0 \uc2f6\uc73c\uc2e0 \uacbd\uc6b0 \uc704 \uc0ac\uc9c4\ucc98\ub7fc \/root\/failover.sh 2&gt; \/dev\/null &gt; failover.txt &amp; \ub97c \uc2e4\ud589\ud558\uba74 failover.txt \ud30c\uc77c\ub85c \uc0dd\uc131\ub418\uba70 \ub370\uc774\ud130\uac00 \uc313\uc774\uac8c\ub429\ub2c8\ub2e4. \uadf8\ub9cc \uc313\uc774\uac8c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[104,105,115,110,6,108,107,109,32,106,114,113,112],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/350"}],"collection":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=350"}],"version-history":[{"count":8,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/350\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/350\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}