{"id":1375,"date":"2026-03-22T22:38:28","date_gmt":"2026-03-22T13:38:28","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1375"},"modified":"2026-03-22T22:38:28","modified_gmt":"2026-03-22T13:38:28","slug":"extrabackup%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-mysql-%eb%b0%b1%ec%97%85-%ec%88%98%ed%96%89","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1375","title":{"rendered":"extrabackup\uc744 \uc774\uc6a9\ud55c mysql  \ubc31\uc5c5 \uc218\ud589"},"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=1375\/#%EC%86%8C_%EA%B0%9C\" >\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=1375\/#%EC%84%A4%EC%B9%98_%EC%8B%A4%ED%96%89\" >\uc124\uce58 &amp; \uc2e4\ud589<\/a><\/li><\/ul><\/nav><\/div>\n<h3 id=\"bkmrk-%EC%86%8C-%EA%B0%9C\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%86%8C_%EA%B0%9C\"><\/span>\uc18c \uac1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-%EC%84%9C%EB%B9%84%EC%8A%A4-%EA%B5%AC%EB%8F%99%EC%A4%91%EC%97%90-mysqldump%EB%A5%BC-\">\n<li>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\ubb38\uc11c Refactoring\uc744 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2e4.\uc11c\ube44\uc2a4 \uad6c\ub3d9\uc911\uc5d0 Mysqldump\ub97c \uc774\uc6a9\ud55c \ubc31\uc5c5 \uc218\ud589\uc2dc table lock\uc774 \ubc1c\uc0dd\ud558\uae30 \ub54c\ubb38\uc5d0 \uc11c\ube44\uc2a4 \uc7a5\uc560 \uac00\ub2a5\uc131 \uc874\uc7ac.<\/li>\n<li>\ub300\uc6a9\ub7c9 DB\uc758 \uacbd\uc6b0 raw\ub2e8\uc704\ub85c backup\uc744 \uc218\ud589\ud558\uae30 \ub54c\ubb38\uc5d0 \uc218\uc2ed\ubd84 ~ \uc218\uc2dc\uac04 \uc18c\uc694<\/li>\n<\/ol>\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-1377\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed.jpg\" alt=\"\" width=\"2304\" height=\"1728\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed.jpg 2304w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-300x225.jpg 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-1024x768.jpg 1024w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-768x576.jpg 768w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-1536x1152.jpg 1536w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-2048x1536.jpg 2048w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/03\/2c448da3-7c2f-4412-8558-b084c866b9ed-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<h3 id=\"bkmrk-%EC%84%A4%EC%B9%98-%26-%EC%8B%A4%ED%96%89\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EC%84%A4%EC%B9%98_%EC%8B%A4%ED%96%89\"><\/span>\uc124\uce58 &amp; \uc2e4\ud589<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol id=\"bkmrk-1%EC%B0%A8-%EC%84%9C%EB%B2%84%EB%8A%94-%EC%A0%95%EC%83%81%2C-2%EC%B0%A8-%EC%84%9C%EB%B2%84%EB%8A%94-%EC%B6%94%EA%B0%80\">\n<li>1\ucc28 \uc11c\ubc84\ub294 \uc815\uc0c1, 2\ucc28 \uc11c\ubc84\ub294 \ucd94\uac00\ub85c \uad6c\uc131\ud55c \uc11c\ubc84\ub77c\uace0 \uac00\uc815\ud558\uace0..<\/li>\n<li>\uc804\uccb4\uc11c\ubc84\ub300\uc0c1 &#8211; extra backup \ud328\ud0a4\uc9c0 \uc124\uce58 &#8211; \u00a0<a title=\"https:\/\/www.percona.com\/downloads\/Percona-XtraBackup-2.4\/LATEST\/\" href=\"https:\/\/www.percona.com\/downloads\/Percona-XtraBackup-2.4\/LATEST\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.percona.com\/downloads\/Percona-XtraBackup-2.4\/LATEST\/<\/a><\/li>\n<li>1\ucc28 \uc11c\ubc84 &#8211; \ubc31\uc5c5\ud55c \ub370\uc774\ud130 \uc800\uc7a5\uc6a9 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131\n<div>\n<div class=\"box\">\n<div class=\"code\">$\u00a0mkdir\u00a0\/tmp\/db_backup<\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>1\ucc28 \uc11c\ubc84 &#8211; Full backup\uc73c\ub85c \ubc31\uc5c5 \uc218\ud589\uc2dc\n<pre><code class=\"language-Python\">$\u00a0innobackupex\u00a0\u00a0~-~-defaults-file=\/etc\/my.cnf\u00a0~-~-user\u00a0root\u00a0~-~-password\u00a0'root\uc554\ud638'\u00a0\/tmp\/db_backup\/\r\n\\\\....\r\n\u00a0innobackupex:\u00a0MySQL\u00a0binlog\u00a0position:\u00a0filename\u00a0'mysql-bin.000100',\u00a0position\u00a0001\r\n\u00a0innobackupex:\u00a0completed\u00a0OK!\r\n#\u00a0\/tmp\/db_backup\/\u00a0\ud558\uc704\ub85c\u00a0\ub144-\uc6d4-\uc77c-\uc2dc-\ubd84-\ucd08\u00a0\ub514\ub809\ud1a0\ub9ac\u00a0\uc0dd\uc131\ub428\r\n#\u00a0binlog\u00a0\ud30c\uc77c\uc815\ubcf4\u00a0\ud655\uc778\u00a0\ubc0f\u00a0position\uc815\ubcf4\ub97c\u00a0\uac00\uc9c0\uace0\u00a0\uc788\uc5b4\uc57c\u00a0\ud568.\r\n<\/code><\/pre>\n<\/li>\n<li>\ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c 2\ucc28\uc11c\ubc84\ub85c\u00a0\u00a0\ubcf5\uc0ac\n<pre><code class=\"language-Python\">$\u00a0scp\u00a0-r\u00a0\/tmp\/db_backup\u00a0csadmin@1.2.3.4:\/tmp\/<\/code><\/pre>\n<\/li>\n<li>2\ucc28\uc11c\ubc84 &#8211;\u00a0 mysql \uc885\ub8cc\n<pre><code class=\"language-Python\">$\u00a0\/etc\/init.d\/mysqld\u00a0stop<\/code><\/pre>\n<\/li>\n<li>2\uc11c\ubc84 &#8211; DB \ubcf5\uc6d0\uc2dc \ub370\uc774\ud130 \uacbd\ub85c\uc5d0 \uc788\ub294 \ud30c\uc77c \uc0ad\uc81c\n<pre><code class=\"language-Python\">$\u00a0rm\u00a0-rf\u00a0\/home\/data\/mysql\/<\/code><\/pre>\n<\/li>\n<li>2\ucc28 \uc11c\ubc84 &#8211;\u00a0DB\ub85c\uadf8 \ubcf5\uc6d0\n<pre><code class=\"language-Python\">$\u00a0innobackupex\u00a0~-~-apply-log\u00a0\/home\/mysqlxtra\/2021-08-07_01-00-03<\/code><\/pre>\n<\/li>\n<li>2\ucc28 \uc11c\ubc84 &#8211; DB\ub370\uc774\ud130 \ubcf5\uc6d0\n<pre><code class=\"language-Python\">$\u00a0innobackupex\u00a0~-~-copy-back\u00a0\/home\/mysqlxtra\/2021-08-07_01-00-03<\/code><\/pre>\n<\/li>\n<li>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc7ac\uad6c\uc131 (3-a\uacfc\uc815\uc5d0\uc11c \ud655\uc778\ub41c binlog \uc815\ubcf4 \uae30\uc7ac\ud558\uba74 \ub428)\n<pre><code class=\"language-SQL\">mysql&gt;\u00a0stop\u00a0slave;\r\nmysql&gt;\u00a0change\u00a0master\u00a0to\u00a0master_log_file='mysql-bin.000100',master_log_pos=001;\r\nmysql&gt;\u00a0start\u00a0slave;\r\nmysql&gt;\u00a0show\u00a0slave\u00a0status\u00a0\\G;\r\n...<\/code><\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\uc18c \uac1c \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \uae30\uc874\ubb38\uc11c Refactoring\uc744 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2e4.\uc11c\ube44\uc2a4 \uad6c\ub3d9\uc911\uc5d0 Mysqldump\ub97c \uc774\uc6a9\ud55c \ubc31\uc5c5 \uc218\ud589\uc2dc table&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1377,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[391,389],"class_list":["post-1375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-backup","tag-extrabackup"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1375","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=1375"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1375\/revisions"}],"predecessor-version":[{"id":1379,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1375\/revisions\/1379"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1377"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1375"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}