{"id":1401,"date":"2026-03-22T23:03:14","date_gmt":"2026-03-22T14:03:14","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1401"},"modified":"2026-03-22T23:24:24","modified_gmt":"2026-03-22T14:24:24","slug":"maxscale%ea%b8%b0%eb%b0%98%ec%9d%98-db-%ec%9d%b4%ec%a4%91%ed%99%94-%ec%9a%b4%ec%98%81","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1401","title":{"rendered":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\ubaa9 \ucc28<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#%EC%8B%9C%EC%9E%91%ED%95%98%EB%8A%94%EB%A7%90\" >\uc2dc\uc791\ud558\ub294\ub9d0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#%EA%B0%9C_%EC%9A%94\" >\uac1c \uc694<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#Maxscale_%EC%86%8C%EA%B0%9C\" >Maxscale \uc18c\uac1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#SW_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0\" >S\/W \uc124\uce58\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#%EB%AA%A8%EB%8B%88%ED%84%B0%EB%A7%81\" >\ubaa8\ub2c8\ud130\ub9c1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/www.igoni.kr\/?p=1401\/#%EC%9E%A5%EC%95%A0%EC%A1%B0%EC%B9%98\" >\uc7a5\uc560\uc870\uce58<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%8B%9C%EC%9E%91%ED%95%98%EB%8A%94%EB%A7%90\"><\/span>\uc2dc\uc791\ud558\ub294\ub9d0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4.\n\uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4.\nigoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694&#8230;(\uac10\uc0ac)(\uac10\uc0ac)\nOpensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse;width: 100%\" border=\"1\"><colgroup> <col style=\"width: 99.881%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1403\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"2304\" height=\"1728\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/03bcc72f-aae4-43c5-b58d-6290b3bf83a9.jpg\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" align=\"none\" \/><\/figure><\/td>\n<\/tr>\n<tr>\n<td class=\"align-right\">perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h3 id=\"bkmrk-%EA%B0%9C-%EC%9A%94\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EA%B0%9C_%EC%9A%94\"><\/span>\uac1c \uc694<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p id=\"bkmrk-%EA%B8%B0%EC%A1%B4-mysql-%2B-myql-mmm-\">\uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810<\/p>\n<ol id=\"bkmrk-%EB%B9%84%EB%8F%99%EA%B8%B0%EC%8B%9D-replication-%EA%B5%AC%EC%A1%B0%EC%97%90\">\n\n<li>\ube44\ub3d9\uae30\uc2dd replication \uad6c\uc870\uc5d0\uc11c read \/ write\uac00 \ub9ce\uc740 \uacbd\uc6b0 replication\uc774 \uae68\uc9c0\uac70\ub098 \uc9c0\uc5f0\ub418\ub294 \ud604\uc0c1\uc774 \ube48\ubc88\ud568<\/li>\n\n<li>mmm\uc758 \ubc84\uc804 \uc5c5\ub370\uc774\ud2b8\uac00 \uc5c6\uc74c ( latest\ubc84\uc804\uc778 2.2.1\uc740 2012\ub144 12\uc6d4\uc774 \ub9c8\uc9c0\ub9c9)<\/li>\n\n<li>mmm \ubc84\uadf8\ub85c \uc778\ud55c failover \/ failback \uc774\uc288\uac00 \ubc1c\uc0dd\uc774 \uc788\uc74c<\/li>\n<\/ol>\n<h3 id=\"bkmrk-maxscale-%EC%86%8C%EA%B0%9C\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"Maxscale_%EC%86%8C%EA%B0%9C\"><\/span>Maxscale \uc18c\uac1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_mmd_1405\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"231\" height=\"371\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/drawing-3-1677414924.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" align=\"none\" \/><\/figure>\n<ol id=\"bkmrk-mariadb%EC%97%90%EC%84%9C-%EC%A0%9C%EA%B3%B5%ED%95%98%EB%8A%94-db%ED%81%B4%EB%9F%AC%EC%8A%A4\">\n\n<li>Mariadb\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 DB\ud074\ub7ec\uc2a4\ud130 \uad6c\uc131<\/li>\n\n<li>glaera cluster\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130\uc774\uc911\ud654, maxscale\ub97c \uc774\uc6a9\ud55c db proxy \uad6c\uc870\ub85c \ub418\uc5b4 \uc788\uc74c<\/li>\n\n<li>\uae30\ubcf8\uc801\uc73c\ub85c BSD\ub77c\uc774\uc120\uc2a4\ub97c \uc801\uc6a9\ud558\uace0 \uc788\uace0, BSD\ub77c\uc774\uc120\uc2a4\uc758 \uacbd\uc6b0 S\/W \uac1c\ubc1c\uc0ac\uac00 \uc801\uc6a9\ud55c \ub0a0\uc9dc \uc774\ud6c4\uc5d0\ub294 GPL \ub77c\uc774\uc120\uc2a4\ub85c \ubcc0\uacbd\ub428\n<ol>\n\n<li>BSD \ub77c\uc774\uc120\uc2a4\ub97c \uc801\uc6a9\ubc1b\ub294 \uacbd\uc6b0 \uc5f0\ub3d9\ud560 \uc218 \uc788\ub294 \ub178\ub4dc\uc218\ub294 3\ub300 \ubbf8\ub9cc, \uc989 2\ub300\uae4c\uc9c0\ub9cc maxscale\uc5d0 \uc5f0\uacb0\ud560 \uc218 \uc788\uace0 \uadf8 \uc218\ub7c9\uc744 \ub118\ub294 \uacbd\uc6b0 \ub77c\uc774\uc120\uc2a4 \ube44\uc6a9 \ubc1c\uc0dd\uc774 \ud544\uc694\ud568<\/li>\n\n<li>GPL\uc758 \uacbd\uc6b0 \uc5f0\ub3d9 \ub178\ub4dc \uc218 \uc81c\ud55c\uc5c6\uc74c<\/li>\n\n<li>&#8217;22\ub144 2\uc6d4 \uae30\uc900\uc73c\ub85c \ud655\uc778\ub41c \uba54\uc774\uc800 \ubc84\uc804\ubcc4 BSD\ub77c\uc774\uc120\uc2a4 \uc720\ud6a8\uae30\uac04\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<ol>\n\n<li>2.0\u00a0\u2192\u00a02019-01-01 (BSD \ub77c\uc774\uc120\uc2a4 \ub9cc\ub8cc, \uc5f0\uacb0\ub178\ub4dc \uc218 \uc81c\ud55c\uc5c6\uc74c)<\/li>\n\n<li>2.1\u00a0\u2192\u00a02019-07-01 (BSD \ub77c\uc774\uc120\uc2a4 \ub9cc\ub8cc, \uc5f0\uacb0\ub178\ub4dc \uc218 \uc81c\ud55c\uc5c6\uc74c)<\/li>\n\n<li>2.2\u00a0\u2192\u00a02020-01-01 (BSD \ub77c\uc774\uc120\uc2a4 \ub9cc\ub8cc, \uc5f0\uacb0\ub178\ub4dc \uc218 \uc81c\ud55c\uc5c6\uc74c)<\/li>\n\n<li>2.3\u00a0\u2192\u00a02024-06-02<\/li>\n\n<li>2.4\u00a0\u2192\u00a02026-01-04<\/li>\n\n<li>2.5 \u2192 2027-10-10<\/li>\n\n<li>6.2 \u2192 2026-03-08<\/li>\n\n<li>6.3 &#8211; 2026-05-03<\/li>\n\n<li>6.4 &#8211; 2027-11-30<\/li>\n\n<li>23.0.8 &#8211; 2027-11-30<\/li>\n<\/ol>\n<\/li>\n\n<li>\ubcf4\ub2e4 \uc0c1\uc138\ud55c \ub0b4\uc6a9\uc740 https:\/\/github.com\/mariadb-corporation\/MaxScale \uc744 \ucc38\uace0\ud558\uba74 \ub429\ub2c8\ub2e4<\/li>\n<\/ol>\n<\/li>\n\n<li>\uadf8\uc678\uc5d0 \ubca4\ub354\uc0ac\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.\n<ol>\n\n<li>scale out environment\u00a0 &#8211; \ubcc4\ub3c4 DB \ub2e4\uc6b4\ud0c0\uc784\uc5c6\uc774 \uc2a4\ucf00\uc77c-\uc544\uc6c3\uc774 \uac00\ub2a5, read \/ write spilit\uc774 \uac00\ub2a5<\/li>\n\n<li>High availability &#8211; \uc7a5\uc560 \ubaa8\ub2c8\ud130\ub9c1\uc744 \uc704\ud574 read transction\uc744 \ub77c\uc6b0\ub529<\/li>\n\n<li>Secure database &#8211; app\uc774 DB\uc5d0 \uc811\uadfc\ud558\ub294\uac83\uc774 \uc544\ub2c8\ub77c maxsale\ub85c \uc811\uadfc\ud558\uae30 \ub54c\ubb38\uc5d0 \uc11c\ubc84 \uc811\uadfc \uc815\ubcf4 \ud655\ubcf4\uac00 \uac00\ub2a5, \ubc29\ud654\ubcbd \ud544\ud130 \uc0ac\uc6a9\uc2dc \ud074\ub7ec\uc2a4\ud130 \uc5f0\uacb0\uc744 \uc81c\uc548\ud574\uc11c DDos \uacf5\uaca9\uc73c\ub85c\ubd80\ud130 \uc11c\ubc84 \ubcf4\ud638\uac00 \uac00\ub2a5<\/li>\n<\/ol>\n<\/li>\n\n<li>MMM \/ Maxscale \ube44\uad50<\/li>\n<\/ol>\n<table id=\"bkmrk-%ED%95%AD-%EB%AA%A9-mysql-%2B-mysql-mm\" style=\"width: 100%;border-collapse: collapse;border-style: solid;border-width: 1px\" border=\"1\">\n<thead>\n<tr style=\"height: 10px\">\n<td class=\"align-center\" style=\"width: 18.9466%;height: 10px\"><strong>\ud56d \ubaa9<\/strong><\/td>\n<td class=\"align-center\" style=\"width: 38.489%;height: 10px\"><strong>Mysql + Mysql-MMM<\/strong><\/td>\n<td class=\"align-center\" style=\"width: 42.5405%;height: 10px\"><strong>Mariadb + Maxscale<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr style=\"height: 29.7969px\">\n<td style=\"width: 18.9466%;height: 29.7969px\">\uc11c\ubc84 \uc218\ub7c9<\/td>\n<td style=\"width: 38.489%;height: 29.7969px\">2(DB) + 1(monitor)<\/td>\n<td style=\"width: 42.5405%;height: 29.7969px\">3(DB) + 1(Maxscale)<\/td>\n<\/tr>\n<tr style=\"height: 29.7969px\">\n<td style=\"width: 18.9466%;height: 29.7969px\">DB\ubc84\uc804<\/td>\n<td style=\"width: 38.489%;height: 29.7969px\">Mysql<\/td>\n<td style=\"width: 42.5405%;height: 29.7969px\">Mariadb 10 \uc774\uc0c1<\/td>\n<\/tr>\n<tr style=\"height: 46.5938px\">\n<td style=\"width: 18.9466%;height: 46.5938px\">\ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd<\/td>\n<td style=\"width: 38.489%;height: 46.5938px\">replication<\/td>\n<td style=\"width: 42.5405%;height: 46.5938px\">galera cluster<\/td>\n<\/tr>\n<tr style=\"height: 29.7969px\">\n<td style=\"width: 18.9466%;height: 29.7969px\">\ubaa8\ub2c8\ud130\ub9c1 \ubc29\uc2dd<\/td>\n<td style=\"width: 38.489%;height: 29.7969px\">monitor\u00a0\u2192 agent\ub85c db\uc0c1\ud0dc \ud655\uc778<\/td>\n<td style=\"width: 42.5405%;height: 29.7969px\">maxscale\u00a0\u2192 DB \ubc29\ud5a5\uc73c\ub85c \uc0c1\ud0dc \ud655\uc778<\/td>\n<\/tr>\n<tr style=\"height: 103.625px\">\n<td style=\"width: 18.9466%;height: 103.625px\">failover\uc808\ucc28<\/td>\n<td style=\"width: 38.489%;height: 103.625px\">\n<div>\n<ol>\n\n<li>monitor\uc5d0\uc11c db health check<\/li>\n\n<li>Active DB \uc7a5\uc560\ud0d0\uc9c0<\/li>\n\n<li>Active DB\uc5d0 \uc801\uc6a9\ub41c VIP\ud68c\uc218<\/li>\n\n<li>Standby DB\uc5d0 VIP \ud560\ub2f9<\/li>\n<\/ol>\n<\/div><\/td>\n<td style=\"width: 42.5405%;height: 103.625px\">\n<div>\n<ol>\n\n<li>maxscale\uc5d0\uc11c \uac01 DB health check<\/li>\n\n<li>Active DB \uc7a5\uc560\ud0d0\uc9c0<\/li>\n\n<li>DB \uc811\uc18d \ucc28\ub2e8<\/li>\n<\/ol>\n<\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 id=\"bkmrk-s%2Fw-%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"SW_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0\"><\/span>S\/W \uc124\uce58\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%EC%8B%9C%EC%8A%A4%ED%85%9C-%EA%B5%AC%EC%84%B1%EB%8F%84%C2%A0-maxscale-%3A-\">\n\n<li>\uc2dc\uc2a4\ud15c \uad6c\uc131\ub3c4\n<ol>\n\n<li>maxscale : 192.168.0.101<\/li>\n\n<li>db1 : 192.168.0.102<\/li>\n\n<li>db2 : 192.168.0.103<\/li>\n<\/ol>\n<\/li>\n\n<li>Maxscale \uc124\uce58 \ud558\uae30\n<ol>\n\n<li>\ub9ac\ud3ec\uc9c0\ud130\ub9ac \uad6c\uc131\n<pre><code class=\"language-Python\">$&gt;&nbsp;&nbsp;vi&nbsp;\/etc\/yum.repos.d\/mariadb.repo\n[mariadb-main]\nname&nbsp;=&nbsp;MariaDB&nbsp;Server\nbaseurl&nbsp;=&nbsp;https:~\/~\/downloads.mariadb.com\/MariaDB\/mariadb-10.5\/yum\/rhel\/7\/x86_64\ngpgkey&nbsp;=&nbsp;file:~\/~\/\/etc\/pki\/rpm-gpg\/MariaDB-Server-GPG-KEY\ngpgcheck&nbsp;=&nbsp;1\nenabled&nbsp;=&nbsp;1\n[mariadb-maxscale]\n#&nbsp;To&nbsp;use&nbsp;the&nbsp;latest&nbsp;stable&nbsp;release&nbsp;of&nbsp;MaxScale,&nbsp;use&nbsp;&quot;latest&quot;&nbsp;as&nbsp;the&nbsp;version\n#&nbsp;To&nbsp;use&nbsp;the&nbsp;latest&nbsp;beta&nbsp;(or&nbsp;stable&nbsp;if&nbsp;no&nbsp;current&nbsp;beta)&nbsp;release&nbsp;of&nbsp;MaxScale,&nbsp;use&nbsp;&quot;beta&quot;&nbsp;as&nbsp;the&nbsp;version\nname&nbsp;=&nbsp;MariaDB&nbsp;MaxScale\nbaseurl&nbsp;=&nbsp;https:~\/~\/dlm.mariadb.com\/repo\/maxscale\/latest\/yum\/rhel\/7\/x86_64\ngpgkey&nbsp;=&nbsp;file:~\/~\/\/etc\/pki\/rpm-gpg\/MariaDB-MaxScale-GPG-KEY\ngpgcheck&nbsp;=&nbsp;1\nenabled&nbsp;=&nbsp;1\n[mariadb-tools]\nname&nbsp;=&nbsp;MariaDB&nbsp;Tools\nbaseurl&nbsp;=&nbsp;https:~\/~\/downloads.mariadb.com\/Tools\/rhel\/7\/x86_64\ngpgkey&nbsp;=&nbsp;file:~\/~\/\/etc\/pki\/rpm-gpg\/MariaDB-Enterprise-GPG-KEY\ngpgcheck&nbsp;=&nbsp;1\nenabled&nbsp;=&nbsp;1<\/code><\/pre>\n<\/li>\n<\/ol>\n<\/li>\n\n<li>\ud328\ud0a4\uc9c0 \uc124\uce58 \ud6c4 \uc124\uc815\ud558\uae30\n<pre><code class=\"language-Python\">$&gt;&nbsp;yum&nbsp;install&nbsp;maxscale&nbsp;-y\n...\n$&gt;&nbsp;vi&nbsp;\/etc\/maxscale.cnf\n#&nbsp;MaxScale&nbsp;documentation:\n#&nbsp;https:~\/~\/mariadb.com\/kb\/en\/mariadb-maxscale-25\/\n#&nbsp;Global&nbsp;parameters\n#\n#&nbsp;Complete&nbsp;list&nbsp;of&nbsp;configuration&nbsp;options:\n#&nbsp;https:~\/~\/mariadb.com\/kb\/en\/mariadb-maxscale-25-mariadb-maxscale-configuration-guide\/\n[maxscale]\nthreads=auto\n#&nbsp;Server&nbsp;definitions\n#\n#&nbsp;Set&nbsp;the&nbsp;address&nbsp;of&nbsp;the&nbsp;server&nbsp;to&nbsp;the&nbsp;network\n#&nbsp;address&nbsp;of&nbsp;a&nbsp;MariaDB&nbsp;server.\n#\n[server1]\ntype=server\naddress=192.168.0.102\nport=3306\nprotocol=MariaDBBackend\n[server2]\ntype=server\naddress=192.168.0.103\nport=3306\nprotocol=MariaDBBackend\n[server3]\ntype=server\naddress=192.168.0.101\nport=3306\nprotocol=MariaDBBackend\n#&nbsp;Monitor&nbsp;for&nbsp;the&nbsp;servers\n#\n#&nbsp;This&nbsp;will&nbsp;keep&nbsp;MaxScale&nbsp;aware&nbsp;of&nbsp;the&nbsp;state&nbsp;of&nbsp;the&nbsp;servers.\n#&nbsp;MariaDB&nbsp;Monitor&nbsp;documentation:\n#&nbsp;https:~\/~\/mariadb.com\/kb\/en\/maxscale-25-monitors\/\n[MariaDB-Monitor]\ntype=monitor\n#module=mariadbmon   #Replication\uc73c\ub85c \ub370\uc774\ud130 \ub3d9\uae30\ud654\uc2dc \uc120\ud0dd\nmodule=galeramon     #GaleraCluster\ub85c \ub370\uc774\ud130 \ub3d9\uae30\ud654\uc2dc \uc120\ud0dd\nservers=server1,server2,server3\nuser=maxscale&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#maxscale\uc774 db\uc811\uadfc\ud560\ub54c \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\uba85\npassword=maxscale&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#maxscale\uc774 db\uc811\uadfc\ud560\ub54c \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\ud328\uc2a4\uc6cc\ub4dc\nmonitor_interval=2000\n#&nbsp;Service&nbsp;definitions\n#\n#&nbsp;Service&nbsp;Definition&nbsp;for&nbsp;a&nbsp;read-only&nbsp;service&nbsp;and\n#&nbsp;a&nbsp;read\/write&nbsp;splitting&nbsp;service.\n#\n#&nbsp;ReadConnRoute&nbsp;documentation:\n#&nbsp;https:~\/~\/mariadb.com\/kb\/en\/mariadb-maxscale-25-readconnroute\/\n[Read-Only-Service]\ntype=service\nrouter=readconnroute\nservers=server1\nuser=myuser\npassword=mypwd\nrouter_options=slave\n#&nbsp;ReadWriteSplit&nbsp;documentation:\n#&nbsp;https:~\/~\/mariadb.com\/kb\/en\/mariadb-maxscale-25-readwritesplit\/\n[Read-Write-Service]\ntype=service\nrouter=readwritesplit\nservers=server1,server2&nbsp; &nbsp;#read \/ write \ubd84\uc0b0\ud560 \uc11c\ubc84 \uc815\ubcf4\nuser=maxscale&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#maxscale\uc774 db\uc811\uadfc\ud560\ub54c \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\uba85\npassword=maxscale&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#maxscale\uc774 db\uc811\uadfc\ud560\ub54c \uc0ac\uc6a9\ud558\ub294 \uacc4\uc815\ud328\uc2a4\uc6cc\ub4dc\n#&nbsp;Listener&nbsp;definitions&nbsp;for&nbsp;the&nbsp;services\n#\n#&nbsp;These&nbsp;listeners&nbsp;represent&nbsp;the&nbsp;ports&nbsp;the\n#&nbsp;services&nbsp;will&nbsp;listen&nbsp;on.\n#\n[Read-Only-Listener]\ntype=listener\nservice=Read-Only-Service\nprotocol=MariaDBClient\nport=4008\n[Read-Write-Listener]\ntype=listener\nservice=Read-Write-Service\nprotocol=MariaDBClient\nport=4006<\/code><\/pre>\n<\/li>\n\n<li>Mariadb \uad6c\uc131\ud558\uae30\n<div>\n<ol>\n\n<li>\u00a0\ud328\ud0a4\uc9c0 \ub0b4\ub824\ubc1b\uae30\n<pre><code class=\"language-shell\">$&gt;&nbsp;wget&nbsp;https:\/\/downloads.mariadb.org\/interstitial\/mariadb-10.5.11\/bintar-linux-x86_64\/mariadb-10.5.11-linux-x86_64.tar.gz -O&nbsp;mariadb-10.5.11-linux-x86_64.tar.gz<\/code><\/pre>\n\u00a0<\/li>\n\n<li>DB\uc124\uce58 \ud6c4 galera clutser \uad6c\uc131\n<pre><code class=\"language-Python\">$&gt;&nbsp;tar&nbsp;-zxvf&nbsp;mariadb-10.5.11-linux-x86_64.tar.gz&nbsp;-C&nbsp;\/usr\/local\/\n...\n$&gt;&nbsp;vi&nbsp;\/etc\/my.cnf\n[galera]\n#&nbsp;Mandatory&nbsp;settings\nwsrep_on=ON\nwsrep_provider=\/usr\/local\/mariadb\/lib\/galera-4\/libgalera_smm.so\nwsrep_cluster_address=gcomm:~\/~\/192.168.0.102,192.168.0.103,192.168.0.101\nbinlog_format=row\ndefault_storage_engine=InnoDB\ninnodb_autoinc_lock_mode=2\nwsrep_node_address=192.168.0.101\n#\n#&nbsp;Allow&nbsp;server&nbsp;to&nbsp;accept&nbsp;connections&nbsp;on&nbsp;all&nbsp;interfaces.\n#\nbind-address=0.0.0.0\n#\n#&nbsp;Optional&nbsp;setting\n#wsrep_slave_threads=1\n#innodb_flush_log_at_trx_commit=0<\/code><\/pre>\n<\/li>\n<\/ol>\n<\/div><\/li>\n\n<li>\uccab\ubc88\uc9f8 \ub178\ub4dc\uc5d0\uc11c galera cluster master \uc120\uc5b8 (mariadb \ud504\ub85c\uc138\uc2a4\ub3c4 \uc2e4\ud589\ud568)\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;galera_new_cluster<\/code><\/pre>\n<\/li>\n\n<li>\ub098\uba38\uc9c0 \ub178\ub4dc\uc5d0\uc11c mariadb \uc2e4\ud589\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;.\/mariadbd-safe<\/code><\/pre>\n<\/li>\n\n<li>DB\uad8c\ud55c \uc124\uc815\n<pre><code class=\"language-SQL\">MariaDB&nbsp;[(none)]&gt;&nbsp;grant&nbsp;select&nbsp;on&nbsp;mysql.*&nbsp;to&nbsp;maxscale@&#039;%&#039;&nbsp;identified&nbsp;by&nbsp;&#039;maxscale&#039;&nbsp;with&nbsp;grant&nbsp;option;<\/code><\/pre>\n<\/li>\n<\/ol>\n<h3 id=\"bkmrk-%EB%AA%A8%EB%8B%88%ED%84%B0%EB%A7%81\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EB%AA%A8%EB%8B%88%ED%84%B0%EB%A7%81\"><\/span>\ubaa8\ub2c8\ud130\ub9c1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-maxscale%EC%84%9C%EB%B9%84%EC%8A%A4-%EC%8B%A4%ED%96%89-%24%3E%C2%A0sy\">\n\n<li>maxscale\uc11c\ube44\uc2a4 \uc2e4\ud589\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;systemctl&nbsp;start&nbsp;maxscale<\/code><\/pre>\n<\/li>\n\n<li>maxscle\uc5d0 \ub4f1\ub85d\ub41c \uc11c\ubc84 \ud604\ud56d\ud655\uc778\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;maxctrl&nbsp;list&nbsp;servers\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502&nbsp;Server&nbsp;&nbsp;\u2502&nbsp;Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Port&nbsp;\u2502&nbsp;Connections&nbsp;\u2502&nbsp;State&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;GTID&nbsp;\u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502&nbsp;server1&nbsp;\u2502&nbsp;192.168.0.102&nbsp;\u2502&nbsp;3306&nbsp;\u2502&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Slave,&nbsp;Synced,&nbsp;Running&nbsp;&nbsp;\u2502&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502&nbsp;server2&nbsp;\u2502&nbsp;192.168.0.103&nbsp;\u2502&nbsp;3306&nbsp;\u2502&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Slave,&nbsp;Synced,&nbsp;Running&nbsp;&nbsp;\u2502&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502&nbsp;server3&nbsp;\u2502&nbsp;192.168.0.101&nbsp;\u2502&nbsp;3306&nbsp;\u2502&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Master,&nbsp;Synced,&nbsp;Running&nbsp;\u2502&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/code><\/pre>\n<\/li>\n\n<li>\uc11c\ube44\uc2a4 \uc0c1\ud0dc \ud655\uc778\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;maxctrl&nbsp;list&nbsp;services\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502&nbsp;Service&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Router&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;Connections&nbsp;\u2502&nbsp;Total&nbsp;Connections&nbsp;\u2502&nbsp;Servers&nbsp;\u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502&nbsp;Read-Write-Service&nbsp;\u2502&nbsp;readwritesplit&nbsp;\u2502&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;server1&nbsp;\u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502&nbsp;Read-Only-Service&nbsp;&nbsp;\u2502&nbsp;readconnroute&nbsp;&nbsp;\u2502&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2502&nbsp;server1&nbsp;\u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/code><\/pre>\n<\/li>\n<\/ol>\n<h3 id=\"bkmrk-%EC%9E%A5%EC%95%A0%EC%A1%B0%EC%B9%98\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%9E%A5%EC%95%A0%EC%A1%B0%EC%B9%98\"><\/span>\uc7a5\uc560\uc870\uce58<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%EC%A0%84%EC%B2%B4db%EC%84%9C%EB%B2%84-%EC%9E%A5%EC%95%A0%EC%8B%9C-%EC%A1%B0%EC%B9%98-%EA%B0%81-db%EC%84%9C%EB%B2%84\">\n\n<li>\uc804\uccb4DB\uc11c\ubc84 \uc7a5\uc560\uc2dc \uc870\uce58\n<ol>\n\n<li>\uac01 DB\uc11c\ubc84 \uc811\uc18d \ud6c4 \ub370\uc774\ud130 \uacbd\ub85c \uc9c4\uc785 \ud6c4 &#8220;grastate.dat \ud30c\uc77c \ud655\uc778\n<pre><code class=\"language-Python\">$&gt;&gt;&nbsp;&nbsp;cat&nbsp;grastate.dat\n#&nbsp;GALERA&nbsp;saved&nbsp;state\nversion:&nbsp;2.1\nuuid:&nbsp;&nbsp;&nbsp;&nbsp;7d985eca-de63-11eb-87c6-0ad28b9e1f30\nseqno:&nbsp;&nbsp;&nbsp;-1\nsafe_to_bootstrap:&nbsp;0<\/code><\/pre>\n<\/li>\n\n<li>safe_to_bootstrap\uc774 1\uc778 \uac12\uc744 \ucc3e\uc544\uc11c \ud574\ub2f9 \ub178\ub4dc\uc5d0\uc11c galera_new__cluster \uc7ac\uc2e4\ud589\nsafe_to_bootstrap\uc774 1\uc778 \uac12\uc774 \uc804\uccb4 down\uc804\uc5d0 master \uc5ed\ud65c\ud588\ub358 node<\/li>\n<\/ol>\n<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"<p>\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c&hellip;<\/p>","protected":false},"author":1,"featured_media":1403,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[401],"class_list":["post-1401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-maxscale"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"artop0420\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.igoni.kr\/?p=1401\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ko_KR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1401\" \/>\n\t\t<meta property=\"og:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-03-22T14:03:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-03-22T14:24:24+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#blogposting\",\"name\":\"maxscale\\uae30\\ubc18\\uc758 DB \\uc774\\uc911\\ud654 \\uc6b4\\uc601 - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"maxscale\\uae30\\ubc18\\uc758 DB \\uc774\\uc911\\ud654 \\uc6b4\\uc601\",\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/03bcc72f-aae4-43c5-b58d-6290b3bf83a9.jpg\",\"width\":2304,\"height\":1728},\"datePublished\":\"2026-03-22T23:03:14+09:00\",\"dateModified\":\"2026-03-22T23:24:24+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#webpage\"},\"articleSection\":\"Mysql&amp;MariaDB, maxscale\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.igoni.kr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"position\":2,\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"position\":3,\"name\":\"Mysql&amp;MariaDB\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#listItem\",\"name\":\"maxscale\\uae30\\ubc18\\uc758 DB \\uc774\\uc911\\ud654 \\uc6b4\\uc601\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#listItem\",\"position\":4,\"name\":\"maxscale\\uae30\\ubc18\\uc758 DB \\uc774\\uc911\\ud654 \\uc6b4\\uc601\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401\",\"name\":\"maxscale\\uae30\\ubc18\\uc758 DB \\uc774\\uc911\\ud654 \\uc6b4\\uc601 - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc2dc\\uc791\\ud558\\ub294\\ub9d0 \\uc548\\ub155\\ud558\\uc138\\uc694, \\uace0\\ub2c8 \\uc785\\ub2c8\\ub2e4. \\uae30\\uc874\\uc5d0 \\uc791\\uc131\\ud588\\ub358 \\ucee8\\ud150\\uce20\\ub4e4 \\uc5c5\\ub370\\uc774\\ud2b8\\ub97c \\ud558\\uba74\\uc11c \\ubb38\\uc11c\\uc758 \\ub9ac\\ud329\\ud1a0\\ub9c1(Refactoring)\\uc744 \\uc9c4\\ud589\\ud574\\ubcf4\\ub824\\uace0 \\ud569\\ub2c8\\ub2e4. \\uc774\\ubc88\\uc5d4 igoni.kr\\uc5d0\\uc11c \\uc81c\\uc77c \\ub9ce\\uc774 \\uac80\\uc0c9\\ud574\\uc11c \\uc720\\uc785\\ub418\\ub294 db proxy\\uc778 maxscale \\uc785\\ub2c8\\ub2e4. igoni.kr \\uc758 50%\\uac00 maxscale \\uc774\\uc600\\ub294\\ub370\\uc694...(\\uac10\\uc0ac)(\\uac10\\uc0ac) Opensource \\uae30\\ubc18\\uc758 DB Proxy\\uc5d0 \\uadf8\\ub9cc\\ud07c \\uae4a\\uc740 \\uad00\\uc2ec\\uc774 \\uc788\\uc73c\\uc2e0\\uac83 \\uac19\\ub124\\uc694. \\ub2e4\\ub4e4 \\ube44\\uc2b7\\ud55c \\ucc98\\uc9c0(?)\\uc778\\uac83 \\uac19\\uc2b5\\ub2c8\\ub2e4. perplexity\\uc5d0\\uc11c \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8\\uc9c0 \\uac1c \\uc694 \\uae30\\uc874 Mysql + myql-mmm \\uad6c\\uc870\\uae30\\ubc18\\uc5d0\\uc11c\\uc758 DB\\uc774\\uc911\\ud654 \\uad6c\\uc870\\uc5d0\\uc11c\\uc758 \\ubb38\\uc81c\\uc810\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/03bcc72f-aae4-43c5-b58d-6290b3bf83a9.jpg\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401\\\/#mainImage\",\"width\":2304,\"height\":1728},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1401#mainImage\"},\"datePublished\":\"2026-03-22T23:03:14+09:00\",\"dateModified\":\"2026-03-22T23:24:24+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/\",\"name\":\"\\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc798\\ub098\\uac00\\ub294 \\uc804\\uc0b0\\uc7c1\\uc774\\uc758 \\ube14\\ub85c\\uadf8\",\"inLanguage\":\"ko-KR\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774","description":"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810","canonical_url":"http:\/\/www.igoni.kr\/?p=1401","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1401#blogposting","name":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774","headline":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601","author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"publisher":{"@id":"http:\/\/www.igoni.kr\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/03bcc72f-aae4-43c5-b58d-6290b3bf83a9.jpg","width":2304,"height":1728},"datePublished":"2026-03-22T23:03:14+09:00","dateModified":"2026-03-22T23:24:24+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1401#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1401#webpage"},"articleSection":"Mysql&amp;MariaDB, maxscale"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1401#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","position":1,"name":"Home","item":"http:\/\/www.igoni.kr","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","position":2,"name":"4. DBMS \uc815\ubcf4 \uae30\ub85d","item":"http:\/\/www.igoni.kr\/?cat=379","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","position":3,"name":"Mysql&amp;MariaDB","item":"http:\/\/www.igoni.kr\/?cat=381","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1401#listItem","name":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1401#listItem","position":4,"name":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601","previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"}}]},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/#person","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1401#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/?author=1#author","url":"http:\/\/www.igoni.kr\/?author=1","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1401#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"WebPage","@id":"http:\/\/www.igoni.kr\/?p=1401#webpage","url":"http:\/\/www.igoni.kr\/?p=1401","name":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774","description":"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1401#breadcrumblist"},"author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"creator":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/03bcc72f-aae4-43c5-b58d-6290b3bf83a9.jpg","@id":"http:\/\/www.igoni.kr\/?p=1401\/#mainImage","width":2304,"height":1728},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1401#mainImage"},"datePublished":"2026-03-22T23:03:14+09:00","dateModified":"2026-03-22T23:24:24+09:00"},{"@type":"WebSite","@id":"http:\/\/www.igoni.kr\/#website","url":"http:\/\/www.igoni.kr\/","name":"\uc774\uace4\uc544\uc774","description":"\uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","inLanguage":"ko-KR","publisher":{"@id":"http:\/\/www.igoni.kr\/#person"}}]},"og:locale":"ko_KR","og:site_name":"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","og:type":"article","og:title":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774","og:description":"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810","og:url":"http:\/\/www.igoni.kr\/?p=1401","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-03-22T14:03:14+00:00","article:modified_time":"2026-03-22T14:24:24+00:00","twitter:card":"summary_large_image","twitter:title":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601 - \uc774\uace4\uc544\uc774","twitter:description":"\uc2dc\uc791\ud558\ub294\ub9d0 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ud588\ub358 \ucee8\ud150\uce20\ub4e4 \uc5c5\ub370\uc774\ud2b8\ub97c \ud558\uba74\uc11c \ubb38\uc11c\uc758 \ub9ac\ud329\ud1a0\ub9c1(Refactoring)\uc744 \uc9c4\ud589\ud574\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ubc88\uc5d4 igoni.kr\uc5d0\uc11c \uc81c\uc77c \ub9ce\uc774 \uac80\uc0c9\ud574\uc11c \uc720\uc785\ub418\ub294 db proxy\uc778 maxscale \uc785\ub2c8\ub2e4. igoni.kr \uc758 50%\uac00 maxscale \uc774\uc600\ub294\ub370\uc694...(\uac10\uc0ac)(\uac10\uc0ac) Opensource \uae30\ubc18\uc758 DB Proxy\uc5d0 \uadf8\ub9cc\ud07c \uae4a\uc740 \uad00\uc2ec\uc774 \uc788\uc73c\uc2e0\uac83 \uac19\ub124\uc694. \ub2e4\ub4e4 \ube44\uc2b7\ud55c \ucc98\uc9c0(?)\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uac1c \uc694 \uae30\uc874 Mysql + myql-mmm \uad6c\uc870\uae30\ubc18\uc5d0\uc11c\uc758 DB\uc774\uc911\ud654 \uad6c\uc870\uc5d0\uc11c\uc758 \ubb38\uc81c\uc810","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1401","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-03-22 14:03:14","updated":"2026-08-07 15:16:39","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=379\" title=\"4. DBMS \uc815\ubcf4 \uae30\ub85d\">4. DBMS \uc815\ubcf4 \uae30\ub85d<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=381\" title=\"Mysql&amp;MariaDB\">Mysql&amp;MariaDB<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tmaxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.igoni.kr"},{"label":"4. DBMS \uc815\ubcf4 \uae30\ub85d","link":"http:\/\/www.igoni.kr\/?cat=379"},{"label":"Mysql&amp;MariaDB","link":"http:\/\/www.igoni.kr\/?cat=381"},{"label":"maxscale\uae30\ubc18\uc758 DB \uc774\uc911\ud654 \uc6b4\uc601","link":"http:\/\/www.igoni.kr\/?p=1401"}],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1401"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions"}],"predecessor-version":[{"id":1407,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions\/1407"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1403"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}