{"id":1321,"date":"2024-12-20T15:40:10","date_gmt":"2024-12-20T07:40:10","guid":{"rendered":"http:\/\/learning.sino-vt.com:8988\/?p=1321"},"modified":"2024-12-20T15:40:25","modified_gmt":"2024-12-20T07:40:25","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93data%e7%9b%ae%e5%bd%95%e4%b8%8b%e6%9c%89%e5%a4%a7%e9%87%8fbinlog%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"http:\/\/learning.sino-vt.com:8988\/index.php\/2024\/12\/20\/%e6%95%b0%e6%8d%ae%e5%ba%93data%e7%9b%ae%e5%bd%95%e4%b8%8b%e6%9c%89%e5%a4%a7%e9%87%8fbinlog%e6%96%87%e4%bb%b6\/","title":{"rendered":"\u6570\u636e\u5e93data\u76ee\u5f55\u4e0b\u6709\u5927\u91cfbinlog\u6587\u4ef6"},"content":{"rendered":"<p>mysql8.0\u7684\u7248\u672c\uff0c\u5728\/usr\/local\/mysql\/data\/\u4e0b\u751f\u6210binlog\u65e5\u5fd7\u6587\u4ef6\uff0c\u8fd9\u4e9b\u6587\u4ef6\u9ed8\u8ba4\u6ca1\u6709\u9650\u5236\uff0c\u53ef\u80fd\u4f1a\u9020\u6210\u670d\u52a1\u5668\u7684\u5b58\u50a8\u7a7a\u95f4\u6cbe\u6ee1\u7684\u60c5\u51b5\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1322\" src=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/8C4A9793-77E9-4469-9981-FDCFB789E1C0.png\" alt=\"\" width=\"585\" height=\"429\" srcset=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/8C4A9793-77E9-4469-9981-FDCFB789E1C0.png 585w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/8C4A9793-77E9-4469-9981-FDCFB789E1C0-300x220.png 300w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/p>\n<p>\u5904\u7406\u529e\u6cd5\uff1a\u5728my.cnf\u6587\u4ef6\u4e2d\u7684\u3010mysqld\u3011\u6a21\u5757\u4e0b\u589e\u52a0\u4ee5\u4e0b\u4e24\u884c\u53c2\u6570\uff08\u53ef\u4ee5\u6839\u636e\u60c5\u51b5\u8c03\u6574\u53c2\u6570\u503c\uff09<\/p>\n<p>expire_logs_days=10\u00a0 \u00a0 #\u4fdd\u7559\u65e5\u5fd7\u7684\u5929\u6570<br \/>\nmax_binlog_size=1024M\u00a0 \u00a0 \u00a0#\u5355\u4e2a\u6587\u4ef6\u6700\u5927\u4f53\u79ef<\/p>\n<p>\u589e\u52a0\u53c2\u6570\u540e\u91cd\u542fmysql\u670d\u52a1\uff0c\u8d85\u51fa\u8303\u56f4\u7684\u4f1a\u88ab\u6e05\u7406<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1323\" src=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/\u5fae\u4fe1\u56fe\u7247_20241220154823.png\" alt=\"\" width=\"774\" height=\"490\" srcset=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/\u5fae\u4fe1\u56fe\u7247_20241220154823.png 774w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/\u5fae\u4fe1\u56fe\u7247_20241220154823-300x190.png 300w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/\u5fae\u4fe1\u56fe\u7247_20241220154823-768x486.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u53c2\u8003\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1324\" src=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/87488719-D54D-43BC-A02B-13EA5DD4DC7E.png\" alt=\"\" width=\"917\" height=\"977\" srcset=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/87488719-D54D-43BC-A02B-13EA5DD4DC7E.png 917w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/87488719-D54D-43BC-A02B-13EA5DD4DC7E-282x300.png 282w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2024\/12\/87488719-D54D-43BC-A02B-13EA5DD4DC7E-768x818.png 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql8.0\u7684\u7248\u672c\uff0c\u5728\/usr\/local\/mysql\/data\/\u4e0b\u751f\u6210binlog\u65e5\u5fd7\u6587\u4ef6\uff0c\u8fd9\u4e9b\u6587\u4ef6\u9ed8\u8ba4 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[21],"class_list":["post-1321","post","type-post","status-publish","format-standard","hentry","category-auditsys","tag-mysql"],"_links":{"self":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/comments?post=1321"}],"version-history":[{"count":1,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1321\/revisions"}],"predecessor-version":[{"id":1325,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1321\/revisions\/1325"}],"wp:attachment":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/media?parent=1321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/categories?post=1321"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/tags?post=1321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}