{"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_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=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\"><colgroup> <col style=\"width: 99.881%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1371\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"2304\" height=\"1728\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/8c8e8032-cbf0-44db-8f21-5c467ae43137.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<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\n<li>Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd\n<ul>\n\n<li>WEB\/WAS \u2192\u00a0\u00a0DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ &#8230;)<\/li>\n\n<li>DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5.<\/li>\n\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\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\n<li>Galera Cluster\uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654\n<ul>\n\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\n<li>WEB\/WAS \u2192\u00a0\u00a0DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ &#8230;)<\/li>\n\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\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\">\u00a0<\/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\n<li>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc740 1\uac1c\uc758 Thread\ub9cc \uc218\ud589<\/li>\n\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\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><\/td>\n<td style=\"width: 45.9833%;height: 120.451px\" colspan=\"1\">\n<div>\n<ul>\n\n<li>innodb\ub9cc \uc9c0\uc6d0<\/li>\n\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><\/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\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><\/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\n<li>\ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd\n<ul>\n\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)\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\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\n<li>\ud074\ub7ec\uc2a4\ud130 \ub9f4\ubc84\n<ul>\n\n<li>Donor : \uc804\uccb4 \ub370\uc774\ud130\ub97c \uac00\uc9c4 DB<\/li>\n\n<li>Joiner : Donor\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ubc1b\ub294 \ub178\ub4dc<\/li>\n<\/ul>\n<\/li>\n\n<li>\ub370\uc774\ud130 \ub3d9\uae30\ud654 \uc5d4\uc9c4\n<ul>\n\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\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\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\n<li>\uc124\uce58\ud658\uacbd\n<ul>\n\n<li>OS : Centos 7.5<\/li>\n\n<li>DBMS : Mariadb 10.4.7<\/li>\n\n<li>Galera : 4.26-4.2.1<\/li>\n<\/ul>\n<\/li>\n\n<li>\uc791\uc5c5\uc21c\uc11c<\/li>\n\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;&nbsp;yum&nbsp;install&nbsp;libaio&nbsp;socat Judy&nbsp; .\/galera-4-26.4.2 1.rhel7.el7.centos.x86_64<\/code><\/pre>\n<\/li>\n\n<li>\/etc\/my.cnf\uc5d0 \uc544\ub798\ub0b4\uc6a9 \uc801\uc6a9\n<pre><code class=\"language-Python\">[client]\nport&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;3306\nsocket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;\/tmp\/mysql.sock\n\n[mysqld]\nuser&nbsp;=&nbsp;mysql\nport&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;3306\nsocket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;\/tmp\/mysql.sock\nskip-external-locking\nkey_buffer_size&nbsp;=&nbsp;384M\nmax_allowed_packet&nbsp;=&nbsp;1M\ntable_open_cache&nbsp;=&nbsp;512\nsort_buffer_size&nbsp;=&nbsp;2M\nread_buffer_size&nbsp;=&nbsp;2M\nread_rnd_buffer_size&nbsp;=&nbsp;8M\nmyisam_sort_buffer_size&nbsp;=&nbsp;64M\nthread_cache_size&nbsp;=&nbsp;8\nquery_cache_size&nbsp;=&nbsp;32M\n#thread_concurrency&nbsp;=&nbsp;8\nexpire_logs_days&nbsp;=&nbsp;30\nwait_timeout&nbsp;=&nbsp;60\n#skip-name-resolve\nbasedir=\/usr\/local\/mysql\ndatadir=\/data\/db_data\n\nmax_heap_table_size&nbsp;=&nbsp;190M\nmax_allowed_packet&nbsp;=&nbsp;&nbsp;16M\ntmp_table_size&nbsp;=&nbsp;64M\njoin_buffer_size&nbsp;=&nbsp;64M\ninnodb_buffer_pool_size&nbsp;=&nbsp;950M\n#innodb_doublewrite&nbsp;=&nbsp;0\ninnodb_flush_log_at_timeout&nbsp;=&nbsp;3\n#innodb_read_io_threads&nbsp;=&nbsp;32\n#innodb_write_io_threads&nbsp;=&nbsp;16\n#character_set_client&nbsp;=&nbsp;utf8mb4\n\n#log-bin=mysql-bin\n\nserver-id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;2\n\n[galera]\nwsrep_on=ON\n#wsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\nwsrep_provider=\/usr\/lib64\/galera-4\/libgalera_smm.so\nwsrep_cluster_address=&quot;gcomm:\/\/172.21.113.109,172.21.113.69&quot;&nbsp;#\ud074\ub7ec\uc2a4\ud130&nbsp;\uad6c\uc131\ud560&nbsp;IP\nbinlog_format=row\ndefault_storage_engine=InnoDB\ninnodb_autoinc_lock_mode=2\nwsrep_cluster_name=cluster\nwsrep_node_address=&quot;172.21.113.109&quot;&nbsp;&nbsp;#\uc790\uae30&nbsp;IP\uac00&nbsp;\uc791\uc131\ub418\uc5b4&nbsp;\uc788\uc73c\uba74&nbsp;\ub428\nbind-address=0.0.0.0\nwsrep_sst_method=mariabackup\nwsrep_sst_auth=&quot;root:root&quot;\nwsrep_provider_options=&quot;pc.bootstrap=YES&quot;<\/code><\/pre>\n\u00a0\n\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\"><\/div>\n<\/div>\n<\/div>\n<\/div><\/li>\n    <li class=\"null\">mysql_install_db \uc2e4\ud589\n<pre><code class=\"language-Python\">#&gt;&nbsp;\/usr\/local\/mysql\/scripts\/mysql_install_db\nInstalling&nbsp;MariaDB\/MySQL&nbsp;system&nbsp;tables&nbsp;in&nbsp;&#039;\/data\/db_data&#039;&nbsp;...\nwsrep&nbsp;loader:&nbsp;[INFO]&nbsp;wsrep_load():&nbsp;loading&nbsp;provider&nbsp;library&nbsp;&#039;none&#039;\nOK\n\nTo&nbsp;start&nbsp;mysqld&nbsp;at&nbsp;boot&nbsp;time&nbsp;you&nbsp;have&nbsp;to&nbsp;copy\nsupport-files\/mysql.server&nbsp;to&nbsp;the&nbsp;right&nbsp;place&nbsp;for&nbsp;your&nbsp;system\n\nTwo&nbsp;all-privilege&nbsp;accounts&nbsp;were&nbsp;created.\nOne&nbsp;is&nbsp;root@localhost,&nbsp;it&nbsp;has&nbsp;no&nbsp;password,&nbsp;but&nbsp;you&nbsp;need&nbsp;to\nbe&nbsp;system&nbsp;&#039;root&#039;&nbsp;user&nbsp;to&nbsp;connect.&nbsp;Use,&nbsp;for&nbsp;example,&nbsp;sudo&nbsp;mysql\nThe&nbsp;second&nbsp;is&nbsp;mysql@localhost,&nbsp;it&nbsp;has&nbsp;no&nbsp;password&nbsp;either,&nbsp;but\nyou&nbsp;need&nbsp;to&nbsp;be&nbsp;the&nbsp;system&nbsp;&#039;mysql&#039;&nbsp;user&nbsp;to&nbsp;connect.\nAfter&nbsp;connecting&nbsp;you&nbsp;can&nbsp;set&nbsp;the&nbsp;password,&nbsp;if&nbsp;you&nbsp;would&nbsp;need&nbsp;to&nbsp;be\nable&nbsp;to&nbsp;connect&nbsp;as&nbsp;any&nbsp;of&nbsp;these&nbsp;users&nbsp;with&nbsp;a&nbsp;password&nbsp;and&nbsp;without&nbsp;sudo\n\nSee&nbsp;the&nbsp;MariaDB&nbsp;Knowledgebase&nbsp;at&nbsp;http:\/\/mariadb.com\/kb&nbsp;or&nbsp;the\nMySQL&nbsp;manual&nbsp;for&nbsp;more&nbsp;instructions.\n\nYou&nbsp;can&nbsp;start&nbsp;the&nbsp;MariaDB&nbsp;daemon&nbsp;with:\ncd&nbsp;&#039;\/usr\/local\/mysql&#039;&nbsp;;&nbsp;\/usr\/local\/mysql\/bin\/mysqld_safe&nbsp;--datadir=&#039;\/data\/db_data&#039;\n\nYou&nbsp;can&nbsp;test&nbsp;the&nbsp;MariaDB&nbsp;daemon&nbsp;with&nbsp;mysql-test-run.pl\ncd&nbsp;&#039;\/usr\/local\/mysql\/mysql-test&#039;&nbsp;;&nbsp;perl&nbsp;mysql-test-run.pl\n\nPlease&nbsp;report&nbsp;any&nbsp;problems&nbsp;at&nbsp;http:\/\/mariadb.org\/jira\n\nThe&nbsp;latest&nbsp;information&nbsp;about&nbsp;MariaDB&nbsp;is&nbsp;available&nbsp;at&nbsp;http:\/\/mariadb.org\/.\nYou&nbsp;can&nbsp;find&nbsp;additional&nbsp;information&nbsp;about&nbsp;the&nbsp;MySQL&nbsp;part&nbsp;at:\nhttp:\/\/dev.mysql.com\nConsider&nbsp;joining&nbsp;MariaDB&#039;s&nbsp;strong&nbsp;and&nbsp;vibrant&nbsp;community:\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><\/li>\n\n<li>Mysql Secuinstall \uad6c\uc131\n<pre><code class=\"language-Python\">#&nbsp;\/usr\/local\/mysql\/bin\/mysql_secure_installation\n\nNOTE:&nbsp;RUNNING&nbsp;ALL&nbsp;PARTS&nbsp;OF&nbsp;THIS&nbsp;SCRIPT&nbsp;IS&nbsp;RECOMMENDED&nbsp;FOR&nbsp;ALL&nbsp;MariaDB\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SERVERS&nbsp;IN&nbsp;PRODUCTION&nbsp;USE!&nbsp;&nbsp;PLEASE&nbsp;READ&nbsp;EACH&nbsp;STEP&nbsp;CAREFULLY!\n\nIn&nbsp;order&nbsp;to&nbsp;log&nbsp;into&nbsp;MariaDB&nbsp;to&nbsp;secure&nbsp;it,&nbsp;we&#039;ll&nbsp;need&nbsp;the&nbsp;current\npassword&nbsp;for&nbsp;the&nbsp;root&nbsp;user.&nbsp;If&nbsp;you&#039;ve&nbsp;just&nbsp;installed&nbsp;MariaDB,&nbsp;and\nhaven&#039;t&nbsp;set&nbsp;the&nbsp;root&nbsp;password&nbsp;yet,&nbsp;you&nbsp;should&nbsp;just&nbsp;press&nbsp;enter&nbsp;here.\n\nEnter&nbsp;current&nbsp;password&nbsp;for&nbsp;root&nbsp;(enter&nbsp;for&nbsp;none):\nOK,&nbsp;successfully&nbsp;used&nbsp;password,&nbsp;moving&nbsp;on...\n\nSetting&nbsp;the&nbsp;root&nbsp;password&nbsp;or&nbsp;using&nbsp;the&nbsp;unix_socket&nbsp;ensures&nbsp;that&nbsp;nobody\ncan&nbsp;log&nbsp;into&nbsp;the&nbsp;MariaDB&nbsp;root&nbsp;user&nbsp;without&nbsp;the&nbsp;proper&nbsp;authorisation.\n\nYou&nbsp;already&nbsp;have&nbsp;your&nbsp;root&nbsp;account&nbsp;protected,&nbsp;so&nbsp;you&nbsp;can&nbsp;safely&nbsp;answer&nbsp;&#039;n&#039;.\n\nSwitch&nbsp;to&nbsp;unix_socket&nbsp;authentication&nbsp;[Y\/n]&nbsp;n\n...&nbsp;skipping.\n\nYou&nbsp;already&nbsp;have&nbsp;your&nbsp;root&nbsp;account&nbsp;protected,&nbsp;so&nbsp;you&nbsp;can&nbsp;safely&nbsp;answer&nbsp;&#039;n&#039;.\n\nChange&nbsp;the&nbsp;root&nbsp;password?&nbsp;[Y\/n]&nbsp;y\nNew&nbsp;password:\nRe-enter&nbsp;new&nbsp;password:\nPassword&nbsp;updated&nbsp;successfully!\nReloading&nbsp;privilege&nbsp;tables..\n...&nbsp;Success!\n\nBy&nbsp;default,&nbsp;a&nbsp;MariaDB&nbsp;installation&nbsp;has&nbsp;an&nbsp;anonymous&nbsp;user,&nbsp;allowing&nbsp;anyone\nto&nbsp;log&nbsp;into&nbsp;MariaDB&nbsp;without&nbsp;having&nbsp;to&nbsp;have&nbsp;a&nbsp;user&nbsp;account&nbsp;created&nbsp;for\nthem.&nbsp;&nbsp;This&nbsp;is&nbsp;intended&nbsp;only&nbsp;for&nbsp;testing,&nbsp;and&nbsp;to&nbsp;make&nbsp;the&nbsp;installation\ngo&nbsp;a&nbsp;bit&nbsp;smoother.&nbsp;&nbsp;You&nbsp;should&nbsp;remove&nbsp;them&nbsp;before&nbsp;moving&nbsp;into&nbsp;a\nproduction&nbsp;environment.\n\nRemove&nbsp;anonymous&nbsp;users?&nbsp;[Y\/n]&nbsp;y\n...&nbsp;Success!\n\nNormally,&nbsp;root&nbsp;should&nbsp;only&nbsp;be&nbsp;allowed&nbsp;to&nbsp;connect&nbsp;from&nbsp;&#039;localhost&#039;.&nbsp;&nbsp;This\nensures&nbsp;that&nbsp;someone&nbsp;cannot&nbsp;guess&nbsp;at&nbsp;the&nbsp;root&nbsp;password&nbsp;from&nbsp;the&nbsp;network.\n\nDisallow&nbsp;root&nbsp;login&nbsp;remotely?&nbsp;[Y\/n]&nbsp;y\n...&nbsp;Success!\n\nBy&nbsp;default,&nbsp;MariaDB&nbsp;comes&nbsp;with&nbsp;a&nbsp;database&nbsp;named&nbsp;&#039;test&#039;&nbsp;that&nbsp;anyone&nbsp;can\naccess.&nbsp;&nbsp;This&nbsp;is&nbsp;also&nbsp;intended&nbsp;only&nbsp;for&nbsp;testing,&nbsp;and&nbsp;should&nbsp;be&nbsp;removed\nbefore&nbsp;moving&nbsp;into&nbsp;a&nbsp;production&nbsp;environment.\n\nRemove&nbsp;test&nbsp;database&nbsp;and&nbsp;access&nbsp;to&nbsp;it?&nbsp;[Y\/n]&nbsp;y\n-&nbsp;Dropping&nbsp;test&nbsp;database...\n...&nbsp;Success!\n-&nbsp;Removing&nbsp;privileges&nbsp;on&nbsp;test&nbsp;database...\n...&nbsp;Success!\n\nReloading&nbsp;the&nbsp;privilege&nbsp;tables&nbsp;will&nbsp;ensure&nbsp;that&nbsp;all&nbsp;changes&nbsp;made&nbsp;so&nbsp;far\nwill&nbsp;take&nbsp;effect&nbsp;immediately.\n\nReload&nbsp;privilege&nbsp;tables&nbsp;now?&nbsp;[Y\/n]&nbsp;y\n...&nbsp;Success!\n\nCleaning&nbsp;up...\n\nAll&nbsp;done!&nbsp;&nbsp;If&nbsp;you&#039;ve&nbsp;completed&nbsp;all&nbsp;of&nbsp;the&nbsp;above&nbsp;steps,&nbsp;your&nbsp;MariaDB\ninstallation&nbsp;should&nbsp;now&nbsp;be&nbsp;secure.\n\nThanks&nbsp;for&nbsp;using&nbsp;MariaDB!<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div><\/li>\n\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\">#&nbsp;\/usr\/local\/mysql\/support-files\/mysql.server&nbsp;start&nbsp;&nbsp;--wsrep-new-cluster\nStarting&nbsp;MariaDB&nbsp;SUCCESS!\n190911&nbsp;13:43:35&nbsp;mysqld_safe&nbsp;Logging&nbsp;to&nbsp;&#039;\/data\/db_data\/localhost.err&#039;.\n190911&nbsp;13:43:35&nbsp;mysqld_safe&nbsp;Starting&nbsp;mysqld&nbsp;daemon&nbsp;with&nbsp;databases&nbsp;from&nbsp;\/data\/db_data<\/code><\/pre>\n\u00a0\n\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div><\/li>\n\n<li>DB\uc811\uc18d\uacc4\uc815 \uad8c\ud55c \uc124\uc815\n<pre><code class=\"language-SQL\">MariaDB&nbsp;[(none)]&gt;&nbsp;grant&nbsp;all&nbsp;privileges&nbsp;on&nbsp;*.*&nbsp;to&nbsp;root@&#039;localhost&#039;&nbsp;identified&nbsp;by&nbsp;&#039;root&#039;&nbsp;with&nbsp;grant&nbsp;option;<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\"><\/div>\n<\/div>\n<\/div>\n<\/div><\/li>\n\n<li>2\ubc88 \uc11c\ubc84\uc5d0\uc11c mysql \ud504\ub85c\uc138\uc2a4 \uc2e4\ud589\n<pre><code class=\"language-Python\">#&nbsp;\/usr\/local\/mysql\/support-files\/mysql.server&nbsp;start\nStarting&nbsp;MariaDB.190911&nbsp;13:51:30&nbsp;mysqld_safe&nbsp;Logging&nbsp;to&nbsp;&#039;\/data\/db_data\/localhost.err&#039;.\n190911&nbsp;13:51:30&nbsp;mysqld_safe&nbsp;Starting&nbsp;mysqld&nbsp;daemon&nbsp;with&nbsp;databases&nbsp;from&nbsp;\/data\/db_data\n................&nbsp;SUCCESS!<\/code><\/pre>\n<\/li>\n\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;&nbsp;cat&nbsp;\/data\/db_data\/grastate.dat\n#&nbsp;GALERA&nbsp;saved&nbsp;state\nversion:&nbsp;2.1\nuuid:&nbsp;&nbsp;&nbsp;&nbsp;fbb2c143-8b5e-11ec-8ea1-36a72f3e94f3\nseqno:&nbsp;&nbsp;&nbsp;-1\n#\ub9c8\uc9c0\ub9c9\uc5d0&nbsp;\uc885\ub8cc\ub41c&nbsp;\ub178\ub4dc\uac00&nbsp;1\ub85c&nbsp;\ud45c\uae30\ub418\uc5b4&nbsp;\uc788\ub2e4.\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\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 \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\n\u2502 Monitor         \u2502 State   \u2502 Servers          \u2502\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\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1, server2 \u2502\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\n<\/code><\/pre>\n\u00a0<\/li>\n    <li class=\"null\">server2\ub97c \uc81c\uc678\ud558\uae30\n<pre><code class=\"language-\">$&gt; maxctrl unlink monitor MariaDB-Monitor server2\nOK\n<\/code><\/pre>\n\u00a0<\/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 \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\n\u2502 Monitor         \u2502 State   \u2502 Servers \u2502\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\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1 \u2502\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\n<\/code><\/pre>\n\u00a0<\/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\nOK\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 \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\n\u2502 Monitor         \u2502 State   \u2502 Servers          \u2502\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\n\u2502 MariaDB-Monitor \u2502 Running \u2502 server1, server2 \u2502\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\n<\/code><\/pre>\n\u00a0<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p id=\"bkmrk-\"><\/p>\n<p id=\"bkmrk-reference%C2%A0\"><em>Reference\u00a0<\/em><\/p>\n<ul id=\"bkmrk-https%3A%2F%2Fongamedev.ti\">\n\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\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>","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>","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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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\" \/>\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=1369\" \/>\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=\"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1369\" \/>\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-22T13:26:48+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-03-22T13:26:48+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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\" \/>\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=1369#blogposting\",\"name\":\"centos7 galera cluster\\uc124\\uce58 - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"centos7 galera cluster\\uc124\\uce58\",\"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\\\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg\",\"width\":2304,\"height\":1728},\"datePublished\":\"2026-03-22T22:26:48+09:00\",\"dateModified\":\"2026-03-22T22:26:48+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369#webpage\"},\"articleSection\":\"Mysql&amp;MariaDB, centos7, galera\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369#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=1369#listItem\",\"name\":\"centos7 galera cluster\\uc124\\uce58\"},\"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=1369#listItem\",\"position\":4,\"name\":\"centos7 galera cluster\\uc124\\uce58\",\"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=1369#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=1369#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=1369#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369\",\"name\":\"centos7 galera cluster\\uc124\\uce58 - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\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 \\uc704\\ud574 \\uad6c\\ucd95\\ud558\\uae30 \\uc704\\ud55c \\ubb38\\uc11c\\uc785\\ub2c8\\ub2e4. perplexity\\uc5d0\\uc11c \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8\\uc9c0 \\uc2dc\\uc2a4\\ud15c \\uc18c\\uac1c Replication \\uae30\\ubc18\\uc758 \\ub370\\uc774\\ud130 \\ub3d9\\uae30\\ud654 \\ubc29\\uc2dd WEB\\\/WAS \\u2192 DB#1 DDL \\uc720\\uc785 (insert \\\/ modify \\\/ delete \\\/ ...) DB#1\\uc11c\\ubc84\\ub294 binlog\\uc5d0 \\uc800\\uc7a5. 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\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369#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\\\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369\\\/#mainImage\",\"width\":2304,\"height\":1728},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1369#mainImage\"},\"datePublished\":\"2026-03-22T22:26:48+09:00\",\"dateModified\":\"2026-03-22T22:26:48+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":"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774","description":"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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","canonical_url":"http:\/\/www.igoni.kr\/?p=1369","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1369#blogposting","name":"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774","headline":"centos7 galera cluster\uc124\uce58","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\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg","width":2304,"height":1728},"datePublished":"2026-03-22T22:26:48+09:00","dateModified":"2026-03-22T22:26:48+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1369#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1369#webpage"},"articleSection":"Mysql&amp;MariaDB, centos7, galera"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1369#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=1369#listItem","name":"centos7 galera cluster\uc124\uce58"},"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=1369#listItem","position":4,"name":"centos7 galera cluster\uc124\uce58","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=1369#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=1369#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=1369#webpage","url":"http:\/\/www.igoni.kr\/?p=1369","name":"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774","description":"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1369#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\/8c8e8032-cbf0-44db-8f21-5c467ae43137.jpg","@id":"http:\/\/www.igoni.kr\/?p=1369\/#mainImage","width":2304,"height":1728},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1369#mainImage"},"datePublished":"2026-03-22T22:26:48+09:00","dateModified":"2026-03-22T22:26:48+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":"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774","og:description":"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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","og:url":"http:\/\/www.igoni.kr\/?p=1369","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-03-22T13:26:48+00:00","article:modified_time":"2026-03-22T13:26:48+00:00","twitter:card":"summary_large_image","twitter:title":"centos7 galera cluster\uc124\uce58 - \uc774\uace4\uc544\uc774","twitter:description":"\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 \uc704\ud574 \uad6c\ucd95\ud558\uae30 \uc704\ud55c \ubb38\uc11c\uc785\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uc2dc\uc2a4\ud15c \uc18c\uac1c Replication \uae30\ubc18\uc758 \ub370\uc774\ud130 \ub3d9\uae30\ud654 \ubc29\uc2dd WEB\/WAS \u2192 DB#1 DDL \uc720\uc785 (insert \/ modify \/ delete \/ ...) DB#1\uc11c\ubc84\ub294 binlog\uc5d0 \uc800\uc7a5. 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","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1369","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 13:26:48","updated":"2026-08-07 15:16:40","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\tcentos7 galera cluster\uc124\uce58\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":"centos7 galera cluster\uc124\uce58","link":"http:\/\/www.igoni.kr\/?p=1369"}],"_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}]}}