{"id":5049,"date":"2025-05-01T16:27:09","date_gmt":"2025-05-01T08:27:09","guid":{"rendered":"https:\/\/blog.smallken.ink\/?p=5049"},"modified":"2025-05-01T19:38:38","modified_gmt":"2025-05-01T11:38:38","slug":"mysql-%e5%81%9a%e4%ba%92%e7%9b%b8%e5%82%99%e7%b7%a9","status":"publish","type":"post","link":"https:\/\/blog.smallken.site\/?p=5049","title":{"rendered":"\u80fd\u4e0d\u80fd\u5728\u5169\u500b\u4e0d\u540c\u4e3b\u6a5f\u4e4b\u9593\u7684mysql \u8cc7\u6599\u8868, \u505a\u4e92\u76f8\u5099\u7de9\u7684\u4f5c\u7528"},"content":{"rendered":"\n<p>\u597d\u7684\uff0c\u7576\u7136\u53ef\u4ee5\uff01\u5728\u5169\u500b\u4e0d\u540c\u7684 MySQL \u4e3b\u6a5f\u4e4b\u9593\u5efa\u7acb\u8cc7\u6599\u8868\u7684\u4e92\u76f8\u5099\u63f4\u6a5f\u5236\uff0c\u6700\u5e38\u898b\u4e14\u6709\u6548\u7684\u65b9\u5f0f\u5c31\u662f\u4f7f\u7528 <strong>MySQL Replication (\u4e3b\u5f9e\u8907\u88fd)<\/strong>\u3002<\/p>\n\n\n\n<p>\u96d6\u7136 MySQL Replication \u7684\u4e3b\u8981\u76ee\u7684\u662f\u5c07\u4e00\u500b\u4e3b\u4f3a\u670d\u5668\u7684\u8cc7\u6599\u540c\u6b65\u5230\u4e00\u500b\u6216\u591a\u500b\u5f9e\u4f3a\u670d\u5668\uff0c\u4f46\u900f\u904e\u4e00\u4e9b\u8a2d\u5b9a\uff0c\u4f60\u53ef\u4ee5\u5be6\u73fe\u985e\u4f3c\u4e92\u76f8\u5099\u63f4\u7684\u6548\u679c\u3002\u4ee5\u4e0b\u662f\u5e7e\u7a2e\u53ef\u4ee5\u8003\u616e\u7684\u65b9\u6cd5\uff1a<\/p>\n\n\n\n<p><strong>\u65b9\u6cd5\u4e00\uff1a\u50b3\u7d71\u7684\u4e3b\u5f9e\u8907\u88fd (Master-Slave Replication)<\/strong><\/p>\n\n\n\n<p>\u9019\u662f\u6700\u5e38\u898b\u7684 MySQL \u8907\u88fd\u65b9\u5f0f\u3002\u4f60\u53ef\u4ee5\u8a2d\u5b9a\u5176\u4e2d\u4e00\u53f0\u4e3b\u6a5f\u4f5c\u70ba\u4e3b\u8981\u5beb\u5165\u7684 <strong>Master<\/strong>\uff0c\u53e6\u4e00\u53f0\u4f5c\u70ba\u552f\u8b80\u7684 <strong>Slave<\/strong>\u3002\u7576 Master \u767c\u751f\u6545\u969c\u6642\uff0c\u4f60\u53ef\u4ee5\u5c07 Slave \u63d0\u5347\u70ba\u65b0\u7684 Master\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u512a\u9ede\uff1a<\/strong> \u8a2d\u5b9a\u76f8\u5c0d\u7c21\u55ae\uff0c\u8b80\u5beb\u5206\u96e2\u53ef\u4ee5\u63d0\u5347\u6548\u80fd\u3002<\/li>\n\n\n\n<li><strong>\u7f3a\u9ede\uff1a<\/strong> \u5728 Master \u6545\u969c\u6642\u9700\u8981\u624b\u52d5\u4ecb\u5165\u5c07 Slave \u63d0\u5347\u70ba Master\uff0c\u53ef\u80fd\u6703\u6709\u77ed\u66ab\u7684\u670d\u52d9\u4e2d\u65b7\u3002\u8cc7\u6599\u53ea\u6703\u55ae\u5411\u5f9e Master \u8907\u88fd\u5230 Slave\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u8a2d\u5b9a\u6b65\u9a5f (\u7c21\u8ff0)\uff1a<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5728 Master \u4f3a\u670d\u5668\u4e0a\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u555f\u7528 Binary Log (binlog)\u3002<\/li>\n\n\n\n<li>\u8a2d\u5b9a\u552f\u4e00\u7684 <code>server-id<\/code>\u3002<\/li>\n\n\n\n<li>\u5efa\u7acb\u4e00\u500b\u5c08\u7528\u65bc\u8907\u88fd\u7684\u4f7f\u7528\u8005\u4e26\u6388\u4e88 <code>REPLICATION SLAVE<\/code> \u6b0a\u9650\u3002<\/li>\n\n\n\n<li>\u9396\u5b9a Master \u8cc7\u6599\u5eab\u4e26\u53d6\u5f97\u5f53\u524d\u7684 binlog \u6a94\u6848\u540d\u548c\u4f4d\u7f6e\u3002<\/li>\n\n\n\n<li>\u5099\u4efd Master \u8cc7\u6599\u5eab\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u5728 Slave \u4f3a\u670d\u5668\u4e0a\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u8a2d\u5b9a\u552f\u4e00\u7684 <code>server-id<\/code> (\u8207 Master \u4e0d\u540c)\u3002<\/li>\n\n\n\n<li>\u914d\u7f6e\u9023\u7dda\u5230 Master \u7684\u8cc7\u8a0a (Master IP\u3001\u4f7f\u7528\u8005\u3001\u5bc6\u78bc\u3001binlog \u6a94\u6848\u540d\u548c\u4f4d\u7f6e)\u3002<\/li>\n\n\n\n<li>\u532f\u5165\u5f9e Master \u5099\u4efd\u7684\u8cc7\u6599\u3002<\/li>\n\n\n\n<li>\u555f\u52d5 Slave \u7684\u8907\u88fd\u7a0b\u5e8f\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>\u65b9\u6cd5\u4e8c\uff1a\u96d9\u4e3b\u8907\u88fd (Master-Master Replication)<\/strong><\/p>\n\n\n\n<p>\u9019\u662f\u4e00\u7a2e\u66f4\u9032\u968e\u7684\u8a2d\u5b9a\uff0c\u8b93\u5169\u53f0\u4f3a\u670d\u5668\u90fd\u4f5c\u70ba Master\uff0c\u4e26\u4e14\u4e92\u76f8\u8907\u88fd\u5c0d\u65b9\u7684\u8cc7\u6599\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u512a\u9ede\uff1a<\/strong> \u4efb\u4f55\u4e00\u53f0\u4f3a\u670d\u5668\u90fd\u53ef\u4ee5\u63a5\u53d7\u5beb\u5165\uff0c\u5177\u6709\u66f4\u9ad8\u7684\u5bb9\u932f\u80fd\u529b\u3002<\/li>\n\n\n\n<li><strong>\u7f3a\u9ede\uff1a<\/strong> \u8a2d\u5b9a\u8f03\u8907\u96dc\uff0c\u9700\u8981\u4ed4\u7d30\u8655\u7406\u6f5b\u5728\u7684\u5beb\u5165\u885d\u7a81\u554f\u984c (\u4f8b\u5982\u5169\u53f0\u4e3b\u6a5f\u540c\u6642\u4fee\u6539\u540c\u4e00\u7b46\u8cc7\u6599)\u3002\u901a\u5e38\u9700\u8981\u61c9\u7528\u7a0b\u5f0f\u5c64\u6216 MySQL \u672c\u8eab\u7684\u885d\u7a81\u89e3\u6c7a\u6a5f\u5236\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u8a2d\u5b9a\u6b65\u9a5f (\u7c21\u8ff0)\uff1a<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5728\u5169\u53f0\u4f3a\u670d\u5668\u4e0a\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u555f\u7528 Binary Log (binlog)\u3002<\/li>\n\n\n\n<li>\u70ba\u6bcf\u53f0\u4f3a\u670d\u5668\u8a2d\u5b9a\u552f\u4e00\u7684 <code>server-id<\/code>\u3002<\/li>\n\n\n\n<li>\u5728\u6bcf\u53f0\u4f3a\u670d\u5668\u4e0a\u5efa\u7acb\u4e00\u500b\u5c08\u7528\u65bc\u8907\u88fd\u7684\u4f7f\u7528\u8005\u4e26\u6388\u4e88 <code>REPLICATION SLAVE<\/code> \u548c <code>REPLICATION CLIENT<\/code> \u6b0a\u9650\u7d66\u5c0d\u65b9\u3002<\/li>\n\n\n\n<li>\u4e92\u76f8\u914d\u7f6e\u5c0d\u65b9\u7684\u9023\u7dda\u8cc7\u8a0a (IP\u3001\u4f7f\u7528\u8005\u3001\u5bc6\u78bc\u3001binlog \u6a94\u6848\u540d\u548c\u4f4d\u7f6e)\u3002<\/li>\n\n\n\n<li>\u4e92\u76f8\u5099\u4efd\u5c0d\u65b9\u7684\u8cc7\u6599\u4e26\u532f\u5165\u3002<\/li>\n\n\n\n<li>\u5728\u5169\u53f0\u4f3a\u670d\u5668\u4e0a\u555f\u52d5\u8907\u88fd\u7a0b\u5e8f\u3002<\/li>\n\n\n\n<li><strong>\u91cd\u8981\uff1a<\/strong> \u5efa\u8b70\u4f7f\u7528 <code>auto_increment_increment<\/code> \u548c <code>auto_increment_offset<\/code> \u4f86\u907f\u514d\u81ea\u589e\u4e3b\u9375\u885d\u7a81\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>\u65b9\u6cd5\u4e09\uff1a\u591a\u6e90\u8907\u88fd (Multi-Source Replication)<\/strong><\/p>\n\n\n\n<p>MySQL 5.7 \u53ca\u66f4\u9ad8\u7248\u672c\u652f\u63f4\u591a\u6e90\u8907\u88fd\uff0c\u5141\u8a31\u4e00\u500b Slave \u4f3a\u670d\u5668\u5f9e\u591a\u500b Master \u4f3a\u670d\u5668\u63a5\u6536\u8cc7\u6599\u3002\u4f60\u53ef\u4ee5\u8a2d\u5b9a\u5169\u53f0\u4f3a\u670d\u5668\u90fd\u4f5c\u70ba\u5c0d\u65b9\u7684 &#8220;Master&#8221;\uff0c\u8b93\u5b83\u5011\u7684\u8cc7\u6599\u90fd\u8907\u88fd\u5230\u5c0d\u65b9 (\u4f5c\u70ba &#8220;Slave&#8221; \u7684\u89d2\u8272)\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u512a\u9ede\uff1a<\/strong> \u6bd4\u96d9\u4e3b\u8907\u88fd\u66f4\u6e05\u6670\u5730\u5b9a\u7fa9\u4e86\u8907\u88fd\u95dc\u4fc2\uff0c\u53ef\u80fd\u66f4\u5bb9\u6613\u7ba1\u7406\u3002<\/li>\n\n\n\n<li><strong>\u7f3a\u9ede\uff1a<\/strong> \u9700\u8981\u8f03\u9ad8\u7248\u672c\u7684 MySQL\u3002\u4ecd\u7136\u9700\u8981\u8003\u616e\u6f5b\u5728\u7684\u8cc7\u6599\u885d\u7a81\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u8a2d\u5b9a\u6b65\u9a5f (\u7c21\u8ff0)\uff1a<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5728\u5169\u53f0\u4f3a\u670d\u5668\u4e0a\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u555f\u7528 Binary Log (binlog)\u3002<\/li>\n\n\n\n<li>\u70ba\u6bcf\u53f0\u4f3a\u670d\u5668\u8a2d\u5b9a\u552f\u4e00\u7684 <code>server-id<\/code>\u3002<\/li>\n\n\n\n<li>\u5728\u6bcf\u53f0\u4f3a\u670d\u5668\u4e0a\u5efa\u7acb\u4e00\u500b\u5c08\u7528\u65bc\u8907\u88fd\u7684\u4f7f\u7528\u8005\u4e26\u6388\u4e88 <code>REPLICATION SLAVE<\/code> \u6b0a\u9650\u7d66\u5c0d\u65b9\u3002<\/li>\n\n\n\n<li>\u5728\u6bcf\u53f0\u4f3a\u670d\u5668\u4e0a\u914d\u7f6e\u591a\u500b\u8907\u88fd\u901a\u9053\uff0c\u5206\u5225\u6307\u5411\u5c0d\u65b9\u4f5c\u70ba Master\u3002<\/li>\n\n\n\n<li>\u70ba\u6bcf\u500b\u901a\u9053\u914d\u7f6e\u9023\u7dda\u8cc7\u8a0a (Master IP\u3001\u4f7f\u7528\u8005\u3001\u5bc6\u78bc\u3001binlog \u6a94\u6848\u540d\u548c\u4f4d\u7f6e)\u3002<\/li>\n\n\n\n<li>\u4e92\u76f8\u5099\u4efd\u5c0d\u65b9\u7684\u8cc7\u6599\u4e26\u532f\u5165\u3002<\/li>\n\n\n\n<li>\u5728\u5169\u53f0\u4f3a\u670d\u5668\u4e0a\u555f\u52d5\u5404\u500b\u8907\u88fd\u901a\u9053\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>\u9078\u64c7\u54ea\u7a2e\u65b9\u6cd5\u53d6\u6c7a\u65bc\u4f60\u7684\u5177\u9ad4\u9700\u6c42\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5982\u679c\u4f60\u7684\u61c9\u7528\u7a0b\u5f0f\u4e3b\u8981\u5728\u4e00\u500b\u4e3b\u6a5f\u4e0a\u5beb\u5165\uff0c\u800c\u53e6\u4e00\u53f0\u4e3b\u8981\u7528\u65bc\u8b80\u53d6\u6216\u4f5c\u70ba\u6545\u969c\u5099\u63f4\uff0c\u90a3\u9ebc\u50b3\u7d71\u7684\u4e3b\u5f9e\u8907\u88fd\u53ef\u80fd\u5c31\u8db3\u5920\u4e86\u3002<\/li>\n\n\n\n<li>\u5982\u679c\u4f60\u5e0c\u671b\u5169\u53f0\u4e3b\u6a5f\u90fd\u80fd\u8655\u7406\u5beb\u5165\uff0c\u4e26\u4e14\u5728\u5176\u4e2d\u4e00\u53f0\u6545\u969c\u6642\u53e6\u4e00\u53f0\u53ef\u4ee5\u7acb\u5373\u63a5\u7ba1\uff0c\u90a3\u9ebc\u96d9\u4e3b\u8907\u88fd\u6216\u591a\u6e90\u8907\u88fd\u53ef\u80fd\u66f4\u9069\u5408\uff0c\u4f46\u9700\u8981\u66f4\u8b39\u614e\u5730\u8655\u7406\u6f5b\u5728\u7684\u885d\u7a81\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>\u91cd\u8981\u6ce8\u610f\u4e8b\u9805\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u7db2\u8def\u9023\u7dda\uff1a<\/strong> \u78ba\u4fdd\u5169\u53f0\u4e3b\u6a5f\u4e4b\u9593\u7684\u7db2\u8def\u9023\u7dda\u7a69\u5b9a\u53ef\u9760\u3002<\/li>\n\n\n\n<li><strong>\u8cc7\u6599\u4e00\u81f4\u6027\uff1a<\/strong> \u7121\u8ad6\u9078\u64c7\u54ea\u7a2e\u65b9\u6cd5\uff0c\u90fd\u9700\u8981\u5bc6\u5207\u76e3\u63a7\u8907\u88fd\u72c0\u614b\uff0c\u78ba\u4fdd\u8cc7\u6599\u7684\u4e00\u81f4\u6027\u3002<\/li>\n\n\n\n<li><strong>\u6e2c\u8a66\uff1a<\/strong> \u5728\u751f\u7522\u74b0\u5883\u4e2d\u5be6\u65bd\u4e4b\u524d\uff0c\u52d9\u5fc5\u5728\u6e2c\u8a66\u74b0\u5883\u4e2d\u5145\u5206\u6e2c\u8a66\u4f60\u7684\u5099\u63f4\u65b9\u6848\uff0c\u5305\u62ec\u6a21\u64ec\u6545\u969c\u5207\u63db\u3002<\/li>\n\n\n\n<li><strong>\u5ef6\u9072\uff1a<\/strong> \u8907\u88fd\u53ef\u80fd\u6703\u5b58\u5728\u4e00\u5b9a\u7684\u5ef6\u9072\uff0c\u4f60\u9700\u8981\u6839\u64da\u4f60\u7684\u61c9\u7528\u7a0b\u5f0f\u5c0d\u5ef6\u9072\u7684\u5bb9\u5fcd\u5ea6\u9032\u884c\u8a55\u4f30\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u7e3d\u4e4b\uff0cMySQL Replication \u63d0\u4f9b\u4e86\u5728\u4e0d\u540c\u4e3b\u6a5f\u4e4b\u9593\u5be6\u73fe\u8cc7\u6599\u8868\u4e92\u76f8\u5099\u63f4\u7684\u6a5f\u5236\u3002\u4f60\u9700\u8981\u6839\u64da\u4f60\u7684\u5177\u9ad4\u9700\u6c42\u548c\u6280\u8853\u80fd\u529b\u9078\u64c7\u6700\u9069\u5408\u4f60\u7684\u65b9\u6cd5\uff0c\u4e26\u4ed4\u7d30\u914d\u7f6e\u548c\u6e2c\u8a66\u3002\u5efa\u8b70\u67e5\u95b1 MySQL \u7684\u5b98\u65b9\u6587\u4ef6\u4ee5\u7372\u5f97\u66f4\u8a73\u7d30\u7684\u8a2d\u5b9a\u6307\u5357\u3002<\/p>\n\n\n\n<p>\u597d, \u8acb\u8a73\u8ff0 \u65b9\u6cd5\u4e00\uff1a\u50b3\u7d71\u7684\u4e3b\u5f9e\u8907\u88fd (Master-Slave Replication) \u7684\u6b65\u9a5f<\/p>\n\n\n\n<p>\u597d\u7684\uff0c\u4ee5\u4e0b\u5c07\u8a73\u7d30\u8aaa\u660e\u5982\u4f55\u8a2d\u5b9a\u50b3\u7d71\u7684 MySQL \u4e3b\u5f9e\u8907\u88fd (Master-Slave Replication)\u3002\u9019\u500b\u904e\u7a0b\u9700\u8981\u5728 Master \u548c Slave \u5169\u53f0\u4f3a\u670d\u5668\u4e0a\u9032\u884c\u914d\u7f6e\u3002<\/p>\n\n\n\n<p><strong>\u5047\u8a2d\u60c5\u5883\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Master \u4f3a\u670d\u5668\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>IP \u4f4d\u5740\uff1a<code>192.168.1.100<\/code><\/li>\n\n\n\n<li>MySQL \u7248\u672c\uff1a\u5047\u8a2d\u70ba 8.0<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Slave \u4f3a\u670d\u5668\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>IP \u4f4d\u5740\uff1a<code>192.168.1.101<\/code><\/li>\n\n\n\n<li>MySQL \u7248\u672c\uff1a\u5047\u8a2d\u70ba 8.0 (\u5efa\u8b70\u8207 Master \u7248\u672c\u4e00\u81f4\u6216\u66f4\u9ad8)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>\u6b65\u9a5f 1\uff1a\u5728 Master \u4f3a\u670d\u5668 (192.168.1.100) \u4e0a\u914d\u7f6e<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7de8\u8f2f MySQL \u914d\u7f6e\u6587\u4ef6\uff1a<\/strong><ul><li>\u627e\u5230\u4f60\u7684 MySQL \u914d\u7f6e\u6587\u4ef6\u3002\u5728 Ubuntu \u7cfb\u7d71\u4e0a\uff0c\u901a\u5e38\u4f4d\u65bc <code>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> \u6216 <code>\/etc\/my.cnf<\/code>\u3002<\/li><li>\u4f7f\u7528\u6587\u5b57\u7de8\u8f2f\u5668\uff08\u4f8b\u5982 <code>nano<\/code> \u6216 <code>vim<\/code>\uff09\u6253\u958b\u8a72\u6587\u4ef6\uff0c\u4e26\u627e\u5230 <code>[mysqld]<\/code> \u90e8\u5206\u3002<\/li><li>\u9032\u884c\u4ee5\u4e0b\u4fee\u6539\u6216\u6dfb\u52a0\uff1a<\/li><\/ul>\u7a0b\u5f0f\u78bc\u7247\u6bb5<code>[mysqld] server-id=1 # \u8a2d\u5b9a Master \u4f3a\u670d\u5668\u7684\u552f\u4e00 ID (\u5fc5\u9808\u662f\u552f\u4e00\u7684\u6b63\u6574\u6578) log_bin=mysql-bin # \u555f\u7528 Binary Log\uff0c\u9019\u662f\u8907\u88fd\u7684\u57fa\u790e binlog_format=ROW # \u8a2d\u5b9a Binary Log \u7684\u683c\u5f0f (ROW \u683c\u5f0f\u66f4\u5b89\u5168\uff0c\u63a8\u85a6\u4f7f\u7528) # binlog_do_db=mySite # \u53ef\u9078\uff1a\u53ea\u8a18\u9304\u7279\u5b9a\u8cc7\u6599\u5eab\u7684\u64cd\u4f5c (\u5982\u679c\u53ea\u60f3\u8907\u88fd mySite) # binlog_ignore_db=other_db # \u53ef\u9078\uff1a\u5ffd\u7565\u7279\u5b9a\u8cc7\u6599\u5eab\u7684\u64cd\u4f5c bind-address=192.168.1.100 # \u78ba\u4fdd MySQL \u76e3\u807d\u7684\u662f Master \u7684 IP \u4f4d\u5740 (\u5982\u679c\u9700\u8981\u5916\u90e8\u9023\u7dda)<\/code>\n<ul class=\"wp-block-list\">\n<li><strong><code>server-id<\/code>\uff1a<\/strong> \u70ba\u4f60\u7684 Master \u4f3a\u670d\u5668\u8a2d\u5b9a\u4e00\u500b\u552f\u4e00\u7684\u6574\u6578 ID\u3002\u5728\u4f60\u7684\u8907\u88fd\u74b0\u5883\u4e2d\uff0c\u6bcf\u500b\u4f3a\u670d\u5668\u90fd\u5fc5\u9808\u6709\u4e0d\u540c\u7684 <code>server-id<\/code>\u3002<\/li>\n\n\n\n<li><strong><code>log_bin<\/code>\uff1a<\/strong> \u6307\u5b9a Binary Log \u6a94\u6848\u540d\u7684\u524d\u7db4\u3002MySQL \u6703\u5728\u9019\u500b\u524d\u7db4\u5f8c\u9762\u52a0\u4e0a\u5e8f\u5217\u865f\u3002<\/li>\n\n\n\n<li><strong><code>binlog_format<\/code>\uff1a<\/strong> \u8a2d\u5b9a Binary Log \u7684\u683c\u5f0f\u3002<code>ROW<\/code> \u683c\u5f0f\u8a18\u9304\u5be6\u969b\u7684\u884c\u8b8a\u66f4\uff0c\u6bd4 <code>STATEMENT<\/code> \u683c\u5f0f\u66f4\u5b89\u5168\uff0c\u80fd\u907f\u514d\u67d0\u4e9b\u8a9e\u53e5\u5728 Slave \u4e0a\u57f7\u884c\u7d50\u679c\u4e0d\u4e00\u81f4\u7684\u554f\u984c\u3002<code>MIXED<\/code> \u683c\u5f0f\u662f\u5169\u8005\u7684\u6df7\u5408\u3002<\/li>\n\n\n\n<li><strong><code>binlog_do_db<\/code> \u548c <code>binlog_ignore_db<\/code>\uff1a<\/strong> \u9019\u5169\u500b\u9078\u9805\u662f\u53ef\u9078\u7684\u3002\u5982\u679c\u4f60\u53ea\u60f3\u8907\u88fd\u7279\u5b9a\u7684\u8cc7\u6599\u5eab\uff0c\u53ef\u4ee5\u4f7f\u7528 <code>binlog_do_db<\/code> \u6307\u5b9a\uff1b\u5982\u679c\u4f60\u60f3\u6392\u9664\u67d0\u4e9b\u8cc7\u6599\u5eab\u4e0d\u88ab\u8907\u88fd\uff0c\u53ef\u4ee5\u4f7f\u7528 <code>binlog_ignore_db<\/code>\u3002<\/li>\n\n\n\n<li><strong><code>bind-address<\/code>\uff1a<\/strong> \u78ba\u4fdd MySQL \u76e3\u807d\u7684\u662f Master \u4f3a\u670d\u5668\u7684 IP \u4f4d\u5740\uff0c\u4ee5\u4fbf Slave \u4f3a\u670d\u5668\u53ef\u4ee5\u9023\u7dda\u3002\u5982\u679c\u9700\u8981\u5141\u8a31\u4f86\u81ea\u4efb\u4f55 IP \u7684\u9023\u7dda\uff0c\u53ef\u4ee5\u8a2d\u5b9a\u70ba <code>0.0.0.0<\/code>\uff0c\u4f46\u901a\u5e38\u5efa\u8b70\u9650\u5236\u70ba Slave \u7684 IP \u6216\u7279\u5b9a\u7684\u7db2\u8def\u7bc4\u570d\u4ee5\u63d0\u9ad8\u5b89\u5168\u6027\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u91cd\u65b0\u555f\u52d5 MySQL \u4f3a\u670d\u5668\uff1a<\/strong><ul><li>\u5132\u5b58\u5c0d\u914d\u7f6e\u6587\u4ef6\u7684\u66f4\u6539\u4e26\u91cd\u65b0\u555f\u52d5 MySQL \u670d\u52d9\uff0c\u4ee5\u4f7f\u914d\u7f6e\u751f\u6548\u3002<\/li><\/ul>Bash<code>sudo systemctl restart mysql<\/code><\/li>\n\n\n\n<li><strong>\u5efa\u7acb\u7528\u65bc\u8907\u88fd\u7684\u4f7f\u7528\u8005\uff1a<\/strong><ul><li>\u767b\u5165\u5230 Master \u4f3a\u670d\u5668\u7684 MySQL\uff1a<\/li><\/ul>Bash<code>mysql -u root -p<\/code><ul><li>\u5728 MySQL \u547d\u4ee4\u5217\u4e2d\uff0c\u5efa\u7acb\u4e00\u500b\u5c08\u9580\u7528\u65bc\u8907\u88fd\u7684\u4f7f\u7528\u8005\u3002\u5efa\u8b70\u9650\u5236\u9019\u500b\u4f7f\u7528\u8005\u53ea\u80fd\u5f9e Slave \u4f3a\u670d\u5668\u7684 IP \u4f4d\u5740\u9023\u7dda\uff0c\u4ee5\u63d0\u9ad8\u5b89\u5168\u6027\u3002\u5c07 <code>&lt;slave_user&gt;<\/code> \u66ff\u63db\u70ba\u4f60\u5e0c\u671b\u4f7f\u7528\u7684\u4f7f\u7528\u8005\u540d\uff08\u4f8b\u5982 <code>replica<\/code>\uff09\uff0c\u4e26\u5c07 <code>&lt;your_password&gt;<\/code> \u66ff\u63db\u70ba\u5b89\u5168\u7684\u5bc6\u78bc\uff1a<\/li><\/ul>SQL<code>CREATE USER '&lt;slave_user&gt;'@'192.168.1.101' IDENTIFIED BY '&lt;your_password&gt;';<\/code><ul><li>\u6388\u4e88\u8a72\u4f7f\u7528\u8005 <code>REPLICATION SLAVE<\/code> \u6b0a\u9650\uff1a<\/li><\/ul>SQL<code>GRANT REPLICATION SLAVE ON *.* TO '&lt;slave_user&gt;'@'192.168.1.101';<\/code><ul><li>\u5237\u65b0\u6b0a\u9650\uff1a<\/li><\/ul>SQL<code>FLUSH PRIVILEGES;<\/code><ul><li>\u9000\u51fa MySQL \u547d\u4ee4\u5217\uff1a<\/li><\/ul>SQL<code>exit<\/code><\/li>\n\n\n\n<li><strong>\u9396\u5b9a Master \u8cc7\u6599\u5eab\u4e26\u53d6\u5f97\u5f53\u524d\u7684 Binary Log \u6587\u4ef6\u540d\u548c\u4f4d\u7f6e\uff1a<\/strong><ul><li>\u518d\u6b21\u767b\u5165\u5230 Master \u4f3a\u670d\u5668\u7684 MySQL\uff1a<\/li><\/ul>Bash<code>mysql -u root -p<\/code><ul><li>\u9396\u5b9a\u6240\u6709\u8cc7\u6599\u5eab\uff0c\u4ee5\u78ba\u4fdd\u5728\u5099\u4efd\u904e\u7a0b\u4e2d\u4e0d\u6703\u6709\u65b0\u7684\u5beb\u5165\u64cd\u4f5c\uff1a<\/li><\/ul>SQL<code>FLUSH TABLES WITH READ LOCK;<\/code><ul><li>\u53d6\u5f97\u5f53\u524d\u7684 Binary Log \u6587\u4ef6\u540d\u548c\u4f4d\u7f6e\uff1a<\/li><\/ul>SQL<code>SHOW MASTER STATUS;<\/code>\n<ul class=\"wp-block-list\">\n<li>\u8a18\u4e0b <code>File<\/code> \u548c <code>Position<\/code> \u7684\u503c\u3002\u4f60\u5c07\u5728\u914d\u7f6e Slave \u4f3a\u670d\u5668\u6642\u9700\u8981\u9019\u4e9b\u8cc7\u8a0a\u3002<\/li>\n\n\n\n<li><strong>\u4e0d\u8981\u95dc\u9589\u9019\u500b MySQL \u9023\u7dda\uff01<\/strong> \u4f60\u9700\u8981\u5728\u9396\u5b9a\u72c0\u614b\u4e0b\u9032\u884c\u8cc7\u6599\u5099\u4efd\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u5099\u4efd Master \u8cc7\u6599\u5eab\uff1a<\/strong><ul><li>\u5728\u53e6\u4e00\u500b\u7d42\u7aef\u6a5f\u8996\u7a97\u4e2d\uff0c\u4f7f\u7528 <code>mysqldump<\/code> \u5de5\u5177\u5099\u4efd Master \u4f3a\u670d\u5668\u7684\u8cc7\u6599\u3002\u4f60\u53ef\u4ee5\u9078\u64c7\u5099\u4efd\u6240\u6709\u8cc7\u6599\u5eab\u6216\u7279\u5b9a\u7684\u8cc7\u6599\u5eab (<code>mySite<\/code>)\u3002<\/li><li><strong>\u5099\u4efd\u6240\u6709\u8cc7\u6599\u5eab\uff1a<\/strong><\/li><\/ul>Bash<code>mysqldump -u root -p --all-databases --master-data=2 &gt; \/tmp\/master_backup.sql<\/code><ul><li><strong>\u5099\u4efd\u7279\u5b9a\u8cc7\u6599\u5eab (<code>mySite<\/code>)\uff1a<\/strong><\/li><\/ul>Bash<code>mysqldump -u root -p mySite --master-data=2 &gt; \/tmp\/mysite_backup.sql<\/code>\n<ul class=\"wp-block-list\">\n<li><code>--master-data=2<\/code> \u9078\u9805\u6703\u5728\u5099\u4efd\u6a94\u6848\u4e2d\u5305\u542b <code>CHANGE MASTER TO<\/code> \u8a9e\u53e5\uff0c\u5176\u4e2d\u5305\u542b\u4e86\u5f53\u524d\u7684 Binary Log \u6587\u4ef6\u540d\u548c\u4f4d\u7f6e\uff0c\u65b9\u4fbf Slave \u4f3a\u670d\u5668\u5f8c\u7e8c\u914d\u7f6e\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u89e3\u9664 Master \u8cc7\u6599\u5eab\u7684\u9396\u5b9a\uff1a<\/strong><ul><li>\u56de\u5230\u4e4b\u524d\u9396\u5b9a\u8cc7\u6599\u5eab\u7684 MySQL \u547d\u4ee4\u5217\u8996\u7a97\uff0c\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u89e3\u9664\u9396\u5b9a\uff1a<\/li><\/ul>SQL<code>UNLOCK TABLES;<\/code><ul><li>\u9000\u51fa MySQL \u547d\u4ee4\u5217\uff1a<\/li><\/ul>SQL<code>exit<\/code><\/li>\n<\/ol>\n\n\n\n<p><strong>\u6b65\u9a5f 2\uff1a\u5728 Slave \u4f3a\u670d\u5668 (192.168.1.101) \u4e0a\u914d\u7f6e<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7de8\u8f2f MySQL \u914d\u7f6e\u6587\u4ef6\uff1a<\/strong><ul><li>\u627e\u5230 Slave \u4f3a\u670d\u5668\u4e0a\u7684 MySQL \u914d\u7f6e\u6587\u4ef6\uff08\u901a\u5e38\u4e5f\u662f <code>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> \u6216 <code>\/etc\/my.cnf<\/code>\uff09\u3002<\/li><li>\u4f7f\u7528\u6587\u5b57\u7de8\u8f2f\u5668\u6253\u958b\u8a72\u6587\u4ef6\uff0c\u4e26\u627e\u5230 <code>[mysqld]<\/code> \u90e8\u5206\u3002<\/li><li>\u9032\u884c\u4ee5\u4e0b\u4fee\u6539\u6216\u6dfb\u52a0\uff1a<\/li><\/ul>\u7a0b\u5f0f\u78bc\u7247\u6bb5<code>[mysqld] server-id=2 # \u8a2d\u5b9a Slave \u4f3a\u670d\u5668\u7684\u552f\u4e00 ID (\u5fc5\u9808\u8207 Master \u4e0d\u540c) # relay_log=mysql-relay-bin # \u53ef\u9078\uff1a\u6307\u5b9a Relay Log \u7684\u6a94\u6848\u540d\u524d\u7db4 (\u9810\u8a2d\u5373\u53ef) # log_slave_updates=1 # \u53ef\u9078\uff1a\u5982\u679c\u9019\u500b Slave \u4e5f\u6703\u4f5c\u70ba\u5176\u4ed6 Slave \u7684 Master\uff0c\u5247\u9700\u8981\u555f\u7528 bind-address=192.168.1.101 # \u78ba\u4fdd MySQL \u76e3\u807d\u7684\u662f Slave \u7684 IP \u4f4d\u5740 (\u5982\u679c\u9700\u8981\u5916\u90e8\u9023\u7dda)<\/code>\n<ul class=\"wp-block-list\">\n<li><strong><code>server-id<\/code>\uff1a<\/strong> \u70ba\u4f60\u7684 Slave \u4f3a\u670d\u5668\u8a2d\u5b9a\u4e00\u500b\u552f\u4e00\u7684\u6574\u6578 ID\uff0c<strong>\u5fc5\u9808\u8207 Master \u7684 <code>server-id<\/code> \u4e0d\u540c<\/strong>\u3002<\/li>\n\n\n\n<li><strong><code>relay_log<\/code>\uff1a<\/strong> Slave \u4f3a\u670d\u5668\u6703\u4f7f\u7528 Relay Log \u4f86\u8a18\u9304\u5f9e Master \u63a5\u6536\u5230\u7684 Binary Log \u4e8b\u4ef6\u3002\u9810\u8a2d\u6703\u81ea\u52d5\u8a2d\u5b9a\u3002<\/li>\n\n\n\n<li><strong><code>log_slave_updates<\/code>\uff1a<\/strong> \u5982\u679c\u9019\u500b Slave \u4f3a\u670d\u5668\u672a\u4f86\u4e5f\u53ef\u80fd\u4f5c\u70ba\u5176\u4ed6 Slave \u4f3a\u670d\u5668\u7684 Master\uff0c\u4f60\u9700\u8981\u555f\u7528\u9019\u500b\u9078\u9805\uff0c\u8b93 Slave \u4e5f\u8a18\u9304\u5b83\u57f7\u884c\u7684\u66f4\u65b0\u5230\u81ea\u5df1\u7684 Binary Log \u4e2d\u3002<\/li>\n\n\n\n<li><strong><code>bind-address<\/code>\uff1a<\/strong> \u78ba\u4fdd MySQL \u76e3\u807d\u7684\u662f Slave \u4f3a\u670d\u5668\u7684 IP \u4f4d\u5740\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u91cd\u65b0\u555f\u52d5 MySQL \u4f3a\u670d\u5668\uff1a<\/strong><ul><li>\u5132\u5b58\u5c0d\u914d\u7f6e\u6587\u4ef6\u7684\u66f4\u6539\u4e26\u91cd\u65b0\u555f\u52d5 MySQL \u670d\u52d9\uff1a<\/li><\/ul>Bash<code>sudo systemctl restart mysql<\/code><\/li>\n\n\n\n<li><strong>\u532f\u5165 Master \u4f3a\u670d\u5668\u7684\u5099\u4efd\u8cc7\u6599\uff1a<\/strong><ul><li>\u5c07\u4f60\u5728 Master \u4f3a\u670d\u5668\u4e0a\u5099\u4efd\u7684 SQL \u6a94\u6848 (<code>\/tmp\/master_backup.sql<\/code> \u6216 <code>\/tmp\/mysite_backup.sql<\/code>) \u50b3\u8f38\u5230 Slave \u4f3a\u670d\u5668\u4e0a\uff08\u4f8b\u5982\u4f7f\u7528 <code>scp<\/code> \u547d\u4ee4\uff09\u3002\u5047\u8a2d\u4f60\u5c07\u5176\u50b3\u8f38\u5230 Slave \u4f3a\u670d\u5668\u7684 <code>\/tmp<\/code> \u76ee\u9304\u3002<\/li><li>\u767b\u5165\u5230 Slave \u4f3a\u670d\u5668\u7684 MySQL\uff1a<\/li><\/ul>Bash<code>mysql -u root -p<\/code><ul><li>\u532f\u5165\u5099\u4efd\u6a94\u6848\uff1a<\/li><\/ul>SQL<code>SOURCE \/tmp\/master_backup.sql; # \u5982\u679c\u4f60\u5099\u4efd\u4e86\u6240\u6709\u8cc7\u6599\u5eab # \u6216\u8005 SOURCE \/tmp\/mysite_backup.sql; # \u5982\u679c\u4f60\u53ea\u5099\u4efd\u4e86 mySite \u8cc7\u6599\u5eab<\/code><ul><li>\u9000\u51fa MySQL \u547d\u4ee4\u5217\uff1a<\/li><\/ul>SQL<code>exit<\/code><\/li>\n\n\n\n<li><strong>\u914d\u7f6e Slave \u4f3a\u670d\u5668\u4ee5\u9023\u63a5\u5230 Master\uff1a<\/strong><ul><li>\u518d\u6b21\u767b\u5165\u5230 Slave \u4f3a\u670d\u5668\u7684 MySQL\uff1a<\/li><\/ul>Bash<code>mysql -u root -p<\/code><ul><li>\u4f7f\u7528 <code>CHANGE MASTER TO<\/code> \u547d\u4ee4\u914d\u7f6e Slave \u9023\u63a5\u5230 Master\u3002\u5c07 <code>&lt;master_ip&gt;<\/code>, <code>&lt;replication_user&gt;<\/code>, <code>&lt;replication_password&gt;<\/code>, <code>&lt;master_log_file&gt;<\/code>, \u548c <code>&lt;master_log_position&gt;<\/code> \u66ff\u63db\u70ba\u4f60\u5728 Master \u4f3a\u670d\u5668\u4e0a\u53d6\u5f97\u7684\u5be6\u969b\u503c\u548c\u4f60\u5728 Master \u4e0a\u5efa\u7acb\u7684\u8907\u88fd\u4f7f\u7528\u8005\u8cc7\u8a0a\uff1a<\/li><\/ul>SQL<code>CHANGE MASTER TO MASTER_HOST='192.168.1.100', MASTER_USER='&lt;slave_user&gt;', MASTER_PASSWORD='&lt;your_password&gt;', MASTER_LOG_FILE='&lt;File \u503c&gt;', MASTER_LOG_POS=&lt;Position \u503c&gt;;<\/code><ul><li>\u4f8b\u5982\uff1a<\/li><\/ul>SQL<code>CHANGE MASTER TO MASTER_HOST='192.168.1.100', MASTER_USER='replica', MASTER_PASSWORD='your_secret_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=123;<\/code><\/li>\n\n\n\n<li><strong>\u555f\u52d5 Slave \u7684\u8907\u88fd\u9032\u7a0b\uff1a<\/strong> SQL<code>START SLAVE;<\/code><\/li>\n\n\n\n<li><strong>\u6aa2\u67e5 Slave \u7684\u8907\u88fd\u72c0\u614b\uff1a<\/strong> SQL<code>SHOW SLAVE STATUS\\G<\/code>\n<ul class=\"wp-block-list\">\n<li>\u4ed4\u7d30\u67e5\u770b\u8f38\u51fa\u7d50\u679c\u3002\u4f60\u9700\u8981\u95dc\u6ce8\u4ee5\u4e0b\u5e7e\u500b\u91cd\u8981\u7684\u6b04\u4f4d\uff1a\n<ul class=\"wp-block-list\">\n<li><code>Slave_IO_State<\/code>: \u61c9\u8a72\u986f\u793a <code>Waiting for master to send event<\/code>\u3002<\/li>\n\n\n\n<li><code>Slave_SQL_Running_State<\/code>: \u61c9\u8a72\u986f\u793a <code>Slave has read all relay log; waiting for more updates<\/code>\u3002<\/li>\n\n\n\n<li><code>Seconds_Behind_Master<\/code>: \u61c9\u8a72\u662f <code>0<\/code> (\u6216\u975e\u5e38\u5c0f\u7684\u6578\u503c)\uff0c\u8868\u793a Slave \u8207 Master \u7684\u540c\u6b65\u6c92\u6709\u5ef6\u9072\u3002\u5982\u679c\u9019\u500b\u503c\u5f88\u5927\uff0c\u8868\u793a Slave \u843d\u5f8c\u65bc Master\u3002<\/li>\n\n\n\n<li><code>Master_Log_File<\/code>: \u986f\u793a Slave \u7576\u524d\u6b63\u5728\u8b80\u53d6\u7684 Master \u7684 Binary Log \u6587\u4ef6\u540d\u3002<\/li>\n\n\n\n<li><code>Read_Master_Log_Pos<\/code>: \u986f\u793a Slave \u5728 Master \u7684 Binary Log \u4e2d\u7684\u8b80\u53d6\u4f4d\u7f6e\u3002<\/li>\n\n\n\n<li><code>Relay_Log_File<\/code>: \u986f\u793a Slave \u7576\u524d\u6b63\u5728\u5beb\u5165\u6216\u57f7\u884c\u7684 Relay Log \u6587\u4ef6\u540d\u3002<\/li>\n\n\n\n<li><code>Relay_Log_Pos<\/code>: \u986f\u793a Slave \u5728 Relay Log \u4e2d\u7684\u4f4d\u7f6e\u3002<\/li>\n\n\n\n<li><code>Last_IO_Error<\/code> \u548c <code>Last_SQL_Error<\/code>: \u5982\u679c\u6709\u932f\u8aa4\uff0c\u9019\u88e1\u6703\u986f\u793a\u932f\u8aa4\u8a0a\u606f\u3002\u78ba\u4fdd\u9019\u5169\u500b\u6b04\u4f4d\u90fd\u662f\u7a7a\u7684\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u6e2c\u8a66\u8907\u88fd\uff1a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5728 Master \u4f3a\u670d\u5668\u4e0a\u57f7\u884c\u4e00\u4e9b\u5beb\u5165\u64cd\u4f5c\uff08\u4f8b\u5982\u63d2\u5165\u3001\u66f4\u65b0\u3001\u522a\u9664\u8cc7\u6599\uff09\u3002<\/li>\n\n\n\n<li>\u5728 Slave \u4f3a\u670d\u5668\u4e0a\u67e5\u8a62\u8cc7\u6599\uff0c\u78ba\u8a8d\u9019\u4e9b\u64cd\u4f5c\u662f\u5426\u5df2\u7d93\u540c\u6b65\u904e\u4f86\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><strong>\u505c\u6b62\u548c\u555f\u52d5 Slave \u8907\u88fd\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u505c\u6b62 Slave \u8907\u88fd\uff1a SQL<code>STOP SLAVE;<\/code><\/li>\n\n\n\n<li>\u555f\u52d5 Slave \u8907\u88fd\uff1a SQL<code>START SLAVE;<\/code><\/li>\n<\/ul>\n\n\n\n<p><strong>\u6ce8\u610f\u4e8b\u9805\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u78ba\u4fdd Master \u548c Slave \u4f3a\u670d\u5668\u7684\u6642\u9418\u540c\u6b65\uff0c\u53ef\u4ee5\u4f7f\u7528 NTP \u670d\u52d9\u3002<\/li>\n\n\n\n<li>\u7db2\u8def\u7a69\u5b9a\u6027\u5c0d\u65bc\u8907\u88fd\u81f3\u95dc\u91cd\u8981\u3002<\/li>\n\n\n\n<li>\u76e3\u63a7\u8907\u88fd\u72c0\u614b\uff0c\u53ca\u6642\u8655\u7406\u53ef\u80fd\u51fa\u73fe\u7684\u932f\u8aa4\u3002<\/li>\n\n\n\n<li>\u5728\u751f\u7522\u74b0\u5883\u4e2d\u9032\u884c\u4efb\u4f55\u914d\u7f6e\u66f4\u6539\u4e4b\u524d\uff0c\u52d9\u5fc5\u5728\u6e2c\u8a66\u74b0\u5883\u4e2d\u9032\u884c\u5145\u5206\u7684\u6e2c\u8a66\u3002<\/li>\n\n\n\n<li>\u5982\u679c\u4f60\u7684 Master \u4e0a\u555f\u7528\u4e86\u9632\u706b\u7246\uff0c\u8acb\u78ba\u4fdd\u5141\u8a31\u4f86\u81ea Slave IP \u4f4d\u5740\u7684 MySQL \u9023\u63a5 (\u9810\u8a2d\u662f 3306 \u7aef\u53e3)\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u5b8c\u6210\u4ee5\u4e0a\u6b65\u9a5f\u5f8c\uff0c\u4f60\u5c31\u6210\u529f\u914d\u7f6e\u4e86\u50b3\u7d71\u7684 MySQL \u4e3b\u5f9e\u8907\u88fd\u3002Master \u4f3a\u670d\u5668\u4e0a\u7684\u8cc7\u6599\u8b8a\u66f4\u5c07\u6703\u81ea\u52d5\u540c\u6b65\u5230 Slave \u4f3a\u670d\u5668\u3002Slave \u4f3a\u670d\u5668\u53ef\u4ee5\u7528\u65bc\u8b80\u53d6\u64cd\u4f5c\uff0c\u6216\u8005\u5728 Master \u4f3a\u670d\u5668\u767c\u751f\u6545\u969c\u6642\uff0c\u53ef\u4ee5\u5c07 Slave \u63d0\u5347\u70ba\u65b0\u7684 Master (\u9700\u8981\u624b\u52d5\u64cd\u4f5c)\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u597d\u7684\uff0c\u7576\u7136\u53ef\u4ee5\uff01\u5728\u5169\u500b\u4e0d\u540c\u7684 MySQL \u4e3b\u6a5f\u4e4b\u9593\u5efa\u7acb\u8cc7\u6599\u8868\u7684\u4e92\u76f8\u5099\u63f4\u6a5f\u5236\uff0c\u6700\u5e38\u898b\u4e14\u6709\u6548\u7684\u65b9\u5f0f\u5c31\u662f\u4f7f\u7528 MyS&#8230;<\/p>\n","protected":false},"author":1,"featured_media":5070,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5049","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/5049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5049"}],"version-history":[{"count":5,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/5049\/revisions"}],"predecessor-version":[{"id":5071,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/5049\/revisions\/5071"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/media\/5070"}],"wp:attachment":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}