{"id":2676,"date":"2026-10-24T09:01:31","date_gmt":"2026-10-24T09:01:31","guid":{"rendered":"https:\/\/wayhope.kro.kr\/?p=2676"},"modified":"2026-10-24T09:21:10","modified_gmt":"2026-10-24T09:21:10","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b6%84%ec%82%b0-%ed%8c%8c%ed%8b%b0%ec%85%94%eb%8b%9d-%ec%83%a4%eb%94%a9-%ec%83%a4%eb%93%9c-%ed%82%a4-%ec%84%a4%ea%b3%84%ec%99%80-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9e%ac","status":"publish","type":"post","link":"https:\/\/wayhope.kro.kr\/?p=2676","title":{"rendered":"DB \ub370\uc774\ud130 \ubd84\uc0b0 #\ud30c\ud2f0\uc154\ub2dd, \uc0e4\ub529, \uc0e4\ub4dc \ud0a4 \uc124\uacc4\uc640 \ub370\uc774\ud130 \uc7ac\ubd84\ubc30"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130 \ubd84\uc0b0\uc774 \ud544\uc694\ud55c \uc774\uc720<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc11c\ube44\uc2a4\uc758 \ub370\uc774\ud130\uac00 \uc99d\uac00\ud558\uba74 \ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub9cc\uc73c\ub85c \ubaa8\ub4e0 \uc694\uccad\uc744 \ucc98\ub9ac\ud558\uae30 \uc5b4\ub824\uc6cc\uc9c4\ub2e4. \ub370\uc774\ud130\uac00 \ub9ce\uc544\uc9c8\uc218\ub85d \uc800\uc7a5 \uacf5\uac04\uc774 \ubd80\uc871\ud574\uc9c8 \uc218 \uc788\uace0, \ud2b9\uc815 \ud14c\uc774\ube14\uc5d0 \ucffc\ub9ac\uac00 \uc9d1\uc911\ub418\uba74 \uc77d\uae30\u00b7\uc4f0\uae30 \uc131\ub2a5\uc774 \uc800\ud558\ub41c\ub2e4. \ub610\ud55c \ub2e8\uc77c \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O\uc5d0\ub294 \ubb3c\ub9ac\uc801\uc778 \ud55c\uacc4\uac00 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95 \uc911 \ud558\ub098\uac00 <strong>\ub370\uc774\ud130 \ubd84\uc0b0(Data Distribution)<\/strong> \uc774\ub2e4. \ub370\uc774\ud130\ub97c \ub17c\ub9ac\uc801 \ub610\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc5ec\ub7ec \uc601\uc5ed\uc5d0 \ub098\ub204\uc5b4 \uc800\uc7a5\ud558\uace0, \ud544\uc694\uc5d0 \ub530\ub77c \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0\uc11c \ucc98\ub9ac\ud558\ub3c4\ub85d \uad6c\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ubd84\uc0b0\uacfc \uad00\ub828\ub41c \uc8fc\uc694 \uac1c\ub150\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ud30c\ud2f0\uc154\ub2dd(Partitioning)<\/strong>: \ud558\ub098\uc758 \ud14c\uc774\ube14\uc774\ub098 \ub370\uc774\ud130 \uc9d1\ud569\uc744 \uc5ec\ub7ec \ubd80\ubd84\uc73c\ub85c \ub098\ub204\ub294 \uae30\ubc95<\/li>\n\n\n\n<li><strong>\uc0e4\ub529(Sharding)<\/strong>: \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ub3c5\ub9bd\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \ubd84\uc0b0\ud558\ub294 \uae30\ubc95<\/li>\n\n\n\n<li><strong>\uc0e4\ub4dc \ud0a4(Shard Key)<\/strong>: \ub370\uc774\ud130\ub97c \uc5b4\ub290 \uc0e4\ub4dc\uc5d0 \uc800\uc7a5\ud560\uc9c0 \uacb0\uc815\ud558\ub294 \uae30\uc900<\/li>\n\n\n\n<li><strong>\ub370\uc774\ud130 \uc7ac\ubd84\ubc30(Rebalancing)<\/strong>: \ub370\uc774\ud130 \uc99d\uac00\ub098 \uc11c\ubc84 \ubcc0\uacbd\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \ubc30\uce58\ud558\ub294 \uc791\uc5c5<\/li>\n\n\n\n<li><strong>\ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Distributed Database)<\/strong>: \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \ub370\uc774\ud130\ub97c \ubd84\uc0b0\ud558\uc5ec \uad00\ub9ac\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uac1c\ub150\ub4e4\uc740 \uc11c\ub85c \uc5f0\uacb0\ub418\uc5b4 \uc788\uc9c0\ub9cc \ub3d9\uc77c\ud558\uc9c0 \uc54a\ub2e4. \ud2b9\ud788 \ud30c\ud2f0\uc154\ub2dd\uacfc \uc0e4\ub529\uc740 \ub370\uc774\ud130\ub97c \ub098\ub208\ub2e4\ub294 \uacf5\ud1b5\uc810\uc774 \uc788\uc9c0\ub9cc, \ubd84\uc0b0 \ubc94\uc704\uc640 \uc6b4\uc601 \ubc29\uc2dd\uc5d0\uc11c \ucc28\uc774\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ud30c\ud2f0\uc154\ub2dd(Partitioning)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud30c\ud2f0\uc154\ub2dd\uc740 \ud558\ub098\uc758 \ud070 \ud14c\uc774\ube14\uc744 \uc5ec\ub7ec \uac1c\uc758 \uc791\uc740 \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub204\uc5b4 \uad00\ub9ac\ud558\ub294 \uae30\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c\ub294 \ud558\ub098\uc758 \ud14c\uc774\ube14\ucc98\ub7fc \uc811\uadfc\ud560 \uc218 \uc788\uc9c0\ub9cc, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\ubd80\uc5d0\uc11c\ub294 \uc870\uac74\uc5d0 \ub530\ub77c \ub370\uc774\ud130\uac00 \uc5ec\ub7ec \ud30c\ud2f0\uc158\uc73c\ub85c \ub098\ub258\uc5b4 \uc800\uc7a5\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784 \uc11c\ubc84\uc758 \uc811\uc18d \uae30\ub85d\uc774 \uc218\uc5b5 \uac74\uc73c\ub85c \uc99d\uac00\ud588\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE game_logs (\n    id BIGINT NOT NULL,\n    user_id BIGINT NOT NULL,\n    event_type VARCHAR(50) NOT NULL,\n    created_at TIMESTAMP NOT NULL\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 \uc811\uc18d \uae30\ub85d\uc774 \ud558\ub098\uc758 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\uba74 \ub370\uc774\ud130\uac00 \uc99d\uac00\ud560\uc218\ub85d \uc778\ub371\uc2a4 \ud06c\uae30\uc640 \uc720\uc9c0 \uad00\ub9ac \ube44\uc6a9\uc774 \ucee4\uc9c8 \uc218 \uc788\ub2e4. \uc774\ub54c <code>created_at<\/code>\uc744 \uae30\uc900\uc73c\ub85c \uc6d4\ubcc4 \ud30c\ud2f0\uc154\ub2dd\uc744 \uc801\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \uae30\uac04\ubcc4\ub85c \ubd84\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubc94\uc704 \ud30c\ud2f0\uc154\ub2dd(Range Partitioning)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\uc815 \uac12\uc758 \ubc94\uc704\ub97c \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub098\ub204\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc0dd\uc131 \ub0a0\uc9dc\ub97c \uae30\uc900\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \ubd84\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>2026\ub144 1\uc6d4 \ub370\uc774\ud130<\/li>\n\n\n\n<li>2026\ub144 2\uc6d4 \ub370\uc774\ud130<\/li>\n\n\n\n<li>2026\ub144 3\uc6d4 \ub370\uc774\ud130<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub0a0\uc9dc\ub098 \uc22b\uc790\ucc98\ub7fc \uc21c\uc11c\uac00 \uc874\uc7ac\ud558\ub294 \uac12\uc5d0 \uc801\ud569\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7a5\uc810\uc740 \ud2b9\uc815 \uae30\uac04\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \uc624\ub798\ub41c \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud560 \ub54c \uad00\ub828 \ud30c\ud2f0\uc158\ub9cc \ub300\uc0c1\uc73c\ub85c \uc791\uc5c5\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc810\uc740 \ucd5c\uadfc \ub370\uc774\ud130\uc5d0 \uc4f0\uae30 \uc694\uccad\uc774 \uc9d1\uc911\ub420 \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4. \ud2b9\ud788 \uc2dc\uac04\uc21c\uc73c\ub85c \ub370\uc774\ud130\uac00 \uacc4\uc18d \uc99d\uac00\ud558\uba74 \ucd5c\uc2e0 \ud30c\ud2f0\uc158\uc5d0 \ubd80\ud558\uac00 \uc9d1\uc911\ub420 \uac00\ub2a5\uc131\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubaa9\ub85d \ud30c\ud2f0\uc154\ub2dd(List Partitioning)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\uc815 \uac12\uc758 \ubaa9\ub85d\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubd84\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc9c0\uc5ed \ucf54\ub4dc\ub098 \uc11c\ube44\uc2a4 \uc720\ud615\uc744 \uae30\uc900\uc73c\ub85c \ub098\ub20c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PARTITION BY LIST (region_code)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uac1c\ub150\uc801\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\ubd84\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>KR<\/code>: \ud55c\uad6d \uc0ac\uc6a9\uc790 \ub370\uc774\ud130<\/li>\n\n\n\n<li><code>JP<\/code>: \uc77c\ubcf8 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130<\/li>\n\n\n\n<li><code>US<\/code>: \ubbf8\uad6d \uc0ac\uc6a9\uc790 \ub370\uc774\ud130<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ubd84\ub958 \uae30\uc900\uc774 \uba85\ud655\ud558\uace0 \uac12\uc758 \uc885\ub958\uac00 \uc81c\ud55c\uc801\uc77c \ub54c \uc720\uc6a9\ud558\ub2e4. \ubc18\uba74 \uc0c8\ub85c\uc6b4 \uc9c0\uc5ed\uc774 \ucd94\uac00\ub420 \ub54c \ud30c\ud2f0\uc158 \uad00\ub9ac\uac00 \ud544\uc694\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud574\uc2dc \ud30c\ud2f0\uc154\ub2dd(Hash Partitioning)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\uc815 \uceec\ub7fc\uc5d0 \ud574\uc2dc \ud568\uc218\ub97c \uc801\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ud30c\ud2f0\uc158\uc5d0 \ubd84\uc0b0\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>partition = hash(user_id) % partition_count<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ud30c\ud2f0\uc158\uc774 4\uac1c\ub77c\uba74 \ud574\uc2dc \uacb0\uacfc\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c 0\ubd80\ud130 3\uae4c\uc9c0\uc758 \ud30c\ud2f0\uc158\uc5d0 \ubc30\uce58\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\uc815 \ubc94\uc704\uc5d0 \ub370\uc774\ud130\uac00 \uc9d1\uc911\ub418\ub294 \ud604\uc0c1\uc744 \uc904\uc774\ub294 \ub370 \uc720\ub9ac\ud558\uc9c0\ub9cc, \ud2b9\uc815 \ub0a0\uc9dc\uc758 \ub370\uc774\ud130\ub9cc \uc870\ud68c\ud558\ub294 \uac83\ucc98\ub7fc \ubc94\uc704 \uc870\uac74\uc774 \uc911\uc694\ud55c \ucffc\ub9ac\uc5d0\ub294 \uc801\ud569\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc704 \ucf54\ub4dc\ub294 \ub3d9\uc791 \uc6d0\ub9ac\ub97c \uc124\uba85\ud558\uae30 \uc704\ud55c \uc608\uc2dc\ub2e4. \uc2e4\uc81c SQL \ubb38\ubc95\uacfc \uc9c0\uc6d0 \ubc29\uc2dd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\ud488\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c4\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud30c\ud2f0\uc154\ub2dd\uc758 \ud575\uc2ec: Partition Pruning<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud30c\ud2f0\uc154\ub2dd\uc758 \uc131\ub2a5\uc0c1 \uc774\uc810\uc740 \ub2e8\uc21c\ud788 \ub370\uc774\ud130\ub97c \ub098\ub204\ub294 \uac83\uc5d0\uc11c \ub05d\ub098\uc9c0 \uc54a\ub294\ub2e4. \ucffc\ub9ac \uc870\uac74\uc744 \ubc14\ud0d5\uc73c\ub85c \ubd88\ud544\uc694\ud55c \ud30c\ud2f0\uc158\uc744 \uc81c\uc678\ud560 \uc218 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 2026\ub144 3\uc6d4\uc758 \ub85c\uadf8\ub9cc \uc870\ud68c\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\nFROM game_logs\nWHERE created_at &gt;= '2026-03-01'\n  AND created_at &lt; '2026-04-01';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub0a0\uc9dc \uc870\uac74\uc744 \ud65c\uc6a9\ud574 3\uc6d4 \ud30c\ud2f0\uc158\ub9cc \uc870\ud68c\ud55c\ub2e4\uba74 \uc804\uccb4 \ub370\uc774\ud130\ub97c \ud0d0\uc0c9\ud558\ub294 \ube44\uc6a9\uc744 \uc904\uc77c \uc218 \uc788\ub2e4. \uc774\ub97c \ud30c\ud2f0\uc158 \ud504\ub8e8\ub2dd(Partition Pruning)\uc774\ub77c\uace0 \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\ub300\ub85c \ucffc\ub9ac \uc870\uac74\uc774 \ud30c\ud2f0\uc158 \ud0a4\uc640 \ub9de\uc9c0 \uc54a\uac70\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc870\uac74\uc744 \ud65c\uc6a9\ud560 \uc218 \uc5c6\ub2e4\uba74 \uc5ec\ub7ec \ud30c\ud2f0\uc158\uc744 \ud0d0\uc0c9\ud574\uc57c \ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub610\ud55c \ud30c\ud2f0\uc154\ub2dd\uc740 \uc778\ub371\uc2a4\ub97c \ub300\uccb4\ud558\uc9c0 \uc54a\ub294\ub2e4. \ud30c\ud2f0\uc158 \ub0b4\ubd80\uc5d0\uc11c\ub3c4 \uc801\uc808\ud55c \uc778\ub371\uc2a4 \uc124\uacc4\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc0e4\ub529(Sharding)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub529\uc740 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \ub098\ub204\uc5b4 \uc800\uc7a5\ud558\ub294 \uae30\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud30c\ud2f0\uc154\ub2dd\uc774 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\ubd80\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \ub098\ub204\ub294 \ubc29\uc2dd\uc73c\ub85c\ub3c4 \uad6c\ud604\ub420 \uc218 \uc788\ub2e4\uba74, \uc0e4\ub529\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ub370\uc774\ud130\ub97c \ubd84\uc0b0\ud558\ub294 \uc218\ud3c9 \ud655\uc7a5 \uc804\ub7b5\uc744 \uc758\ubbf8\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\uac00 3\ucc9c\ub9cc \uac74\uc774\ub77c\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \ud558\ub098\uc758 \uc11c\ubc84\uac00 \uad00\ub9ac\ud55c\ub2e4. \uc0e4\ub529\uc744 \uc801\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ubd84\uc0b0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> <code>                 Application\n                       |\n                  Shard Router\n                       |\n          +------------+------------+\n          |            |            |\n       Shard A      Shard B      Shard C\n       User 0~N     User N~M     User M~Z<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc704 \uad6c\uc870\ub294 \ubc94\uc704 \uc0e4\ub529\uc744 \ub2e8\uc21c\ud654\ud55c \uc608\uc2dc\ub2e4. \uc2e4\uc81c \ubc94\uc704 \uacbd\uacc4\uc640 \uc0e4\ub4dc \uad6c\uc131\uc740 \ub370\uc774\ud130 \ubd84\ud3ec\uc640 \uc6b4\uc601 \ud658\uacbd\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c4\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub529\uc758 \ubaa9\uc801\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130 \uc800\uc7a5 \uacf5\uac04\uc744 \uc5ec\ub7ec \uc11c\ubc84\ub85c \ubd84\uc0b0\ud55c\ub2e4.<\/li>\n\n\n\n<li>\uc77d\uae30\u00b7\uc4f0\uae30 \uc694\uccad\uc744 \uc5ec\ub7ec \uc11c\ubc84\uc5d0\uc11c \ucc98\ub9ac\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/li>\n\n\n\n<li>\ud2b9\uc815 \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O \ubd80\ub2f4\uc744 \uc904\uc778\ub2e4.<\/li>\n\n\n\n<li>\uc11c\ubc84\ub97c \ucd94\uac00\ud558\uc5ec \uc800\uc7a5 \uc6a9\ub7c9\uacfc \ucc98\ub9ac \ub2a5\ub825\uc744 \ud655\uc7a5\ud560 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uc0e4\ub529\uc774 \uc801\uc6a9\ub418\uc5c8\ub2e4\uace0 \ud574\uc11c \uc131\ub2a5\uc774 \uc790\ub3d9\uc73c\ub85c \ud5a5\uc0c1\ub418\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uc694\uccad\uc774 \ud2b9\uc815 \uc0e4\ub4dc\uc5d0 \uc9d1\uc911\ub418\uac70\ub098 \uc5ec\ub7ec \uc0e4\ub4dc\uc5d0 \uac78\uce5c \ucffc\ub9ac\uac00 \ub9ce\ub2e4\uba74 \uc624\ud788\ub824 \uc6b4\uc601 \ubcf5\uc7a1\ub3c4\uc640 \uc751\ub2f5 \uc9c0\uc5f0\uc774 \uc99d\uac00\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc218\ud3c9 \ud655\uc7a5\uacfc \uc218\uc9c1 \ud655\uc7a5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud655\uc7a5 \ubc29\uc2dd\uc740 \ud06c\uac8c \uc218\uc9c1 \ud655\uc7a5\uacfc \uc218\ud3c9 \ud655\uc7a5\uc73c\ub85c \ub098\ub20c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc218\uc9c1 \ud655\uc7a5(Scale-up)<\/strong> \uc740 \uae30\uc874 \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c \uc131\ub2a5\uc744 \ub192\uc774\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7a5\uc810\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ub370\uc774\ud130 \uad6c\uc870\ub97c \ud06c\uac8c \ubcc0\uacbd\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4. \ud558\uc9c0\ub9cc \ud558\ub4dc\uc6e8\uc5b4\uc758 \uc0c1\ud55c\uc120\uacfc \ube44\uc6a9 \ud6a8\uc728\uc131\uc5d0 \ud55c\uacc4\uac00 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc218\ud3c9 \ud655\uc7a5(Scale-out)<\/strong> \uc740 \uc5ec\ub7ec \uc11c\ubc84\ub97c \ucd94\uac00\ud558\uc5ec \ucc98\ub9ac \ubd80\ud558\uc640 \ub370\uc774\ud130\ub97c \ubd84\uc0b0\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub529\uc740 \ub300\ud45c\uc801\uc778 \uc218\ud3c9 \ud655\uc7a5 \uc804\ub7b5\uc774\ub2e4. \ub2e4\ub9cc \ub370\uc774\ud130 \ub77c\uc6b0\ud305, \uc11c\ubc84 \uac04 \ud1b5\uc2e0, \uc7a5\uc560 \ucc98\ub9ac, \ub370\uc774\ud130 \uc7ac\ubd84\ubc30 \ub4f1 \ucd94\uac00\uc801\uc778 \uc124\uacc4\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c \ub2e8\uc77c \uc11c\ubc84\uc758 \uc790\uc6d0 \uc99d\uc124\ub85c \ucda9\ubd84\ud55c \uc0c1\ud669\uc774\ub77c\uba74 \ubb34\uc870\uac74 \uc0e4\ub529\ubd80\ud130 \ub3c4\uc785\ud560 \ud544\uc694\ub294 \uc5c6\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc0e4\ub4dc \ud0a4 \uc124\uacc4(Shard Key Design)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4\ub294 \ud2b9\uc815 \ub370\uc774\ud130\uac00 \uc5b4\ub290 \uc0e4\ub4dc\uc5d0 \uc800\uc7a5\ub420\uc9c0 \uacb0\uc815\ud558\ub294 \uae30\uc900\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4 \uc124\uacc4\ub294 \uc0e4\ub529 \uc544\ud0a4\ud14d\ucc98\uc5d0\uc11c \uac00\uc7a5 \uc911\uc694\ud55c \uacb0\uc815 \uc911 \ud558\ub098\ub2e4. \uc798\ubabb\ub41c \ud0a4\ub97c \uc120\ud0dd\ud558\uba74 \ub370\uc774\ud130\uac00 \ud2b9\uc815 \uc11c\ubc84\uc5d0 \uc9d1\uc911\ub418\uac70\ub098, \ub300\ubd80\ubd84\uc758 \uc694\uccad\uc774 \uc5ec\ub7ec \uc0e4\ub4dc\ub97c \ub3d9\uc2dc\uc5d0 \uc870\ud68c\ud574\uc57c \ud558\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub300\ud45c\uc801\uc778 \uc0e4\ub4dc \ud0a4 \ud6c4\ubcf4\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>user_id<\/code>: \uc0ac\uc6a9\uc790 \uc2dd\ubcc4\uc790<\/li>\n\n\n\n<li><code>guild_id<\/code>: \uae38\ub4dc \uc2dd\ubcc4\uc790<\/li>\n\n\n\n<li><code>region_id<\/code>: \uc9c0\uc5ed \uc2dd\ubcc4\uc790<\/li>\n\n\n\n<li><code>created_at<\/code>: \uc0dd\uc131 \uc2dc\uac04<\/li>\n\n\n\n<li><code>tenant_id<\/code>: \ud14c\ub10c\ud2b8 \uc2dd\ubcc4\uc790<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5b4\ub5a4 \ud0a4\uac00 \uc801\ud569\ud55c\uc9c0\ub294 \ub370\uc774\ud130 \uc790\uccb4\ubcf4\ub2e4 <strong>\uc2e4\uc81c \ucffc\ub9ac \ud328\ud134\uacfc \ubd80\ud558 \ubd84\ud3ec<\/strong>\uc5d0 \ub530\ub77c \uacb0\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uce74\ub514\ub110\ub9ac\ud2f0(Cardinality)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uce74\ub514\ub110\ub9ac\ud2f0\ub294 \ud2b9\uc815 \uceec\ub7fc\uc774 \uac00\uc9c8 \uc218 \uc788\ub294 \uace0\uc720 \uac12\uc758 \uac1c\uc218\uc640 \uad00\ub828\ub41c \uac1c\ub150\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 <code>region_id<\/code>\uac00 \ud55c\uad6d, \uc77c\ubcf8, \ubbf8\uad6d\uc758 \uc138 \uac00\uc9c0 \uac12\ub9cc \uac00\uc9c4\ub2e4\uba74 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub0ae\ub2e4. \ubc18\uba74 <code>user_id<\/code>\uac00 \uc218\ubc31\ub9cc \uac1c\uc758 \uace0\uc720 \uac12\uc744 \uac00\uc9c4\ub2e4\uba74 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub192\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4\uc758 \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \uc9c0\ub098\uce58\uac8c \ub0ae\uc73c\uba74 \ub370\uc774\ud130\ub97c \ucda9\ubd84\ud788 \ubd84\uc0b0\ud558\uae30 \uc5b4\ub835\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uc9c0\uc5ed \ucf54\ub4dc\ub9cc\uc73c\ub85c 10\uac1c \uc0e4\ub4dc\ub97c \ubd84\ubc30\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790. \uc2e4\uc81c \uc9c0\uc5ed\uc774 \uc138 \uacf3\ubfd0\uc774\ub77c\uba74 \uc138 \uacf3\uc758 \ub370\uc774\ud130\ub9cc \ubc30\uce58\ub418\uac70\ub098, \uc9c0\uc5ed\ubcc4 \ub370\uc774\ud130\ub7c9 \ucc28\uc774\uc5d0 \ub530\ub77c \uc77c\ubd80 \uc0e4\ub4dc\uc5d0 \ubd80\ud558\uac00 \uc9d1\uc911\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\ub300\ub85c \uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub192\ub2e4\uace0 \ubc18\ub4dc\uc2dc \uc88b\uc740 \uac83\uc740 \uc544\ub2c8\ub2e4. \uace0\uc720 \uac12\uc774 \ub9ce\ub354\ub77c\ub3c4 \ud2b9\uc815 \ud0a4\uc5d0 \uc694\uccad\uc774 \uc9d1\uc911\ub41c\ub2e4\uba74 \ud574\ub2f9 \uc0e4\ub4dc\uac00 \ubcd1\ubaa9\uc774 \ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub370\uc774\ud130 \ubd84\ud3ec\uc640 \ud56b\uc2a4\ud31f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud56b\uc2a4\ud31f(Hotspot)\uc740 \ud2b9\uc815 \uc0e4\ub4dc\uc5d0 \ub370\uc774\ud130\ub098 \uc694\uccad\uc774 \uc9d1\uc911\ub418\ub294 \ud604\uc0c1\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c \ubaa8\ub4e0 \ud50c\ub808\uc774\uc5b4\uac00 \uacf5\ud1b5\uc73c\ub85c \ucc38\uc5ec\ud558\ub294 \ub300\uaddc\ubaa8 \uc774\ubca4\ud2b8\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud558\uc790. \ud2b9\uc815 <code>event_id<\/code>\ub97c \uc0e4\ub4dc \ud0a4\ub85c \uc0ac\uc6a9\ud558\uba74 \uc774\ubca4\ud2b8 \uad00\ub828 \ub370\uc774\ud130\uc640 \uc694\uccad\uc774 \ud558\ub098\uc758 \uc0e4\ub4dc\uc5d0 \uc9d1\uc911\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubb38\uc81c\ub97c \uc904\uc774\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\uc2dd\uc744 \uac80\ud1a0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc0ac\uc6a9\uc790 ID \uae30\ubc18\uc73c\ub85c \ubd84\uc0b0\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ud574\uc2dc \uae30\ubc18 \uc0e4\ub529\uc744 \uc801\uc6a9\ud55c\ub2e4.<\/li>\n\n\n\n<li>\uc694\uccad\uc774 \uc9d1\uc911\ub418\ub294 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\ub85c \ubd84\ub9ac\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ud544\uc694\ud55c \uacbd\uc6b0 \ubcf5\ud569 \uc0e4\ub4dc \ud0a4\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ud2b9\uc815 \ub370\uc774\ud130\uc758 \uc4f0\uae30 \ubd80\ud558\ub97c \ubcc4\ub3c4\uc758 \ucc98\ub9ac \uad6c\uc870\ub85c \ubd84\uc0b0\ud55c\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8, \uc0e4\ub4dc \ud0a4\ub97c \ubb34\uc791\uc815 \ubcf5\uc7a1\ud558\uac8c \ub9cc\ub4e4\uba74 \ub370\uc774\ud130 \uc870\ud68c\uc640 \uc6b4\uc601\uc774 \uc5b4\ub824\uc6cc\uc9c4\ub2e4. \ubd84\uc0b0 \ud6a8\uacfc\uc640 \uc870\ud68c \ud6a8\uc728 \uc0ac\uc774\uc5d0\uc11c \uade0\ud615\uc744 \uc7a1\uc544\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucffc\ub9ac \ud328\ud134\uacfc \ub85c\uceec\ub9ac\ud2f0(Locality)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ub85c\uceec\ub9ac\ud2f0\ub294 \ud568\uaed8 \uc870\ud68c\ud558\uac70\ub098 \ubcc0\uacbd\ud558\ub294 \ub370\uc774\ud130\uac00 \uac00\uae4c\uc6b4 \uc704\uce58\uc5d0 \ubc30\uce58\ub418\uc5b4 \uc788\ub294 \uc815\ub3c4\ub97c \uc758\ubbf8\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \uac8c\uc784\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc815\ubcf4, \uc778\ubca4\ud1a0\ub9ac, \ud018\uc2a4\ud2b8 \uc9c4\ud589 \uc0c1\ud0dc\ub97c \uc790\uc8fc \ud568\uaed8 \uc870\ud68c\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790 ID\ub97c \uae30\uc900\uc73c\ub85c \uad00\ub828 \ub370\uc774\ud130\ub97c \ub3d9\uc77c\ud55c \uc0e4\ub4dc\uc5d0 \ubc30\uce58\ud558\uba74 \ud574\ub2f9 \uc694\uccad\uc744 \ud558\ub098\uc758 \uc0e4\ub4dc\uc5d0\uc11c \ucc98\ub9ac\ud560 \uac00\ub2a5\uc131\uc774 \ub192\uc544\uc9c4\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Shard A\n \u251c\u2500 User 1001\n \u251c\u2500 Inventory 1001\n \u2514\u2500 Quest 1001\n\nShard B\n \u251c\u2500 User 2001\n \u251c\u2500 Inventory 2001\n \u2514\u2500 Quest 2001<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uad6c\uc870\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \ub2e8\uc704 \uc870\ud68c\uac00 \uac04\ub2e8\ud574\uc9c4\ub2e4. \ubc18\uba74 \uc5ec\ub7ec \uc0ac\uc6a9\uc790 \uac04 \uac70\ub798\ub098 \uc804\uccb4 \uc0ac\uc6a9\uc790 \ud1b5\uacc4\ucc98\ub7fc \uc5ec\ub7ec \uc0e4\ub4dc\uc758 \ub370\uc774\ud130\uac00 \ud544\uc694\ud55c \uc791\uc5c5\uc740 \ubcf5\uc7a1\ud574\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4\ub97c \uacb0\uc815\ud560 \ub54c\ub294 \ub2e4\uc74c \uc9c8\ubb38\uc5d0 \ub2f5\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uac00\uc7a5 \ube48\ubc88\ud558\uac8c \uc2e4\ud589\ub418\ub294 \ucffc\ub9ac\ub294 \ubb34\uc5c7\uc778\uac00?<\/li>\n\n\n\n<li>\uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \ud568\uaed8 \uc870\ud68c\ub418\uac70\ub098 \ubcc0\uacbd\ub418\ub294\uac00?<\/li>\n\n\n\n<li>\uc77d\uae30\uc640 \uc4f0\uae30 \ubd80\ud558\ub294 \uc5b4\ub5a4 \ubd84\ud3ec\ub97c \uac00\uc9c0\ub294\uac00?<\/li>\n\n\n\n<li>\ud2b9\uc815 \ud0a4\uc5d0 \uc694\uccad\uc774 \uc9d1\uc911\ub420 \uac00\ub2a5\uc131\uc774 \uc788\ub294\uac00?<\/li>\n\n\n\n<li>\ub370\uc774\ud130\uac00 \uc99d\uac00\ud588\uc744 \ub54c \uc0e4\ub4dc\ub97c \ucd94\uac00\ud558\uae30 \uc26c\uc6b4\uac00?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uc9c8\ubb38\uc5d0 \ub300\ud55c \ub2f5\uc774 \uc0e4\ub4dc \ud0a4 \uc124\uacc4\uc758 \uae30\uc900\uc774 \ub41c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc0e4\ub529 \uc804\ub7b5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\ubc94\uc704 \uae30\ubc18 \uc0e4\ub529(Range-based Sharding)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4\uc758 \uac12 \ubc94\uc704\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ubd84\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Shard A: user_id 1 ~ 1,000,000\nShard B: user_id 1,000,001 ~ 2,000,000\nShard C: user_id 2,000,001 ~ 3,000,000<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc7a5\uc810\uc740 \ubc94\uc704 \uc870\ud68c\uac00 \ube44\uad50\uc801 \uc27d\uace0 \ud2b9\uc815 \ub370\uc774\ud130\uac00 \uc5b4\ub290 \uc0e4\ub4dc\uc5d0 \uc788\ub294\uc9c0 \ud310\ub2e8\ud558\uae30 \ud3b8\ud558\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e8\uc810\uc740 \uac12\uc774 \uc99d\uac00\ud558\ub294 \ubc29\ud5a5\uc73c\ub85c \uc4f0\uae30\uac00 \uc9d1\uc911\ub418\uac70\ub098 \ud2b9\uc815 \ubc94\uc704\uc5d0 \ub370\uc774\ud130\uac00 \ubab0\ub9ac\uba74 \ud56b\uc2a4\ud31f\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud574\uc2dc \uae30\ubc18 \uc0e4\ub529(Hash-based Sharding)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \ud0a4\uc5d0 \ud574\uc2dc \ud568\uc218\ub97c \uc801\uc6a9\ud574 \uc0e4\ub4dc\ub97c \uacb0\uc815\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>shard_index = hash(user_id) % shard_count<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790 ID\uac00 \uace0\ub974\uac8c \ubd84\ud3ec\ud55c\ub2e4\uba74 \ub370\uc774\ud130\uc640 \uc694\uccad\uc744 \uc5ec\ub7ec \uc0e4\ub4dc\uc5d0 \ubd84\uc0b0\ud558\uae30 \uc720\ub9ac\ud558\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \uc0e4\ub4dc \uac1c\uc218\uac00 \ubcc0\uacbd\ub418\uba74 \uae30\uc874 \ub370\uc774\ud130\uc758 \ub9e4\ud551\uc774 \ud06c\uac8c \ub2ec\ub77c\uc9c8 \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc0e4\ub4dc\uac00 4\uac1c\uc77c \ub54c \uc0ac\uc6a9\ud558\ub358 \ub098\uba38\uc9c0 \uc5f0\uc0b0\uc744 5\uac1c\ub85c \ubcc0\uacbd\ud558\uba74 \uc0c1\ub2f9\uc218 \ub370\uc774\ud130\uac00 \uc0c8\ub85c\uc6b4 \uc704\uce58\ub85c \uc774\ub3d9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubb38\uc81c\ub97c \uc644\ud654\ud558\uae30 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\uac00 \uc77c\uad00\ub41c \ud574\uc2f1(Consistent Hashing)\uc774\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub514\ub809\ud130\ub9ac \uae30\ubc18 \uc0e4\ub529(Directory-based Sharding)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ubcc4\ub3c4\uc758 \ub9e4\ud551 \uc815\ubcf4\ub85c \ub370\uc774\ud130\uac00 \uc704\uce58\ud55c \uc0e4\ub4dc\ub97c \uacb0\uc815\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>user_id 1001 -&gt; Shard A\nuser_id 2001 -&gt; Shard C\nuser_id 3001 -&gt; Shard B<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ubc29\uc2dd\uc740 \ub370\uc774\ud130 \uc704\uce58\ub97c \uc720\uc5f0\ud558\uac8c \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uc0e4\ub4dc \ub9e4\ud551 \uc815\ubcf4\ub97c \uad00\ub9ac\ud558\ub294 \uc2dc\uc2a4\ud15c\uc774 \ud544\uc694\ud558\ub2e4. \ub9e4\ud551 \uc815\ubcf4\uc758 \uac00\uc6a9\uc131, \uce90\uc2f1, \ub3d9\uae30\ud654, \uc7a5\uc560 \ubcf5\uad6c\ub3c4 \ud568\uaed8 \uace0\ub824\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ub370\uc774\ud130 \uc7ac\ubd84\ubc30(Rebalancing)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \uc7ac\ubd84\ubc30\ub294 \uae30\uc874 \uc0e4\ub4dc\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uc0c8\ub85c\uc6b4 \uc0e4\ub4dc \uad6c\uc131\uc5d0 \ub9de\uac8c \uc774\ub3d9\ud558\uac70\ub098 \uc7ac\ubc30\uce58\ud558\ub294 \uc791\uc5c5\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ucd08\uae30\uc5d0\ub294 \ub450 \uac1c\uc758 \uc0e4\ub4dc\ub85c \ucda9\ubd84\ud588\ub354\ub77c\ub3c4 \uc0ac\uc6a9\uc790\uc640 \ub370\uc774\ud130\uac00 \uc99d\uac00\ud558\uba74 \uc11c\ubc84\ub97c \ucd94\uac00\ud574\uc57c \ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Before\n\nShard A: 50%\nShard B: 50%\n\n        \u2193 \ub370\uc774\ud130 \uc99d\uac00 \ubc0f \uc11c\ubc84 \ucd94\uac00\n\nAfter\n\nShard A: \uc57d 33%\nShard B: \uc57d 33%\nShard C: \uc57d 34%<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc704 \uc218\uce58\ub294 \uade0\ub4f1 \ubd84\ubc30\ub97c \uac00\uc815\ud55c \uac1c\ub150\uc801 \uc608\uc2dc\ub2e4. \uc2e4\uc81c \ub370\uc774\ud130\ub7c9\uacfc \uc694\uccad\ub7c9\uc740 \ubc18\ub4dc\uc2dc \uade0\ub4f1\ud574\uc9c0\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub2e8\uc21c \ud574\uc2dc \ubc29\uc2dd\uc758 \uc7ac\ubd84\ubc30 \ubb38\uc81c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc74c\uacfc \uac19\uc740 \uc0e4\ub4dc \uc120\ud0dd \ub85c\uc9c1\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function getShard(userId: number, shardCount: number): number {\n  return userId % shardCount;\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc\uac00 3\uac1c\uc77c \ub54c\uc640 4\uac1c\uc77c \ub54c\ub97c \ube44\uad50\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>user_id = 10\n\n10 % 3 = 1\n10 % 4 = 2<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc \uac1c\uc218\uac00 \ubcc0\uacbd\ub418\uba74 \ub3d9\uc77c\ud55c \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\uac00 \ub2e4\ub978 \uc0e4\ub4dc\uc5d0 \uc704\uce58\ud574\uc57c \ud55c\ub2e4. \uae30\uc874 \ub370\uc774\ud130\ub97c \uc2e4\uc81c\ub85c \uc774\ub3d9\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \uc0c8\ub85c\uc6b4 \uc704\uce58\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ucc3e\uc9c0 \ubabb\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c \uc0e4\ub4dc \uac1c\uc218\ub9cc \ubcc0\uacbd\ud558\ub294 \uac83\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0 \uc54a\ub2e4. \ub370\uc774\ud130 \uc774\ub3d9\uacfc \ub77c\uc6b0\ud305 \ubcc0\uacbd\uc744 \ud568\uaed8 \ucc98\ub9ac\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc77c\uad00\ub41c \ud574\uc2f1(Consistent Hashing)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\uad00\ub41c \ud574\uc2f1\uc740 \uc0e4\ub4dc\uc640 \ub370\uc774\ud130\ub97c \ud574\uc2dc \uacf5\uac04\uc5d0 \ubc30\uce58\ud558\uace0, \ub370\uc774\ud130\uac00 \ud574\ub2f9\ud558\ub294 \uad6c\uac04\uc758 \uc0e4\ub4dc\uc5d0 \uc5f0\uacb0\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub4dc\ub97c \ucd94\uac00\ud558\uac70\ub098 \uc81c\uac70\ud560 \ub54c \uc77c\ubc18\uc801\uc778 \ubaa8\ub4c8\ub85c \ud574\uc2f1\ubcf4\ub2e4 \uc774\ub3d9\ud574\uc57c \ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc904\uc77c \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uc77c\uad00\ub41c \ud574\uc2f1\uc774 \ub370\uc774\ud130 \uc7ac\ubd84\ubc30\ub97c \uc644\uc804\ud788 \uc81c\uac70\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uac00\uc0c1 \ub178\ub4dc, \ub370\uc774\ud130 \uade0\ud615, \uc0e4\ub4dc\ubcc4 \uc6a9\ub7c9 \ucc28\uc774 \ub4f1\uc744 \uace0\ub824\ud574\uc57c \ud558\uba70, \uc2e4\uc81c \ub370\uc774\ud130 \uc774\ub3d9\uc740 \uc5ec\uc804\ud788 \ud544\uc694\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uac00\uc0c1 \ub178\ub4dc(Virtual Nodes)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uac00\uc0c1 \ub178\ub4dc\ub294 \ud558\ub098\uc758 \ubb3c\ub9ac\uc801 \uc0e4\ub4dc\ub97c \ud574\uc2dc \uacf5\uac04\uc758 \uc5ec\ub7ec \uc704\uce58\uc5d0 \ubc30\uce58\ud558\ub294 \uae30\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubb3c\ub9ac\uc801 \uc0e4\ub4dc\uac00 \ud558\ub098\uc758 \uc704\uce58\ub9cc \ucc28\uc9c0\ud558\uba74 \ub370\uc774\ud130 \ubd84\ud3ec\uac00 \ubd88\uade0\ub4f1\ud574\uc9c8 \uc218 \uc788\ub2e4. \uc5ec\ub7ec \uac00\uc0c1 \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \ubd84\ud3ec\ub97c \uac1c\uc120\ud558\uace0 \uc11c\ubc84 \ucd94\uac00\u00b7\uc81c\uac70 \uc2dc \uc774\ub3d9\ud560 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc138\ubc00\ud558\uac8c \uc870\uc815\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\ub9cc \uac00\uc0c1 \ub178\ub4dc \uc218\ub97c \ub298\ub9ac\ub294 \uac83\ub9cc\uc73c\ub85c \uc2e4\uc81c \ub370\uc774\ud130\ub7c9\uacfc \uc694\uccad\ub7c9\uc774 \uc644\ubcbd\ud558\uac8c \uade0\ub4f1\ud574\uc9c0\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc548\uc804\ud55c \ub370\uc774\ud130 \uc7ac\ubd84\ubc30 \uc808\ucc28<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6b4\uc601 \uc911\uc778 \uc11c\ube44\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc774\ub3d9\ud560 \ub54c\ub294 \ub370\uc774\ud130 \uc190\uc2e4\uacfc \ubd88\uc77c\uce58\ub97c \ubc29\uc9c0\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ubc18\uc801\uc778 \uc808\ucc28\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ub300\uc0c1 \uc0e4\ub4dc \uc900\ube44<\/strong>: \uc0c8\ub85c\uc6b4 \uc0e4\ub4dc\uc640 \uc2a4\ud0a4\ub9c8, \uc778\ub371\uc2a4\ub97c \uc900\ube44\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\ucd08\uae30 \ub370\uc774\ud130 \ubcf5\uc0ac<\/strong>: \uae30\uc874 \uc0e4\ub4dc\uc758 \ub370\uc774\ud130\ub97c \uc2e0\uaddc \uc0e4\ub4dc\ub85c \ubcf5\uc0ac\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\ubcc0\uacbd \uc0ac\ud56d \ub3d9\uae30\ud654<\/strong>: \ubcf5\uc0ac \uc911 \ubc1c\uc0dd\ud55c \uc4f0\uae30\ub97c \ucd94\uc801\ud558\uc5ec \uc2e0\uaddc \uc0e4\ub4dc\uc5d0 \ubc18\uc601\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\uac80\uc99d<\/strong>: \ub370\uc774\ud130 \uac74\uc218, \uccb4\ud06c\uc12c, \ud575\uc2ec \ub808\ucf54\ub4dc \ubc0f \uc81c\uc57d \uc870\uac74\uc744 \ud655\uc778\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\ub77c\uc6b0\ud305 \uc804\ud658<\/strong>: \uc77d\uae30\u00b7\uc4f0\uae30 \uc694\uccad\uc744 \uc0c8\ub85c\uc6b4 \uc704\uce58\ub85c \uc804\ud658\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\uc548\uc815\uc131 \ud655\uc778<\/strong>: \uc624\ub958\uc728, \uc9c0\uc5f0 \uc2dc\uac04, \ub370\uc774\ud130 \ubd88\uc77c\uce58\ub97c \uac10\uc2dc\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\uae30\uc874 \ub370\uc774\ud130 \uc815\ub9ac<\/strong>: \ub864\ubc31 \uac00\ub2a5\uc131\uacfc \ubcf4\uc874 \uc815\ucc45\uc744 \uace0\ub824\ud574 \uc774\uc804 \ub370\uc774\ud130\ub97c \uc81c\uac70\ud55c\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \ub370\uc774\ud130 \ubcf5\uc0ac\uc640 \ub77c\uc6b0\ud305 \uc804\ud658 \uc0ac\uc774\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \ub3d9\uc2dc \uc4f0\uae30\ub97c \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud560 \uac83\uc778\uc9c0\uac00 \uc911\uc694\ud558\ub2e4. \uc774 \ubd80\ubd84\uc774 \uc124\uacc4\ub418\uc9c0 \uc54a\uc73c\uba74 \ubcf5\uc0ac \ub3c4\uc911 \ubcc0\uacbd\ub41c \ub370\uc774\ud130\uac00 \ub204\ub77d\ub418\uac70\ub098 \uc911\ubcf5 \ubc18\uc601\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \uc7ac\ubd84\ubc30\ub294 \ub2e8\uc21c\ud55c \ub370\uc774\ud130 \ubcf5\uc0ac \uc791\uc5c5\uc774 \uc544\ub2c8\ub2e4. \ub370\uc774\ud130 \uc77c\uad00\uc131, \uc11c\ube44\uc2a4 \uac00\uc6a9\uc131, \uc7a5\uc560 \ubcf5\uad6c\ub97c \ud3ec\ud568\ud558\ub294 \uc6b4\uc601 \uc791\uc5c5\uc774\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Distributed Database)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \ubd84\uc0b0\ud558\uc5ec \uc800\uc7a5\ud558\uace0 \ucc98\ub9ac\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\ub294 \uc0e4\ub529\ubfd0 \uc544\ub2c8\ub77c, \ubcf5\uc81c(Replication), \ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158, \uc7a5\uc560 \ubcf5\uad6c, \ub178\ub4dc \uac04 \ud1b5\uc2e0\uacfc \uac19\uc740 \uc5ec\ub7ec \uae30\uc220\uc744 \uc870\ud569\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\uae30\uc11c \uc0e4\ub529\uacfc \ubcf5\uc81c\ub294 \uad6c\ubd84\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc0e4\ub529<\/strong>: \uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130\uc758 \uc77c\ubd80\ub97c \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \uc800\uc7a5\ud55c\ub2e4.<\/li>\n\n\n\n<li><strong>\ubcf5\uc81c<\/strong>: \ub3d9\uc77c\ud55c \ub370\uc774\ud130\uc758 \uc0ac\ubcf8\uc744 \uc5ec\ub7ec \ub178\ub4dc\uc5d0 \uc800\uc7a5\ud55c\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0e4\ub529\uc740 \uc800\uc7a5 \uc6a9\ub7c9\uacfc \ucc98\ub9ac \ubd80\ud558\ub97c \ubd84\uc0b0\ud558\ub294 \ub370 \ucd08\uc810\uc744 \ub9de\ucd94\uace0, \ubcf5\uc81c\ub294 \uc77d\uae30 \ucc98\ub9ac \ub2a5\ub825\uc774\ub098 \uac00\uc6a9\uc131, \uc7a5\uc560 \ub300\uc751\uc744 \uac1c\uc120\ud558\ub294 \ub370 \ud65c\uc6a9\ub41c\ub2e4. \uc2e4\uc81c \ud6a8\uacfc\ub294 \ubcf5\uc81c \ubc29\uc2dd\uacfc \uc2dc\uc2a4\ud15c \uad6c\uc131\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c4\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc870\ub97c \uad6c\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> <code>                  Application\n                        |\n                    Shard Router\n                        |\n             +----------+----------+\n             |                     |\n          Shard A               Shard B\n             |                     |\n        +----+----+           +----+----+\n        |         |           |         |\n     Primary   Replica     Primary   Replica<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uac01 \uc0e4\ub4dc\ub294 \uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130\ub97c \ub2f4\ub2f9\ud558\uace0, \uac01 \uc0e4\ub4dc \ub0b4\ubd80\uc5d0\uc11c\ub294 Primary\uc640 Replica\ub97c \uad6c\uc131\ud574 \ubcf5\uc81c\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uad6c\uc870\ub294 \ub370\uc774\ud130 \ubd84\uc0b0\uacfc \ubcf5\uc81c\ub97c \ud568\uaed8 \ud65c\uc6a9\ud558\ub294 \uc608\uc2dc\ub2e4. \ubaa8\ub4e0 \ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub3d9\uc77c\ud55c \uad6c\uc131\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc8fc\uc694 \uacfc\uc81c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\ub098\uc758 \ud2b8\ub79c\uc7ad\uc158\uc774 \uc5ec\ub7ec \uc0e4\ub4dc\uc758 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud574\uc57c \ud55c\ub2e4\uba74 \uc6d0\uc790\uc131\uc744 \ubcf4\uc7a5\ud558\uae30 \uc5b4\ub824\uc6cc\uc9c4\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ud50c\ub808\uc774\uc5b4 A\uac00 \ud50c\ub808\uc774\uc5b4 B\uc5d0\uac8c \uac8c\uc784 \uc7ac\ud654\ub97c \uc804\ub2ec\ud558\ub294 \uc791\uc5c5\uc774 \uc11c\ub85c \ub2e4\ub978 \uc0e4\ub4dc\uc5d0 \uc704\uce58\ud55c\ub2e4\uba74, A\uc758 \uc794\uc561 \uac10\uc18c\uc640 B\uc758 \uc794\uc561 \uc99d\uac00\ub97c \uc77c\uad00\ub418\uac8c \ucc98\ub9ac\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub54c \ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158 \ud504\ub85c\ud1a0\ucf5c\uc744 \uc0ac\uc6a9\ud558\uac70\ub098, \ube44\ub3d9\uae30 \uba54\uc2dc\uc9c0\uc640 \ubcf4\uc0c1 \uc791\uc5c5\uc744 \uc774\uc6a9\ud558\ub294 \uad6c\uc870\ub97c \uac80\ud1a0\ud560 \uc218 \uc788\ub2e4. \uc5b4\ub5a4 \ubc29\uc2dd\uc774 \uc801\ud569\ud55c\uc9c0\ub294 \ub370\uc774\ud130 \uc815\ud569\uc131 \uc694\uad6c\uc0ac\ud56d\uacfc \uc7a5\uc560 \uc0c1\ud669\uc5d0\uc11c \ud5c8\uc6a9 \uac00\ub2a5\ud55c \ub3d9\uc791\uc5d0 \ub530\ub77c \uacb0\uc815\ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\ubd84\uc0b0 \uc870\uc778<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec \uc0e4\ub4dc\uc5d0 \ubd84\uc0b0\ub41c \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\uba74 \ub124\ud2b8\uc6cc\ud06c \ud1b5\uc2e0\uacfc \ub370\uc774\ud130 \uc774\ub3d9\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4. \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc5ec\ub7ec \ub178\ub4dc\uc5d0\uc11c \uc218\uc9d1\ud574\uc57c \ud55c\ub2e4\uba74 \ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc870\uc778\ubcf4\ub2e4 \ube44\uc6a9\uc774 \ucee4\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub97c \uc904\uc774\uae30 \uc704\ud574 \ud568\uaed8 \uc870\ud68c\ub418\ub294 \ub370\uc774\ud130\ub97c \uac19\uc740 \uc0e4\ub4dc\uc5d0 \ubc30\uce58\ud558\uac70\ub098, \uc77d\uae30 \uc804\uc6a9 \uc9d1\uacc4 \ud14c\uc774\ube14\uacfc \ubcc4\ub3c4\uc758 \ubd84\uc11d \uc2dc\uc2a4\ud15c\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc7a5\uc560 \ucc98\ub9ac<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud55c \ub178\ub4dc\uac00 \uc911\ub2e8\ub418\ub354\ub77c\ub3c4 \uc11c\ube44\uc2a4\uac00 \uc9c0\uc18d\ub420 \uc218 \uc788\ub3c4\ub85d \ubcf5\uc81c, \uc7a5\uc560 \uac10\uc9c0, \ub9ac\ub354 \uc120\ucd9c, \ubcf5\uad6c \uc808\ucc28\ub97c \uc124\uacc4\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uadf8\ub7ec\ub098 \ubcf5\uc81c\ubcf8\uc774 \uc874\uc7ac\ud55c\ub2e4\uace0 \ud574\uc11c \ubaa8\ub4e0 \uc7a5\uc560\uc5d0\uc11c \ub370\uc774\ud130 \uc190\uc2e4\uc774 \ubc29\uc9c0\ub418\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \ubcf5\uc81c \uc9c0\uc5f0, \ub3d9\uae30\uc2dd\u00b7\ube44\ub3d9\uae30\uc2dd \ubcf5\uc81c \ubc29\uc2dd, \uc7a5\uc560 \uc870\uce58 \uc2dc\uc810\uc5d0 \ub530\ub77c \uacb0\uacfc\uac00 \ub2ec\ub77c\uc9c8 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uc77c\uad00\uc131\uacfc \uac00\uc6a9\uc131<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubd84\uc0b0 \ud658\uacbd\uc5d0\uc11c\ub294 \ub178\ub4dc \uac04 \ud1b5\uc2e0\uc774 \uc9c0\uc5f0\ub418\uac70\ub098 \ub04a\uae38 \uc218 \uc788\ub2e4. \uc774\ub54c \uc2dc\uc2a4\ud15c\uc774 \ucd5c\uc2e0 \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uc744 \uc6b0\uc120\ud560\uc9c0, \uc77c\ubd80 \uc694\uccad\uc744 \uacc4\uc18d \ucc98\ub9ac\ud558\ub294 \uac00\uc6a9\uc131\uc744 \uc6b0\uc120\ud560\uc9c0 \uc815\ucc45\uc744 \uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 \uc694\uccad\uc5d0\uc11c \ud56d\uc0c1 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \ubcf4\uc7a5\ud558\uba74\uc11c \ub124\ud2b8\uc6cc\ud06c \ubd84\ud560 \uc0c1\ud669\uc5d0\uc11c\ub3c4 \ubaa8\ub4e0 \ub178\ub4dc\uac00 \uacc4\uc18d \uc815\uc0c1 \ucc98\ub9ac\ud558\ub3c4\ub85d \ub9cc\ub4dc\ub294 \uac83\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \ubd88\uac00\ub2a5\ud558\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130 \uc885\ub958\ubcc4\ub85c \ud544\uc694\ud55c \uc77c\uad00\uc131 \uc218\uc900\uc744 \uc815\uc758\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \ubd84\uc0b0 \uc124\uacc4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uac8c\uc784 \uc11c\ubc84\ub294 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130, \uc778\ubca4\ud1a0\ub9ac, \uac8c\uc784 \uae30\ub85d, \ub9e4\uce58 \uc815\ubcf4, \ub7ad\ud0b9 \ub4f1 \uc11c\ub85c \ub2e4\ub978 \ud2b9\uc131\uc744 \uac00\uc9c4 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud55c\ub2e4. \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ub3d9\uc77c\ud55c \uc0e4\ub4dc \ud0a4\ub85c \ubd84\uc0b0\ud558\ub294 \uac83\uc774 \ud56d\uc0c1 \ucd5c\uc120\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uacc4\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>\ub370\uc774\ud130<\/th><th>\uace0\ub824\ud560 \ubd84\uc0b0 \uae30\uc900<\/th><th>\uc124\uacc4\uc0c1 \uc8fc\uc758\uc810<\/th><\/tr><tr><td>\uc0ac\uc6a9\uc790 \uc815\ubcf4<\/td><td><code>user_id<\/code><\/td><td>\uc0ac\uc6a9\uc790\ubcc4 \uc811\uadfc \uc9d1\uc911\ub3c4<\/td><\/tr><tr><td>\uc778\ubca4\ud1a0\ub9ac<\/td><td><code>user_id<\/code><\/td><td>\uc7ac\ud654 \ubc0f \uc544\uc774\ud15c \uc815\ud569\uc131<\/td><\/tr><tr><td>\uac8c\uc784 \ub85c\uadf8<\/td><td><code>created_at<\/code> \ub610\ub294 \uc0ac\uc6a9\uc790 ID<\/td><td>\uae30\uac04\ubcc4 \uc870\ud68c\uc640 \ub370\uc774\ud130 \uc99d\uac00<\/td><\/tr><tr><td>\uae38\ub4dc \uc815\ubcf4<\/td><td><code>guild_id<\/code><\/td><td>\uae38\ub4dc \ub2e8\uc704 \uc694\uccad \uc9d1\uc911<\/td><\/tr><tr><td>\ub9e4\uce58 \uae30\ub85d<\/td><td><code>match_id<\/code> \ub610\ub294 \uc0ac\uc6a9\uc790 ID<\/td><td>\ub9e4\uce58 \uc870\ud68c\uc640 \uc0ac\uc6a9\uc790\ubcc4 \uc870\ud68c\uc758 \uade0\ud615<\/td><\/tr><tr><td>\ub7ad\ud0b9<\/td><td>\ubcc4\ub3c4 \ub7ad\ud0b9 \uc800\uc7a5\uc18c \ub610\ub294 \ubd84\uc0b0 \uc9d1\uacc4<\/td><td>\uc804\uccb4 \uc815\ub82c\uacfc \uc0c1\uc704 \uc21c\uc704 \uc870\ud68c \ube44\uc6a9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ud45c\ub294 \uac00\ub2a5\ud55c \uc124\uacc4 \ubc29\ud5a5\uc744 \uc81c\uc2dc\ud55c \uac83\uc774\ub2e4. \uc2e4\uc81c \uc0e4\ub4dc \ud0a4\ub294 \ub370\uc774\ud130 \uc811\uadfc \ud328\ud134, \ud2b8\ub798\ud53d \uaddc\ubaa8, \uc815\ud569\uc131 \uc694\uad6c\uc0ac\ud56d\uc744 \uce21\uc815\ud55c \ub4a4 \uacb0\uc815\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b9\ud788 \uac8c\uc784 \uc7ac\ud654\uc640 \uc778\ubca4\ud1a0\ub9ac\ub294 \ub2e8\uc21c\ud55c \uc870\ud68c \uc131\ub2a5\ubcf4\ub2e4 \ub370\uc774\ud130 \uc815\ud569\uc131\uc774 \uc911\uc694\ud560 \uc218 \uc788\ub2e4. \uc5ec\ub7ec \uc0e4\ub4dc\uc5d0 \uac78\uce5c \uac70\ub798\uac00 \ube48\ubc88\ud558\ub2e4\uba74 \uc0e4\ub529\uc73c\ub85c \uc5bb\ub294 \uc131\ub2a5\uc0c1 \uc774\uc810\ubcf4\ub2e4 \ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158 \ube44\uc6a9\uc774 \ucee4\uc9c8 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\uba74 \ub85c\uadf8\ub098 \ubd84\uc11d \ub370\uc774\ud130\ucc98\ub7fc \uc2dc\uac04 \ubc94\uc704\ubcc4 \uc870\ud68c\uc640 \ub300\ub7c9 \uc800\uc7a5\uc774 \uc911\uc694\ud55c \ub370\uc774\ud130\ub294 \uc2dc\uac04 \uae30\ubc18 \ud30c\ud2f0\uc154\ub2dd \ub610\ub294 \ubcc4\ub3c4\uc758 \ubd84\uc11d \uc800\uc7a5\uc18c\uac00 \ub354 \uc801\ud569\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub530\ub77c\uc11c \ub370\uc774\ud130 \uc885\ub958\ubcc4\ub85c \ubd84\uc0b0 \uc804\ub7b5\uc744 \ub2e4\ub974\uac8c \uc801\uc6a9\ud558\ub294 \uac83\uc774 \ud569\ub9ac\uc801\uc774\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc5b8\uc81c \ub370\uc774\ud130 \ubd84\uc0b0\uc744 \ub3c4\uc785\ud574\uc57c \ud558\ub294\uac00?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \ubd84\uc0b0\uc740 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc94\uc6a9\uc801\uc778 \ucd5c\uc801\ud654 \uae30\ubc95\uc774 \uc544\ub2c8\ub2e4. \ubd84\uc0b0 \uad6c\uc870\ub294 \uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc9c0\ub9cc, \uadf8 \ub300\uac00\ub85c \uc6b4\uc601 \ubcf5\uc7a1\ub3c4\uc640 \uc7a5\uc560 \ub300\uc751 \ube44\uc6a9\uc774 \uc99d\uac00\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub3c4\uc785 \uc804\uc5d0\ub294 \ub2e4\uc74c \uc21c\uc11c\ub85c \uac80\ud1a0\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc778\ub371\uc2a4\uc640 \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \uc810\uac80\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ubd88\ud544\uc694\ud55c \ucffc\ub9ac, N+1 \uc870\ud68c, \uacfc\ub3c4\ud55c \ub370\uc774\ud130 \ubc18\ud658\uc744 \uc904\uc778\ub2e4.<\/li>\n\n\n\n<li>\ucee4\ub125\uc158 \ud480\uacfc \uc11c\ubc84 \uc790\uc6d0 \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud55c\ub2e4.<\/li>\n\n\n\n<li>\uc77d\uae30 \ubd80\ud558\uac00 \ubb38\uc81c\ub77c\uba74 \uc77d\uae30 \uc804\uc6a9 \ubcf5\uc81c\ubcf8\uc744 \uac80\ud1a0\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ud14c\uc774\ube14\uc774 \uc9c0\ub098\uce58\uac8c \ucee4\uc84c\ub2e4\uba74 \ud30c\ud2f0\uc154\ub2dd\uc744 \uac80\ud1a0\ud55c\ub2e4.<\/li>\n\n\n\n<li>\ub2e8\uc77c \uc11c\ubc84\uc758 \uc6a9\ub7c9\uacfc \ucc98\ub9ac \ub2a5\ub825\uc774 \ud55c\uacc4\uc5d0 \ub3c4\ub2ec\ud588\ub2e4\uba74 \uc0e4\ub529\uc744 \uac80\ud1a0\ud55c\ub2e4.<\/li>\n\n\n\n<li>\uc0e4\ub529\uc744 \ub3c4\uc785\ud55c\ub2e4\uba74 \uc0e4\ub4dc \ud0a4, \uc7ac\ubd84\ubc30, \uc7a5\uc560 \ubcf5\uad6c \uc804\ub7b5\uc744 \ud568\uaed8 \uc124\uacc4\ud55c\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc911\uc694\ud55c \uac83\uc740 \ud604\uc7ac \ubcd1\ubaa9\uc774 \uc5b4\ub514\uc5d0 \uc788\ub294\uc9c0 \ud655\uc778\ud558\ub294 \uac83\uc774\ub2e4. \ub2e8\uc77c \uc11c\ubc84\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \ub290\ub9b0 \ucffc\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uc9c0 \uc54a\uc740 \ucc44 \uc0e4\ub529\ubd80\ud130 \ub3c4\uc785\ud558\uba74 \ubcf5\uc7a1\ud55c \ubd84\uc0b0 \uad6c\uc870 \uc704\uc5d0\uc11c \ub3d9\uc77c\ud55c \ube44\ud6a8\uc728\uc744 \uc720\uc9c0\ud558\uac8c \ub420 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \ubd84\uc0b0\uc774 \ud544\uc694\ud55c \uc774\uc720 \uc11c\ube44\uc2a4\uc758 \ub370\uc774\ud130\uac00 \uc99d\uac00\ud558\uba74 \ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub9cc\uc73c\ub85c \ubaa8\ub4e0 \uc694\uccad\uc744 \ucc98\ub9ac\ud558\uae30 \uc5b4\ub824\uc6cc\uc9c4\ub2e4. \ub370\uc774\ud130\uac00 \ub9ce\uc544\uc9c8\uc218\ub85d \uc800\uc7a5 \uacf5\uac04\uc774 \ubd80\uc871\ud574\uc9c8 \uc218 \uc788\uace0, \ud2b9\uc815 \ud14c\uc774\ube14\uc5d0 \ucffc\ub9ac\uac00 \uc9d1\uc911\ub418\uba74 \uc77d\uae30\u00b7\uc4f0\uae30 \uc131\ub2a5\uc774 \uc800\ud558\ub41c\ub2e4. \ub610\ud55c \ub2e8\uc77c \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O\uc5d0\ub294 \ubb3c\ub9ac\uc801\uc778 \ud55c\uacc4\uac00 \uc874\uc7ac\ud55c\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95 \uc911 \ud558\ub098\uac00 \ub370\uc774\ud130 \ubd84\uc0b0(Data Distribution) \uc774\ub2e4. \ub370\uc774\ud130\ub97c \ub17c\ub9ac\uc801 \ub610\ub294 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc5ec\ub7ec \uc601\uc5ed\uc5d0 \ub098\ub204\uc5b4 [&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-2676","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\/2676","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=2676"}],"version-history":[{"count":2,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2676\/revisions"}],"predecessor-version":[{"id":2691,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2676\/revisions\/2691"}],"wp:attachment":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}