{"id":1369,"date":"2026-03-22T22:26:48","date_gmt":"2026-03-22T13:26:48","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1369"},"modified":"2026-03-22T22:26:48","modified_gmt":"2026-03-22T13:26:48","slug":"centos7-galera-cluster%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1369","title":{"rendered":"centos7 galera cluster\uc124\uce58"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 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=1369\/#%EC%8B%9C%EC%8A%A4%ED%85%9C_%EC%86%8C%EA%B0%9C\" >\uc2dc\uc2a4\ud15c \uc18c\uac1c<\/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=1369\/#Galera_%EC%9A%A9%EC%96%B4_%EC%84%A4%EB%AA%85\" >Galera \uc6a9\uc5b4 \uc124\uba85<\/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=1369\/#%EC%8B%9C%EC%8A%A4%ED%85%9C_%EA%B5%AC%EC%B6%95%ED%95%98%EA%B8%B0\" >\uc2dc\uc2a4\ud15c \uad6c\ucd95\ud558\uae30<\/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=1369\/#Maxscale%EC%97%90%EC%84%9C_%EC%84%9C%EB%B2%84%EA%B4%80%EB%A6%AC\" >Maxscale\uc5d0\uc11c \uc11c\ubc84\uad00\ub9ac<\/a><\/li><\/ul><\/nav><\/div>\n<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uae30\uc874\ubb38\uc800 Refactoring\uc744 \uc9c4\ud589\ud558\uace0 \uc788\uc5b4\uc694<\/p>\n<p id=\"bkmrk-dbms%EA%B5%90%EC%B2%B4%28mysql%C2%A0%E2%86%92-maria\">DBMS\uad50\uccb4(Mysql \u2192 Mariadb)\ub97c \ucd94\uc9c4\ud558\uba74\uc11c \uc774\uc911\ud654 \uad6c\uc131\uc744 replication \uc5d0\uc11c galera_cluster\ub85c \uc804\ud658\ud558\uae30 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.881%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1371\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg\" alt=\"\" width=\"2304\" height=\"1728\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg 2304w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-300x225.jpg 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-1024x768.jpg 1024w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-768x576.jpg 768w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-1536x1152.jpg 1536w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-2048x1536.jpg 2048w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137-1300x975.jpg 1300w\" sizes=\"auto, (max-width: 2304px) 100vw, 2304px\" \/><\/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<h3 id=\"bkmrk-%EC%8B%9C%EC%8A%A4%ED%85%9C-%EC%86%8C%EA%B0%9C\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%8B%9C%EC%8A%A4%ED%85%9C_%EC%86%8C%EA%B0%9C\"><\/span>\uc2dc\uc2a4\ud15c \uc18c\uac1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-replication-%EA%B8%B0%EB%B0%98%EC%9D%98-%EB%8D%B0%EC%9D%B4%ED%84%B0-\">\n<li>Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd\n<ul>\n<li>WEB\/WAS \u2192\u00a0\u00a0DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ &#8230;)<\/li>\n<li>DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5.<\/li>\n<li>DB#2 \uc11c\ubc84\ub294 IO Thread\uac00 master\uc11c\ubc84\ub85c \uc811\uc18d\ud574\uc11c \ubcc0\uacbd\ub0b4\uc6a9 \ud655\uc778 \ud6c4 \ubcc0\uacbd\uc0ac\ud56d\uc774 \uc788\uc73c\uba74 replication \ub85c\uadf8\uc5d0 \uc800\uc7a5<br \/>\n1*.DB#2 \uc11c\ubc84\ub294 SQL Thread\uac00 replication \ub85c\uadf8\ub97c \uc77d\uc5b4\uc11c \ubcc0\uacbd\uc0ac\ud56d \uc800\uc7a5<\/li>\n<\/ul>\n<\/li>\n<li>Galera Cluster\uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654\n<ul>\n<li>wsrep api\ub97c \ud1b5\ud574 DB#1, DB#2 \uc811\uc18d \ubc0f \ub370\uc774\ud130 \ubcf5\uc81c\ud558\uae30 \uc704\ud55c \uc778\ud130\ud398\uc774\uc2a4 \uc0dd\uc131<\/li>\n<li>WEB\/WAS \u2192\u00a0\u00a0DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ &#8230;)<\/li>\n<li>DB#1\uc740 DB#2\uc5d0\ub3c4 DDL\uc801\uc6a9\ud558\ub77c\ub294 \uc694\uccad \ud6c4 \ubaa8\ub4e0 \ub178\ub4dc\uac00 \uc815\uc0c1\uc751\ub2f5\ud558\uba74\u00a0DDL \uc800\uc7a5<\/li>\n<\/ul>\n<\/li>\n<li>\uac01 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd \ube44\uad50<\/li>\n<\/ol>\n<table id=\"bkmrk-replication-galera-%EB%8F%99\" style=\"width: 100%; height: 271.614px;\">\n<tbody>\n<tr style=\"height: 35.4688px;\">\n<th style=\"width: 8.39549%; height: 35.4688px;\" scope=\"col\">&nbsp;<\/th>\n<th style=\"width: 45.484%; height: 35.4688px;\" colspan=\"1\" scope=\"col\"><strong>replication<\/strong><\/th>\n<th style=\"width: 45.9833%; height: 35.4688px;\" scope=\"col\"><strong>galera<\/strong><\/th>\n<\/tr>\n<tr style=\"height: 57.8472px;\">\n<td style=\"width: 8.39549%; height: 57.8472px;\">\ub3d9\uae30\ud654 \ubc29\uc2dd<\/td>\n<td style=\"width: 45.484%; height: 57.8472px;\" colspan=\"1\">\ube44\ub3d9\uae30<\/td>\n<td style=\"width: 45.9833%; height: 57.8472px;\">\ub3d9\uae30\uc2dd<\/td>\n<\/tr>\n<tr style=\"height: 120.451px;\">\n<td style=\"width: 8.39549%; height: 120.451px;\" colspan=\"1\">\ub2e8 \uc810<\/td>\n<td style=\"width: 45.484%; height: 120.451px;\" colspan=\"1\">\n<div>\n<ul>\n<li>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc740 1\uac1c\uc758 Thread\ub9cc \uc218\ud589<\/li>\n<li>\ub370\uc774\ud130 \ubd88\uc77c\uce58\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 \uc774\uc911\ud654 \uad6c\uc131\uc774 \ud480\ub9b4 \uc218 \uc788\uc74c<\/li>\n<li>master binlog\uac00 expire\ub41c \uacbd\uc6b0, \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubd88\uac00\ub2a5<\/li>\n<\/ul>\n<\/div>\n<\/td>\n<td style=\"width: 45.9833%; height: 120.451px;\" colspan=\"1\">\n<div>\n<ul>\n<li>innodb\ub9cc \uc9c0\uc6d0<\/li>\n<li>\ud14c\uc774\ube14\ubcc4\ub85c PK\uac00 \uc874\uc7ac\ud574\uc57c \ud568. \uc5c6\ub294 \uacbd\uc6b0 \ub370\uc774\ud130 \uc21c\uc11c\uc758 \ucc28\uc774\uac00 \uc788\uc744\uc218 \uc788\uc74c<\/li>\n<\/ul>\n<\/div>\n<\/td>\n<\/tr>\n<tr style=\"height: 57.8472px;\">\n<td style=\"width: 8.39549%; height: 57.8472px;\" colspan=\"1\">\uc6b4\uc601\ub178\ub4dc<\/td>\n<td style=\"width: 45.484%; height: 57.8472px;\" colspan=\"1\">2\ub300(Active\u00a0 \/ Standby \uad8c\uc7a5)<\/td>\n<td style=\"width: 45.9833%; height: 57.8472px;\" colspan=\"1\">3\ub300\uc774\uc0c1 \ud640\uc218 \uc218\ub7c9\uc73c\ub85c \uc0ac\uc6a9 \uad8c\uc7a5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol id=\"bkmrk-%EC%84%9C%EB%B9%84%EC%8A%A4%EC%9A%A9-%ED%86%B5%EC%8B%A0%ED%8F%AC%ED%8A%B8-%ED%8F%AC%ED%8A%B8%EC%A0%95%EB%B3%B4-%EC%82%AC%EC%9A%A9%EC%9A%A9%EB%8F%84-\">\n<li>\uc11c\ube44\uc2a4\uc6a9 \ud1b5\uc2e0\ud3ec\ud2b8\n<div>\n<table>\n<tbody>\n<tr>\n<th scope=\"col\"><strong>\ud3ec\ud2b8\uc815\ubcf4<\/strong><\/th>\n<th scope=\"col\"><strong>\uc0ac\uc6a9\uc6a9\ub3c4<\/strong><\/th>\n<th scope=\"col\"><strong>\ud1b5\uc2e0\ubc29\ud5a5<\/strong><\/th>\n<\/tr>\n<tr>\n<td>tcp\/3306<\/td>\n<td>DB\ub370\uc774\ud130 \ud1b5\uc2e0\ud3ec\ud2b8<\/td>\n<td>WEB\/WEB\u00a0\u2192 DBMS<\/td>\n<\/tr>\n<tr>\n<td>tcp\/4567, udp\/4567<\/td>\n<td>DB\ub178\ub4dc\ubcc4 \uc5f0\ub3d9\uc0c1\ud0dc \ud655\uc778, \uba40\ud2f0\uce90\uc2a4\ud2b8\ub85c \ubcf5\uc81c\uc2dc \ud574\ub2f9 \ud3ec\ud2b8 \uc0ac\uc6a9(tcp\/upd)<\/td>\n<td>DB1\u00a0\u2194 DB2<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\">tcp\/4568<\/td>\n<td colspan=\"1\">Galera \uc99d\ubd84 \ub370\uc774\ud130 \uc804\uc1a1<\/td>\n<td colspan=\"1\">DB1\u00a0\u2194 DB2<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\">tcp\/4444<\/td>\n<td colspan=\"1\">Galera \uc804\uccb4 \ub370\uc774\ud130 \uc804\uc1a1<\/td>\n<td colspan=\"1\">DB1\u00a0\u2194 DB2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/li>\n<\/ol>\n<h3 id=\"bkmrk-galera-%EC%9A%A9%EC%96%B4-%EC%84%A4%EB%AA%85\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"Galera_%EC%9A%A9%EC%96%B4_%EC%84%A4%EB%AA%85\"><\/span>Galera \uc6a9\uc5b4 \uc124\uba85<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%8F%99%EA%B8%B0%ED%99%94-%EB%B0%A9%EC%8B%9D-wsrep%3B-wr\">\n<li>\ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd\n<ul>\n<li>WSREP; Write Set REPlication &#8211; Innodb \uc5d4\uc9c4\ub0b4\ubd80\uc5d0\uc11c Write Set(\ud2b8\ub79c\uc7ad\uc158\uc744 \uae30\ub85d\ud558\ub294 \ub370\uc774\ud130 \uadf8\ub8f9)<br \/>\n1*.SST; State Snapshot Transfer &#8211; \uc804\uccb4 \ub370\uc774\ud130 \uc804\uc1a1 (\ucc98\uc74c \ud074\ub7ec\uc2a4\ud130 \uad6c\uc131\ud560 \ub54c \uc0ac\uc6a9)<\/li>\n<li>IST; Incremental State Transfer &#8211; \ubcc0\uacbd\ub41c \ub370\uc774\ud130 \uc804\uc1a1 (\ud3c9\uc0c1\uc2dc \uc6b4\uc601\uc911\uc77c \ub54c \uc0ac\uc6a9)<\/li>\n<\/ul>\n<\/li>\n<li>\ud074\ub7ec\uc2a4\ud130 \ub9f4\ubc84\n<ul>\n<li>Donor : \uc804\uccb4 \ub370\uc774\ud130\ub97c \uac00\uc9c4 DB<\/li>\n<li>Joiner : Donor\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ubc1b\ub294 \ub178\ub4dc<\/li>\n<\/ul>\n<\/li>\n<li>\ub370\uc774\ud130 \ub3d9\uae30\ud654 \uc5d4\uc9c4\n<ul>\n<li>rsync : rsync\uae30\ubc18\uc73c\ub85c \ud30c\uc77c\uc804\uc1a1, \ub370\uc774\ud130 \ub3d9\uae30\ud654 \uc18d\ub3c4\ub294 \ube60\ub974\ub098 \ub370\uc774\ud130 \ub3d9\uae30\ud654\ub97c \uc704\ud574\u00a0 \u00a0Donor \uc11c\ubc84\uc5d0 \ub370\uc774\ud130 Lock\uc744 \uc218\ud589\ud568<\/li>\n<li>mariabackup ( \ud574\ub2f9\ubc29\uc2dd \uad8c\uc7a5) : mariabackup \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud574 SST \uc218\ud589, \ubc31\uc5c5 \uc2a4\ud2b8\ub9ac\ubc0d\uc744 \uc704\ud574 socat \ud328\ud0a4\uc9c0\uac00 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud568 Donor Lock\ub97c \ucd5c\uc18c\ud654 \ud55c \ubc29\uc2dd,<\/li>\n<li>xtrabackup (Mariadb 10.3\uc774\ud6c4\ub85c \uc81c\uacf5\uc554\ud568, mariabackup \uc0ac\uc6a9 \uad8c\uc7a5)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3 id=\"bkmrk-%EC%8B%9C%EC%8A%A4%ED%85%9C-%EA%B5%AC%EC%B6%95%ED%95%98%EA%B8%B0\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%8B%9C%EC%8A%A4%ED%85%9C_%EA%B5%AC%EC%B6%95%ED%95%98%EA%B8%B0\"><\/span>\uc2dc\uc2a4\ud15c \uad6c\ucd95\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%EC%84%A4%EC%B9%98%ED%99%98%EA%B2%BD-os-%3A-centos-7.5\">\n<li>\uc124\uce58\ud658\uacbd\n<ul>\n<li>OS : Centos 7.5<\/li>\n<li>DBMS : Mariadb 10.4.7<\/li>\n<li>Galera : 4.26-4.2.1<\/li>\n<\/ul>\n<\/li>\n<li>\uc791\uc5c5\uc21c\uc11c<\/li>\n<li>galera rpm \uc124\uce58(\uc774\uc288\uc0ac\ud56d : Mariadb\uc5d0 \ud3ec\ud568\ub41c galera \ud50c\ub7ec\uadf8\uc778 \uc0ac\uc6a9\uc2dc OPENSSL1.0.0\uc774 \uc5c6\ub2e4\ub294 \uc5d0\ub7ec\uba54\uc2dc\uc9c0 \ubc1c\uc0dd\n<pre><code class=\"language-Python\">#&gt;\u00a0yum\u00a0install\u00a0libaio\u00a0socat Judy\u00a0 .\/galera-4-26.4.2 1.rhel7.el7.centos.x86_64<\/code><\/pre>\n<\/li>\n<li>\/etc\/my.cnf\uc5d0 \uc544\ub798\ub0b4\uc6a9 \uc801\uc6a9\n<pre><code class=\"language-Python\">[client]\r\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a03306\r\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a0\/tmp\/mysql.sock\r\n\r\n[mysqld]\r\nuser\u00a0=\u00a0mysql\r\nport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a03306\r\nsocket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a0\/tmp\/mysql.sock\r\nskip-external-locking\r\nkey_buffer_size\u00a0=\u00a0384M\r\nmax_allowed_packet\u00a0=\u00a01M\r\ntable_open_cache\u00a0=\u00a0512\r\nsort_buffer_size\u00a0=\u00a02M\r\nread_buffer_size\u00a0=\u00a02M\r\nread_rnd_buffer_size\u00a0=\u00a08M\r\nmyisam_sort_buffer_size\u00a0=\u00a064M\r\nthread_cache_size\u00a0=\u00a08\r\nquery_cache_size\u00a0=\u00a032M\r\n#thread_concurrency\u00a0=\u00a08\r\nexpire_logs_days\u00a0=\u00a030\r\nwait_timeout\u00a0=\u00a060\r\n#skip-name-resolve\r\nbasedir=\/usr\/local\/mysql\r\ndatadir=\/data\/db_data\r\n\r\nmax_heap_table_size\u00a0=\u00a0190M\r\nmax_allowed_packet\u00a0=\u00a0\u00a016M\r\ntmp_table_size\u00a0=\u00a064M\r\njoin_buffer_size\u00a0=\u00a064M\r\ninnodb_buffer_pool_size\u00a0=\u00a0950M\r\n#innodb_doublewrite\u00a0=\u00a00\r\ninnodb_flush_log_at_timeout\u00a0=\u00a03\r\n#innodb_read_io_threads\u00a0=\u00a032\r\n#innodb_write_io_threads\u00a0=\u00a016\r\n#character_set_client\u00a0=\u00a0utf8mb4\r\n\r\n#log-bin=mysql-bin\r\n\r\nserver-id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=\u00a02\r\n\r\n\r\n[galera]\r\nwsrep_on=ON\r\n#wsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\nwsrep_provider=\/usr\/lib64\/galera-4\/libgalera_smm.so\r\nwsrep_cluster_address=\"gcomm:\/\/172.21.113.109,172.21.113.69\"\u00a0#\ud074\ub7ec\uc2a4\ud130\u00a0\uad6c\uc131\ud560\u00a0IP\r\nbinlog_format=row\r\ndefault_storage_engine=InnoDB\r\ninnodb_autoinc_lock_mode=2\r\nwsrep_cluster_name=cluster\r\nwsrep_node_address=\"172.21.113.109\"\u00a0\u00a0#\uc790\uae30\u00a0IP\uac00\u00a0\uc791\uc131\ub418\uc5b4\u00a0\uc788\uc73c\uba74\u00a0\ub428\r\nbind-address=0.0.0.0\r\nwsrep_sst_method=mariabackup\r\nwsrep_sst_auth=\"root:root\"\r\nwsrep_provider_options=\"pc.bootstrap=YES\"<\/code><\/pre>\n<p>&nbsp;<\/p>\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n<li class=\"null\">mysql_install_db \uc2e4\ud589\n<pre><code class=\"language-Python\">#&gt;\u00a0\/usr\/local\/mysql\/scripts\/mysql_install_db\r\nInstalling\u00a0MariaDB\/MySQL\u00a0system\u00a0tables\u00a0in\u00a0'\/data\/db_data'\u00a0...\r\nwsrep\u00a0loader:\u00a0[INFO]\u00a0wsrep_load():\u00a0loading\u00a0provider\u00a0library\u00a0'none'\r\nOK\r\n\r\nTo\u00a0start\u00a0mysqld\u00a0at\u00a0boot\u00a0time\u00a0you\u00a0have\u00a0to\u00a0copy\r\nsupport-files\/mysql.server\u00a0to\u00a0the\u00a0right\u00a0place\u00a0for\u00a0your\u00a0system\r\n\r\n\r\nTwo\u00a0all-privilege\u00a0accounts\u00a0were\u00a0created.\r\nOne\u00a0is\u00a0root@localhost,\u00a0it\u00a0has\u00a0no\u00a0password,\u00a0but\u00a0you\u00a0need\u00a0to\r\nbe\u00a0system\u00a0'root'\u00a0user\u00a0to\u00a0connect.\u00a0Use,\u00a0for\u00a0example,\u00a0sudo\u00a0mysql\r\nThe\u00a0second\u00a0is\u00a0mysql@localhost,\u00a0it\u00a0has\u00a0no\u00a0password\u00a0either,\u00a0but\r\nyou\u00a0need\u00a0to\u00a0be\u00a0the\u00a0system\u00a0'mysql'\u00a0user\u00a0to\u00a0connect.\r\nAfter\u00a0connecting\u00a0you\u00a0can\u00a0set\u00a0the\u00a0password,\u00a0if\u00a0you\u00a0would\u00a0need\u00a0to\u00a0be\r\nable\u00a0to\u00a0connect\u00a0as\u00a0any\u00a0of\u00a0these\u00a0users\u00a0with\u00a0a\u00a0password\u00a0and\u00a0without\u00a0sudo\r\n\r\nSee\u00a0the\u00a0MariaDB\u00a0Knowledgebase\u00a0at\u00a0http:\/\/mariadb.com\/kb\u00a0or\u00a0the\r\nMySQL\u00a0manual\u00a0for\u00a0more\u00a0instructions.\r\n\r\nYou\u00a0can\u00a0start\u00a0the\u00a0MariaDB\u00a0daemon\u00a0with:\r\ncd\u00a0'\/usr\/local\/mysql'\u00a0;\u00a0\/usr\/local\/mysql\/bin\/mysqld_safe\u00a0--datadir='\/data\/db_data'\r\n\r\nYou\u00a0can\u00a0test\u00a0the\u00a0MariaDB\u00a0daemon\u00a0with\u00a0mysql-test-run.pl\r\ncd\u00a0'\/usr\/local\/mysql\/mysql-test'\u00a0;\u00a0perl\u00a0mysql-test-run.pl\r\n\r\nPlease\u00a0report\u00a0any\u00a0problems\u00a0at\u00a0http:\/\/mariadb.org\/jira\r\n\r\nThe\u00a0latest\u00a0information\u00a0about\u00a0MariaDB\u00a0is\u00a0available\u00a0at\u00a0http:\/\/mariadb.org\/.\r\nYou\u00a0can\u00a0find\u00a0additional\u00a0information\u00a0about\u00a0the\u00a0MySQL\u00a0part\u00a0at:\r\nhttp:\/\/dev.mysql.com\r\nConsider\u00a0joining\u00a0MariaDB's\u00a0strong\u00a0and\u00a0vibrant\u00a0community:\r\nhttps:\/\/mariadb.org\/get-involved\/<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\">\n<div class=\"linenos\"><\/div>\n<div><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>Mysql Secuinstall \uad6c\uc131\n<pre><code class=\"language-Python\">#\u00a0\/usr\/local\/mysql\/bin\/mysql_secure_installation\r\n\r\nNOTE:\u00a0RUNNING\u00a0ALL\u00a0PARTS\u00a0OF\u00a0THIS\u00a0SCRIPT\u00a0IS\u00a0RECOMMENDED\u00a0FOR\u00a0ALL\u00a0MariaDB\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SERVERS\u00a0IN\u00a0PRODUCTION\u00a0USE!\u00a0\u00a0PLEASE\u00a0READ\u00a0EACH\u00a0STEP\u00a0CAREFULLY!\r\n\r\nIn\u00a0order\u00a0to\u00a0log\u00a0into\u00a0MariaDB\u00a0to\u00a0secure\u00a0it,\u00a0we'll\u00a0need\u00a0the\u00a0current\r\npassword\u00a0for\u00a0the\u00a0root\u00a0user.\u00a0If\u00a0you've\u00a0just\u00a0installed\u00a0MariaDB,\u00a0and\r\nhaven't\u00a0set\u00a0the\u00a0root\u00a0password\u00a0yet,\u00a0you\u00a0should\u00a0just\u00a0press\u00a0enter\u00a0here.\r\n\r\nEnter\u00a0current\u00a0password\u00a0for\u00a0root\u00a0(enter\u00a0for\u00a0none):\r\nOK,\u00a0successfully\u00a0used\u00a0password,\u00a0moving\u00a0on...\r\n\r\nSetting\u00a0the\u00a0root\u00a0password\u00a0or\u00a0using\u00a0the\u00a0unix_socket\u00a0ensures\u00a0that\u00a0nobody\r\ncan\u00a0log\u00a0into\u00a0the\u00a0MariaDB\u00a0root\u00a0user\u00a0without\u00a0the\u00a0proper\u00a0authorisation.\r\n\r\nYou\u00a0already\u00a0have\u00a0your\u00a0root\u00a0account\u00a0protected,\u00a0so\u00a0you\u00a0can\u00a0safely\u00a0answer\u00a0'n'.\r\n\r\nSwitch\u00a0to\u00a0unix_socket\u00a0authentication\u00a0[Y\/n]\u00a0n\r\n...\u00a0skipping.\r\n\r\nYou\u00a0already\u00a0have\u00a0your\u00a0root\u00a0account\u00a0protected,\u00a0so\u00a0you\u00a0can\u00a0safely\u00a0answer\u00a0'n'.\r\n\r\nChange\u00a0the\u00a0root\u00a0password?\u00a0[Y\/n]\u00a0y\r\nNew\u00a0password:\r\nRe-enter\u00a0new\u00a0password:\r\nPassword\u00a0updated\u00a0successfully!\r\nReloading\u00a0privilege\u00a0tables..\r\n...\u00a0Success!\r\n\r\n\r\nBy\u00a0default,\u00a0a\u00a0MariaDB\u00a0installation\u00a0has\u00a0an\u00a0anonymous\u00a0user,\u00a0allowing\u00a0anyone\r\nto\u00a0log\u00a0into\u00a0MariaDB\u00a0without\u00a0having\u00a0to\u00a0have\u00a0a\u00a0user\u00a0account\u00a0created\u00a0for\r\nthem.\u00a0\u00a0This\u00a0is\u00a0intended\u00a0only\u00a0for\u00a0testing,\u00a0and\u00a0to\u00a0make\u00a0the\u00a0installation\r\ngo\u00a0a\u00a0bit\u00a0smoother.\u00a0\u00a0You\u00a0should\u00a0remove\u00a0them\u00a0before\u00a0moving\u00a0into\u00a0a\r\nproduction\u00a0environment.\r\n\r\nRemove\u00a0anonymous\u00a0users?\u00a0[Y\/n]\u00a0y\r\n...\u00a0Success!\r\n\r\nNormally,\u00a0root\u00a0should\u00a0only\u00a0be\u00a0allowed\u00a0to\u00a0connect\u00a0from\u00a0'localhost'.\u00a0\u00a0This\r\nensures\u00a0that\u00a0someone\u00a0cannot\u00a0guess\u00a0at\u00a0the\u00a0root\u00a0password\u00a0from\u00a0the\u00a0network.\r\n\r\nDisallow\u00a0root\u00a0login\u00a0remotely?\u00a0[Y\/n]\u00a0y\r\n...\u00a0Success!\r\n\r\nBy\u00a0default,\u00a0MariaDB\u00a0comes\u00a0with\u00a0a\u00a0database\u00a0named\u00a0'test'\u00a0that\u00a0anyone\u00a0can\r\naccess.\u00a0\u00a0This\u00a0is\u00a0also\u00a0intended\u00a0only\u00a0for\u00a0testing,\u00a0and\u00a0should\u00a0be\u00a0removed\r\nbefore\u00a0moving\u00a0into\u00a0a\u00a0production\u00a0environment.\r\n\r\nRemove\u00a0test\u00a0database\u00a0and\u00a0access\u00a0to\u00a0it?\u00a0[Y\/n]\u00a0y\r\n-\u00a0Dropping\u00a0test\u00a0database...\r\n...\u00a0Success!\r\n-\u00a0Removing\u00a0privileges\u00a0on\u00a0test\u00a0database...\r\n...\u00a0Success!\r\n\r\nReloading\u00a0the\u00a0privilege\u00a0tables\u00a0will\u00a0ensure\u00a0that\u00a0all\u00a0changes\u00a0made\u00a0so\u00a0far\r\nwill\u00a0take\u00a0effect\u00a0immediately.\r\n\r\nReload\u00a0privilege\u00a0tables\u00a0now?\u00a0[Y\/n]\u00a0y\r\n...\u00a0Success!\r\n\r\nCleaning\u00a0up...\r\n\r\nAll\u00a0done!\u00a0\u00a0If\u00a0you've\u00a0completed\u00a0all\u00a0of\u00a0the\u00a0above\u00a0steps,\u00a0your\u00a0MariaDB\r\ninstallation\u00a0should\u00a0now\u00a0be\u00a0secure.\r\n\r\nThanks\u00a0for\u00a0using\u00a0MariaDB!<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>\ud074\ub7ec\uc2a4\ud130 \uad6c\uc131(\ucd5c\ucd08\ub85c \uad6c\uc131\ud558\ub294 \uc11c\ubc84\uc5d0\uc11c\ub9cc \uc9c4\ud589\ud558\uba74 \ub428\n<pre><code class=\"language-Python\">#\u00a0\/usr\/local\/mysql\/support-files\/mysql.server\u00a0start\u00a0\u00a0--wsrep-new-cluster\r\nStarting\u00a0MariaDB\u00a0SUCCESS!\r\n190911\u00a013:43:35\u00a0mysqld_safe\u00a0Logging\u00a0to\u00a0'\/data\/db_data\/localhost.err'.\r\n190911\u00a013:43:35\u00a0mysqld_safe\u00a0Starting\u00a0mysqld\u00a0daemon\u00a0with\u00a0databases\u00a0from\u00a0\/data\/db_data<\/code><\/pre>\n<p>&nbsp;<\/p>\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>DB\uc811\uc18d\uacc4\uc815 \uad8c\ud55c \uc124\uc815\n<pre><code class=\"language-SQL\">MariaDB\u00a0[(none)]&gt;\u00a0grant\u00a0all\u00a0privileges\u00a0on\u00a0*.*\u00a0to\u00a0root@'localhost'\u00a0identified\u00a0by\u00a0'root'\u00a0with\u00a0grant\u00a0option;<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>2\ubc88 \uc11c\ubc84\uc5d0\uc11c mysql \ud504\ub85c\uc138\uc2a4 \uc2e4\ud589\n<pre><code class=\"language-Python\">#\u00a0\/usr\/local\/mysql\/support-files\/mysql.server\u00a0start\r\nStarting\u00a0MariaDB.190911\u00a013:51:30\u00a0mysqld_safe\u00a0Logging\u00a0to\u00a0'\/data\/db_data\/localhost.err'.\r\n190911\u00a013:51:30\u00a0mysqld_safe\u00a0Starting\u00a0mysqld\u00a0daemon\u00a0with\u00a0databases\u00a0from\u00a0\/data\/db_data\r\n................\u00a0SUCCESS!<\/code><\/pre>\n<\/li>\n<li>Glaracluster \uc7ac\uc2e4\ud589\uc2dc \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc885\ub8cc\ub41c \ub178\ub4dc\ub97c \ucc3e\uc544\uc11c \ud574\ub2f9 \ub178\ub4dc\uc5d0 new-cluster\ub97c \ucd94\uac00\ud558\uba74 \ub41c\ub2e4\n<pre><code class=\"language-Python\">$&gt;\u00a0cat\u00a0\/data\/db_data\/grastate.dat\r\n#\u00a0GALERA\u00a0saved\u00a0state\r\nversion:\u00a02.1\r\nuuid:\u00a0\u00a0\u00a0\u00a0fbb2c143-8b5e-11ec-8ea1-36a72f3e94f3\r\nseqno:\u00a0\u00a0\u00a0-1\r\n#\ub9c8\uc9c0\ub9c9\uc5d0\u00a0\uc885\ub8cc\ub41c\u00a0\ub178\ub4dc\uac00\u00a01\ub85c\u00a0\ud45c\uae30\ub418\uc5b4\u00a0\uc788\ub2e4.\r\nsafe_to_bootstrap: 1<\/code><\/pre>\n<\/li>\n<\/ol>\n<ul id=\"bkmrk-bootstrap%EC%9D%84-1%EB%A1%9C-%EA%B8%B0%EC%9E%AC%EB%90%9C-%EC%84%9C%EB%B2%84\">\n<li>\n<ul>\n<li class=\"null\">bootstrap\uc744 1\ub85c \uae30\uc7ac\ub41c \uc11c\ubc84\uc5d0 &#8211;wsrep-new-cluster\ub97c \ubd99\uc5ec\uc11c \uc2e4\ud589\ud558\uace0, \uc544\ub2cc \uc11c\ubc84\ub294 \uadf8\ub0e5 \uc2e4\ud589\uc2dc\ud0a4\uba74 \ub41c\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 id=\"bkmrk-%C2%A0\"><span class=\"ez-toc-section\" id=\"Maxscale%EC%97%90%EC%84%9C_%EC%84%9C%EB%B2%84%EA%B4%80%EB%A6%AC\"><\/span>Maxscale\uc5d0\uc11c \uc11c\ubc84\uad00\ub9ac<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0-%EC%84%9C%EB%B2%84-%EB%A7%B4%EB%B2%84%EC%A0%9C%EC%99%B8%EC%A0%88%EC%B0%A8-%28maxs\">\n<li class=\"null\">\ud074\ub7ec\uc2a4\ud130 \uc11c\ubc84 \ub9f4\ubc84\uc81c\uc678\uc808\ucc28 (Maxscale\uc774 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0\uc11c \uc218\ud589)\n<ul>\n<li class=\"null\">\ud604\uc7ac \uad6c\uc131\ub41c \ubaa8\ub2c8\ud130 \uc815\ubcf4\ud655\uc778\n<pre><code class=\"language-\">$&gt;  maxctrl list monitors \r\n\u250c\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\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\r\n\u2502 Monitor         \u2502 State   \u2502 Servers          \u2502\r\n\u251c\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\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\r\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1, server2 \u2502\r\n\u2514\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\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n<\/code><\/pre>\n<p>&nbsp;<\/li>\n<li class=\"null\">server2\ub97c \uc81c\uc678\ud558\uae30\n<pre><code class=\"language-\">$&gt; maxctrl unlink monitor MariaDB-Monitor server2\r\nOK\r\n<\/code><\/pre>\n<p>&nbsp;<\/li>\n<li class=\"null\">\ubaa8\ub2c8\ud130\uc5d0\uc11c \uc81c\uc678\ub41c \uc11c\ubc84 \ud655\uc778\n<pre><code class=\"language-\">$&gt;  maxctrl list monitors \r\n\u250c\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\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\r\n\u2502 Monitor         \u2502 State   \u2502 Servers \u2502\r\n\u251c\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\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\r\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1 \u2502\r\n\u2514\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\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n<\/code><\/pre>\n<p>&nbsp;<\/li>\n<li class=\"null\">2\ubc88\uc11c\ubc84 \ub2e4\uc2dc \ud22c\uc785\n<pre><code class=\"language-\">$&gt; maxctrl link monitor MariaDB-Monitor server2\r\nOK\r\n<\/code><\/pre>\n<\/li>\n<li class=\"null\">\ubaa8\ub2c8\ud130\uc5d0\uc11c \ub2e4\uc2dc \ub4f1\ub85d\ub41c \ubd80\ubd84 \ud655\uc778\n<pre><code class=\"language-\">$&gt;  maxctrl list monitors \r\n\u250c\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\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\r\n\u2502 Monitor         \u2502 State   \u2502 Servers          \u2502\r\n\u251c\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\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\r\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1, server2 \u2502\r\n\u2514\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\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n<\/code><\/pre>\n<p>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p id=\"bkmrk-\">\n<p id=\"bkmrk-reference%C2%A0\"><em>Reference\u00a0<\/em><\/p>\n<ul id=\"bkmrk-https%3A%2F%2Fongamedev.ti\">\n<li><em><span class=\"wikiexternallink\"><a href=\"https:\/\/ongamedev.tistory.com\/entry\/Galera-%ED%8F%AC%ED%8A%B8-%EB%A6%AC%EC%8A%A4%ED%8A%B8-%EB%B0%8F-%EC%9A%A9%EC%96%B4-%EC%A0%95%EB%A6%AC\">https:\/\/ongamedev.tistory.com\/entry\/Galera-%ED%8F%AC%ED%8A%B8-%EB%A6%AC%EC%8A%A4%ED%8A%B8-%EB%B0%8F-%EC%9A%A9%EC%96%B4-%EC%A0%95%EB%A6%AC<\/a><\/span><\/em><\/li>\n<li><em><span class=\"wikiexternallink\"><a href=\"https:\/\/mariadb.com\/kb\/en\/getting-started-with-mariadb-galera-cluster\/\">https:\/\/mariadb.com\/kb\/en\/getting-started-with-mariadb-galera-cluster\/<\/a><\/span><\/em><\/li>\n<\/ul>\n<h3 id=\"bkmrk--0\" class=\"wikigeneratedid\"><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uae30\uc874\ubb38\uc800 Refactoring\uc744 \uc9c4\ud589\ud558\uace0 \uc788\uc5b4\uc694 DBMS\uad50\uccb4(Mysql \u2192 Mariadb)\ub97c \ucd94\uc9c4\ud558\uba74\uc11c \uc774\uc911\ud654 \uad6c\uc131\uc744 replication \uc5d0\uc11c galera_cluster\ub85c \uc804\ud658\ud558\uae30&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[173,387],"class_list":["post-1369","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-centos7","tag-galera"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1369","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=1369"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1369\/revisions"}],"predecessor-version":[{"id":1373,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1369\/revisions\/1373"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1371"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1369"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}