{"id":518,"date":"2026-01-27T02:46:07","date_gmt":"2026-01-27T02:46:07","guid":{"rendered":"https:\/\/blog.gpst.net.cn:4008\/?p=518"},"modified":"2026-01-28T06:24:12","modified_gmt":"2026-01-28T06:24:12","slug":"mysql-5-%e5%90%8c%e6%ad%a5%e9%97%ae%e9%a2%98%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/opshub.com.cn\/?p=518","title":{"rendered":"mysql 5 \u540c\u6b65\u95ee\u9898\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"\n<p>Last_IO_Error: The replication receiver thread cannot start because the master has GTID_MODE = ON and this server has GTID_MODE = OFF.<\/p>\n\n\n\n<p>\u539f\u56e0\uff1aMySQL\u4e3b\u4ece\u7684 <strong>Master<\/strong> \u548c <strong>Slave<\/strong> \u5fc5\u987b \u540c\u65f6\u5f00\u542f\u6216\u8005\u5173\u95ed <strong>enforce-gtid-consistency<\/strong>\u548c <strong>gtid-mode<\/strong> \u529f\u80fd\uff0c\u5373\u8981\u4fdd\u6301\u4e00\u81f4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gtid-mode=on\nenforce-gtid-consistency=true<\/code><\/pre>\n\n\n\n<p>ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository<\/p>\n\n\n\n<p>\u539f\u56e0\uff1a \u4ece\u5e93\u5df2\u7ecf\u5b58\u5728\u4e4b\u524d\u7684relay log.<\/p>\n\n\n\n<p>\u4f7f\u7528reset slave\u8bed\u53e5\uff0c\u6e05\u9664master\u4fe1\u606f\u548crelay\u65e5\u5fd7\u4fe1\u606f\uff0c\u5e76\u521b\u5efa\u5168\u65b0\u7684\u4e2d\u7ee7\u65e5\u5fd7.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; stop slave;\nQuery OK, 0 rows affected, 2 warnings (0.00 sec)\n\n\n\n\nmysql&gt; reset slave;\nQuery OK, 0 rows affected, 1 warning (0.01 sec)\n\n\n\n\nmysql&gt; change master to change master to master_host='10.46.143.59',master_port=3306,master_user='repl',master_password='YiKu2022@!',master_log_file='mysql-bin.000052',master_log_pos=1027010894;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Last_IO_Error: The replication receiver thread cannot start because the master has GTID_MODE = ON and this server has GTID_MODE = OFF. \u539f\u56e0\uff1aMySQL\u4e3b\u4ece\u7684 Master \u548c Slave \u5fc5\u987b \u540c\u65f6\u5f00\u542f\u6216\u8005\u5173\u95ed enforce-gtid-consistency\u548c gtid-mode \u529f\u80fd\uff0c\u5373\u8981\u4fdd\u6301\u4e00\u81f4. ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository \u539f\u56e0\uff1a \u4ece\u5e93\u5df2\u7ecf\u5b58\u5728\u4e4b\u524d\u7684relay log. \u4f7f\u7528reset slave\u8bed\u53e5\uff0c\u6e05\u9664master\u4fe1\u606f\u548crelay\u65e5\u5fd7\u4fe1\u606f\uff0c\u5e76\u521b\u5efa\u5168\u65b0\u7684\u4e2d\u7ee7\u65e5\u5fd7.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-518","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=518"}],"version-history":[{"count":2,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/518\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/518\/revisions\/601"}],"wp:attachment":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}