{"id":5197,"date":"2021-11-24T17:48:43","date_gmt":"2021-11-24T09:48:43","guid":{"rendered":"http:\/\/blog.ywdevops.cn\/?p=5197"},"modified":"2024-09-12T15:22:22","modified_gmt":"2024-09-12T07:22:22","slug":"xtrabackup","status":"publish","type":"post","link":"https:\/\/blog.ywdevops.cn\/index.php\/2021\/11\/24\/xtrabackup\/","title":{"rendered":"xtrabackup\u5907\u4efdmysql(pxb)"},"content":{"rendered":"\n<p class=\"has-medium-font-size wp-block-paragraph\">\u4e00\u3001<strong>Xtrabackup\u4ecb\u7ecd<\/strong>\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> <a rel=\"noreferrer noopener\" href=\"https:\/\/www.percona.com\/software\/mysql-database\/percona-xtrabackup\" target=\"_blank\">Percona XtraBackup<\/a>\uff08\u7b80\u79f0PXB\uff09 \u662f Percona\u516c\u53f8\u5f00\u53d1\u7684\u4e00\u4e2a\u7528\u4e8eMySQL\u6570\u636e\u5e93\u7269\u7406\u70ed\u5907\u7684\u5907\u4efd\u5de5\u5177\uff0c\u652f\u6301MySQL\u3001Percona server\u548cMariaDB\uff0c\u5f00\u6e90\u514d\u8d39\uff0c\u662f\u76ee\u524d\u8f83\u4e3a\u53d7\u6b22\u8fce\u7684\u4e3b\u6d41\u5907\u4efd\u5de5\u5177\u3002xtrabackup\u53ea\u80fd\u5907\u4efdinnoDB\u548cxtraDB\u4e24\u79cd\u6570\u636e\u5f15\u64ce\u7684\u8868\uff0c\u800c<strong>\u4e0d\u80fd\u5907\u4efdMyISAM\u6570\u636e\u8868<\/strong>\u3002 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL\u51b7\u5907\u3001mysqldump\u3001MySQL\u70ed\u62f7\u8d1d\u90fd\u65e0\u6cd5\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u589e\u91cf\u5907\u4efd\uff0c \u5728\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u4e2d\u589e\u91cf\u5907\u4efd\u662f\u975e\u5e38\u5b9e\u7528\u7684\uff0c\u5982\u679c\u6570\u636e\u5927\u4e8e50G\u6216100G\uff0c\u5b58\u50a8\u7a7a\u95f4\u8db3\u591f\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u6bcf\u5929\u8fdb\u884c\u5b8c\u6574\u5907\u4efd\uff0c\u5982\u679c\u6bcf\u5929\u4ea7\u751f\u7684\u6570\u636e\u91cf\u8f83\u5927\uff0c\u9700\u8981\u5b9a\u5236\u6570\u636e\u5907\u4efd\u7b56\u7565\u3002\u4f8b\u5982\u6bcf\u5468\u5b9e\u7528\u5b8c\u6574\u5907\u4efd\uff0c\u5468\u4e00\u5230\u5468\u516d\u5b9e\u7528\u589e\u91cf\u5907\u4efd\u3002\u800cPercona-Xtrabackup\u5c31\u662f\u4e3a\u4e86\u5b9e\u73b0\u589e\u91cf\u5907\u4efd\u800c\u51fa\u73b0\u7684\u4e00\u6b3e\u4e3b\u6d41\u5907\u4efd\u5de5\u5177\uff0cxtrabakackup\u67092\u4e2a\u5de5\u5177\uff0c\u5206\u522b\u662fxtrabakup\u3001innobackupex\u3002 <\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u4e8c\u3001<strong>Xtrabackup\u4f18\u70b9<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li> \u5907\u4efd\u901f\u5ea6\u5feb\uff0c\u7269\u7406\u5907\u4efd\u53ef\u9760 <\/li>\n\n\n\n<li> \u5907\u4efd\u8fc7\u7a0b\u4e0d\u4f1a\u6253\u65ad\u6b63\u5728\u6267\u884c\u7684\u4e8b\u52a1\uff08\u65e0\u9700\u9501\u8868\uff09 <\/li>\n\n\n\n<li> \u80fd\u591f\u57fa\u4e8e\u538b\u7f29\u7b49\u529f\u80fd\u8282\u7ea6\u78c1\u76d8\u7a7a\u95f4\u548c\u6d41\u91cf <\/li>\n\n\n\n<li> \u81ea\u52a8\u5907\u4efd\u6821\u9a8c <\/li>\n\n\n\n<li> \u8fd8\u539f\u901f\u5ea6\u5feb <\/li>\n\n\n\n<li> \u53ef\u4ee5\u6d41\u4f20\u5c06\u5907\u4efd\u4f20\u8f93\u5230\u53e6\u5916\u4e00\u53f0\u673a\u5668\u4e0a <\/li>\n\n\n\n<li> \u5728\u4e0d\u589e\u52a0\u670d\u52a1\u5668\u8d1f\u8f7d\u7684\u60c5\u51b5\u5907\u4efd\u6570\u636e <\/li>\n<\/ul>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u4e09\u3001<strong>Xtrabackup\u5907\u4efd\u539f\u7406<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"821\" height=\"869\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/10\/1-2.png\" alt=\"\" class=\"wp-image-5200\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/10\/1-2.png 821w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/10\/1-2-283x300.png 283w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/10\/1-2-768x813.png 768w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/10\/1-2-567x600.png 567w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>\uff081\uff09innobackupex\u542f\u52a8\u540e\uff0c\u4f1a\u5148fork\u4e00\u4e2a\u8fdb\u7a0b\uff0c\u7528\u4e8e\u542f\u52a8xtrabackup\uff0c\u7136\u540e\u7b49\u5f85xtrabackup\u5907\u4efdibd\u6570\u636e\u6587\u4ef6\uff1b\n\n\uff082\uff09xtrabackup\u5728\u5907\u4efdinnoDB\u6570\u636e\u662f\uff0c\u67092\u79cd\u7ebf\u7a0b\uff1aredo\u62f7\u8d1d\u7ebf\u7a0b\u548cibd\u6570\u636e\u62f7\u8d1d\u7ebf\u7a0b\u3002xtrabackup\u8fdb\u7a0b\u5f00\u59cb\u6267\u884c\u540e\uff0c\u4f1a\u542f\u52a8\u4e00\u4e2aredo\u62f7\u8d1d\u7684\u7ebf\u7a0b\uff0c\u7528\u4e8e\u4ece\u6700\u65b0\u7684checkpoint\u70b9\u5f00\u59cb\u987a\u5e8f\u62f7\u8d1dredo.log\uff1b\u518d\u542f\u52a8ibd\u6570\u636e\u62f7\u8d1d\u7ebf\u7a0b\uff0c\u8fdb\u884c\u62f7\u8d1dibd\u6570\u636e\u3002\u8fd9\u91cc\u662f\u5148\u542f\u52a8redo\u62f7\u8d1d\u7ebf\u7a0b\u7684\u3002\u5728\u6b64\u9636\u6bb5\uff0cinnobackupex\u8fdb\u884c\u5904\u4e8e\u7b49\u5f85\u72b6\u6001\uff08\u7b49\u5f85\u6587\u4ef6\u88ab\u521b\u5efa\uff09\n\n\uff084\uff09xtrabackup\u62f7\u8d1d\u5b8c\u6210ibd\u6570\u636e\u6587\u4ef6\u540e\uff0c\u4f1a\u901a\u77e5innobackupex\uff08\u901a\u8fc7\u521b\u5efa\u6587\u4ef6\uff09\uff0c\u540c\u65f6xtrabackup\u8fdb\u5165\u7b49\u5f85\u72b6\u6001\uff08redo\u7ebf\u7a0b\u4f9d\u65e7\u5728\u62f7\u8d1dredo.log\uff09\n\n\uff085\uff09innobackupex\u6536\u5230xtrabackup\u901a\u77e5\u540e\u54e6\uff0c\u6267\u884cFLUSH TABLES WITH READ LOCK\uff08FTWRL\uff09\uff0c\u53d6\u5f97\u4e00\u81f4\u6027\u4f4d\u70b9\uff0c\u7136\u540e\u5f00\u59cb\u5907\u4efd\u975eInnoDB\u6587\u4ef6\uff08\u5982frm\u3001MYD\u3001MYI\u3001CSV\u3001opt\u3001par\u7b49\u683c\u5f0f\u7684\u6587\u4ef6\uff09\uff0c\u5728\u62f7\u8d1d\u975eInnoDB\u6587\u4ef6\u7684\u8fc7\u7a0b\u5f53\u4e2d\uff0c\u6570\u636e\u5e93\u5904\u4e8e\u5168\u5c40\u53ea\u8bfb\u72b6\u6001\u3002\n\n\uff086\uff09\u5f53innobackup\u62f7\u8d1d\u5b8c\u6240\u6709\u7684\u975eInnoDB\u6587\u4ef6\u540e\uff0c\u4f1a\u901a\u77e5xtrabackup\uff0c\u901a\u77e5\u5b8c\u6210\u540e\uff0c\u8fdb\u5165\u7b49\u5f85\u72b6\u6001\uff1b\n\n\uff087\uff09xtrabackup\u6536\u5230innobackupex\u5907\u4efd\u5b8c\u6210\u7684\u901a\u77e5\u540e\uff0c\u4f1a\u505c\u6b62redo\u62f7\u8d1d\u7ebf\u7a0b\uff0c\u7136\u540e\u901a\u77e5innobackupex\uff0credo.log\u6587\u4ef6\u62f7\u8d1d\u5b8c\u6210\uff1b\n\n\uff088\uff09innobackupex\u6536\u5230redo.log\u5907\u4efd\u5b8c\u6210\u540e\uff0c\u5c31\u8fdb\u884c\u89e3\u9501\u64cd\u4f5c\uff0c\u6267\u884c\uff1aUNLOCK TABLES\uff1b\n\n\uff089\uff09\u6700\u540einnbackupex\u548cxtrabackup\u8fdb\u7a0b\u5404\u81ea\u91ca\u653e\u8d44\u6e90\uff0c\u5199\u5907\u4efd\u5143\u6570\u636e\u4fe1\u606f\u7b49\uff0cinnobackupex\u7b49xtrabackup\u5b50\u8fdb\u7a0b\u7ed3\u675f\u540e\u9000\u51fa\u3002<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u56db\u3001<strong>xtrabackup\u7684\u5b89\u88c5\u90e8\u7f72<\/strong>\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001xtrabackup\u7684\u5b89\u88c5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u6267\u884c\u4e0b\u9762\u547d\u4ee4\u4e0b\u8f7d\u8f6f\u4ef6\u5305\uff0c\u5e76\u5b89\u88c5\n\u4e0b\u8f7d\uff1awget https:\/\/www.percona.com\/downloads\/XtraBackup\/Percona-XtraBackup-2.4.9\/binary\/redhat\/7\/x86_64\/percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm\n\u5b89\u88c5\uff1ayum install -y percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpm\n\u67e5\u770b\u662f\u5426\u5b89\u88c5\u6210\u529f\uff1arpm -qa | grep xtrabackup<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e8c\u8fdb\u5236\u5305\u4f4d\u7f6e\uff1ahttps:\/\/github.com\/percona<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Xtrabackup\u4e2d\u4e3b\u8981\u5305\u542b\u4e24\u4e2a\u5de5\u5177\uff1a\nxtrabackup\uff1a\u662f\u7528\u4e8e\u70ed\u5907innodb\uff0cxtradb\u8868\u4e2d\u6570\u636e\u7684\u5de5\u5177\uff0c\u4e0d\u80fd\u5907\u4efd\u5176\u4ed6\u7c7b\u578b\u7684\u8868\uff0c\u4e5f\u4e0d\u80fd\u5907\u4efd\u6570\u636e\u8868\u7ed3\u6784\uff1b\ninnobackupex\uff1a\u662f\u5c06xtrabackup\u8fdb\u884c\u5c01\u88c5\u7684perl\u811a\u672c\uff0c\u63d0\u4f9b\u4e86\u5907\u4efdmyisam\u8868\u7684\u80fd\u529b\u3002\n\n\u5e38\u7528\u9009\u9879\uff1a\n1\u3001 --host: \u6307\u5b9a\u4e3b\u673a\n2\u3001 --user: \u6307\u5b9a\u7528\u6237\u540d\n3\u3001 --password\uff1a \u6307\u5b9a\u5bc6\u7801\n4\u3001 --port:  \u6307\u5b9a\u7aef\u53e3\n5\u3001 --database: \u6307\u5b9a\u6570\u636e\u5e93\n6\u3001 --incremental: \u521b\u5efa\u589e\u91cf\u5907\u4efd\n7\u3001 --incremental-basedir: \u6307\u5b9a\u5305\u542b\u5b8c\u6574\u5907\u4efd\u7684\u76ee\u5f55\n8\u3001 --incremental-dir:   \u6307\u5b9a\u5305\u542b\u589e\u91cf\u5907\u4efd\u7684\u76ee\u5f55\n9\u3001 --apply-log:  \u5bf9\u5907\u4efd\u8fdb\u884c\u9884\u5904\u7406\u64cd\u4f5c<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u521b\u5efa\u4e00\u4e2a\u6700\u5c0f\u6743\u9650\u7684\u5907\u4efd\u7528\u6237\u8fdb\u884c\u5907\u4efd\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create user 'bkuser'@'localhost' identified by \"bk123456\";   #\u521b\u5efa\u7528\u6237\nflush privileges;    #\u5237\u65b0\u6388\u6743\u8868\nrevoke all privileges,grant option  from 'bkuser'@'localhost'; #\u56de\u6536\u6b64\u7528\u6237\u6240\u6709\u6743\u9650\nflush privileges;   #\u5237\u65b0\u6388\u6743\u8868\ngrant reload,lock tables,replication client,process ON *.* TO 'bkuser'@'localhost';  #\u6388\u6743\u5237\u65b0\u3001\u9501\u8868\u3001\u67e5\u770b\u670d\u52a1\u5668\u72b6\u6001\u3001\u8fdb\u7a0b\u7684\u6743\u9650\nflush privileges;     #\u5237\u65b0\u6388\u6743\u8868<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>\u4e94\u3001\u5907\u4efd\uff1a<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001 \u5907\u4efd\u6240\u6709\u6570\u636e\u5e93\uff1a\u5907\u4efd\u76ee\u5f55\u91cc\u751f\u6210\u65e5\u671f\u547d\u540d\u7684\u6587\u4ef6\u5939 \uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock \/data\/backup\/\n#\u4e0a\u8ff0\u547d\u4ee4\u8868\u793a\u5728\u672c\u673a\u6267\u884c\u7684\n# --defaults-file\uff1a\u6307\u5b9a\u6570\u636e\u5e93\u914d\u7f6e\u4fe1\u606f\uff0c\u975e\u5fc5\u987b\uff0c\u5982\u679c\u4e0d\u5199\u8981\u5199\u8be6\u7ec6\u7684\u6570\u636e\u5e93\u4fe1\u606f\n# \/data\/backup\u8868\u793a\u5907\u4efd\u7684\u4f4d\u7f6e<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"216\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/28.png\" alt=\"\" class=\"wp-image-5721\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/28.png 623w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/28-300x104.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/28-600x208.png 600w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">innobackupex\u4f1a\u5728\u6307\u5b9a\u5b58\u653e\u6570\u636e\u7684\u76ee\u5f55\u4e0b\u7528\u5f53\u524d\u65f6\u95f4\u521b\u5efa\u4e00\u4e2a\u76ee\u5f55\uff0c\u6240\u6709\u751f\u6210\u7684\u5907\u4efd\u6587\u4ef6\u90fd\u4f1a\u8fd9\u4e2a\u65f6\u95f4\u76ee\u5f55\u4e0b \uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"561\" height=\"354\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/29.png\" alt=\"\" class=\"wp-image-5722\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/29.png 561w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/29-300x189.png 300w\" sizes=\"auto, (max-width: 561px) 100vw, 561px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001 \u5907\u4efd\u6240\u6709\u6570\u636e\u5e93\uff0c\u6307\u5b9a\u76ee\u5f55\u7684\u540d\u79f0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5907\u4efd\u65f6\uff0c\u901a\u8fc7\u53c2\u6570 &#8211;no-timestamp \u6765\u963b\u6b62\u547d\u4ee4\u81ea\u52a8\u521b\u5efa\u4e00\u4e2a\u4ee5\u65f6\u95f4\u547d\u540d\u7684\u76ee\u5f55(no\u524d\u9762\u662f\u53cc\u6a2a\u6760)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u6ce8\u610f\uff1a\u6bcf\u4e00\u4e2a\u53c2\u6570\u524d\u9762\u90fd\u662f\u53cc\u6a2a\u6760\ninnobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --no-timestamp \/data\/backup\/linshi\n#\u6b64\u547d\u4ee4\u6267\u884c\u540e\uff0c\u5c06\u4f1a\u521b\u5efalinshi\u6587\u4ef6\u5939\u7528\u4e8e\u5b58\u653e\u5907\u4efd\u6587\u4ef6\u800c\u4e0d\u662f\u65f6\u95f4\u547d\u4ee4\u7684\u76ee\u5f55<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"354\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/30.png\" alt=\"\" class=\"wp-image-5726\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/30.png 558w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/30-300x190.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001\u5907\u4efd\u6240\u6709\u6570\u636e\u5e93\u5e76\u6253\u5305\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u6267\u884c\u6b64\u547d\u4ee4\u540e\uff0c\u4f1a\u5728backup\u76ee\u5f55\u4e0b\u76f4\u63a5\u751f\u6210\u6253\u5305\u540e\u7684\u6587\u4ef6\ninnobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456  --socket=\/tmp\/mysql.sock --stream=tar --no-timestamp \/data\/backup 1&gt; \/data\/backup\/backup.tar\n#\u6ce8\u610f\u53c2\u6570--stream=tar<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"176\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/31.png\" alt=\"\" class=\"wp-image-5728\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/31.png 551w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/31-300x96.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4\u3001\u5907\u4efd\u6240\u6709\u6570\u636e\u5e93\uff0c\u538b\u7f29\u6253\u5305\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --stream=tar --no-timestamp \/data\/backup | gzip &gt; \/data\/backup\/backup.tar.gz<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"174\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/32.png\" alt=\"\" class=\"wp-image-5731\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/32.png 555w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/32-300x94.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5\u3001\u5907\u4efd\u6240\u6709\u6570\u636e\u5e93\u5230\u8fdc\u7a0b\u5e76\u538b\u7f29\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --stream=tar  \/data\/backup | ssh root@192.168.153.129 \"gzip &gt; \/data\/backup\/backup.tar.gz\"\n#\u6ce8\u610f\uff1a\u9700\u8981\u63d0\u524d\u5f00\u901a\u5230\u8fdc\u7a0b\u673a\u5668\u7684\u514d\u5bc6<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"166\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/33.png\" alt=\"\" class=\"wp-image-5734\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/33.png 549w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/33-300x91.png 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6\u3001\u5907\u4efd\u6307\u5b9a\u6570\u636e\u5e93\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --databases=\"n9e_ams n9e_hbs\" --no-timestamp  \/data\/backup\/ams_hbs_database\n#--databases\uff1a\u6307\u5b9a\u6570\u636e\u5e93\uff0c\u4e0a\u8ff0\u547d\u4ee4\u5c06\u5907\u4efdn9e_ams\u548cn9e_hbs\u4e24\u4e2a\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"225\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/34.png\" alt=\"\" class=\"wp-image-5736\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/34.png 558w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/34-300x121.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7\u3001\u5907\u4efd\u4e0d\u540c\u5e93\u4e0b\u7684\u4e0d\u540c\u8868:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --databases=\"n9e_ams.host n9e_hbs.instance\" --no-timestamp  \/data\/backup\/ams_hbs_tables\n#\u8fd8\u662f\u901a\u8fc7--databases\u53c2\u6570\uff0c\u4e0a\u8ff0\u547d\u4ee4\u8868\u793a\u5907\u4efdn9e_ams\u5e93\u4e0b\u7684host\u8868\u548cn9e_hbs\u5e93\u4e0b\u7684instance\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"233\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/35.png\" alt=\"\" class=\"wp-image-5740\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/35.png 531w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/35-300x132.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8\u3001\u5907\u4efd\u4e00\u4e2a\u5e93\u4e0b\u4ee5\u67d0\u4e2a\u5b57\u6bcd\u5f00\u5934\u7684\u8868\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456 --socket=\/tmp\/mysql.sock --include=\"n9e_mon.s\" --no-timestamp  \/data\/backup\/ams_mon_tables\n#--include: \u4f7f\u7528\u5339\u914d\u6b63\u5219\u8868\u8fbe\u5f0f\u5339\u914d\u8868\u540d\uff0c\u4e0a\u8ff0\u547d\u4ee4\u8868\u793a\u5907\u4efdn9e_mon\u5e93\u4e0b\u7684s\u5f00\u5934\u7684\u8868<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"232\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/36-1.png\" alt=\"\" class=\"wp-image-5743\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/36-1.png 535w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/36-1-300x130.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">9\u3001\u589e\u91cf\u5907\u4efd\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456  --no-timestamp --incremental-basedir=\/data\/backup\/linshi --incremental \/data\/backup\/increment_data\n#--incremental-basedir\uff1a\u5168\u91cf\u5907\u4efd\u76ee\u5f55\n#--incremental\uff1a\u589e\u91cf\u5907\u4efd\u76ee\u5f55<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"> <strong>\u516d\u3001\u8fd8\u539f\uff1a<\/strong> <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5907\u4efd\u5b8c\u6210\u540e\uff0c\u6570\u636e\u5c1a\u4e14\u4e0d\u80fd\u7528\u4e8e\u6062\u590d\u64cd\u4f5c\uff0c\u56e0\u4e3a\u5907\u4efd\u7684\u6570\u636e\u4e2d\u53ef\u80fd\u4f1a\u5305\u542b\u5c1a\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1\u6216\u5df2\u7ecf\u63d0\u4ea4\u4f46\u5c1a\u672a\u540c\u6b65\u81f3\u6570\u636e\u6587\u4ef6\u4e2d\u7684\u4e8b\u52a1\u3002\u56e0\u6b64\uff0c\u6b64\u65f6\u6570\u636e\u6587\u4ef6\u4ecd\u5904\u7406\u4e0d\u4e00\u81f4\u72b6\u6001\u3002  \u5229\u7528 &#8211;apply-log\u53c2\u6570\uff0c\u6b64\u53c2\u6570\u901a\u8fc7\u56de\u6eda\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1\u53ca\u540c\u6b65\u5df2\u7ecf\u63d0\u4ea4\u7684\u4e8b\u52a1\u81f3\u6570\u636e\u6587\u4ef6\u4f7f\u6570\u636e\u6587\u4ef6\u5904\u4e8e\u4e00\u81f4\u6027\u72b6\u6001 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001\u9996\u5148\u67e5\u770b\u4e00\u4e2a\u5b8c\u6574\u7684\u5907\u4efd\u6587\u4ef62021-11-25_11-52-35\u4e2d\u7684xtrabackup_checkpoints\u6587\u4ef6\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"553\" height=\"181\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/37-2.png\" alt=\"\" class=\"wp-image-5748\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/37-2.png 553w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/37-2-300x98.png 300w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --apply-log 2021-11-25_11-52-35\/\n#\u6267\u884c\u5b8c\u6210\u540e\uff0cbackup-type\u5c06\u53d8\u6210full-prepared\uff0c\u4e4b\u524d\u662ffull-backuped\u7684\u72b6\u6001<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001\u518d\u6b21\u67e5\u770b xtrabackup_checkpoints \uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"127\" src=\"http:\/\/www.gycysygg.icu\/wp-content\/uploads\/2021\/11\/38-2.png\" alt=\"\" class=\"wp-image-5749\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/38-2.png 551w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2021\/11\/38-2-300x69.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong> \u5168\u91cf\u8fd8\u539f\uff1a<\/strong> <\/p>\n\n\n\n<p class=\"has-luminous-vivid-amber-background-color has-background wp-block-paragraph\">\u6ce8\uff1a \u8fd8\u539f\u65f6\uff0cmysql\u670d\u52a1\u5668\u9700\u8981\u5173\u95ed\uff0c\u800c\u4e14\u6570\u636e\u76ee\u5f55\u5fc5\u987b\u662f\u7a7a\u7684\uff0cinnobackupex \u2013copy-back\u4e0d\u4f1a\u8986\u76d6\u5df2\u5b58\u5728\u7684\u6587\u4ef6 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001\u505c\u6b62myql:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/init.d\/mysqld stop<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u6e05\u7a7a\u6570\u636e\u76ee\u5f55\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/data\/mysql\/data\/*<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001\u8fd8\u539f\u6570\u636e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --defaults-file=\/etc\/my.cnf --copy-back \/data\/backup\/2021-11-25_11-52-35\/\n#--defaults-file: \u6307\u5b9a\u4e86\u4ece\u54ea\u4e2a\u6587\u4ef6\u8bfb\u53d6MySQL\u914d\u7f6e\n#--copy-back: \u6570\u636e\u6062\u590d\u65f6\u5c06\u5907\u4efd\u6570\u636e\u6587\u4ef6\u62f7\u8d1d\u5230MySQL\u670d\u52a1\u5668\u7684datadir<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u9664\u4e86&#8211;copy-back\uff0c\u8fd8\u53ef\u4ee5\u7528&#8211;move-back\uff0c\u533a\u522b\u5982\u4e0b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>--copy-back<\/code>\u53c2\u6570\u4f1a\u5c06\u5907\u4efd\u76ee\u5f55\u4e2d\u7684\u6240\u6709\u6587\u4ef6\u590d\u5236\u5230\u5b83\u4eec\u5728\u6570\u636e\u76ee\u5f55\u4e2d\u7684\u539f\u59cb\u4f4d\u7f6e\u3002\u8fd9\u4e2a\u8fc7\u7a0b\u4e0d\u4f1a\u5220\u9664\u76ee\u6807\u76ee\u5f55\u4e2d\u5df2\u5b58\u5728\u7684\u6587\u4ef6\uff0c\u800c\u662f\u4f1a\u8986\u76d6\u5b83\u4eec\u3002\u8fd9\u4e2a\u53c2\u6570\u901a\u5e38\u5728\u6570\u636e\u76ee\u5f55\u4e3a\u7a7a\u6216\u8005\u4e0d\u9700\u8981\u4fdd\u7559\u73b0\u6709\u6587\u4ef6\u65f6\u4f7f\u7528\u3002\u4f7f\u7528<code>--copy-back<\/code>\u65f6\uff0c\u5907\u4efd\u6587\u4ef6\u5728\u590d\u5236\u540e\u4ecd\u7136\u4fdd\u7559\u5728\u5907\u4efd\u76ee\u5f55\u4e2d\uff0c\u76f4\u5230\u624b\u52a8\u5220\u9664<\/li>\n\n\n\n<li><code>--move-back<\/code>\u53c2\u6570\u4e0e<code>--copy-back<\/code>\u7c7b\u4f3c\uff0c\u4f46\u5b83\u4f1a\u5c06\u5907\u4efd\u6587\u4ef6\u4ece\u5907\u4efd\u76ee\u5f55\u79fb\u52a8\u5230\u6570\u636e\u76ee\u5f55\uff0c\u800c\u4e0d\u662f\u590d\u5236\u3002\u8fd9\u610f\u5473\u7740\u5907\u4efd\u6587\u4ef6\u5728\u79fb\u52a8\u540e\u4f1a\u4ece\u5907\u4efd\u76ee\u5f55\u4e2d\u79fb\u9664\u3002\u8fd9\u4e2a\u53c2\u6570\u9002\u7528\u4e8e\u5728\u6709\u8db3\u591f\u78c1\u76d8\u7a7a\u95f4\u8fdb\u884c\u64cd\u4f5c\u7684\u60c5\u51b5\u4e0b\uff0c\u6216\u8005\u5f53\u4e0d\u9700\u8981\u4fdd\u7559\u5907\u4efd\u6587\u4ef6\u65f6\u3002\u4f7f\u7528<code>--move-back<\/code>\u65f6\uff0c\u4e5f\u9700\u8981\u786e\u4fdd\u6570\u636e\u76ee\u5f55\u4e3a\u7a7a\uff0c\u6216\u8005\u4f7f\u7528<code>--force-non-empty-directories<\/code>\u53c2\u6570\u6765\u5141\u8bb8\u8986\u76d6\u73b0\u6709\u6587\u4ef6<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">4\u3001\u4fee\u6539\u6743\u9650\uff0c\u542f\u52a8\u6570\u636e\u5e93\uff0c\u9a8c\u8bc1\u6570\u636e\u662f\u5426\u6062\u590d\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R mysql:mysql  \/data\/mysql\/data   #\u8d4b\u6743\u9650\n\/etc\/init.d\/mysqld start                 #\u542f\u52a8Mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u603b\u7ed3\u51e0\u4e2a\u6ce8\u610f\u70b9\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>datadir\u76ee\u5f55\u5fc5\u987b\u4e3a\u7a7a\uff0c\u9664\u975e\u6307\u5b9a &#8211;force-non-empty-directorires \u53c2\u6570\uff0c\u5426\u5219&#8211;copy-backup\u9009\u9879\u4e0d\u4f1a\u8986\u76d6<\/li>\n\n\n\n<li>\u5728\u6062\u590d\u4e4b\u524d\uff0c\u5fc5\u987b\u5173\u95edmysql\u793a\u4f8b\uff0c\u8fd0\u884c\u4e2d\u7684Mysql\u65e0\u6cd5\u6062\u590d<\/li>\n\n\n\n<li>\u6062\u590d\u540e\u7684\u6587\u4ef6\u5c5e\u6027\u4f1a\u4fdd\u7559\uff0c\u56e0\u6b64\u5728\u542f\u52a8mysql\u4e4b\u524d\u9700\u8981\u5c06\u6570\u636e\u76ee\u5f55\u53ca\u5176\u5b50\u76ee\u5f55\u5c5e\u4e3b\u548c\u5c5e\u7ec4\u8bbe\u7f6e\u4e3amysql\uff0c\u5426\u5219\u65e0\u6cd5\u542f\u52a8\u6210\u529f<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u589e\u91cf\u8fd8\u539f\uff1a<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001 \u505c\u6b62myql: <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/init.d\/mysqld stop<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"> 2\u3001\u6e05\u7a7a\u6570\u636e\u76ee\u5f55\uff1a <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rm -rf \/data\/mysql\/data\/*<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001 \u5148apply-log\u5168\u91cf\u5907\u4efd <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --apply-log --redo-only 2021-11-25_16-19-12<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">4\u3001 \u628a\u589e\u91cf\u5907\u4efd\u6570\u636e\u5408\u5e76\u5230\u5168\u91cf\u5907\u4efd\u6570\u636e\u4e0a :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex --apply-log --redo-only \/data\/backup\/2021-11-25_16-19-12  --incremental-dir=\/data\/backup\/increment_data<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">5\u3001\u56de\u6eda\u5b8c\u5168\u5907\u4efd\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex  --apply-log \/data\/backup\/2021-11-25_16-19-12<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">6\u3001\u8fd8\u539f\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innobackupex  --defaults-file=\/etc\/my.cnf --copy-back \/data\/backup\/2021-11-25_16-19-12<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">7\u3001\u8bbe\u7f6e\u6743\u9650\uff0c\u542f\u52a8Mysql\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R  mysql:mysql \/data\/mysql\/data\n\/etc\/init.d\/mysqld start<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u9762\u4f8b\u5b50\u8868\u793a\u5907\u4efdmysql\u5230\u8fdc\u7a0b\u673a\u5668\u4e0a\u5e76\u538b\u7f29\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n: '\n @function: backup mysql\n @date: 2021-11-26\n @author: gongguan\n @notice: \u4e0b\u9762\u7684\u538b\u7f29\u540e\u6587\u4ef6\u4e2d\u56e0\u4e3a\u6709\u5206\u949f\uff0c\u5305\u542b\u5192\u53f7\uff0c\u56e0\u6b64\u7528tar\u547d\u4ee4\u89e3\u538b\u7684\u65f6\u5019\uff0c\u4f1a\u63d0\u793atar: Cannot connect to,\u56e0\u6b64\u5728\u89e3\u538b\u7684\u65f6\u5019\u9700\u8981\u6dfb\u52a0\u53c2\u6570--force-local\u5373\u53ef\n'\ndate=$(date +\"%Y-%m-%d~%H:%M:%S\")\nbk_dir=\/data\/backup\/iyin-sass\/mysql\nssh cyyzops@192.168.12.174 test -d ${bk_dir}\nif &#91; $? -eq 0 ];then\n   echo \"dir exists\"\nelse\n   echo \"\u76ee\u5f55\u4e0d\u5b58\u5728\uff0c\u9700\u8981\u521b\u5efa\"\n   ssh cyyzops@192.168.12.174 mkdir -p ${bk_dir}\nfi\n\nfull_bk() {\necho \"&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;\u5f00\u59cb\u5b8c\u5168\u5907\u4efd&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;\"\ninnobackupex --defaults-file=\/etc\/my.cnf --user=bkuser --password=bk123456  --no-timestamp --stream=tar ${bk_dir} | ssh cyyzops@192.168.12.174 \"gzip &gt; ${bk_dir}\/bk_mysql-${date}.tar.gz\"\nsleep 2\nif &#91; $? -eq 0 ];then\n   echo \"mysql bakcup success-${date}\" &gt;&gt; ${bk_dir}\/result_success.txt\n   ssh cyyzops@192.168.12.174 \"find ${bk_dir} -type f -name 'bk_mysql*' -mtime +2 -exec rm -rf {} \\;\"\nelse\n   echo \"mysql backup failed-${date}\" &gt;&gt; ${bk_dir}\/result_failed.txt\nfi\n}\nfull_bk<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">centos8\u5b89\u88c5xtrabckup\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>1\u3001yum install -y https:\/\/repo.percona.com\/yum\/percona-release-latest.noarch.rpm\n2\u3001percona-release enable-only tools release    #\u542f\u7528\u5b58\u50a8\u5e93\n3\u3001percona-release enable-only tools            #\u542f\u7528\u5de5\u5177\u5b58\u50a8\u5e93\n4\u3001yum install -y percona-xtrabackup-24         #\u6267\u884c\u547d\u4ee4\u5b89\u88c5\n5\u3001which xtrabackup \u3001which innobackupex        #\u9a8c\u8bc1\u662f\u5426\u5b89\u88c5\u6210\u529f\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001Xtrabackup\u4ecb\u7ecd\uff1a Percona XtraBackup\uff08\u7b80\u79f0PXB\uff09 \u662f Percona\u516c\u53f8\u5f00\u53d1 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":5710,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,25],"tags":[],"class_list":["post-5197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-database"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"_links":{"self":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/5197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/comments?post=5197"}],"version-history":[{"count":46,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/5197\/revisions"}],"predecessor-version":[{"id":17609,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/5197\/revisions\/17609"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media\/5710"}],"wp:attachment":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media?parent=5197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/categories?post=5197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/tags?post=5197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}