{"id":413,"date":"2021-12-18T21:38:36","date_gmt":"2021-12-18T13:38:36","guid":{"rendered":"https:\/\/blog.zhouhonghe.com\/?p=413"},"modified":"2026-04-24T16:44:01","modified_gmt":"2026-04-24T08:44:01","slug":"mysql%e4%b8%bb%e4%bb%8e%e7%bb%93%e6%9e%84%e6%b7%bb%e5%8a%a0%e4%bb%8e%e6%9c%ba","status":"publish","type":"post","link":"https:\/\/blog.zhouhonghe.com\/?p=413","title":{"rendered":"MySQL\u4e3b\u4ece\u7ed3\u6784\u6dfb\u52a0\u4ece\u673a\uff0c\u5bfc\u51fa\u53ca\u5bfc\u5165\u6570\u636e"},"content":{"rendered":"

MySQL8.0.X\uff0c\u5f00\u542f\u4e86GTID\u3002\u4e3b\u673a\u65e0\u9700\u505c\u673a\u3002<\/p>\n

\u4e3b\u673a<\/strong>
\n1\u3001\u5bfc\u51fa\u6570\u636e
\n> mysqldump -ubackup<\/strong><\/em> -p --all-databases --single-transaction --triggers --routines --events > \/path\/to\/backup\/<\/strong>dump-all.sql<\/strong><\/em><\/code><\/p>\n

2\u3001\u538b\u7f29\uff0c\u4f20\u5230\u4ece\u673a\u3002<\/p>\n

\u4ece\u673a<\/strong><\/p>\n

# \u5bfc\u5165\u6570\u636e
\n> mysql -uroot<\/strong><\/em> -p < dump-all.sql<\/strong><\/em><\/code><\/p>\n

------ 8.0.22 \u4ee5\u540e\u7248\u672c -----<\/p>\n

1. \u914d\u7f6e\u4e3b\u670d\u52a1\u5668\u8fde\u63a5\u4fe1\u606f
\nCHANGE REPLICATION SOURCE TO
\nSOURCE_HOST='REMOTE_HOST<\/strong><\/em>',
\nSOURCE_PORT=PORT<\/em><\/strong>,
\nSOURCE_USER='replicate',
\nSOURCE_PASSWORD='PWD<\/strong><\/em>',
\nSOURCE_AUTO_POSITION=1,
\nGET_SOURCE_PUBLIC_KEY=1;<\/code><\/p>\n

2. \u542f\u52a8\u590d\u5236
\nSTART REPLICA;<\/code><\/p>\n

3. \u67e5\u770b\u590d\u5236\u72b6\u6001
\nSHOW REPLICA STATUS\\G<\/code><\/p>\n

------ 8.0.22 \u4ee5\u524d\u7248\u672c -----<\/p>\n

1\u3001\u8bbe\u7f6e\u4e3b\u673a
\nchange master to master_host='REMOTE_HOST<\/strong><\/em>',master_port=PORT<\/em><\/strong>,master_user='replicate<\/em><\/strong>',master_password='PWD<\/strong><\/em>',master_auto_position=1,GET_MASTER_PUBLIC_KEY=1;<\/code><\/p>\n

2\u3001\u542f\u52a8\u4ece\u673a
\nstart slave;<\/code><\/p>\n

3\u3001\u67e5\u770b\u540c\u6b65\u72b6\u6001
\nshow slave status\\G<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL8.0.X\uff0c\u5f00\u542f\u4e86GTID\u3002\u4e3b\u673a\u65e0\u9700\u505c\u673a\u3002 \u4e3b\u673a 1\u3001\u5bfc\u51fa\u6570\u636e > mysqldump -ub […]<\/p>... ","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-413","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=413"}],"version-history":[{"count":7,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions"}],"predecessor-version":[{"id":655,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions\/655"}],"wp:attachment":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}