{"id":61673,"date":"2025-04-29T13:05:43","date_gmt":"2025-04-29T05:05:43","guid":{"rendered":"https:\/\/fwq.ai\/blog\/61673\/"},"modified":"2025-04-29T13:05:43","modified_gmt":"2025-04-29T05:05:43","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8linux%e4%b8%8a%e9%85%8d%e7%bd%ae%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6-2","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/61673\/","title":{"rendered":"\u5982\u4f55\u5728Linux\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236"},"content":{"rendered":"<p>\u5982\u4f55\u5728\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236<\/p>\n<p>\u5728Linux\u7cfb\u7edf\u4e0b\uff0c\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u662f\u4e00\u9879\u5e38\u89c1\u7684\u4efb\u52a1\u3002\u4e3b\u4ece\u590d\u5236\u53ef\u4ee5\u63d0\u4f9b\u6570\u636e\u5197\u4f59\u5907\u4efd\u3001\u8d1f\u8f7d\u5e73\u8861\u548c\u9ad8\u53ef\u7528\u6027\u7b49\u4f18\u52bf\u3002\u672c\u6587\u5c06\u4ecb\u7ecd\u5982\u4f55\u5728linux\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u7684\u6b65\u9aa4\uff0c\u5e76\u63d0\u4f9b\u76f8\u5e94\u7684\u4ee3\u7801\u793a\u4f8b\u3002<\/p>\n<p>\u6b65\u9aa4\u4e00\uff1a\u5b89\u88c5\u6570\u636e\u5e93\u8f6f\u4ef6<br \/>\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u5728\u4e3b\u670d\u52a1\u5668\u548c\u4ece\u670d\u52a1\u5668\u4e0a\u5b89\u88c5\u76f8\u5e94\u7684\u6570\u636e\u5e93\u8f6f\u4ef6\u3002\u672c\u6587\u4ee5MySQL\u6570\u636e\u5e93\u4e3a\u4f8b\uff0c\u5b89\u88c5\u8fc7\u7a0b\u5982\u4e0b\uff1a<\/p>\n<ol>\n<li>\n<p>\u5728\u4e3b\u670d\u52a1\u5668\u548c\u4ece\u670d\u52a1\u5668\u4e0a\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u6765\u5b89\u88c5MySQL\u6570\u636e\u5e93\uff1a<\/p>\n<pre>sudo apt update\nsudo apt install mysql-server<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<\/ol>\n<p>\u6b65\u9aa4\u4e8c\uff1a\u914d\u7f6e\u4e3b\u670d\u52a1\u5668<br \/>\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u9700\u8981\u5728\u4e3b\u670d\u52a1\u5668\u4e0a\u8fdb\u884c\u4e00\u7cfb\u5217\u914d\u7f6e\uff1a<\/p>\n<ol>\n<li>\n<p>\u7f16\u8f91MySQL\u914d\u7f6e\u6587\u4ef6\/etc\/mysql\/mysql.conf.d\/mysqld.cnf\uff0c\u53d6\u6d88\u4ee5\u4e0b\u884c\u7684\u6ce8\u91ca\uff08\u5220\u9664\u884c\u524d\u7684#\uff09\uff1a<\/p>\n<pre>#bind-address            = 127.0.0.1\n#log_bin                  = \/var\/log\/mysql\/mysql-bin.log\n#binlog_do_db            = mydatabase<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<li>\n<p>\u91cd\u542fMySQL\u670d\u52a1\u5668\uff1a<\/p>\n<pre>sudo service mysql restart<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<li>\n<p>\u767b\u5f55MySQL\u670d\u52a1\u5668\u5e76\u6267\u884c\u4ee5\u4e0bSQL\u547d\u4ee4\uff1a<\/p>\n<pre>mysql -u root -p<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u5728MySQL\u4ea4\u4e92\u754c\u9762\u4e2d\u6267\u884c\uff1a<\/p>\n<pre>CREATE USER 'replication'@'%' IDENTIFIED BY 'password';\nGRANT REPLICATION SLAVE ON *.* TO 'replication'@'%';\nFLUSH PRIVILEGES;\nFLUSH TABLES WITH READ LOCK;\nSHOW MASTER STATUS;<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u8bb0\u4e0bFile\u548cPosition\u5b57\u6bb5\u7684\u503c\uff0c\u6211\u4eec\u5c06\u5728\u4ece\u670d\u52a1\u5668\u4e0a\u7528\u5230\u3002<\/p>\n<\/li>\n<li>\n<p>\u89e3\u9501\u8868\u683c\uff1a<\/p>\n<pre>UNLOCK TABLES;<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<\/ol>\n<p>\u6b65\u9aa4\u4e09\uff1a\u914d\u7f6e\u4ece\u670d\u52a1\u5668<br \/>\u63a5\u4e0b\u6765\uff0c\u5728\u4ece\u670d\u52a1\u5668\u4e0a\u8fdb\u884c\u4e00\u7cfb\u5217\u914d\u7f6e\uff1a<\/p>\n<ol>\n<li>\n<p>\u7f16\u8f91MySQL\u914d\u7f6e\u6587\u4ef6\/etc\/mysql\/mysql.conf.d\/mysqld.cnf\uff0c\u53d6\u6d88\u4ee5\u4e0b\u884c\u7684\u6ce8\u91ca\uff1a<\/p>\n<pre>#bind-address            = 127.0.0.1<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<li>\n<p>\u91cd\u542fMySQL\u670d\u52a1\u5668\uff1a<\/p>\n<pre>sudo service mysql restart<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<li>\n<p>\u767b\u5f55MySQL\u670d\u52a1\u5668\u5e76\u6267\u884c\u4ee5\u4e0bSQL\u547d\u4ee4\uff1a\uff08\u5c06 \u66ff\u6362\u4e3a\u4e3b\u670d\u52a1\u5668\u7684IP\u5730\u5740\uff0c \u548c \u66ff\u6362\u4e3a\u4e0a\u4e00\u6b65\u4e2d\u8bb0\u5f55\u4e0b\u7684File\u548cPosition\u5b57\u6bb5\u7684\u503c\u3002\uff09 <\/p>\n<pre>mysql -u root -p<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u5728MySQL\u4ea4\u4e92\u754c\u9762\u4e2d\u6267\u884c\uff1a<\/p>\n<pre>CHANGE MASTER TO MASTER_HOST='&lt;master-ip&gt;', MASTER_USER='replication', MASTER_PASSWORD='password', MASTER_LOG_FILE='&lt;master-file&gt;', MASTER_LOG_POS=&lt;master-position&gt;;\nSTART SLAVE;&lt;\/master-position&gt;&lt;\/master-file&gt;&lt;\/master-ip&gt;<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/li>\n<li>\n<p>\u68c0\u67e5\u4ece\u670d\u52a1\u5668\u7684\u72b6\u6001\uff1a<\/p>\n<pre>SHOW SLAVE STATUSG<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u786e\u4fddSlave_IO_Running\u548cSlave_SQL_Running\u5b57\u6bb5\u7684\u503c\u90fd\u4e3aYes\uff0c\u8868\u793a\u4e3b\u4ece\u590d\u5236\u5df2\u7ecf\u6210\u529f\u914d\u7f6e\u3002<\/p>\n<\/li>\n<\/ol>\n<p>\u81f3\u6b64\uff0c\u6211\u4eec\u5df2\u7ecf\u5b8c\u6210\u4e86\u5728Linux\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u7684\u8fc7\u7a0b\u3002<\/p>\n<p>\u603b\u7ed3<br \/>\u672c\u6587\u4ecb\u7ecd\u4e86\u5728Linux\u7cfb\u7edf\u4e0b\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u7684\u6b65\u9aa4\uff0c\u5e76\u63d0\u4f9b\u4e86\u76f8\u5e94\u7684\u4ee3\u7801\u793a\u4f8b\u3002\u901a\u8fc7\u4e3b\u4ece\u590d\u5236\uff0c\u6211\u4eec\u53ef\u4ee5\u83b7\u5f97\u6570\u636e\u5197\u4f59\u5907\u4efd\u3001\u8d1f\u8f7d\u5e73\u8861\u548c\u9ad8\u53ef\u7528\u6027\u7b49\u597d\u5904\u3002\u914d\u7f6e\u4e3b\u4ece\u590d\u5236\u65f6\u9700\u8981\u6ce8\u610f\u4e3b\u670d\u52a1\u5668\u548c\u4ece\u670d\u52a1\u5668\u7684\u8f6f\u4ef6\u5b89\u88c5\u548c\u914d\u7f6e\uff0c\u4ee5\u53ca\u6b63\u786e\u8bbe\u7f6e\u4e3b\u4ece\u670d\u52a1\u5668\u7684\u8fde\u63a5\u548c\u6743\u9650\u3002\u5e0c\u671b\u672c\u6587\u5bf9\u4f60\u5728Linux\u7cfb\u7edf\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u6709\u6240\u5e2e\u52a9\u3002<\/p>\n<p>\u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u5728Linux\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8FDCServers\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u4f55\u5728\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236 \u5728Linux\u7cfb\u7edf\u4e0b\uff0c\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u662f\u4e00\u9879\u5e38\u89c1\u7684\u4efb\u52a1\u3002\u4e3b\u4ece\u590d\u5236\u53ef\u4ee5\u63d0\u4f9b\u6570\u636e\u5197\u4f59\u5907\u4efd\u3001\u8d1f\u8f7d\u5e73\u8861\u548c\u9ad8\u53ef\u7528\u6027\u7b49\u4f18\u52bf\u3002\u672c\u6587\u5c06\u4ecb\u7ecd\u5982\u4f55\u5728linux\u4e0a\u914d\u7f6e\u6570\u636e\u5e93\u4e3b\u4ece\u590d\u5236\u7684\u6b65\u9aa4\uff0c\u5e76\u63d0\u4f9b\u76f8\u5e94\u7684\u4ee3\u7801\u793a\u4f8b\u3002 \u6b65\u9aa4\u4e00\uff1a\u5b89\u88c5\u6570\u636e\u5e93\u8f6f\u4ef6\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u5728\u4e3b\u670d\u52a1\u5668\u548c\u4ece\u670d\u52a1\u5668\u4e0a\u5b89\u88c5\u76f8\u5e94\u7684\u6570\u636e\u5e93\u8f6f\u4ef6\u3002\u672c\u6587\u4ee5MySQL\u6570\u636e\u5e93\u4e3a\u4f8b\uff0c\u5b89\u88c5\u8fc7\u7a0b\u5982\u4e0b\uff1a \u5728\u4e3b\u670d\u52a1\u5668\u548c\u4ece\u670d\u52a1\u5668\u4e0a\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u6765\u5b89\u88c5MySQL\u6570\u636e\u5e93\uff1a sudo apt update sudo apt install mysql-server \u767b\u5f55\u540e\u590d\u5236 \u6b65\u9aa4\u4e8c\uff1a\u914d\u7f6e\u4e3b\u670d\u52a1\u5668\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u9700\u8981\u5728\u4e3b\u670d\u52a1\u5668\u4e0a\u8fdb\u884c\u4e00\u7cfb\u5217\u914d\u7f6e\uff1a \u7f16\u8f91MySQL\u914d\u7f6e\u6587\u4ef6\/etc\/mysql\/mysql.conf.d\/mysqld.cnf\uff0c\u53d6\u6d88\u4ee5\u4e0b\u884c\u7684\u6ce8\u91ca\uff08\u5220\u9664\u884c\u524d\u7684#\uff09\uff1a #bind-address = 127.0.0.1 #log_bin = \/var\/log\/mysql\/mysql-bin.log #binlog_do_db = mydatabase \u767b\u5f55\u540e\u590d\u5236 \u91cd\u542fMySQL\u670d\u52a1\u5668\uff1a sudo service mysql restart \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55MySQL\u670d\u52a1\u5668\u5e76\u6267\u884c\u4ee5\u4e0bSQL\u547d\u4ee4\uff1a mysql -u root -p \u767b\u5f55\u540e\u590d\u5236 \u767b\u5f55\u540e\u590d\u5236 \u5728MySQL\u4ea4\u4e92\u754c\u9762\u4e2d\u6267\u884c\uff1a CREATE USER &#8216;replication&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;password&#8217;; GRANT REPLICATION SLAVE ON *.* TO &#8216;replication&#8217;@&#8217;%&#8217;; FLUSH PRIVILEGES; FLUSH [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-61673","post","type-post","status-publish","format-standard","hentry","category-os"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/61673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=61673"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/61673\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=61673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=61673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=61673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}