{"id":1415,"date":"2026-03-22T23:17:36","date_gmt":"2026-03-22T14:17:36","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1415"},"modified":"2026-03-22T23:17:36","modified_gmt":"2026-03-22T14:17:36","slug":"mysql-5-5-%eb%a6%ac%ed%94%8c%eb%a6%ac%ec%bc%80%ec%9d%b4%ec%85%98-%ea%b5%ac%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1415","title":{"rendered":"mysql 5.5 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uad6c\uc131\ud558\uae30"},"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=1415\/#Mysql_55_Replication_%EA%B5%AC%EC%84%B1%ED%95%98%EA%B8%B0Master_%E2%80%93_Slave\" >Mysql 5.5 Replication \uad6c\uc131\ud558\uae30(Master \u2013 Slave)<\/a><\/li><\/ul><\/nav><\/div>\n<h3 id=\"bkmrk-mysql-5.5-replicatio\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"Mysql_55_Replication_%EA%B5%AC%EC%84%B1%ED%95%98%EA%B8%B0Master_%E2%80%93_Slave\"><\/span>Mysql 5.5 Replication \uad6c\uc131\ud558\uae30(Master \u2013 Slave)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul id=\"bkmrk-5.5%EB%B6%80%ED%84%B0%EB%8A%94-%EB%8F%99%EA%B8%B0%ED%99%94%EB%90%98%EB%8A%94-replica\">\n<li>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ub41c \ubb38\uc11c refactoring \uc911\uc774\ub77c, \ud574\ub2f9 \ubb38\uc11c\ub3c4 \uc5c5\ub370\uc774\ud2b8 \ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/li>\n<li>5.5\ubd80\ud130\ub294 \ub3d9\uae30\ud654\ub418\ub294 Replication \uad6c\uc131\uc774 \uac00\ub2a5(5.1\uc740 \ube44\ub3d9\uae30\uc2dd\uc73c\ub85c Data Sync\uc2dc \uc624\ub958 \ubc1c\uc0dd<\/li>\n<\/ul>\n<ol id=\"bkmrk-%EB%A7%88%EC%8A%A4%ED%84%B0-%EC%84%9C%EB%B2%84-%EC%9E%91%EC%97%851.-%2Fetc%2Fmy.\">\n<li>\ub9c8\uc2a4\ud130 \uc11c\ubc84 \uc791\uc5c51. \/etc\/my.cnf\ud30c\uc77c \uc218\uc815\n<pre><code class=\"language-Python\">$&gt; vi \/etc\/my.cnf\r\n...\r\nserver-id = 1\r\nbinlog-do-db=test1234 # \uc801\uc6a9\ud560 DB\uba85\r\nlog-bin=mysql-master-bin # \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc0ac\uc6a9\ud560 \ub85c\uadf8\uba85<\/code><\/pre>\n<div>\n<div>\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\">\n<div class=\"linenos\">\n<table style=\"border-collapse: collapse; width: 99.998%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.8711%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1417\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866.jpg\" alt=\"\" width=\"2304\" height=\"1728\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866.jpg 2304w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-300x225.jpg 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-1024x768.jpg 1024w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-768x576.jpg 768w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-1536x1152.jpg 1536w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-2048x1536.jpg 2048w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/27769726-a24b-4786-83c1-a829a5a7b866-1300x975.jpg 1300w\" sizes=\"auto, (max-width: 2304px) 100vw, 2304px\" \/><\/td>\n<\/tr>\n<tr>\n<td>perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\ub9c8\uc2a4\ud130 \uc11c\ubc84 replication \ud50c\ub7ec\uadf8\uc778 \uc124\uce58\n<pre><code class=\"language-SQL\">mysql&gt; INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';<\/code><\/pre>\n<\/li>\n<li>\ud50c\ub7ec\uadf8\uc778 \ud65c\uc131\ud654\n<pre><code class=\"language-SQL\">mysql&gt; set global rpl_semi_sync_master_enabled=1;\r\nQuery OK, 0 rows affected (0.00 sec)\r\nmysql&gt; set global rpl_semi_sync_master_timeout =1000;\r\nQuery OK, 0 rows affected (0.00 sec)<\/code><\/pre>\n<\/li>\n<li>\uc124\uce58 \ubc0f \ud65c\uc131\ud654 \ud655\uc778\n<pre><code class=\"language-SQL\">mysql&gt; show variables like 'rpl_semi_sync%';\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| Variable_name | Value |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| rpl_semi_sync_master_enabled | ON |\r\n| rpl_semi_sync_master_timeout | 1000 |\r\n| rpl_semi_sync_master_trace_level | 32 |\r\n| rpl_semi_sync_master_wait_no_slave | ON |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+<\/code><\/pre>\n<p>&nbsp;<\/p>\n<div>\n<div class=\"box\"><\/div>\n<\/div>\n<\/li>\n<li>Slave \uc811\uc18d\ud560 \uc218 \uc788\uac8c \uad8c\ud55c \uc124\uc815\n<pre><code class=\"language-SQL\">mysql&gt; grant replication slave on *.* to 'test'@'192.168.10.10' identified by 'test1234';<\/code><\/pre>\n<p>&nbsp;<\/p>\n<div><\/div>\n<\/li>\n<li>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc0c1\ud0dc \ud655\uc778\n<pre><code class=\"language-SQL\">mysql&gt; show master status;\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+\r\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+\r\n| mysql-master-bin.000001 | 107 | test1234 | |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+<\/code><\/pre>\n<\/li>\n<\/ol>\n<\/div>\n<\/li>\n<li>\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\n<ol>\n<li>\u00a0\/etc\/my.cnf\ud30c\uc77c \uc218\uc815\n<pre><code class=\"language-Python\">$&gt; vi \/etc\/my.cnf\r\n...\r\nserver-id = 2\r\nrelay-log = slave-relay-bin<\/code><\/pre>\n<div>\n<div>\n<div class=\"box\"><\/div>\n<\/div>\n<ol>\n<li>\ud50c\ub7ec\uadf8\uc778 \uc124\uce58\n<pre><code class=\"language-SQL\">mysql&gt; INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';<\/code><\/pre>\n<\/li>\n<li>\ud50c\ub7ec\uadf8\uc778 \ud65c\uc131\ud654\n<pre><code class=\"language-SQL\">mysql&gt; set global rpl_semi_sync_slave_enabled=1;<\/code><\/pre>\n<\/li>\n<li>\ud65c\uc131\ud654 \ud655\uc778\n<pre><code class=\"language-SQL\">mysql&gt; show variables like \u2018rpl_semi_sync%\u2019;\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| Variable_name | Value |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| rpl_semi_sync_slave_enabled | ON |\r\n| rpl_semi_sync_slave_trace_level | 32 |\r\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n\r\n2 rows in set (0.01 sec)<\/code><\/pre>\n<p>&nbsp;<\/p>\n<div>\n<div class=\"box\"><\/div>\n<\/div>\n<\/li>\n<li>Master\uc11c\ubc84\uc640 \uc5f0\uacb0\n<pre><code class=\"language-SQL\">mysql&gt; change master to master_host='192.168.10.20', master_user='test', master_password='test1234', master_log_file='mysql-master-bin.000001', master_log_pos=107;<\/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<\/ol>\n<\/div>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p id=\"bkmrk-reference\"><em>Reference<\/em><\/p>\n<ul id=\"bkmrk-http%3A%2F%2Flks21c.blogsp\">\n<li><em><span class=\"wikiexternallink\"><a href=\"http:\/\/lks21c.blogspot.kr\/2011\/10\/mysql-replication-semi-sync-how-to.html\">http:\/\/lks21c.blogspot.kr\/2011\/10\/mysql-replication-semi-sync-how-to.html<\/a><\/span><\/em><\/li>\n<li><em><span class=\"wikiexternallink\"><a href=\"http:\/\/abydos.co.kr\/xe\/index.php?document_srl=1886\">http:\/\/abydos.co.kr\/xe\/index.php?document_srl=1886<\/a><\/span><\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mysql 5.5 Replication \uad6c\uc131\ud558\uae30(Master \u2013 Slave) \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\uc5d0 \uc791\uc131\ub41c \ubb38\uc11c refactoring \uc911\uc774\ub77c, \ud574\ub2f9 \ubb38\uc11c\ub3c4&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1417,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[383,405],"class_list":["post-1415","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-mysql","tag-replication"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1415","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=1415"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions"}],"predecessor-version":[{"id":1419,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions\/1419"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1417"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}