{"id":244,"date":"2024-08-14T15:38:36","date_gmt":"2024-08-14T07:38:36","guid":{"rendered":"https:\/\/www.zhukaifu.cn\/?p=244"},"modified":"2024-10-13T16:57:13","modified_gmt":"2024-10-13T08:57:13","slug":"%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8docker-%e6%b5%8b%e8%af%95mysql%e4%b8%bb%e4%bb%8e%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/www.zhukaifu.cn\/?p=244","title":{"rendered":"\u5982\u4f55\u4f7f\u7528docker \u6d4b\u8bd5mysql\u4e3b\u4ece\u914d\u7f6e"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">1\uff1adocker\u914d\u7f6e<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u62c9\u53d6mysql\u955c\u50cf\ndocker pull mysql\n#\u521b\u5efadocker\u5bb9\u5668\u4e92\u8054\uff0c\u65b0\u5efa\u7f51\u7edc\ndocker network create -d bridge my-net\n#\u4f7f\u7528mysql\u955c\u50cf\u521b\u5efa\u4e24\u4e2amysql\u670d\u52a1\u5668\u5bb9\u5668\uff0c\n#\u8bbe\u7f6e\u5bc6\u7801123456\uff0c\u8bbe\u7f6e\u7aef\u53e3\u6620\u5c04\u5230\u672c\u5730\uff0c\u8bbe\u7f6e\u5bb9\u5668\u4e92\u8054\u7f51\u7edcmy-net\ndocker run --name mysql-2 -e MYSQL_ROOT_PASSWORD=123456 -d -p 3307:3307 --network my-net mysql\ndocker run --name mysql-1 -e MYSQL_ROOT_PASSWORD=123456 -d -p 3306:3306 --network my-net mysql\n\n\n\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1270\" height=\"720\" src=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-2.png\" alt=\"\" class=\"wp-image-250\" srcset=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-2.png 1270w, https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-2-300x170.png 300w, https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-2-1024x581.png 1024w, https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-2-768x435.png 768w\" sizes=\"auto, (max-width: 1270px) 100vw, 1270px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">2\uff1amysql\u914d\u7f6e<\/h1>\n\n\n\n<p>\u7531\u4e8e\u5bb9\u5668\u5185\u6ca1\u6709vim\u7b49\u7f16\u8f91\u547d\u4ee4\uff0c\u6240\u4ee5\u4e34\u65f6\u4f7f\u7528docker desktop\u8f6f\u4ef6\uff0c\u914d\u7f6emysql\u7684\u914d\u7f6e\u6587\u4ef6\/etc\/my.conf\uff0c\u8bbe\u7f6e\u4e3b\u4ece\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u914d\u7f6e\u5bb9\u5668mysql-1  \/etc\/my.conf\nport=3306 \n\nserver-id=1 \n\nlog-bin=mysql-bin \n\nbinlog-format=row \n\n#\u914d\u7f6e\u5bb9\u5668mysql-2 \/etc\/my.conf\n\nport=3307 \n\nserver-id=2 \n\nrelay-log=mysql-relay-bin<\/code><\/pre>\n\n\n\n<p>\u914d\u7f6e\u5b8c\u6210\u91cd\u542f\u4e24\u4e2a\u5bb9\u5668<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">3\uff1a\u6d4b\u8bd5mysql\u8fde\u63a5\u548c\u8bbe\u7f6e\u590d\u5236\u6570\u636e\u7684\u8d26\u53f7<\/h1>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"559\" src=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-1.png\" alt=\"\" class=\"wp-image-248\" srcset=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-1.png 536w, https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-1-288x300.png 288w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u4e3b\u5e93\u914d\u7f6e\n\n#\u521b\u5efa\u590d\u5236\u8d26\u53f7\nCREATE USER repl@localhost IDENTIFIED  BY'123456';\nCREATE USER repl@'%' IDENTIFIED BY '123456';\nGRANT REPLICATION SLAVE ON . TO repl@'localhost';\nGRANT REPLICATION SLAVE ON . TO repl@'%';\nFLUSH PRIVILEGES;\n\nSHOW GRANTS FOR repl @'%';\nSHOW GRANTS FOR repl @'localhost';\n\n#\u67e5\u770b\u4e3b\u5e93\u7684bin log\nSHOW VARIABLES LIKE '%log_bin%';\nSHOW BINARY LOGS;\nSHOW BINARY LOG STATUS\n\n#\u67e5\u770b\u4ece\u5e93\nSHOW REPLICAS;\n\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"559\" src=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image.png\" alt=\"\" class=\"wp-image-249\" srcset=\"https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image.png 536w, https:\/\/www.zhukaifu.cn\/wp-content\/uploads\/2024\/08\/image-288x300.png 288w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u4ece\u5e93\u914d\u7f6e\n\n#\u505c\u6b62\u590d\u5236\u8fdb\u7a0b\nSTOP REPLICA;\n\n#\u521b\u5efa\u590d\u5236\u914d\u7f6e\n#\u4f7f\u7528docket inspect mysql-1\u67e5\u770b\u5bb9\u5668mysql-1\u4e3b\u5e93\u7684ip\u4e3a172.18.0.3\nCHANGE REPLICATION SOURCE TO SOURCE_HOST = '172.18.0.3',\nSOURCE_PORT = 3306,\nSOURCE_USER = 'repl',\nSOURCE_PASSWORD = '123456',\nSOURCE_LOG_FILE = 'mysql-bin.000002',\nSOURCE_LOG_POS = 358;\n\n#\u5f00\u59cb\u590d\u5236\u8fdb\u7a0b\nSTART REPLICA;\n\n#\u67e5\u770b\u590d\u5236\u8fdb\u7a0b\u72b6\u6001\n#########################\n######\u91cd\u8981################\n#\u53ef\u4ee5\u6839\u636e\u8fd9\u4e2a\u5224\u65ad\u590d\u5236\u8fdb\u7a0b\u7684\u72b6\u6001\u548c\u4fe1\u606f\uff0c\u4f8b\u5982\u5931\u8d25\uff0c\u5931\u8d25\u539f\u56e0\u7b49\nSHOW REPLICA STATUS;\n\n\n\n\n<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">4\uff1a\u9047\u5230\u7684\u9519\u8bef<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>1:\u539f\u672c\u6ca1\u6709\u521b\u5efa\u5bb9\u5668\u7f51\u7edc\uff0c\u6240\u4ee5\u5bb9\u5668\u4e4b\u95f4\u662f\u6ca1\u6709\u7f51\u7edc\u7684\uff0c\u4e0d\u662f\u5c5e\u4e8e\u540c\u4e00\u7f51\u7edc\ndocker network create -d bridge my-net\n\n2:\u7531\u4e8e\u6ca1\u6709\u521b\u5efa\u7f51\u7edc\uff0c\u6240\u4ee5\u4ee5\u4e3a\u53ef\u4ee5\u901a\u8fc7\u6620\u5c04\u5230\u672c\u5730\u7684\u7aef\u53e3\u914d\u7f6e\u590d\u5236\n\u9519\u8bef\uff1aCHANGE REPLICATION SOURCE TO SOURCE_HOST = 'local'\n\u6b63\u786e\uff1aCHANGE REPLICATION SOURCE TO SOURCE_HOST = '172.18.0.3'\n\n3\uff1a\u539f\u672c\u662f\u4e0d\u4f7f\u7528docker\u7684\uff0c\u60f3\u5728\u672c\u5730\u673a\u5668\uff0c\u5f00\u542f\u4e24\u4e2amysql\u670d\u52a1\uff0c\u53d1\u73b0\u4e0d\u53ef\u4ee5\uff0c\u53ea\u80fd\u5f00\u542f\u4e00\u4e2a\n\n4\uff1aSHOW REPLICA STATUS;\u63d0\u793a\u5bc6\u7801\u4e0d\u5b89\u5168\uff0c\u8fd9\u65f6\u5019\u9700\u8981\u53bb\u5bb9\u5668mysql-2\u91cc\u9762\u6267\u884c\nmysql -u repl -p123456 -h 172.18.0.3 -P3306 --get-server-public-key\n\u83b7\u53d6\u5230\u5bb9\u5668mysql-1\u7684mysql\u670d\u52a1\u516c\u94a5\n\n5:SHOW REPLICA STATUS;\u53ef\u4ee5\u67e5\u770b\u5177\u4f53\u7684\u9519\u8bef\u4fe1\u606f\uff0c\u5e94\u8be5\u662f\u5728\u5b57\u6bb5Last_IO_Error\n\n6:\u7531\u4e8e\u7248\u672c\u8f83\u65b0mysql 9\u4e86\uff0cSHOW MASTER STATUS;\u5df2\u7ecf\u88ab\u5f03\u7528\u4e86\uff0c\u6539\u4e3aSHOW REPLICAS;\n\n\n<\/code><\/pre>\n\n\n\n<p>\u672c\u6587\u53ea\u662f\u4e3a\u4e86\u6d4b\u8bd5\u4e3b\u4ece\uff0c\u4e0d\u80fd\u4f5c\u4e3a\u6b63\u5f0f\u914d\u7f6e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\uff1adocker\u914d\u7f6e 2\uff1amysql\u914d\u7f6e \u7531\u4e8e\u5bb9\u5668\u5185\u6ca1\u6709vim\u7b49\u7f16\u8f91\u547d\u4ee4\uff0c\u6240\u4ee5\u4e34&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-244","post","type-post","status-publish","format-standard","hentry","category-code-2"],"_links":{"self":[{"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/posts\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=244"}],"version-history":[{"count":4,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/posts\/244\/revisions"}],"predecessor-version":[{"id":251,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=\/wp\/v2\/posts\/244\/revisions\/251"}],"wp:attachment":[{"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhukaifu.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}