{"id":1325,"date":"2021-05-16T16:12:14","date_gmt":"2021-05-16T08:12:14","guid":{"rendered":"http:\/\/diuut.com\/?p=1325"},"modified":"2021-05-16T16:12:15","modified_gmt":"2021-05-16T08:12:15","slug":"mysql%e5%ae%89%e8%a3%85%e4%bb%a5%e5%8f%8a%e9%85%8d%e7%bd%ae%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6","status":"publish","type":"post","link":"https:\/\/diuut.com\/?p=1325","title":{"rendered":"MySQL\u5b89\u88c5\u4ee5\u53ca\u914d\u7f6e\u4e3b\u4ece\u590d\u5236"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote\"><p>\u9700\u6c42<\/p><cite>\u4e09\u53f0\u670d\u52a1\u5668\u4e0a\u642d\u5efaMySQL\u4e00\u4e3b\u4e24\u4ece\u4e3b\u4ece\u590d\u5236\u914d\u7f6e<\/cite><\/blockquote>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_66_1 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\">\u76ee\u5f55<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%AE%89%E8%A3%85%E7%8E%AF%E5%A2%83\" title=\"\u5b89\u88c5\u73af\u5883\">\u5b89\u88c5\u73af\u5883<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%87%86%E5%A4%87%E5%A5%BD%E5%AE%89%E8%A3%85%E5%8C%85\" title=\"\u51c6\u5907\u597d\u5b89\u88c5\u5305\">\u51c6\u5907\u597d\u5b89\u88c5\u5305<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%A4%8D%E5%88%B6%E8%87%B3%E5%AE%89%E8%A3%85%E7%8E%AF%E5%A2%83%E4%B8%AD\" title=\"\u590d\u5236\u81f3\u5b89\u88c5\u73af\u5883\u4e2d\">\u590d\u5236\u81f3\u5b89\u88c5\u73af\u5883\u4e2d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/diuut.com\/?p=1325\/#%E7%B3%BB%E7%BB%9F%E9%85%8D%E7%BD%AE\" title=\"\u7cfb\u7edf\u914d\u7f6e\">\u7cfb\u7edf\u914d\u7f6e<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/diuut.com\/?p=1325\/#%E9%85%8D%E7%BD%AEetchosts\" title=\"\u914d\u7f6e\/etc\/hosts\">\u914d\u7f6e\/etc\/hosts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%85%B3%E9%97%AD%E9%98%B2%E7%81%AB%E5%A2%99\" title=\"\u5173\u95ed\u9632\u706b\u5899\">\u5173\u95ed\u9632\u706b\u5899<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/diuut.com\/?p=1325\/#%E7%A6%81%E6%8E%89Selinux\" title=\"\u7981\u6389Selinux\">\u7981\u6389Selinux<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%BF%AE%E6%94%B9limitsconf_%E6%96%87%E4%BB%B6\" title=\"\u4fee\u6539limits.conf \u6587\u4ef6\">\u4fee\u6539limits.conf \u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%88%9B%E5%BB%BAmysql%E7%94%A8%E6%88%B7\" title=\"\u521b\u5efamysql\u7528\u6237\">\u521b\u5efamysql\u7528\u6237<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%88%9B%E5%BB%BA%E5%AE%89%E8%A3%85%E7%9B%AE%E5%BD%95\" title=\"\u521b\u5efa\u5b89\u88c5\u76ee\u5f55\">\u521b\u5efa\u5b89\u88c5\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%8D%B8%E8%BD%BD%E7%B3%BB%E7%BB%9F%E8%87%AA%E5%B8%A6%E7%9A%84mariadb\" title=\"\u5378\u8f7d\u7cfb\u7edf\u81ea\u5e26\u7684mariadb\">\u5378\u8f7d\u7cfb\u7edf\u81ea\u5e26\u7684mariadb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/diuut.com\/?p=1325\/#%E8%A7%A3%E5%8E%8B%E5%AE%89%E8%A3%85%E6%96%87%E4%BB%B6\" title=\"\u89e3\u538b\u5b89\u88c5\u6587\u4ef6\">\u89e3\u538b\u5b89\u88c5\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/diuut.com\/?p=1325\/#%E9%85%8D%E7%BD%AEmysql%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8F\" title=\"\u914d\u7f6emysql\u73af\u5883\u53d8\u91cf\">\u914d\u7f6emysql\u73af\u5883\u53d8\u91cf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/diuut.com\/?p=1325\/#%E9%85%8D%E7%BD%AEmycnf\" title=\"\u914d\u7f6emy.cnf\">\u914d\u7f6emy.cnf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/diuut.com\/?p=1325\/#%E5%88%9D%E5%A7%8B%E5%8C%96mysql\" title=\"\u521d\u59cb\u5316mysql\">\u521d\u59cb\u5316mysql<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%B8%BB%E4%BB%8E%E8%8A%82%E7%82%B9%E9%83%BD%E5%90%AF%E5%8A%A8mysql%E6%9C%8D%E5%8A%A1\" title=\"\u4e3b\u4ece\u8282\u70b9\u90fd\u542f\u52a8mysql\u670d\u52a1\">\u4e3b\u4ece\u8282\u70b9\u90fd\u542f\u52a8mysql\u670d\u52a1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%BF%AE%E6%94%B9root%E5%AF%86%E7%A0%81\" title=\"\u4fee\u6539root\u5bc6\u7801\">\u4fee\u6539root\u5bc6\u7801<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%B8%BB%E4%BB%8E%E9%85%8D%E7%BD%AE\" title=\"\u4e3b\u4ece\u914d\u7f6e\">\u4e3b\u4ece\u914d\u7f6e<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/diuut.com\/?p=1325\/#2%E4%B8%AA%E4%BB%8E%E8%8A%82%E7%82%B9%E9%85%8D%E7%BD%AE%E5%A4%8D%E5%88%B6%E9%80%9A%E9%81%93db2db3\" title=\"2\u4e2a\u4ece\u8282\u70b9\u914d\u7f6e\u590d\u5236\u901a\u9053(db2\/db3)\">2\u4e2a\u4ece\u8282\u70b9\u914d\u7f6e\u590d\u5236\u901a\u9053(db2\/db3)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%BB%8E%E8%8A%82%E7%82%B9%E5%90%AF%E5%8A%A8%E5%A4%8D%E5%88%B6%E8%BF%9B%E7%A8%8B%E5%B9%B6%E6%A3%80%E6%9F%A5%E5%A4%8D%E5%88%B6%E7%8A%B6%E6%80%81\" title=\"\u4ece\u8282\u70b9\u542f\u52a8\u590d\u5236\u8fdb\u7a0b\u5e76\u68c0\u67e5\u590d\u5236\u72b6\u6001\">\u4ece\u8282\u70b9\u542f\u52a8\u590d\u5236\u8fdb\u7a0b\u5e76\u68c0\u67e5\u590d\u5236\u72b6\u6001<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%BB%8E%E8%8A%82%E7%82%B9%E5%BC%80%E5%90%AFsuper_read_only_slave%E5%8F%AA%E8%AF%BB\" title=\"\u4ece\u8282\u70b9\u5f00\u542fsuper_read_only (slave\u53ea\u8bfb)\">\u4ece\u8282\u70b9\u5f00\u542fsuper_read_only (slave\u53ea\u8bfb)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/diuut.com\/?p=1325\/#%E4%B8%BB%E8%8A%82%E7%82%B9%E5%88%9B%E5%BB%BAtest%E5%BA%93db1\" title=\"\u4e3b\u8282\u70b9\u521b\u5efatest\u5e93(db1)\">\u4e3b\u8282\u70b9\u521b\u5efatest\u5e93(db1)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/diuut.com\/?p=1325\/#%E6%B5%8B%E8%AF%95%E4%B8%BB%E4%BB%8E%E5%88%87%E6%8D%A2\" title=\"\u6d4b\u8bd5\u4e3b\u4ece\u5207\u6362\">\u6d4b\u8bd5\u4e3b\u4ece\u5207\u6362<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/diuut.com\/?p=1325\/#%E9%87%8D%E6%96%B0%E5%B0%86%E4%B8%BB%E8%8A%82%E7%82%B9%E5%88%87%E6%88%90db1\" title=\"\u91cd\u65b0\u5c06\u4e3b\u8282\u70b9\u5207\u6210db1\">\u91cd\u65b0\u5c06\u4e3b\u8282\u70b9\u5207\u6210db1<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h4><span class=\"ez-toc-section\" id=\"%E5%AE%89%E8%A3%85%E7%8E%AF%E5%A2%83\"><\/span>\u5b89\u88c5\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u5b9e\u9645\u4e2d\u662f\u4e09\u53f0\u5b9e\u4f53\u673a\u4e0a\u5206\u522b\u90e8\u7f72\uff0c\u8fd9\u91cc\u4e3a\u4e86\u6f14\u793a\u622a\u56fe\uff0c\u91c7\u7528\u865a\u62df\u673a\u4e2d\u90e8\u7f72\u4e86\u4e09\u4e2aLinux\u73af\u5883\uff0c\u7f51\u7edc\u8bbe\u7f6e\u4e3a\u6865\u63a5\u6a21\u5f0f<\/p>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"%E5%87%86%E5%A4%87%E5%A5%BD%E5%AE%89%E8%A3%85%E5%8C%85\"><\/span>\u51c6\u5907\u597d\u5b89\u88c5\u5305<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p class=\"has-text-align-left\">https:\/\/downloads.mysql.com\/archives\/community\/&nbsp;\u4e2d\u9009\u62e95.7.32-el7-x86_64.tar.gz<\/p>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"%E5%A4%8D%E5%88%B6%E8%87%B3%E5%AE%89%E8%A3%85%E7%8E%AF%E5%A2%83%E4%B8%AD\"><\/span>\u590d\u5236\u81f3\u5b89\u88c5\u73af\u5883\u4e2d<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u5982\u679c\u662f\u5185\u7f51\u73af\u5883\u6ca1\u6709\u5916\u7f51yum\uff0c\u53ef\u4ee5\u901a\u8fc7powerShell \u4e2dscp\u6307\u4ee4 \u5148\u653e\u597d\u538b\u7f29\u5305<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nscp localFile root@192.168.0.106:\/usr\/\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"79\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image.png\" alt=\"\" class=\"wp-image-1326\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-300x43.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"%E7%B3%BB%E7%BB%9F%E9%85%8D%E7%BD%AE\"><\/span>\u7cfb\u7edf\u914d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AEetchosts\"><\/span>\u914d\u7f6e\/etc\/hosts<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nvi \/etc\/hosts\n\n192.168.253.100  db1\n192.168.253.101  db2\n192.168.253.102  db3\n\/\/\u6362\u6210\u81ea\u5df1\u5bf9\u5e94\u7684\u5404\u4e2aip\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"138\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-1.png\" alt=\"\" class=\"wp-image-1328\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-1.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-1-300x75.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E5%85%B3%E9%97%AD%E9%98%B2%E7%81%AB%E5%A2%99\"><\/span>\u5173\u95ed\u9632\u706b\u5899<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsystemctl stop firewalld        \t\t#\u505c\u6b62firewall\nsystemctl disable firewalld\t\t\t#\u7981\u6b62firewall\u5f00\u673a\u542f\u52a8\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"66\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-2.png\" alt=\"\" class=\"wp-image-1329\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-2.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-2-300x36.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E7%A6%81%E6%8E%89Selinux\"><\/span>\u7981\u6389Selinux<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nsetenforce 0\nsed -i 's\/SELINUX=.*\/SELINUX=disabled\/' \/etc\/selinux\/config\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"33\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-3.png\" alt=\"\" class=\"wp-image-1330\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-3.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-3-300x18.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%BF%AE%E6%94%B9limitsconf_%E6%96%87%E4%BB%B6\"><\/span>\u4fee\u6539limits.conf \u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nvi \/etc\/security\/limits.conf\nmysql        soft  nproc      65535\nmysql        hard  nproc      65535\nmysql        soft  nofile     65535\nmysql        hard  nofile     65535\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"389\" height=\"24\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-5.png\" alt=\"\" class=\"wp-image-1333\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-5.png 389w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-5-300x19.png 300w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"516\" height=\"255\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-6.png\" alt=\"\" class=\"wp-image-1334\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-6.png 516w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-6-300x148.png 300w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-6-216x108.png 216w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BAmysql%E7%94%A8%E6%88%B7\"><\/span>\u521b\u5efamysql\u7528\u6237<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nuseradd mysql \npasswd mysql\t\t\t\t#\u5bc6\u7801\u81ea\u884c\u914d\u7f6e\uff0c\u8fd9\u91cc\u7528\u7684 password\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"101\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-7.png\" alt=\"\" class=\"wp-image-1335\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-7.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-7-300x55.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E5%AE%89%E8%A3%85%E7%9B%AE%E5%BD%95\"><\/span>\u521b\u5efa\u5b89\u88c5\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nmkdir -p  \/data\/{log,data,tmp,binlog,relaylog}\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"552\" height=\"71\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-8.png\" alt=\"\" class=\"wp-image-1336\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-8.png 552w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-8-300x39.png 300w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E5%8D%B8%E8%BD%BD%E7%B3%BB%E7%BB%9F%E8%87%AA%E5%B8%A6%E7%9A%84mariadb\"><\/span>\u5378\u8f7d\u7cfb\u7edf\u81ea\u5e26\u7684mariadb<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nrpm -qa|grep mariadb\nrpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"52\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-9.png\" alt=\"\" class=\"wp-image-1351\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-9.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-9-300x28.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E8%A7%A3%E5%8E%8B%E5%AE%89%E8%A3%85%E6%96%87%E4%BB%B6\"><\/span>\u89e3\u538b\u5b89\u88c5\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\ntar -xzvf \/root\/mysql-5.7.32-el7-x86_64.tar.gz -C \/\nmv \/mysql-5.7.32-el7-x86_64 \/mysql\nchown -R mysql:mysql \/mysql \/data\t     #\u9012\u5f52\u6539\u53d8\u6587\u4ef6\u7528\u6237\u6240\u6709\u6743\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"28\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-10.png\" alt=\"\" class=\"wp-image-1352\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-10.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-10-300x15.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"534\" height=\"282\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-11.png\" alt=\"\" class=\"wp-image-1353\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-11.png 534w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-11-300x158.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AEmysql%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8F\"><\/span>\u914d\u7f6emysql\u73af\u5883\u53d8\u91cf<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\ncp \/mysql\/support-files\/mysql.server \/etc\/init.d\/mysqld\nlfconfig\t\t\t\t\t\t\necho &quot;PATH=$PATH:\/mysql\/bin&quot; &gt; \/etc\/profile.d\/mysql.sh\nsource \/etc\/profile.d\/mysql.sh\nchkconfig mysqld on\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"247\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-12.png\" alt=\"\" class=\"wp-image-1354\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-12.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-12-300x134.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AEmycnf\"><\/span>\u914d\u7f6emy.cnf<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nvi \/etc\/my.cnf\n#\uff08master\u548cslave\u53ea\u6709server_id\u4e0d\u540c\uff09\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"24\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-13.png\" alt=\"\" class=\"wp-image-1355\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-13.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-13-300x13.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#91;client]\nsocket=\/mysql\/mysql.sock\n&#91;mysqld] \nport=3306\nuser=mysql\nbasedir=\/mysql #mysql\u8def\u5f84\nsocket=\/mysql\/mysql.sock\n#\u52a0\u8f7d\u534a\u540c\u6b65\u590d\u5236\u4e3b\u5907\u63d2\u4ef6\nplugin-load-add=semisync_master.so\nplugin-load-add=semisync_slave.so\nsymbolic-links=0\nlog-error=\/data\/log\/mysqld.log\nslow_query_log_file=\/data\/log\/slow.log\nslow_query_log=1\nlong_query_time=0.3\n#server_id\u4e09\u53f0\u5206\u522b\u662f1,2,3\nserver_id=1\n#\u5f00\u542fgtid\u6a21\u5f0f\ngtid_mode=ON\nenforce_gtid_consistency=ON\nmaster_info_repository=TABLE\nrelay_log_info_repository=TABLE\nrelay_log_recovery=1\nbinlog_checksum=NONE\nlog_slave_updates=ON\nlog_bin=\/data\/binlog\/binlog\nrelay_log=\/data\/relaylog\/relaylog\nbinlog_format=ROW\ntransaction_write_set_extraction=XXHASH64\ndatadir=\/data\/data\nslave_parallel_type=LOGICAL_CLOCK\nslave_preserve_commit_order=1\nslave_parallel_workers =4  \ninnodb_file_per_table\nsync_binlog = 1\nbinlog-group-commit-sync-delay=20  \nbinlog_group_commit_sync_no_delay_count=5  \ninnodb_lock_wait_timeout = 50\ninnodb_rollback_on_timeout = ON\ninnodb_io_capacity = 5000  \ninnodb_io_capacity_max=15000\ninnodb_thread_concurrency = 0\ninnodb_sync_spin_loops = 200\ninnodb_spin_wait_delay = 6\ninnodb_status_file = 1\ninnodb_purge_threads=4\ninnodb_undo_log_truncate=1  \ninnodb_max_undo_log_size=4G\ninnodb_use_native_aio = 1\ninnodb_autoinc_lock_mode = 2\nlog_slow_admin_statements=1\nexpire_logs_days=7  \ncharacter-set-server=utf8mb4\ncollation-server= utf8mb4_bin\nskip-name-resolve\nlower_case_table_names\nskip-external-locking\nmax_allowed_packet = 1024M\ntable_open_cache = 4000\ntable_open_cache_instances=16\nmax_connections = 4000\nquery_cache_size = 0\nquery_cache_type = 0\ntmp_table_size = 1024M\nmax_heap_table_size = 1024M\ninnodb_log_files_in_group = 3\ninnodb_log_file_size = 1024M\ninnodb_flush_method= O_DIRECT\nlog_timestamps=SYSTEM\n#\u4e09\u4e2a\u8282\u70b9auto_increment_offset\u7684\u503c\u53ef\u4ee5\u8ddfserver_id\u76f8\u540c\nauto_increment_offset=1\nauto_increment_increment=6  \nexplicit_defaults_for_timestamp\nlog_bin_trust_function_creators = 1\ntransaction-isolation = READ-COMMITTED\ninnodb_buffer_pool_instances=8\ninnodb_write_io_threads=4  \ninnodb_read_io_threads=4 \n#\u751f\u4ea7\u73af\u5883\u589e\u52a0\ninnodb_buffer_pool_size=2G  \ninnodb_flush_log_at_trx_commit=1\n#\u8bbe\u7f6e\u4ece\u8282\u70b9\u5e94\u7528relaylog\u540e\u4ea7\u751fbinlog\nlog_slave_updates=1\n#\u8bbe\u7f6e\u4e0d\u81ea\u52a8\u5220\u9664relaylog\n#relay_log_purge=0\n#\u8bbe\u7f6e\u589e\u5f3a\u534a\u540c\u6b65\u590d\u5236\u53c2\u6570\nrpl_semi_sync_master_wait_point= AFTER_SYNC\nrpl_semi_sync_master_enabled=1\nrpl_semi_sync_master_timeout=1000\nrpl_semi_sync_slave_enabled=1\nsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\n<\/pre><\/div>\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E5%88%9D%E5%A7%8B%E5%8C%96mysql\"><\/span>\u521d\u59cb\u5316mysql<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n\/mysql\/bin\/mysqld --user=mysql --basedir=\/mysql --datadir=\/data\/data --initialize\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"41\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-14.png\" alt=\"\" class=\"wp-image-1356\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-14.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-14-300x22.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%B8%BB%E4%BB%8E%E8%8A%82%E7%82%B9%E9%83%BD%E5%90%AF%E5%8A%A8mysql%E6%9C%8D%E5%8A%A1\"><\/span>\u4e3b\u4ece\u8282\u70b9\u90fd\u542f\u52a8mysql\u670d\u52a1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n\u542f\u52a8\u524d\u5148\u521b\u5efamysql\u65e5\u5fd7\u6587\u4ef6\nsu - mysql\ntouch \/data\/log\/mysqld.log\nexit\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"449\" height=\"67\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-15.png\" alt=\"\" class=\"wp-image-1357\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-15.png 449w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-15-300x45.png 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nsystemctl start mysqld\n#\u786e\u4fdd\u542f\u52a8\u6ca1\u62a5\u9519\uff0cps -ef|grep mysql \u53ef\u4ee5\u770b\u5230\u8fdb\u7a0b\n<\/pre><\/div>\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%BF%AE%E6%94%B9root%E5%AF%86%E7%A0%81\"><\/span>\u4fee\u6539root\u5bc6\u7801<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n#\uff08\u4e3b\u4ece\u8282\u70b9\u5747\u9700\u6267\u884c,\u6ce8\u610froot\u5bc6\u7801\uff09\nroot\u521d\u59cb\u5bc6\u7801\u67e5\u627e\uff1a grep password  \/data\/log\/mysqld.log \nmysql -uroot -pR00T_12344\nmysql&gt;SET SQL_LOG_BIN=0;\nset password='R00T_12344'; \nFLUSH PRIVILEGES;\nuse mysql;\nupdate user set host = '%' where user = 'R00T_12344';\nflush privileges;\nSET SQL_LOG_BIN=1;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"216\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-16.png\" alt=\"\" class=\"wp-image-1358\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-16.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-16-300x117.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"369\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-17.png\" alt=\"\" class=\"wp-image-1359\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-17.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-17-300x200.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n#select user,host from mysql.user \u53ef\u4ee5\u67e5\u770b\u5f53\u524d\u5df2\u5f00\u653e\n#\u5982\u67e5\u8be2\u540eroot\u6ca1\u6709\u5f00\u653e\u6743\u9650\uff0c\u5c1d\u8bd5\u4f7f\u7528  \nGRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY 'R00T_12344' WITH GRANT OPTION;\nflush privileges;\n\n<\/pre><\/div>\n\n\n<h4><span class=\"ez-toc-section\" id=\"%E4%B8%BB%E4%BB%8E%E9%85%8D%E7%BD%AE\"><\/span>\u4e3b\u4ece\u914d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"2%E4%B8%AA%E4%BB%8E%E8%8A%82%E7%82%B9%E9%85%8D%E7%BD%AE%E5%A4%8D%E5%88%B6%E9%80%9A%E9%81%93db2db3\"><\/span>2\u4e2a\u4ece\u8282\u70b9\u914d\u7f6e\u590d\u5236\u901a\u9053(db2\/db3)<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql&gt;change master to master_host='db1',master_port=3306,master_user='root',master_password='R00T_12344',MASTER_AUTO_POSITION=1;\t \n\n#\u56e0\u4e3a\u5f00\u542f\u4e86gtid\uff0c\u53ef\u4ee5\u8bbe\u7f6eMASTER_AUTO_POSITION=1\u4f7f\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u6309\u7167gtid\u7684\u4f4d\u7f6e\u590d\u5236\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"36\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-18.png\" alt=\"\" class=\"wp-image-1363\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-18.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-18-300x19.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%BB%8E%E8%8A%82%E7%82%B9%E5%90%AF%E5%8A%A8%E5%A4%8D%E5%88%B6%E8%BF%9B%E7%A8%8B%E5%B9%B6%E6%A3%80%E6%9F%A5%E5%A4%8D%E5%88%B6%E7%8A%B6%E6%80%81\"><\/span>\u4ece\u8282\u70b9\u542f\u52a8\u590d\u5236\u8fdb\u7a0b\u5e76\u68c0\u67e5\u590d\u5236\u72b6\u6001<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n#\u542f\u52a8slave\nmysql&gt;START SLAVE; \n#\u67e5\u770b\u4ece\u5e93\u7684\u72b6\u6001\nmysql&gt;SHOW SLAVE STATUS\\G;\n\n#\u786e\u4fdd \uff1a\n#Slave_IO_Running: Yes \n#Slave_SQL_Running: Yes \n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"195\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-19.png\" alt=\"\" class=\"wp-image-1364\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-19.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-19-300x106.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<p>\u5c1d\u8bd5\u8fde\u63a5\u8fc7\u7a0b\u4e2d\u4f1a\u9047\u5230 \u4e24\u4e2aNo \u7684\u53ef\u80fd\u662f\u672a\u542f\u52a8start salve\uff1b<\/p>\n\n\n\n<p>\u5982\u679c\u662fconnectting yes \u7684\uff0c\u53ef\u80fd\u60c5\u51b5\u5c31\u6709\u591a\u79cd<\/p>\n\n\n\n<ol><li>\u9996\u5148\u6d4b\u8bd5ping db1\uff0c\u80fd\u5426ping\u901a\uff0c\u5982\u679c\u4e0d\u80fd\u8bf4\u660ehosts\u8bbe\u7f6e\u5931\u8d25\uff0c\u91cd\u65b0\u8bbe\u7f6e\uff1b<\/li><li>\u67e5\u770b\u9632\u706b\u5899\u4ee5\u53ca\u7aef\u53e3\u5f00\u653e\u60c5\u51b5\u662f\u5426\u5f00\u653e\uff1b<\/li><li>Change maset\u6307\u4ee4\u6709\u8bef\uff0c\u68c0\u67e5\u7528\u6237\u540d\u53ca\u5bc6\u7801\u662f\u5426\u6b63\u786e\uff1b<\/li><li>\u76f4\u63a5\u672c\u5730\u8fdc\u7a0b\u767b\u5f55mysql -uroot -pR00T_12344 -hdb1\uff0c\u5982\u679c\u4e0d\u80fd\u518d\u6392\u67e5\u8fdc\u7a0b\u767b\u5f55\u95ee\u9898\uff1b<\/li><\/ol>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%BB%8E%E8%8A%82%E7%82%B9%E5%BC%80%E5%90%AFsuper_read_only_slave%E5%8F%AA%E8%AF%BB\"><\/span>\u4ece\u8282\u70b9\u5f00\u542fsuper_read_only (slave\u53ea\u8bfb)<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nset global super_read_only=1;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"554\" height=\"78\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-22.png\" alt=\"\" class=\"wp-image-1367\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-22.png 554w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-22-300x42.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E4%B8%BB%E8%8A%82%E7%82%B9%E5%88%9B%E5%BB%BAtest%E5%BA%93db1\"><\/span>\u4e3b\u8282\u70b9\u521b\u5efatest\u5e93(db1)<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nmysql&gt;\ncreate database test;\nuse test;\ncreate table test (id int primary key);\ninsert into test values(1);\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"390\" height=\"288\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-20.png\" alt=\"\" class=\"wp-image-1365\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-20.png 390w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-20-300x222.png 300w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"523\" height=\"212\" src=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-21.png\" alt=\"\" class=\"wp-image-1366\" srcset=\"https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-21.png 523w, https:\/\/diuut.com\/wp-content\/uploads\/2021\/05\/image-21-300x122.png 300w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/figure>\n\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E4%B8%BB%E4%BB%8E%E5%88%87%E6%8D%A2\"><\/span>\u6d4b\u8bd5\u4e3b\u4ece\u5207\u6362<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n#\u4ece\u8282\u70b9db2\uff1a\uff08\u65b0\u4e3b\u8282\u70b9\uff09\nmysql&gt;\nstop slave;\nset global read_only=0;\n\n#\u539f\u4e3b\u8282\u70b9db1\uff1a\nmysql&gt;\nset global super_read_only=1;\nchange master to master_host='db2',master_port=3306,master_user='rpl_user',master_password='R00T_12344',MASTER_AUTO_POSITION=1;\nstart slave;\nshow slave status \\G;\n\n#\u4ece\u8282\u70b9db3\uff1a\nmysql&gt;\nshow slave status \\G;\nstop slave;\nchange master to master_host='db2',master_port=3306,master_user='rpl_user',master_password='R00T_12344',MASTER_AUTO_POSITION=1;\nstart slave;\nshow slave status \\G;\n\n#db2\u4e0a\u63d2\u5165\u6570\u636e\uff0c\u68c0\u67e5db1\uff0cdb3\u662f\u5426\u6570\u636e\u540c\u6b65\n\n<\/pre><\/div>\n\n\n<h5><span class=\"ez-toc-section\" id=\"%E9%87%8D%E6%96%B0%E5%B0%86%E4%B8%BB%E8%8A%82%E7%82%B9%E5%88%87%E6%88%90db1\"><\/span>\u91cd\u65b0\u5c06\u4e3b\u8282\u70b9\u5207\u6210db1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<p>\u6d4b\u8bd5\u8fc7\u7a0b\u7565\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u540e\u7eed\u6587\u7ae0\u4e2d\u5c06\u4f1a\u66f4\u65b0MHA\u9ad8\u53ef\u7528\u4ee5\u53ca\u8bfb\u5199\u5206\u79bb\u76f8\u5173\u5185\u5bb9\u3002<\/p>\n\n\n\n<p>\u672c\u6587\u7ae0\u4ec5\u7528\u4e8e\u4e2a\u4eba\u8bb0\u5f55\u53ca\u5b66\u4e60\u53c2\u8003\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9700\u6c42 \u4e09\u53f0\u670d\u52a1\u5668\u4e0a\u642d\u5efaMySQL\u4e00\u4e3b\u4e24\u4ece\u4e3b\u4ece\u590d\u5236\u914d\u7f6e \u5b89\u88c5\u73af\u5883 \u5b9e\u9645\u4e2d\u662f\u4e09\u53f0\u5b9e\u4f53\u673a\u4e0a\u5206\u522b\u90e8\u7f72\uff0c\u8fd9\u91cc\u4e3a\u4e86\u6f14\u793a\u622a\u56fe<span class=\"more-button\"><a href=\"https:\/\/diuut.com\/?p=1325\" class=\"more-link\">view all . . .<span class=\"screen-reader-text\">MySQL\u5b89\u88c5\u4ee5\u53ca\u914d\u7f6e\u4e3b\u4ece\u590d\u5236<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":1350,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[9],"_links":{"self":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1325"}],"collection":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1325"}],"version-history":[{"count":10,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1325\/revisions"}],"predecessor-version":[{"id":1368,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1325\/revisions\/1368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/media\/1350"}],"wp:attachment":[{"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}