{"id":708,"date":"2009-09-02T14:40:33","date_gmt":"2009-09-02T06:40:33","guid":{"rendered":"http:\/\/orczhou.com\/?p=708"},"modified":"2009-12-15T13:39:37","modified_gmt":"2009-12-15T05:39:37","slug":"xtrabackup-mysql-innodb","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2009\/09\/xtrabackup-mysql-innodb\/","title":{"rendered":"Xtrabackup\u5907\u4efd\u548c\u6062\u590dMySQL(\u4e0a)"},"content":{"rendered":"<p style=\"text-indent:0\">\n<strong>\u4f5c\u8005\uff1a<\/strong><a href=\"http:\/\/www.flickr.com\/photos\/26825745@N06\/3933896112\/\" title=\"mail by orczhou, on Flickr\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/farm3.static.flickr.com\/2614\/3933896112_8ebfd42177_o.png\" width=\"163\" height=\"22\" alt=\"mail\" \/><\/a><br \/>\n<strong>\u6765\u81ea\uff1a<\/strong>TaobaoDBA 2009\u5e749\u67082\u65e5\u661f\u671f\u4e09<br \/>\n<strong>\u6458\u8981\uff1a<\/strong>\u672c\u6587\u4ecb\u7ecd\u4e86XtraBackup\u7684\u5b89\u88c5\uff08\u7f16\u8bd1\u5b89\u88c5\uff09\u548c\u4f7f\u7528\u3002<a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:start\">Xtrabackup<\/a>\u662f\u4e00\u4e2a\u5bf9InnoDB\u505a\u6570\u636e\u5907\u4efd\u7684\u5de5\u5177\uff0c\u652f\u6301\u5728\u7ebf\u70ed\u5907\u4efd\uff08\u5907\u4efd\u65f6\u4e0d\u5f71\u54cd\u6570\u636e\u8bfb\u5199\uff09\uff0c\u662f\u5546\u4e1a\u5907\u4efd\u5de5\u5177<a href=\"http:\/\/www.innodb.com\/products\/hot-backup\/order\/\">InnoDB Hotbackup<\/a>\u7684\u4e00\u4e2a\u5f88\u597d\u7684<a href=\"http:\/\/www.ningoo.net\/html\/2009\/using_xtrabackup_backup_mysql_database.html\">\u66ff\u4ee3\u54c1<\/a>\u3002\u672c\u6587\u6d4b\u8bd5\u4f7f\u7528\u7684\u662f0.8\u7248\u672c\uff0c\u4e0e\u5f53\u524d\u6700\u65b0\u7248\u672c\u662f0.9<a href=\"http:\/\/www.percona.com\/mysql\/xtrabackup\/0.9\/\">\u533a\u522b\u5e76\u4e0d\u5927<\/a>\u3002Xtrabackup\u6709\u4e24\u4e2a\u4e3b\u8981\u7684\u5de5\u5177\uff1axtrabackup\u3001innobackupex\uff0c\u5176\u4e2dxtrabackup\u53ea\u80fd\u5907\u4efdInnoDB\u548cXtraDB\u4e24\u79cd\u6570\u636e\u8868\uff0cinnobackupex\u5219\u5c01\u88c5\u4e86xtrabackup\uff0c\u540c\u65f6\u53ef\u4ee5\u5907\u4efdMyISAM\u6570\u636e\u8868\u3002\u672c\u6587\u4ec5\u4ec5\u4ecb\u7ecd\u4e86innobackupex\u7684\u5907\u4efd\u548c\u6062\u590d\u3002\n<\/p>\n<p><!--more--><\/p>\n<p style=\"text-indent:0\">\n+++++++++++++++++++++++++++++++++<br \/>\n<strong>\u6b63\u6587\uff1a<\/strong><br \/>\n+++++++++++++++++++++++++++++++++\n<\/p>\n<p style=\"text-indent:0\"><font size=4><b>\u4e00\u3001 \u73af\u5883<\/b><\/font><\/p>\n<p style=\"text-indent:0\">\u6d4b\u8bd5\u4e3b\u673aOS\uff1aLinux RHEL AS 3<\/p>\n<p style=\"text-indent:0\">MySQL InnoDB\u73af\u5883\uff1ainnodb_data_file_path = ibdata1:1G;ibdata2:1G;ibdata3:1G<\/p>\n<p style=\"text-indent:0\">\u521d\u59cb\u5316\u6570\u636e\uff1a<\/p>\n<blockquote><p>\nuse test;<br \/>\nCREATE TABLE items(id INT,var1 VARCHAR(10));<br \/>\n#\u4f7f\u7528\u811a\u672c\u968f\u673a\u63d2\u5165\u7ea61000\u4e07\u6570\u636e\n<\/p><\/blockquote>\n<p style=\"text-indent:0\">\u4e0b\u8f7dXtraBackup\uff1a<\/p>\n<p><a href=\"http:\/\/www.percona.com\/mysql\/xtrabackup\/0.8\/source\/\">http:\/\/www.percona.com\/mysql\/xtrabackup\/0.8\/source\/<\/a><\/p>\n<p>\u8fd9\u91cc\u4e0b\u8f7d\u7684\u662f0.8\u7248\u672c\u7684\u6e90\u7801\u5305<\/p>\n<p style=\"text-indent:0\">\u4e0b\u8f7dMySQL\u6e90\u7801\u5305:<\/p>\n<p><a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#source\">http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#source<\/a><\/p>\n<p>\u56e0\u4e3a\u662f\u7f16\u8bd1\u5b89\u88c5XtraBackup\uff0c\u9700\u8981\u4f7f\u7528MySQL\u7684\u6e90\u4ee3\u7801<\/p>\n<p><a href=\"$clip_image0015.gif\"><img loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"clip_image001\" src=\"$clip_image001_thumb.gif\" border=\"0\" alt=\"clip_image001\" width=\"240\" height=\"1\" \/><\/a><\/p>\n<p style=\"text-indent:0\"><font size=4><b>\u4e8c\u3001 \u7f16\u8bd1\u5b89\u88c5<\/b><\/font><\/p>\n<p>\u4f60\u4e5f\u53ef\u4ee5\u4e0b\u8f7d\u5bf9\u5e94\u5e73\u53f0\u7684\u4e8c\u8fdb\u5236\u7248\u672cXtraBackup\uff0c\u514d\u53bb\u7f16\u8bd1\u5b89\u88c5\u7684\u6b65\u9aa4\uff0c\u4e0d\u8fc7\u76ee\u524d\u4e8c\u8fdb\u5236\u7248\u672c\u652f\u6301\u7684\u5e73\u53f0\u5e76\u4e0d\u591a\uff0c\u6240\u4ee5\u8fd9\u91cc\u5217\u51fa\u7f16\u8bd1\u7684\u6b65\u9aa4\u3002<\/p>\n<blockquote><p>\ntar zxvf mysql-5.0.85.tar.gz #\u89e3\u538b\u6e90\u7801\u5305<\/p>\n<p>tar zxvf xtrabackup-0.8-src.tar.gz #\u89e3\u538b\u6e90\u7801\u5305<\/p>\n<p>mv xtrabackup-0.8-src .\/mysql-5.0.85\/ innobase\/ #\u5c06XtraBackpu\u79fb\u5230InnoDB\u7684\u6e90\u7801\u76ee\u5f55<\/p>\n<p>#\u5982\u679c\u4f7f\u7528\u7684\u662fMySQL5.1\uff0c\u76ee\u5f55\u6539\u4e3a\/mysql-5.1.*\/ storage\/innobase\/<\/p>\n<p>cd mysql-5.0.85\/ innobase #\u8fdb\u5165\u6e90\u4ee3\u7801\u76ee\u5f55<\/p>\n<p>patch \u2013p2 &lt; . \/xtrabackup-0.8-src\/fix_innodb_for_backup.patch #\u7ed9InnoDB\u6e90\u7801\u6253\u4e0a\u8865\u4e01<\/p>\n<p>#\u5982\u679c\u4f7f\u7528\u7684\u662fMySQL5.1\uff0c\u4f7f\u7528fix_innodb_for_backup51.patch<\/p>\n<p>cd .. #\u8fdb\u5165\u76ee\u5f55mysql-5.0.85<\/p>\n<p>.\/configure<\/p>\n<p>make #\u6211\u4eec\u53ea\u9700\u8981Make\u5c31\u53ef\u4ee5\u4e86\uff0c\u4e0d\u9700\u8981Make install<\/p>\n<p>cd innobase\/xtrabackup-0.8-src<\/p>\n<p>make #\u7f16\u8bd1XtraBackup\uff1bMySQL5.1<a href=\"https:\/\/bugs.launchpad.net\/percona-xtrabackup\/+bug\/394374\">\u5fc5\u987b<\/a>\u8981\u4f7f\u7528XtraBackup0.9\n<\/p><\/blockquote>\n<p>\u7f16\u8bd1\u6210\u529f\u540e\uff0c\u6211\u4eec\u4f1a\u83b7\u5f97\u53ef\u6267\u884c\u6587\u4ef6xtrabackup\u3001innobackupex\u3002\u4e3a\u4e86\u65b9\u4fbf\u4f7f\u7528\uff0c\u5206\u522b\u5c06\u5176\u62f7\u8d1d\u5230\u67d0\u4e2a$PATH\u8def\u5f84\u4e0b\u3002\uff08\u6211\u8fd9\u91cc\/u01\/mysql\/bin\/\u662f$PATH\u8def\u5f84\u7684\u4e00\u90e8\u5206\uff09<\/p>\n<blockquote><p>\ncp xtrabackup \/u01\/mysql\/bin\/<\/p>\n<p>cp innobackupex-1.5.1 \/u01\/mysql\/bin\/\n<\/p><\/blockquote>\n<p>\u5b89\u88c5\u4e2d\u8981\u6ce8\u610f\u7684\u95ee\u9898\uff1a<\/p>\n<p>\u7f16\u8bd1XtraBackup\uff1bMySQL5.1<a href=\"https:\/\/bugs.launchpad.net\/percona-xtrabackup\/+bug\/394374\">\u5fc5\u987b<\/a>\u8981\u4f7f\u7528XtraBackup0.9\u3002<\/p>\n<p>\u53e6\u5916\uff0c\u4f7f\u7528MySQL5.1\u7f16\u8bd1\uff0c\u9700\u8981\u7b80\u5355\u7684\u4fee\u6539\u4e00\u4e0bXtraBackup\u7684Makefile:<\/p>\n<blockquote><p>\n#MySQL 5.0<\/p>\n<p>#INC= -I. -I.. -I.\/..\/include -I.\/..\/..\/include<\/p>\n<p>#INNODBOBJS=<\/p>\n<p>#MySQL 5.1<\/p>\n<p>INC= \u2026\u2026<\/p>\n<p>MYSQLOBJS=\n<\/p><\/blockquote>\n<p>\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u4f7f\u7528\u547d\u4ee4innobackupex\u6765\u5907\u4efd\u6211\u4eec\u7684\u6570\u636e\u5e93\u4e86\u3002<\/p>\n<p style=\"text-indent:0\"><font size=4><b>\u4e09\u3001 \u5907\u4efd<\/b><\/font><\/p>\n<p>XtraBackup\u4f7f\u7528\u811a\u672cinnobackupx-1.5.1\u6765\u5907\u4efd\u4f60\u7684\u6570\u636e\u5e93\u3002\u5173\u4e8einnobackupx-1.5.1\u7684\u8be6\u7ec6\u53c2\u6570\uff0c\u8bf7\u53c2\u8003<a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:xtrabackup_manual\">http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:xtrabackup_manual<\/a>\u3002\u8fd9\u91cc\u5217\u51fa\u6bd4\u8f83\u5e38\u7528\u7684\u5907\u4efd\u547d\u4ee4\uff1a\u666e\u901a\u5907\u4efd\u3001\u6253\u5305\uff08Tar\uff09\u5907\u4efd\u3001\u538b\u7f29\uff08Tar gzip\uff09\u5907\u4efd\u3002<\/p>\n<p>\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0cinnobackupex-1.5.1\u4f1a\u6839\u636e\u4f60\u7684\/etc\/my.cnf\u914d\u7f6e\uff0c\u6765\u786e\u5b9a\u4f60\u7684MySQL\u6570\u636e\u4f4d\u7f6e(datadir)\uff0c\u6240\u4ee5\u4f60\u5e76\u4e0d\u9700\u8981\u544a\u8bc9innobackupex-1.5.1\u4f60\u7684MySQL\u6570\u636e\u5728\u54ea\u513f\u3002<\/p>\n<p><font size=3>1. \u666e\u901a\u5907\u4efd<\/font><\/p>\n<blockquote><p>\ninnobackupex-1.5.1 &#45;&#45;user=root &#45;&#45;password=123 \/u01\/backup\/1\/innobackup\/ 2&gt;\/u01\/backup\/1\/1.log\n<\/p><\/blockquote>\n<p>\u5907\u4efd\u65f6\u95f43\u520638\u79d2\uff1b3G\u7684\u8868\u7a7a\u95f4,InnoDB Free 2595840 Kb\u3002<\/p>\n<p>\u8fd9\u91cc\u6211\u4eec\u4f7f\u7528mysql\u7684root\u7528\u6237\u5907\u4efd\uff0c\u5bc6\u7801\u4e3a123\u3002\u5907\u4efd\u7684\u76ee\u6807\u76ee\u5f55\uff08target dir\uff09\u662f\/u01\/backup\/1\/innobackup\/\uff0cinnobackupex-1.5.1\u5c06\u5728\u8be5\u76ee\u5f55\u4e0b\u751f\u6210\u5907\u4efd\u3002\u4f8b\u5982\/u01\/backup\/1\/innobackup\/2009-09-01_11-59-29\u5c31\u662f\u6211\u6267\u884c\u811a\u672c\u540e\u751f\u6210\u7684\u5907\u4efd\uff0c\u6240\u6709\u7684\u5907\u4efd\u6587\u4ef6\u90fd\u5728\u8be5.\/2009-09-01_11-59-29\u76ee\u5f55\u4e0b\u3002<\/p>\n<p>\u8fd9\u91cc\u76842&gt;\/u01\/backup\/1\/1.log\uff0c\u662f\u5c06\u5907\u4efd\u8fc7\u7a0b\u4e2d\u7684\u8f93\u51fa\u4fe1\u606f\u91cd\u5b9a\u5411\u52301.log\u3002\u53e6\u5916innobackupex-1.5.1\u8fd8\u652f\u6301\u589e\u91cf\u5907\u4efd\uff0c\u8fd9\u91cc\u5e76\u6ca1\u6709\u6d4b\u8bd5\u4f7f\u7528\u3002<\/p>\n<p>\u90a3\u5982\u4f55\u6062\u590d\u5462\uff1f\u4e3a\u4e86\u6a21\u62df\u6062\u590d\u8fc7\u7a0b\uff0c\u6211\u5148\u5c06MySQL\u505c\u6b62\uff0c\u5e76\u5220\u9664MySQL\u7684data\u76ee\u5f55\u4e0b\u6240\u6709\u6570\u636e\u6587\u4ef6\u3002<\/p>\n<blockquote><p>\ncd mysql\/data\/ ;rm \u2013rf *;<\/p>\n<p>innobackupex-1.5.1 &#45;&#45;apply-log \/u01\/backup\/1\/innobackup\/2009-09-01_11-59-29<\/p>\n<p>innobackupex-1.5.1 &#45;&#45;apply-log \/u01\/backup\/1\/innobackup\/2009-09-01_11-59-29<\/p>\n<p>innobackupex-1.5.1 &#45;&#45;copy-back \/u01\/backup\/1\/innobackup\/2009-09-01_11-59-29<\/p>\n<p>cd \/u01\/mysql\/data\/<\/p>\n<p>chown -R mysql:dba . #(\u8fd9\u65f6\u5019\u53ef\u80fd\u8fd8\u9700\u8981\u4fee\u6539datadir\u4fee\u6539\u6587\u4ef6\u7684\u6240\u6709\u8005)\n<\/p><\/blockquote>\n<p>\u547d\u4ee4innobackupex-1.5.1\u9700\u8981\u6307\u5b9a\u5177\u4f53\u54ea\u4e2a\u5907\u4efd\u76ee\u5f55\uff0c\u5148\u5e94\u7528\u5907\u4efdlog\uff0c\u7136\u540ecopy back\u3002\u8fd9\u91cc\u7684\u5907\u4efd\u76ee\u5f55\u662f\/u01\/backup\/1\/innobackup\/2009-09-01_11-59-29\u3002\u6062\u590d\u65f6\u95f4\u7ea63\u5206\u949f\u3002<\/p>\n<p>\u503c\u5f97\u4e00\u63d0\u7684\u662f\uff0c\u9ed8\u8ba4innobackupex-1.5.1\u4f1a\u5c06\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4fe1\u606f\u5b58\u653e\u5728\u6587\u4ef6xtrabackup_binlog_info\u4e2d\u53d1\uff08\u65b9\u4fbf\u505aSlave\uff09\u3002<\/p>\n<p>innobackupex-1.5.1\u4f1a\u6839\u636e\/et\/my.cnf\u6765\u786e\u5b9aMySQL\u7684\u6570\u636e\u4f4d\u7f6e\u3002<\/p>\n<p><font size=3>2. \u6253\u5305(Tar)\u5907\u4efd<\/font><\/p>\n<p>\u8fd9\u91cc\u57fa\u672c\u548c\u524d\u9762\u7684\u666e\u901a\u5907\u4efd\u7c7b\u4f3c\uff0c\u5c31\u4e0d\u505a\u8be6\u7ec6\u8bf4\u660e\u4e86\uff0c\u4e4b\u5217\u51fa\u5bf9\u5e94\u7684\u547d\u4ee4\u3002\u503c\u5f97\u4e00\u63d0\u7684\u662f\uff0c\u6062\u590d\u89e3\u538b\u7f29\u65f6\uff0c\u5fc5\u987b\u4f7f\u7528-i\u53c2\u6570\u3002<\/p>\n<blockquote><p>\ninnobackupex-1.5.1 &#45;&#45;user=root &#45;&#45;password=123 &#45;&#45;stream=tar \/u01\/backup\/2\/ 2&gt;\/u01\/backup\/2.log 1&gt;\/u01\/backup\/2\/2.tar\n<\/p><\/blockquote>\n<p>\u5927\u7ea62\u520655\u79d2\u3002\u8fd9\u91cc\u4f7f\u75281&gt;\u505a\u6807\u51c6\u8f93\u51fa\u91cd\u5b9a\u5411\u3002<\/p>\n<p>\u6062\u590d\uff1a<\/p>\n<blockquote>\n<p>tar \u2013ixvf 2.tar #\u89e3\u538b\u538b\u7f29 \u8fd9\u91cc-i\u53c2\u6570\u662f\u5fc5\u987b\u7684\u3002<\/p>\n<p>innobackupex-1.5.1 &#45;&#45;apply-log \/u01\/backup\/2\/innobackup<\/p>\n<p>innobackupex-1.5.1 &#45;&#45;copy-back \/u01\/backup\/2\/innobackup<\/p>\n<p>cd \/u01\/mysql\/data\/<\/p>\n<p>chown -R mysql:dba . #(\u8fd9\u65f6\u5019\u53ef\u80fd\u8fd8\u9700\u8981\u4fee\u6539datadir\u4fee\u6539\u6587\u4ef6\u7684\u6240\u6709\u8005)<\/p>\n<p>mysqld_safe &#45;&#45;user=mysql &amp;\n<\/p><\/blockquote>\n<p><font size=3>3. \u538b\u7f29(tar gzip)\u5907\u4efd<\/font><\/p>\n<blockquote><p>\ninnobackupex-1.5.1 &#45;&#45;user=root &#45;&#45;password=123 &#45;&#45;stream=tar \/u01\/backup\/1\/ 2&gt;\/u01\/backup\/2.log | gzip &gt; \/u01\/backup\/1\/1.tar.gz\n<\/p><\/blockquote>\n<p>\u5927\u7ea63\u5206\u949f\u3002\u8fd9\u91cc\u4f7f\u7528\u4e86\u7ba1\u9053|\u5c06innobackupex-1.5.1\u4f5c\u4e3agzip\u7684\u6807\u51c6\u8f93\u5165\u3002\u5b83\u7684\u6062\u590d\u8fc7\u7a0b\uff0c\u53ea\u9700\u8981\u4f7f\u7528tar \u2013izxvf \u89e3\u538b\u5bf9\u5e94\u7684\u6587\u4ef6\u540e\uff0c\u64cd\u4f5c\u5b8c\u5168\u540c\u666e\u901a\u5907\u4efd\u3002<\/p>\n<p style=\"text-indent:0\"><font size=4><b>\u56db\u3001 \u5173\u4e8eXtraBackup<\/b><\/font><\/p>\n<p>XtraBackup\u8fd8\u5728\u5feb\u901f\u7684\u6210\u957f\u9636\u6bb5\uff0c\u7531<a href=\"http:\/\/www.percona.com\/\">http:\/\/www.percona.com\/<\/a>\u7ef4\u62a4\u3002\u8fd9\u91cc\u5217\u51fa\u4e00\u4e9b\u76f8\u5173\u8d44\u6e90:<\/p>\n<ul>\n<li>\n\u4e3b\u9875\uff1a <a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:start\">http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:start<\/a><\/li>\n<li>Google Group: <a href=\"http:\/\/groups.google.com\/group\/percona-discussion?hl=en\">http:\/\/groups.google.com\/group\/percona-discussion?hl=en<\/a><\/li>\n<li>Launchpad: <a href=\"https:\/\/launchpad.net\/percona-xtrabackup\">https:\/\/launchpad.net\/percona-xtrabackup<\/a><\/li>\n<li>Manual <a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:xtrabackup_manual\">http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:xtrabackup_manual<\/a><\/li>\n<li>Ningoo.net:\n<p><a href=\"http:\/\/www.ningoo.net\/html\/2009\/using_xtrabackup_backup_mysql_database.html\">http:\/\/www.ningoo.net\/html\/2009\/using_xtrabackup_backup_mysql_database.html<\/a><\/li>\n<\/ul>\n<p>\u53c2\u8003\u6587\u732e<\/p>\n<ol>\n<li><a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:start\">http:\/\/www.percona.com\/docs\/wiki\/percona-xtrabackup:start<\/a><\/li>\n<li><a href=\"http:\/\/www.ningoo.net\/html\/2009\/using_xtrabackup_backup_mysql_database.html\">http:\/\/www.ningoo.net\/html\/2009\/using_xtrabackup_backup_mysql_database.html<\/a><\/li>\n<li><a href=\"http:\/\/www.innodb.com\/doc\/hot_backup\/manual.html#innobackup\">http:\/\/www.innodb.com\/doc\/hot_backup\/manual.html#innobackup<\/a><\/li>\n<li><a href=\"http:\/\/www.ibm.com\/developerworks\/cn\/linux\/l-diffp\/index.html\">http:\/\/www.ibm.com\/developerworks\/cn\/linux\/l-diffp\/index.html<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u4f5c\u8005\uff1a \u6765\u81ea\uff1aTaobaoDBA 2009\u5e749\u67082\u65e5\u661f\u671f\u4e09 \u6458\u8981\uff1a\u672c\u6587\u4ecb\u7ecd\u4e86XtraBackup\u7684\u5b89\u88c5\uff08\u7f16\u8bd1\u5b89\u88c5\uff09\u548c\u4f7f\u7528\u3002Xtrabackup\u662f\u4e00\u4e2a\u5bf9InnoDB\u505a\u6570\u636e\u5907\u4efd\u7684\u5de5\u5177\uff0c\u652f\u6301\u5728\u7ebf\u70ed\u5907\u4efd\uff08\u5907\u4efd\u65f6\u4e0d\u5f71\u54cd\u6570\u636e\u8bfb\u5199\uff09\uff0c\u662f\u5546\u4e1a\u5907\u4efd\u5de5\u5177InnoDB Hotbackup\u7684\u4e00\u4e2a\u5f88\u597d\u7684\u66ff\u4ee3\u54c1\u3002\u672c\u6587\u6d4b\u8bd5\u4f7f\u7528\u7684\u662f0.8\u7248\u672c\uff0c\u4e0e\u5f53\u524d\u6700\u65b0\u7248\u672c\u662f0.9\u533a\u522b\u5e76\u4e0d\u5927\u3002Xtrabackup\u6709\u4e24\u4e2a\u4e3b\u8981\u7684\u5de5\u5177\uff1axtrabackup\u3001innobackupex\uff0c\u5176\u4e2dxtrabackup\u53ea\u80fd\u5907\u4efdInnoDB\u548cXtraDB\u4e24\u79cd\u6570\u636e\u8868\uff0cinnobackupex\u5219\u5c01\u88c5\u4e86xtrabackup\uff0c\u540c\u65f6\u53ef\u4ee5\u5907\u4efdMyISAM\u6570\u636e\u8868\u3002\u672c\u6587\u4ec5\u4ec5\u4ecb\u7ecd\u4e86innobackupex\u7684\u5907\u4efd\u548c\u6062\u590d\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[6,4],"tags":[29],"class_list":["post-708","post","type-post","status-publish","format-standard","hentry","category-mysql","category-code-detail","tag-xtrabackup"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=708"}],"version-history":[{"count":30,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/708\/revisions"}],"predecessor-version":[{"id":756,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/708\/revisions\/756"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}