{"id":2673,"date":"2026-10-24T09:00:42","date_gmt":"2026-10-24T09:00:42","guid":{"rendered":"https:\/\/wayhope.kro.kr\/?p=2673"},"modified":"2026-10-24T09:00:55","modified_gmt":"2026-10-24T09:00:55","slug":"db-%eb%b3%b5%ec%a0%9c%ec%99%80-%ec%9d%bd%ea%b8%b0%c2%b7%ec%93%b0%ea%b8%b0-%eb%b6%84%eb%a6%ac-primary-replica-replication-lag","status":"publish","type":"post","link":"https:\/\/wayhope.kro.kr\/?p=2673","title":{"rendered":"DB \ubcf5\uc81c\uc640 \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac #Primary-Replica #Replication Lag"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\uc11c\ube44\uc2a4\uc758 \uc0ac\uc6a9\uc790\uac00 \uc99d\uac00\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc804\ub2ec\ub418\ub294 \uc694\uccad\ub3c4 \ud568\uaed8 \uc99d\uac00\ud55c\ub2e4. \ud2b9\ud788 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\ub294 \ub85c\uadf8\uc778, \ud504\ub85c\ud544 \uc870\ud68c, \uc778\ubca4\ud1a0\ub9ac \uc870\ud68c, \ub7ad\ud0b9 \uc870\ud68c, \uc0c1\uc810 \uc870\ud68c \ub4f1 \ub2e4\uc591\ud55c \uc77d\uae30 \uc694\uccad\uc774 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 \uc77d\uae30\uc640 \uc4f0\uae30 \uc694\uccad\uc744 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0\uc11c \ucc98\ub9ac\ud558\uba74 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O, \ub124\ud2b8\uc6cc\ud06c \ub4f1\uc758 \uc790\uc6d0\uc774 \ubcd1\ubaa9\uc774 \ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub300\ud45c\uc801\uc778 \ubc29\ubc95 \uc911 \ud558\ub098\uac00 <strong>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uc81c(Replication)\uc640 \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac(Read\/Write Splitting)<\/strong> \ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud575\uc2ec\uc740 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \ubcf5\uc81c\ud558\uace0, \ub370\uc774\ud130 \ubcc0\uacbd\uc740 Primary\uc5d0\uc11c \ucc98\ub9ac\ud558\uba70, \uc870\ud68c\ub294 Replica\ub85c \ubd84\uc0b0\ud558\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \ubcf5\uc81c\ub294 \ub370\uc774\ud130\ub97c \ubaa8\ub4e0 \uc11c\ubc84\uc5d0 \uc989\uc2dc \ub3d9\uc77c\ud558\uac8c \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc774 \uc544\ub2c8\ub2e4. \ubcf5\uc81c \uc9c0\uc5f0\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\ub9cc\uc73c\ub85c \ubaa8\ub4e0 \uc131\ub2a5 \ubb38\uc81c\uac00 \ud574\uacb0\ub418\ub294 \uac83\ub3c4 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uae00\uc5d0\uc11c\ub294 Primary-Replica \uad6c\uc870, Replication, Replication Lag, Read Replica, \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\uc758 \ud55c\uacc4\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Primary-Replica \uad6c\uc870<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Primary\uc640 Replica\ub780?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Primary-Replica\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \uc5ed\ud560\uc744 \uad6c\ubd84\ud558\ub294 \uad6c\uc870\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primary<\/strong>: \ub370\uc774\ud130 \ubcc0\uacbd \uc791\uc5c5\uc744 \ucc98\ub9ac\ud558\ub294 \uae30\uc900 \uc11c\ubc84<\/li>\n\n\n\n<li><strong>Replica<\/strong>: Primary\uc758 \ub370\uc774\ud130\ub97c \ubcf5\uc81c\ud558\uc5ec \uc8fc\ub85c \uc77d\uae30 \uc791\uc5c5\uc744 \ucc98\ub9ac\ud558\ub294 \uc11c\ubc84<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130 \ubcc0\uacbd\uc740 Primary\uc5d0\uc11c \uc218\ud589\ud558\uace0, Replica\ub294 \ubcf5\uc81c\ub41c \ub370\uc774\ud130\ub97c \uc774\uc6a9\ud574 \uc870\ud68c \uc694\uccad\uc744 \ucc98\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc694\uccad\uc774 \ubc1c\uc0dd\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\uc694\uccad<\/th><th>\ucc98\ub9ac \uc11c\ubc84<\/th><\/tr><tr><td>\ud50c\ub808\uc774\uc5b4 \uc815\ubcf4 \uc870\ud68c<\/td><td>Replica<\/td><\/tr><tr><td>\uc778\ubca4\ud1a0\ub9ac \uc870\ud68c<\/td><td>Replica<\/td><\/tr><tr><td>\ub7ad\ud0b9 \uc870\ud68c<\/td><td>Replica<\/td><\/tr><tr><td>\uc544\uc774\ud15c \uad6c\ub9e4<\/td><td>Primary<\/td><\/tr><tr><td>\ud3ec\uc778\ud2b8 \ucc28\uac10<\/td><td>Primary<\/td><\/tr><tr><td>\uce90\ub9ad\ud130 \uc774\ub984 \ubcc0\uacbd<\/td><td>Primary<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub807\uac8c \uc694\uccad\uc744 \ubd84\ub9ac\ud558\uba74 Primary\uc5d0 \uc9d1\uc911\ub418\ub358 \uc870\ud68c \ubd80\ud558\ub97c \uc5ec\ub7ec Replica\ub85c \ubd84\uc0b0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uad6c\uc870<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"> <code>                 Game Server\n                       |\n             Database Router\n                       |\n          +------------+------------+\n          |                         |\n     Write Request             Read Request\n          |                         |\n          v                         v\n      +---------+              +----------+\n      | Primary | ------------&gt;| Replica 1|\n      +---------+  Replication  +----------+\n          |                         ^\n          |                         |\n          +-------------------------+\n                    Replication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \ud658\uacbd\uc5d0\uc11c\ub294 Primary\uac00 \uc5ec\ub7ec Replica\uc5d0 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc804\ud30c\ud55c\ub2e4. \uc704 \uad6c\uc870\ub294 \uac1c\ub150\uc744 \uc124\uba85\ud558\uae30 \uc704\ud55c \ub2e8\uc21c\ud654\ub41c \uc608\uc2dc\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\uac00 \uc5ec\ub7ec \uac1c\ub77c\uba74 \uc77d\uae30 \uc694\uccad\uc744 \uac01 \uc11c\ubc84\uc5d0 \ubd84\uc0b0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> <code>               Game Server\n                     |\n              Database Router\n                \/          \\\n          Write              Read\n            |                 |\n            v          +------+------+\n        +---------+    |      |      |\n        | Primary |    v      v      v\n        +---------+  Replica Replica Replica\n                       1       2      3<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc Replica\uac00 \ub9ce\uc544\uc9c4\ub2e4\uace0 \ud574\uc11c \uc4f0\uae30 \ucc98\ub9ac\ub7c9\uae4c\uc9c0 \uc790\ub3d9\uc73c\ub85c \uc99d\uac00\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 Primary-Replica \uad6c\uc870\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \uc4f0\uae30 \uc694\uccad\uc774 \uc5ec\uc804\ud788 Primary\uc5d0 \uc9d1\uc911\ub418\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Primary-Replica \uad6c\uc870\uc758 \uc7a5\uc810<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc77d\uae30 \ubd80\ud558 \ubd84\uc0b0<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc870\ud68c \uc694\uccad\uc744 \uc5ec\ub7ec Replica\ub85c \ubd84\uc0b0\ud558\uc5ec Primary\uc758 CPU\uc640 \ub514\uc2a4\ud06c I\/O \ubd80\ub2f4\uc744 \uc904\uc77c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc11c\ube44\uc2a4 \ud655\uc7a5\uc131<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77d\uae30 \uc694\uccad\uc774 \uc99d\uac00\ud558\uba74 Replica\ub97c \ucd94\uac00\ud558\uc5ec \uc77d\uae30 \ucc98\ub9ac \ub2a5\ub825\uc744 \ud655\uc7a5\ud560 \uc218 \uc788\ub2e4. \ub2e8, \ub124\ud2b8\uc6cc\ud06c, \ubcf5\uc81c \ucc98\ub9ac\ub7c9, \uc2a4\ud1a0\ub9ac\uc9c0 \ub4f1 \ub2e4\ub978 \ubcd1\ubaa9\ub3c4 \ud568\uaed8 \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc7a5\uc560 \ub300\uc751<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uc5d0 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c Replica\ub97c \uc0c8\ub85c\uc6b4 Primary\ub85c \uc2b9\uaca9\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ubcf5\uad6c\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \ubcf5\uc81c \uc9c0\uc5f0\uc774\ub098 \ube44\ub3d9\uae30 \ubcf5\uc81c\ub85c \uc778\ud574 \ucd5c\uc2e0 \ub370\uc774\ud130 \uc77c\ubd80\uac00 \uc720\uc2e4\ub420 \uc218 \uc788\uc73c\uba70, \uc790\ub3d9 \uc2b9\uaca9\uc5d0\ub294 \uc7a5\uc560 \uac10\uc9c0, \ub9ac\ub354 \uc120\ucd9c, \uae30\uc874 Primary\uc758 \uc4f0\uae30 \ucc28\ub2e8 \ub4f1\uc758 \uc808\ucc28\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Replication<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Replication\uc774\ub780?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Replication\uc740 \ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubcf5\uc81c\ud558\ub294 \uacfc\uc815\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uc5d0\uc11c \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ubcc0\uacbd \ub0b4\uc6a9\uc744 \ub85c\uadf8\ub85c \uae30\ub85d\ud558\uace0, Replica\ub294 \ud574\ub2f9 \ub0b4\uc6a9\uc744 \uc804\ub2ec\ubc1b\uc544 \uc790\uc2e0\uc758 \ub370\uc774\ud130\uc5d0 \ubc18\uc601\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ubc14\uc774\ub108\ub9ac \ub85c\uadf8(Binary Log)\ub97c \uc774\uc6a9\ud574 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc804\ub2ec\ud558\uace0, Replica\uac00 \uc774\ub97c \uc801\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uae30\ubcf8\uc801\uc778 \uacfc\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>1. \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 Primary\uc5d0 \uc4f0\uae30 \uc694\uccad\n              |\n              v\n2. Primary\uc5d0\uc11c \ud2b8\ub79c\uc7ad\uc158 \uc2e4\ud589\n              |\n              v\n3. \ubcc0\uacbd \uc0ac\ud56d\uc744 Binary Log\uc5d0 \uae30\ub85d\n              |\n              v\n4. Replica\uac00 \ubcc0\uacbd \ub85c\uadf8\ub97c \uc218\uc2e0\n              |\n              v\n5. Replica\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\n              |\n              v\n6. Replica \ub370\uc774\ud130 \uac31\uc2e0 \uc644\ub8cc<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc815\ud655\ud55c \ub0b4\ubd80 \ucc98\ub9ac \uc21c\uc11c\uc640 \ub85c\uadf8 \uae30\ub85d \ubc29\uc2dd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uacfc \ubcf5\uc81c \uc124\uc815\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub3d9\uae30 \ubcf5\uc81c\uc640 \ube44\ub3d9\uae30 \ubcf5\uc81c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\uc81c \ubc29\uc2dd\uc740 \ubcc0\uacbd \uc0ac\ud56d\uc774 Replica\uc5d0 \ubc18\uc601\ub418\ub294 \uc2dc\uc810\uacfc Primary\uac00 \uc4f0\uae30 \uc694\uccad\uc758 \uc131\uacf5\uc744 \ud655\uc815\ud558\ub294 \uc870\uac74\uc5d0 \ub530\ub77c \uad6c\ubd84\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ube44\ub3d9\uae30 \ubcf5\uc81c(Asynchronous Replication)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ucee4\ubc0b\ud55c \ub4a4 Replica\uc758 \uc801\uc6a9 \uc644\ub8cc\ub97c \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0 \uc131\uacf5\uc744 \ubc18\ud658\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Client\n  |\n  v\nPrimary: \ubcc0\uacbd \ubc0f \ucee4\ubc0b\n  |\n  +------&gt; Client: \uc131\uacf5 \uc751\ub2f5\n  |\n  +------&gt; Replica: \ubcc0\uacbd \uc0ac\ud56d \uc801\uc6a9<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7a5\uc810\uc740 \uc4f0\uae30 \uc751\ub2f5 \uc9c0\uc5f0\uc774 \ube44\uad50\uc801 \ub0ae\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc810\uc740 Primary\uc758 \ucee4\ubc0b \uc774\ud6c4 Replica\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\uae30 \uc804\uc5d0 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uba74, \ud574\ub2f9 \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc0c8 Primary\uc5d0 \ubc18\uc601\ub418\uc9c0 \uc54a\uc744 \uac00\ub2a5\uc131\uc774 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub3d9\uae30 \ubcf5\uc81c(Synchronous Replication)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uac00 \uc4f0\uae30 \uc131\uacf5\uc744 \ud655\uc815\ud558\uae30 \uc804\uc5d0 \uc815\ud574\uc9c4 Replica\uc758 \uc751\ub2f5\uc774\ub098 \ubcf5\uc81c \ud655\uc778\uc744 \uae30\ub2e4\ub9ac\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \ub3d9\uae30 \ubcf5\uc81c\ub77c\uace0 \ud574\uc11c \ubc18\ub4dc\uc2dc \ubaa8\ub4e0 Replica\uc758 \ub370\uc774\ud130 \uc801\uc6a9\uc774 \uc644\ub8cc\ub420 \ub54c\uae4c\uc9c0 \uae30\ub2e4\ub9ac\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uc81c\ud488\uacfc \uc124\uc815\uc5d0 \ub530\ub77c \ub85c\uadf8 \uc218\uc2e0, \ub85c\uadf8 \ub514\uc2a4\ud06c \uae30\ub85d, \ud2b8\ub79c\uc7ad\uc158 \uc801\uc6a9 \ub4f1 \ud655\uc778\ud558\ub294 \ub2e8\uacc4\uac00 \ub2e4\ub974\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7a5\uc810\uc740 \ubcf5\uc81c \ud655\uc778 \uc870\uac74\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \uc720\uc2e4 \uac00\ub2a5\uc131\uc744 \uc904\uc77c \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc810\uc740 Replica\uc758 \uc751\ub2f5\uc774 \ub2a6\uac70\ub098 \ub124\ud2b8\uc6cc\ud06c \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uba74 \uc4f0\uae30 \uc9c0\uc5f0\uc774 \uc99d\uac00\ud558\uac70\ub098 \uc4f0\uae30 \ucc98\ub9ac\uac00 \uc81c\ud55c\ub420 \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\uad6c\ubd84<\/th><th>\ube44\ub3d9\uae30 \ubcf5\uc81c<\/th><th>\ub3d9\uae30 \ubcf5\uc81c<\/th><\/tr><tr><td>\uc4f0\uae30 \uc9c0\uc5f0<\/td><td>\uc0c1\ub300\uc801\uc73c\ub85c \ub0ae\uc74c<\/td><td>\uc0c1\ub300\uc801\uc73c\ub85c \ub192\uc744 \uc218 \uc788\uc74c<\/td><\/tr><tr><td>\ubcf5\uc81c \ud655\uc778<\/td><td>\ucee4\ubc0b \uc131\uacf5 \uc804\uc5d0 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uc74c<\/td><td>\uc124\uc815\ub41c \ud655\uc778 \uc870\uac74\uc744 \uae30\ub2e4\ub9bc<\/td><\/tr><tr><td>\ub370\uc774\ud130 \uc720\uc2e4 \uc704\ud5d8<\/td><td>\uc7a5\uc560 \uc2dc \uc874\uc7ac\ud560 \uc218 \uc788\uc74c<\/td><td>\uc124\uc815\uc5d0 \ub530\ub77c \uac10\uc18c<\/td><\/tr><tr><td>\uc7a5\uc560 \uc601\ud5a5<\/td><td>\ucd5c\uc2e0 \ub370\uc774\ud130\uac00 \ub204\ub77d\ub420 \uc218 \uc788\uc74c<\/td><td>\uc751\ub2f5 \uc9c0\uc5f0\uc774\ub098 \uc4f0\uae30 \uc911\ub2e8 \uac00\ub2a5<\/td><\/tr><tr><td>\uc8fc\uc694 \uace0\ub824 \uc0ac\ud56d<\/td><td>\ubcf5\uc81c \uc9c0\uc5f0, \uc7a5\uc560 \ubcf5\uad6c<\/td><td>\uac00\uc6a9\uc131, \ub124\ud2b8\uc6cc\ud06c \uc9c0\uc5f0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\uc81c\ub294 \ub2e8\uc21c\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubcf5\uc0ac\ud558\ub294 \uc791\uc5c5\uc774 \uc544\ub2c8\ub2e4. \ub370\uc774\ud130 \uc77c\uad00\uc131, \uc7a5\uc560 \ubcf5\uad6c, \uc751\ub2f5 \uc2dc\uac04 \uc0ac\uc774\uc5d0\uc11c \uc801\uc808\ud55c \uade0\ud615\uc744 \uc120\ud0dd\ud558\ub294 \uc124\uacc4 \ubb38\uc81c\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Replication Lag<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Replication Lag\ub780?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Replication Lag\ub294 Primary\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc774 Replica\uc5d0 \ubc18\uc601\ub418\uae30\uae4c\uc9c0 \ubc1c\uc0dd\ud558\ub294 \uc9c0\uc5f0\uc744 \uc758\ubbf8\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ud50c\ub808\uc774\uc5b4\uc758 \ud3ec\uc778\ud2b8\uac00 1,000\uc810\uc5d0\uc11c 700\uc810\uc73c\ub85c \ubcc0\uacbd\ub418\uc5c8\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>player_id: 1001\npoints: 700<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc Replica\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc544\uc9c1 \uc801\uc6a9\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c1\ud0dc\uc77c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>player_id: 1001\npoints: 1000<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub54c Replica\uc5d0\uc11c \uc870\ud68c\ud558\uba74 \uc774\ubbf8 \ucc28\uac10\ub41c \ud3ec\uc778\ud2b8\uac00 \uc544\ub2c8\ub77c \uc774\uc804 \ud3ec\uc778\ud2b8\uac00 \ubc18\ud658\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uac83\uc774 Replication Lag\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294 \ub300\ud45c\uc801\uc778 \ubb38\uc81c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Replication Lag\uac00 \ubc1c\uc0dd\ud558\ub294 \uc6d0\uc778<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub124\ud2b8\uc6cc\ud06c \uc9c0\uc5f0<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uc640 Replica \uc0ac\uc774\uc758 \ub124\ud2b8\uc6cc\ud06c \uc9c0\uc5f0\uc73c\ub85c \uc778\ud574 \ubcc0\uacbd \ub85c\uadf8 \uc804\ub2ec\uc774 \ub2a6\uc5b4\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Replica\uc758 \ucc98\ub9ac \ub2a5\ub825 \ubd80\uc871<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc0dd\uc131\ud558\ub294 \uc18d\ub3c4\ubcf4\ub2e4 Replica\uac00 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\ub294 \uc18d\ub3c4\uac00 \ub290\ub9ac\uba74 \ubcf5\uc81c \ub300\uae30\uc5f4\uc774 \uc99d\uac00\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub300\ub7c9 \ud2b8\ub79c\uc7ad\uc158<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud558\ub294 \ud2b8\ub79c\uc7ad\uc158\uc740 Replica\uac00 \ucc98\ub9ac\ud574\uc57c \ud558\ub294 \uc791\uc5c5\ub7c9\uc744 \uc99d\uac00\uc2dc\ud0a8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ub514\uc2a4\ud06c I\/O \ubcd1\ubaa9<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\uc758 \ub514\uc2a4\ud06c \uc131\ub2a5\uc774 \ubd80\uc871\ud558\uac70\ub098 \ub2e4\ub978 \uc791\uc5c5\uacfc \uc790\uc6d0\uc744 \uacbd\uc7c1\ud558\uba74 \ub85c\uadf8 \uc801\uc6a9\uc774 \uc9c0\uc5f0\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ubcf5\uc81c \uad6c\uc870\uc758 \ubcf5\uc7a1\uc131<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\uc81c \ud1a0\ud3f4\ub85c\uc9c0, \ubcd1\ub82c \uc801\uc6a9 \uc124\uc815, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc758 \ub0b4\ubd80 \ucc98\ub9ac \ubc29\uc2dd \ub4f1\uc5d0 \ub530\ub77c\uc11c\ub3c4 \uc9c0\uc5f0 \ud2b9\uc131\uc774 \ub2ec\ub77c\uc9c4\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Replication Lag\uac00 \ub9cc\ub4dc\ub294 \uc2e4\uc81c \ubb38\uc81c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uac8c\uc784\uc5d0\uc11c \ud3ec\uc778\ud2b8 \ucc28\uac10\uacfc \uc0c1\uc810 \uc870\ud68c\uac00 \uc5f0\uc18d\uc73c\ub85c \ubc1c\uc0dd\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>1. \ud50c\ub808\uc774\uc5b4 \ud3ec\uc778\ud2b8: 1,000\n\n2. Primary\uc5d0\uc11c \uc544\uc774\ud15c \uad6c\ub9e4\n   \ud3ec\uc778\ud2b8: 1,000 \u2192 700\n\n3. \uad6c\ub9e4 \uc694\uccad \uc131\uacf5 \uc751\ub2f5\n\n4. \uc9c1\ud6c4 Replica\uc5d0\uc11c \ud3ec\uc778\ud2b8 \uc870\ud68c\n\n5. Replica\uac00 \uc544\uc9c1 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\uc9c0 \ubabb\ud568\n   \uc870\ud68c \uacb0\uacfc: 1,000<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud50c\ub808\uc774\uc5b4 \uc785\uc7a5\uc5d0\uc11c\ub294 \uad6c\ub9e4\uac00 \uc131\uacf5\ud588\ub294\ub370 \ud3ec\uc778\ud2b8\uac00 \ucc28\uac10\ub418\uc9c0 \uc54a\uc740 \uac83\ucc98\ub7fc \ubcf4\uc778\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \ubb38\uc81c\ub294 \ub2e8\uc21c\ud55c \ud654\uba74 \ud45c\uc2dc \uc624\ub958\ub97c \ub118\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \ub9cc\ub4e4 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc624\ub798\ub41c \uc778\ubca4\ud1a0\ub9ac \ud45c\uc2dc<\/li>\n\n\n\n<li>\uad6c\ub9e4 \uc9c1\ud6c4 \uad6c\ub9e4 \uac00\ub2a5 \uc5ec\ubd80\ub97c \uc798\ubabb \ud310\ub2e8<\/li>\n\n\n\n<li>\uce90\ub9ad\ud130 \uc815\ubcf4\uc758 \uc77c\uc2dc\uc801\uc778 \ubd88\uc77c\uce58<\/li>\n\n\n\n<li>\ucd5c\uc2e0 \ub370\uc774\ud130\uac00 \ud544\uc694\ud55c \uc5c5\ubb34 \ucc98\ub9ac\uc758 \uc624\ub958<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \ud3ec\uc778\ud2b8 \ucc28\uac10, \uc544\uc774\ud15c \uc9c0\uae09, \uad6c\ub9e4 \uac00\ub2a5 \uc5ec\ubd80 \ud310\uc815\uacfc \uac19\uc774 \uc815\ud655\uc131\uc774 \uc911\uc694\ud55c \uc791\uc5c5\uc5d0\uc11c\ub294 \uc624\ub798\ub41c Replica \ub370\uc774\ud130\ub97c \uae30\uc900\uc73c\ub85c \uacb0\uc815\uc744 \ub0b4\ub9ac\uba74 \uc548 \ub41c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Replication Lag \ub300\uc751 \ubc29\ubc95<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ucd5c\uc2e0 \ub370\uc774\ud130\uac00 \ud544\uc694\ud55c \uc870\ud68c\ub294 Primary \uc0ac\uc6a9<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc4f0\uae30 \uc9c1\ud6c4 \uacb0\uacfc\ub97c \ud655\uc778\ud574\uc57c \ud558\ub294 \uc694\uccad\uc740 Primary\uc5d0\uc11c \uc870\ud68c\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uc544\uc774\ud15c \uad6c\ub9e4\n    |\n    v\nPrimary\uc5d0\uc11c \ud3ec\uc778\ud2b8 \ucc28\uac10\n    |\n    v\nPrimary\uc5d0\uc11c \ucd5c\uc2e0 \ud3ec\uc778\ud2b8 \uc870\ud68c\n    |\n    v\n\uc751\ub2f5 \ubc18\ud658<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc77d\uae30 \ud6c4 \uc4f0\uae30 \uc77c\uad00\uc131 \ubcf4\uc7a5<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud55c \ub4a4 \uc774\uc5b4\uc9c0\ub294 \uc870\ud68c\uc5d0\uc11c \uc790\uc2e0\uc758 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub3c4\ub85d \uc815\ucc45\uc744 \uc124\uacc4\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc77c\uc815 \uc2dc\uac04 \ub3d9\uc548 \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uc870\ud68c\ub97c Primary\ub85c \ubcf4\ub0b4\uac70\ub098, \uc4f0\uae30 \uc694\uccad\uc758 \uacb0\uacfc\ub97c \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0 \uc9c1\uc811 \ubc18\ud658\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ubcf5\uc81c \uc9c0\uc5f0 \ubaa8\ub2c8\ud130\ub9c1<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcf5\uc81c \uc9c0\uc5f0\uc744 \uce21\uc815\ud558\uace0 \uc77c\uc815 \uae30\uc900\uc744 \ucd08\uacfc\ud55c Replica\ub97c \uc77d\uae30 \ub300\uc0c1\uc5d0\uc11c \uc81c\uc678\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \ubcf5\uc81c \uc9c0\uc5f0\uc744 \uce21\uc815\ud558\ub294 \uc9c0\ud45c\uac00 \uc2e4\uc81c \ub370\uc774\ud130 \uc801\uc6a9 \uc2dc\uc810\uacfc \uc815\ud655\ud788 \uc77c\uce58\ud558\ub294\uc9c0\ub294 \uc0ac\uc6a9 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub2c8\ud130\ub9c1 \ubc29\uc2dd\uc5d0 \ub530\ub77c \ub2e4\ub974\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Replica \uc77d\uae30 \ub300\uae30<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud544\uc694\ud55c \uacbd\uc6b0 \ud2b9\uc815 \ubcc0\uacbd \uc0ac\ud56d\uc774 Replica\uc5d0 \ubc18\uc601\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c \ub4a4 \uc870\ud68c\ud558\ub3c4\ub85d \uad6c\ud604\ud560 \uc218 \uc788\ub2e4. \uadf8\ub7ec\ub098 \ubaa8\ub4e0 \uc694\uccad\uc5d0 \uc801\uc6a9\ud558\uba74 \uc9c0\uc5f0\uacfc \ubcf5\uc7a1\uc131\uc774 \uc99d\uac00\ud558\ubbc0\ub85c \uc120\ud0dd\uc801\uc73c\ub85c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud575\uc2ec\uc740 \ubaa8\ub4e0 \uc870\ud68c\ub97c \ubb34\uc870\uac74 Replica\ub85c \ubcf4\ub0b4\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \uc870\ud68c\uc5d0 \uc694\uad6c\ub418\ub294 \ucd5c\uc2e0\uc131 \uc218\uc900\uc744 \uba3c\uc800 \uc815\uc758\ud558\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Read Replica<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Read Replica\ub780?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Read Replica\ub294 Primary\uc758 \ub370\uc774\ud130\ub97c \ubcf5\uc81c\ud558\uace0 \uc77d\uae30 \uc694\uccad\uc744 \ucc98\ub9ac\ud558\ub3c4\ub85d \uc6b4\uc601\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uc81c\ubcf8\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\uc640 Replica\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \ubcc4\ub3c4\uc758 \uc11c\ubc84\uc77c \uc218\ub3c4 \uc788\uace0, \ud074\ub77c\uc6b0\ub4dc \ud658\uacbd\uc5d0\uc11c \ubcc4\ub3c4 \uc778\uc2a4\ud134\uc2a4\ub85c \uad6c\uc131\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ubc18\uc801\uc778 \uad6c\uc870\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> <code>               Application Server\n                        |\n                 Database Layer\n                   \/         \\\n                  \/           \\\n             Write             Read\n               |                 |\n               v                 v\n           Primary          Read Replica\n               |                 ^\n               +-----------------+\n                  Replication<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc694\uccad\uc758 \uc131\uaca9\uc5d0 \ub530\ub77c \uc801\uc808\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc744 \uc120\ud0dd\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Node.js\uc5d0\uc11c \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Node.js\uc640 TypeScript \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \uacc4\uce35\uc744 \ubd84\ub9ac\ud558\ub294 \uc608\uc2dc\ub2e4. \uc544\ub798 \ucf54\ub4dc\ub294 <code>mysql2\/promise<\/code>\ub97c \uc0ac\uc6a9\ud558\ub294 \uac04\ub2e8\ud55c \uad6c\uc870\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import mysql from \"mysql2\/promise\";\n\nconst primaryPool = mysql.createPool({\n  host: process.env.DB_PRIMARY_HOST,\n  user: process.env.DB_USER,\n  password: process.env.DB_PASSWORD,\n  database: process.env.DB_NAME,\n  connectionLimit: 20,\n});\n\nconst replicaPool = mysql.createPool({\n  host: process.env.DB_REPLICA_HOST,\n  user: process.env.DB_USER,\n  password: process.env.DB_PASSWORD,\n  database: process.env.DB_NAME,\n  connectionLimit: 40,\n});\n\n\/\/ \uc870\ud68c \uc804\uc6a9 \ud568\uc218\nexport async function readQuery&lt;T = any&gt;(\n  sql: string,\n  params: unknown&#91;] = &#91;],\n): Promise&lt;T&#91;]&gt; {\n  const &#91;rows] = await replicaPool.query(sql, params);\n  return rows as T&#91;];\n}\n\n\/\/ \ubcc0\uacbd \uc804\uc6a9 \ud568\uc218\nexport async function writeQuery(\n  sql: string,\n  params: unknown&#91;] = &#91;],\n): Promise&lt;void&gt; {\n  await primaryPool.execute(sql, params);\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9 \uc608\uc2dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ \ud50c\ub808\uc774\uc5b4 \uc815\ubcf4 \uc870\ud68c\nconst players = await readQuery(\n  \"SELECT id, nickname FROM players WHERE id = ?\",\n  &#91;1001],\n);\n\n\/\/ \ud50c\ub808\uc774\uc5b4 \ub2c9\ub124\uc784 \ubcc0\uacbd\nawait writeQuery(\n  \"UPDATE players SET nickname = ? WHERE id = ?\",\n  &#91;\"NewPlayer\", 1001],\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uc608\uc2dc\uc5d0\uc11c\ub294 \uc870\ud68c \uc694\uccad\uc740 Replica\ub85c, \ubcc0\uacbd \uc694\uccad\uc740 Primary\ub85c \ubcf4\ub0b8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8, <code>readQuery()<\/code>\uc640 <code>writeQuery()<\/code>\ub294 \uc2e4\uc81c \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc644\uc804\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uacc4\uce35\uc774 \uc544\ub2c8\ub2e4. \ub2e4\uc74c \uc0ac\ud56d\uc744 \ucd94\uac00\ub85c \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc785\ub825\uac12\uacfc SQL \uc720\ud615 \uac80\uc99d<\/li>\n\n\n\n<li>\uc5f0\uacb0 \uc624\ub958 \ubc0f \ud0c0\uc784\uc544\uc6c3 \ucc98\ub9ac<\/li>\n\n\n\n<li>\ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac<\/li>\n\n\n\n<li>\ubcf5\uc81c \uc9c0\uc5f0 \ub300\uc751<\/li>\n\n\n\n<li>\uc77d\uae30 \uc804\uc6a9 \uacc4\uc815 \uad8c\ud55c \uc124\uc815<\/li>\n\n\n\n<li>Replica \uc7a5\uc560 \uc2dc \ub300\uccb4 \ub3d9\uc791<\/li>\n\n\n\n<li>SQL \uc8fc\uc785 \ubc29\uc9c0\ub97c \uc704\ud55c \ud30c\ub77c\ubbf8\ud130 \ubc14\uc778\ub529<\/li>\n\n\n\n<li>\ub370\uc774\ud130 \ubcc0\uacbd \uc9c1\ud6c4\uc758 \uc870\ud68c \ub77c\uc6b0\ud305<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \ud2b8\ub79c\uc7ad\uc158\uc740 \ud558\ub098\uc758 Primary \uc5f0\uacb0\uc5d0\uc11c \uc2dc\uc791\ud558\uace0 \ucee4\ubc0b\ud574\uc57c \ud55c\ub2e4. \ud2b8\ub79c\uc7ad\uc158 \ub3c4\uc911 \uc784\uc758\ub85c Replica \uc5f0\uacb0\uc744 \uc0ac\uc6a9\ud558\uba74 \ub3d9\uc77c\ud55c \ud2b8\ub79c\uc7ad\uc158\uc758 \uc77c\uad00\uc131\uc744 \ubcf4\uc7a5\ud560 \uc218 \uc5c6\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\ub97c \uc704\ud55c \ub77c\uc6b0\ud305 \uc815\ucc45<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc21c\ud788 SQL\uc774 <code>SELECT<\/code>\ub85c \uc2dc\uc791\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc5ec \uc77d\uae30\uc640 \uc4f0\uae30\ub97c \ubd84\ub9ac\ud558\ub294 \ubc29\uc2dd\uc740 \uc548\uc804\ud558\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \ucffc\ub9ac\ub294 \uc870\ud68c\ucc98\ub7fc \ubcf4\uc774\uc9c0\ub9cc \ub370\uc774\ud130 \ubcc0\uacbd\uc774\ub098 \uc7a0\uae08\uacfc \uad00\ub828\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM inventory\nWHERE player_id = ?\nFOR UPDATE;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><code>FOR UPDATE<\/code>\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ud2b8\ub79c\uc7ad\uc158 \uc548\uc5d0\uc11c \ud589 \uc7a0\uae08\uc744 \ud68d\ub4dd\ud558\uae30 \uc704\ud55c \ucffc\ub9ac\ub2e4. \uc774\ub7ec\ud55c \ucffc\ub9ac\ub97c Replica\ub85c \ubcf4\ub0b4\uba74 \uc758\ub3c4\ud55c \uc7a0\uae08 \ubc0f \ud2b8\ub79c\uc7ad\uc158 \ub3d9\uc791\uc744 \ubcf4\uc7a5\ud560 \uc218 \uc5c6\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c SQL \ubb38\uc790\uc5f4\ub9cc \ubd84\uc11d\ud558\uae30\ubcf4\ub2e4\ub294 Repository \ub610\ub294 \ub370\uc774\ud130 \uc811\uadfc \uacc4\uce35\uc5d0\uc11c \uc791\uc5c5\uc758 \ubaa9\uc801\uc5d0 \ub530\ub77c \uba85\uc2dc\uc801\uc73c\ub85c \uc5f0\uacb0\uc744 \uc120\ud0dd\ud558\ub294 \ud3b8\uc774 \uc548\uc804\ud558\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>class PlayerRepository {\n  async findProfile(playerId: number) {\n    \/\/ \uc77c\ubc18 \uc870\ud68c: Replica\n  }\n\n  async updateNickname(\n    playerId: number,\n    nickname: string,\n  ) {\n    \/\/ \ub370\uc774\ud130 \ubcc0\uacbd: Primary\n  }\n\n  async findLatestBalance(playerId: number) {\n    \/\/ \ucd5c\uc2e0\uc131\uc774 \uc911\uc694\ud55c \uc870\ud68c: Primary\n  }\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ucc98\ub7fc \uba54\uc11c\ub4dc\uc758 \ucc45\uc784\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \uacbd\ub85c\ub97c \ubd84\ub9ac\ud558\uba74 \ub77c\uc6b0\ud305 \uc815\ucc45\uc744 \ucd94\uc801\ud558\uace0 \ud14c\uc2a4\ud2b8\ud558\uae30 \uc26c\uc6cc\uc9c4\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\uc758 \ud55c\uacc4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\ub294 \uc720\uc6a9\ud558\uc9c0\ub9cc \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc4f0\uae30 \uc131\ub2a5\uc740 \uc790\ub3d9\uc73c\ub85c \uc99d\uac00\ud558\uc9c0 \uc54a\ub294\ub2e4<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Primary-Replica \uad6c\uc870\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ubaa8\ub4e0 \uc4f0\uae30 \uc694\uccad\uc774 Primary\uc5d0 \uc9d1\uc911\ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Read Request  \u2192 Replica 1\nRead Request  \u2192 Replica 2\nRead Request  \u2192 Replica 3\n\nWrite Request \u2192 Primary\nWrite Request \u2192 Primary\nWrite Request \u2192 Primary<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\ub97c 10\ub300 \ucd94\uac00\ud558\ub354\ub77c\ub3c4 Primary\uc758 \uc4f0\uae30 \ucc98\ub9ac \ub2a5\ub825\uc774 \uc790\ub3d9\uc73c\ub85c 10\ubc30 \uc99d\uac00\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc4f0\uae30 \ubd80\ud558\uac00 \ubcd1\ubaa9\uc774\ub77c\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc744 \uac80\ud1a0\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc778\ub371\uc2a4 \ubc0f SQL \ucd5c\uc801\ud654<\/li>\n\n\n\n<li>\ubd88\ud544\uc694\ud55c \uc4f0\uae30 \uc81c\uac70<\/li>\n\n\n\n<li>\ud2b8\ub79c\uc7ad\uc158 \uc2dc\uac04 \ub2e8\ucd95<\/li>\n\n\n\n<li>\ubc30\uce58 \ucc98\ub9ac<\/li>\n\n\n\n<li>\ub370\uc774\ud130 \ubaa8\ub378 \uac1c\uc120<\/li>\n\n\n\n<li>\uc0e4\ub529\uc744 \ud1b5\ud55c \ub370\uc774\ud130 \ubd84\uc0b0<\/li>\n\n\n\n<li>\uc4f0\uae30 \uc694\uccad\uc758 \ube44\ub3d9\uae30 \ucc98\ub9ac \ubc0f \ud050 \ud65c\uc6a9<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8, \ube44\ub3d9\uae30 \ud050\ub97c \ud65c\uc6a9\ud558\uba74 \ucc98\ub9ac \uc2dc\uc810\uc774 \ub2ec\ub77c\uc9c0\ubbc0\ub85c \uc5c5\ubb34\uc0c1 \ud5c8\uc6a9\ub418\ub294 \uc77c\uad00\uc131 \uc218\uc900\uc744 \ud568\uaed8 \uc124\uacc4\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubcf5\uc81c \uc9c0\uc5f0\uc73c\ub85c \uc778\ud55c \uc77c\uad00\uc131 \ubb38\uc81c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\ub294 Primary\uc640 \ud56d\uc0c1 \ub3d9\uc77c\ud55c \uc2dc\uc810\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uc5ec \uc8fc\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ucd5c\uc2e0 \uc0c1\ud0dc\uac00 \uc911\uc694\ud55c \uc870\ud68c\uae4c\uc9c0 Replica\ub85c \ubcf4\ub0b4\uba74 \uc624\ub798\ub41c \ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \ud310\ub2e8\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c \uc870\ud68c \uc694\uccad\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\ubd84\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\uc870\ud68c \uc720\ud615<\/th><th>\uad8c\uc7a5 \ucc98\ub9ac<\/th><\/tr><tr><td>\uc77c\ubc18\uc801\uc778 \ud504\ub85c\ud544 \uc870\ud68c<\/td><td>Replica \uac00\ub2a5<\/td><\/tr><tr><td>\ub7ad\ud0b9 \ubc0f \ud1b5\uacc4 \uc870\ud68c<\/td><td>Replica \uac00\ub2a5<\/td><\/tr><tr><td>\uad6c\ub9e4 \uc9c1\ud6c4 \ud3ec\uc778\ud2b8 \ud655\uc778<\/td><td>Primary \ub610\ub294 \uc4f0\uae30 \uacb0\uacfc \uc0ac\uc6a9<\/td><\/tr><tr><td>\uad6c\ub9e4 \uac00\ub2a5 \uc5ec\ubd80 \ud310\uc815<\/td><td>Primary\uc758 \ud2b8\ub79c\uc7ad\uc158 \uae30\ubc18 \uac80\uc99d<\/td><\/tr><tr><td>\uc544\uc774\ud15c \uc9c0\uae09 \uc5ec\ubd80 \ud655\uc778<\/td><td>Primary\uc758 \ucd5c\uc2e0 \uc0c1\ud0dc \ud655\uc778<\/td><\/tr><tr><td>\ub370\uc774\ud130 \ubcc0\uacbd \ud6c4 \uc989\uc2dc \ud655\uc778\ud574\uc57c \ud558\ub294 \uc870\ud68c<\/td><td>Primary \ub610\ub294 \uc77c\uad00\uc131 \ubcf4\uc7a5 \ubc29\uc2dd \uc801\uc6a9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ud45c\ub294 \uc77c\ubc18\uc801\uc778 \uc124\uacc4 \uae30\uc900\uc774\ub2e4. \uc2e4\uc81c \uc120\ud0dd\uc740 \ub370\uc774\ud130\uc758 \uc911\uc694\ub3c4\uc640 \ud5c8\uc6a9 \uac00\ub2a5\ud55c \uc9c0\uc5f0\uc5d0 \ub530\ub77c \uacb0\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc6b4\uc601 \ube44\uc6a9\uacfc \ubcf5\uc7a1\uc131 \uc99d\uac00<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\ub97c \ucd94\uac00\ud558\uba74 \ub2e8\uc21c\ud788 \uc11c\ubc84 \ube44\uc6a9\ub9cc \uc99d\uac00\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130 \ubcf5\uc81c \ubc0f \ubaa8\ub2c8\ud130\ub9c1<\/li>\n\n\n\n<li>\uc7a5\uc560 \uac10\uc9c0 \ubc0f \ubcf5\uad6c<\/li>\n\n\n\n<li>\uc5f0\uacb0 \ud480 \uad00\ub9ac<\/li>\n\n\n\n<li>\uc77d\uae30 \ub300\uc0c1 \uc120\ud0dd<\/li>\n\n\n\n<li>\ubcf5\uc81c \uc9c0\uc5f0 \ub300\uc751<\/li>\n\n\n\n<li>\uc6b4\uc601 \ud658\uacbd\ubcc4 \uc124\uc815 \uad00\ub9ac<\/li>\n\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5c5\uadf8\ub808\uc774\ub4dc \ubc0f \uc720\uc9c0\ubcf4\uc218<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \uad00\ub9ac \ube44\uc6a9\ub3c4 \ud568\uaed8 \uc99d\uac00\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub610\ud55c Replica\uac00 \uc7a5\uc560\ub97c \uc77c\uc73c\ud0a4\uac70\ub098 \ubcf5\uc81c \uc9c0\uc5f0\uc774 \uc2ec\ud574\uc9c0\uba74 \uc77d\uae30 \uc694\uccad\uc744 Primary\ub85c \uc804\ud658\ud560\uc9c0, \uc77c\ubd80 \uc870\ud68c\ub97c \uc81c\ud55c\ud560\uc9c0 \uacb0\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primary\ub85c \ubaa8\ub4e0 \uc77d\uae30\ub97c \uc804\ud658\ud558\uba74 Primary\uc5d0 \uacfc\ubd80\ud558\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc7a5\uc560 \uc2dc\ub098\ub9ac\uc624\uae4c\uc9c0 \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Replica\ub97c \ub298\ub824\ub3c4 \ubaa8\ub4e0 \uc870\ud68c\uac00 \ube68\ub77c\uc9c0\uc9c0\ub294 \uc54a\ub294\ub2e4<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc870\ud68c \ubd80\ud558\uac00 \ubd84\uc0b0\ub418\ub354\ub77c\ub3c4 \ub2e4\uc74c\uacfc \uac19\uc740 \ubcd1\ubaa9\uc740 \ub0a8\uc744 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ube44\ud6a8\uc728\uc801\uc778 SQL<\/li>\n\n\n\n<li>\uc778\ub371\uc2a4 \ub204\ub77d<\/li>\n\n\n\n<li>\ub300\ub7c9 \ub370\uc774\ud130 \uc804\uc1a1<\/li>\n\n\n\n<li>\ub192\uc740 \ub124\ud2b8\uc6cc\ud06c \uc9c0\uc5f0<\/li>\n\n\n\n<li>\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 Connection Pool \uace0\uac08<\/li>\n\n\n\n<li>\ud2b9\uc815 Replica\uc5d0 \uc9d1\uc911\ub418\ub294 \uc694\uccad<\/li>\n\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc678\ubd80\uc758 \uce90\uc2dc \ub610\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubcd1\ubaa9<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c \uba3c\uc800 \uc2e4\ud589 \uacc4\ud68d\uacfc \uc131\ub2a5 \uc9c0\ud45c\ub97c \ud655\uc778\ud558\uace0 \uc2e4\uc81c \ubcd1\ubaa9\uc774 \uc77d\uae30 \ucc98\ub9ac\ub7c9\uc778\uc9c0 \ud310\ub2e8\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc7a5\uc560 \ub300\uc751\uacfc \ub370\uc774\ud130 \uc720\uc2e4 \uac00\ub2a5\uc131<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ube44\ub3d9\uae30 \ubcf5\uc81c \ud658\uacbd\uc5d0\uc11c Primary\uac00 \uc7a5\uc560\ub97c \uc77c\uc73c\ud0a4\uba74 Replica\uc5d0 \uc544\uc9c1 \uc804\ub2ec\ub418\uc9c0 \uc54a\uc558\uac70\ub098 \uc801\uc6a9\ub418\uc9c0 \uc54a\uc740 \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc874\uc7ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Replica\ub97c \uc0c8 Primary\ub85c \uc2b9\uaca9\ud558\ub354\ub77c\ub3c4 \uae30\uc874 Primary\uc5d0\uc11c \uc131\uacf5 \ucc98\ub9ac\ud588\ub358 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc774 \ubcf4\uc874\ub41c\ub2e4\uace0 \ubcf4\uc7a5\ud560 \uc218\ub294 \uc5c6\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c\ub294 \ub2e4\uc74c \ud56d\ubaa9\uc744 \ud568\uaed8 \uc124\uacc4\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc7a5\uc560 \uac10\uc9c0\uc640 \uc2b9\uaca9 \uc808\ucc28<\/li>\n\n\n\n<li>Split-brain \ubc29\uc9c0<\/li>\n\n\n\n<li>\uae30\uc874 Primary\uc758 \uc4f0\uae30 \ucc28\ub2e8<\/li>\n\n\n\n<li>\ub370\uc774\ud130 \uc720\uc2e4 \ud5c8\uc6a9 \ubc94\uc704<\/li>\n\n\n\n<li>\ubcf5\uad6c \uc2dc\uc810 \ubaa9\ud45c(RPO)<\/li>\n\n\n\n<li>\ubcf5\uad6c \uc2dc\uac04 \ubaa9\ud45c(RTO)<\/li>\n\n\n\n<li>\ubc31\uc5c5\uacfc \ubcf5\uad6c \uac80\uc99d<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Replication\uc740 \ubc31\uc5c5\uc744 \ub300\uccb4\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc798\ubabb\ub41c \ub370\uc774\ud130 \ubcc0\uacbd\uc774\ub098 \uc0ad\uc81c\uac00 \ubcf5\uc81c\ub418\uba74 Replica\uc5d0\ub3c4 \ub3d9\uc77c\ud55c \ubb38\uc81c\uac00 \uc804\ud30c\ub420 \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2e4\ubb34\uc5d0\uc11c \uace0\ub824\ud560 \uc124\uacc4 \uae30\uc900<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac\ub294 \uc11c\ubc84 \uc218\ub97c \ub298\ub9ac\ub294 \uc791\uc5c5\uc774 \uc544\ub2c8\ub77c \ub370\uc774\ud130\uc758 \ucd5c\uc2e0\uc131 \uc694\uad6c\uc640 \ucc98\ub9ac \ubd80\ud558\ub97c \ubd84\ub9ac\ud558\ub294 \uc791\uc5c5\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub3c4\uc785 \uc804\uc5d0\ub294 \ub2e4\uc74c \uc0ac\ud56d\uc744 \ud655\uc778\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc77d\uae30\uc640 \uc4f0\uae30\uc758 \ube44\uc728\uc740 \uc5b4\ub290 \uc815\ub3c4\uc778\uac00?<\/li>\n\n\n\n<li>\uc2e4\uc81c \ubcd1\ubaa9\uc740 Primary\uc758 \uc870\ud68c \ubd80\ud558\uc778\uac00?<\/li>\n\n\n\n<li>\uc5b4\ub5a4 \uc870\ud68c\uac00 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \ubc18\ub4dc\uc2dc \uc694\uad6c\ud558\ub294\uac00?<\/li>\n\n\n\n<li>\ubcf5\uc81c \uc9c0\uc5f0\uc744 \uc5b4\ub290 \uc815\ub3c4\uae4c\uc9c0 \ud5c8\uc6a9\ud560 \uc218 \uc788\ub294\uac00?<\/li>\n\n\n\n<li>Replica \uc7a5\uc560 \uc2dc \uc77d\uae30 \uc694\uccad\uc740 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud560 \uac83\uc778\uac00?<\/li>\n\n\n\n<li>Primary \uc7a5\uc560 \uc2dc \ub370\uc774\ud130 \uc720\uc2e4\uc744 \uc5b4\ub514\uae4c\uc9c0 \ud5c8\uc6a9\ud560 \uac83\uc778\uac00?<\/li>\n\n\n\n<li>Replica\ub97c \ucd94\uac00\ud558\ub294 \ube44\uc6a9\uc774 \uc131\ub2a5 \uac1c\uc120 \ud6a8\uacfc\ubcf4\ub2e4 \ub0ae\uc740\uac00?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\ub294 \ub7ad\ud0b9, \ud1b5\uacc4, \uacf5\uac1c \ud504\ub85c\ud544\ucc98\ub7fc \uc57d\uac04 \uc624\ub798\ub41c \ub370\uc774\ud130\uac00 \ud5c8\uc6a9\ub418\ub294 \uc870\ud68c\uc640 \ud3ec\uc778\ud2b8, \uad6c\ub9e4, \uc778\ubca4\ud1a0\ub9ac \ubcc0\uacbd\ucc98\ub7fc \uc815\ud655\uc131\uc774 \uc911\uc694\ud55c \uc791\uc5c5\uc744 \uad6c\ubd84\ud558\ub294 \uac83\uc774 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 \uc870\ud68c\ub97c Replica\ub85c \ubcf4\ub0b4\ub294 \uac83\uc774 \ubaa9\ud45c\uac00 \uc544\ub2c8\ub2e4. <strong>\ucd5c\uc2e0\uc131\uc774 \ud544\uc694\ud55c \uc791\uc5c5\uc740 \uc815\ud655\ud558\uac8c \ucc98\ub9ac\ud558\uace0, \ucd5c\uc2e0\uc131\uc774 \ub35c \uc911\uc694\ud55c \uc870\ud68c\ub294 \ubd84\uc0b0\ud558\uc5ec \ucc98\ub9ac\ud558\ub294 \uac83<\/strong>\uc774 \ud575\uc2ec\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc11c\ube44\uc2a4\uc758 \uc0ac\uc6a9\uc790\uac00 \uc99d\uac00\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc804\ub2ec\ub418\ub294 \uc694\uccad\ub3c4 \ud568\uaed8 \uc99d\uac00\ud55c\ub2e4. \ud2b9\ud788 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\ub294 \ub85c\uadf8\uc778, \ud504\ub85c\ud544 \uc870\ud68c, \uc778\ubca4\ud1a0\ub9ac \uc870\ud68c, \ub7ad\ud0b9 \uc870\ud68c, \uc0c1\uc810 \uc870\ud68c \ub4f1 \ub2e4\uc591\ud55c \uc77d\uae30 \uc694\uccad\uc774 \ubc1c\uc0dd\ud55c\ub2e4. \ubaa8\ub4e0 \uc77d\uae30\uc640 \uc4f0\uae30 \uc694\uccad\uc744 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0\uc11c \ucc98\ub9ac\ud558\uba74 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O, \ub124\ud2b8\uc6cc\ud06c \ub4f1\uc758 \uc790\uc6d0\uc774 \ubcd1\ubaa9\uc774 \ub420 \uc218 \uc788\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub300\ud45c\uc801\uc778 \ubc29\ubc95 \uc911 \ud558\ub098\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uc81c(Replication)\uc640 \uc77d\uae30\u00b7\uc4f0\uae30 \ubd84\ub9ac(Read\/Write [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2673","post","type-post","status-publish","format-standard","hentry","category-dev-logs"],"_links":{"self":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2673"}],"version-history":[{"count":2,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2673\/revisions"}],"predecessor-version":[{"id":2675,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2673\/revisions\/2675"}],"wp:attachment":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}