{"id":129,"date":"2007-07-02T23:26:14","date_gmt":"2007-07-02T15:26:14","guid":{"rendered":"http:\/\/blog.zhouhonghe.com\/?p=129"},"modified":"2007-07-02T23:26:33","modified_gmt":"2007-07-02T15:26:33","slug":"mysql5-master-slave%e5%a4%87%e4%bb%bd%e6%96%b9%e6%a1%88","status":"publish","type":"post","link":"https:\/\/blog.zhouhonghe.com\/?p=129","title":{"rendered":"Mysql5 Master &#038; Slave\u5907\u4efd\u65b9\u6848"},"content":{"rendered":"<p>\u5b9e\u73b0\u4e00\u4e2aMaster\u5bf9\u4e24Slave\uff0c\u5f53Master\u4e0d\u80fd\u5de5\u4f5c\u65f6\uff0c\u5176\u4e2d\u4efb\u4e00Slave\u53ef\u4ee5\u8f6c\u4e3aMaster\u3002<\/p>\n<p>\u6d4b\u8bd5\u73af\u5883\uff1aLinux AS3 + Mysql5.0.22<\/p>\n<p><strong>\u5b89\u88c5Mysql5:<\/strong><\/p>\n<p>\u00a0 # tar -zxvf mysql-5.0.22.tar.gz<br \/>\n\u00a0 # cd mysql-5.0.22<br \/>\n\u00a0 # .\/configure --prefix=\/usr\/local\/mysql-5.0.22 --with-charset=gbk --with-extra-charsets=all --localstatedir=\/data\/mysql5.0.22<br \/>\n\u00a0 # make<br \/>\n\u00a0 # make install<br \/>\n\u00a0 # cp support-files\/my-small.cnf \/etc\/my5.0.22.cfg<br \/>\n\u00a0 # \/usr\/local\/mysql-5.0.22\/bin\/mysql_install_db<br \/>\n\u00a0 # chown -R mysql.mysql \/data\/mysql5.0.22\/<br \/>\n\u00a0<\/p>\n<p><strong>Master\u914d\u7f6e\uff1a<\/strong><\/p>\n<p>\u00a0\u00a0\u00a0 server-id=1<br \/>\n\u00a0\u00a0\u00a0 log-bin=&lt;\u6700\u597d\u8d77\u4e2a\u540d\u5b50&gt;\u00a0\u00a0\u00a0<br \/>\n\u00a0\u00a0\u00a0 set-variable\u00a0\u00a0\u00a0 = max_binlog_size=100M<\/p>\n<p>\u00a0\u00a0\u00a0 binlog-do-db=&lt;\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d&gt;<\/p>\n<p><strong>\u5728Master\u5efa\u7acb\u5907\u4efd\u7528\u6237\uff1a<\/strong><\/p>\n<p>\u00a0\u00a0\u00a0 mysql&gt; GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'&lt;slaveIP&gt;' IDENTIFIED BY 'backpassword';<\/p>\n<p><strong>Slave\u914d\u7f6e\uff1a<\/strong><\/p>\n<p>\u00a0\u00a0\u00a0 server-id=2<br \/>\n\u00a0\u00a0\u00a0 log-bin=&lt;\u8bb0\u5f55bin log,\u5c06\u6765\u53ef\u4ee5\u505a\u4e3aMaster&gt;<\/p>\n<p>\u00a0\u00a0\u00a0 master-host=&lt;hostname or IP&gt;<br \/>\n\u00a0\u00a0\u00a0 master-port=3306<br \/>\n\u00a0\u00a0\u00a0 master-user=&lt;replicator&gt;<br \/>\n\u00a0\u00a0\u00a0 master-password=&lt;password&gt;<br \/>\n\u00a0\u00a0\u00a0<br \/>\n\u00a0\u00a0\u00a0 max-relay-log-size=500M<br \/>\n\u00a0\u00a0\u00a0 master-connect-retry=30<br \/>\n\u00a0\u00a0\u00a0 relay-log=mysql-replay-log<br \/>\n\u00a0\u00a0\u00a0 relay-log-index=&lt;mysql-replay-bin.index&gt;<\/p>\n<p>\u00a0\u00a0\u00a0 #\u53ef\u4ee5\u91cd\u547d\u540d\u6570\u636e\u5e93\u540d\u79f0<br \/>\n\u00a0\u00a0\u00a0 #replicate-rewrite-db=&lt;\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d&gt;-&gt;renamed_db<br \/>\n\u00a0\u00a0\u00a0 #replicate-do-db=renamed_db<br \/>\n\u00a0\u00a0\u00a0 replicate-do-db=&lt;bakup_db&gt;<\/p>\n<p>\u00a0\u00a0\u00a0 slave-skip-errors=126,1062<\/p>\n<p><strong>\u5b9e\u65bd\u6ce8\u610f\u4e8b\u9879\uff1a<\/strong><br \/>\n\uf06c 1. \u9996\u5148\u5728SLAVE\u4e0a\u5efa\u7acb\u76f8\u5e94\u6570\u636e\u5e93\u3002<br \/>\n\uf06c 2. \u7ed9\uff2daster\u3001Slave \u7684Data\u76ee\u5f55\u8db3\u591f\u7684\u78c1\u76d8\u7a7a\u95f4\u4ee5\u5b58\u653ebinlog\u6587\u4ef6\u3002<br \/>\n\uf06c 3. \u540c\u6b65\u524d\u8bf7Dump\u51faMaster\u6570\u636e\uff0c\u7136\u540e\u5bfc\u5165Slave\uff0c\u786e\u4fdd\u4e24\u8005\u521d\u59cb\u6570\u636e\u5b8c\u5168\u4e00\u81f4\u3002<br \/>\n\uf06c 4. \u5982\u679c\u540c\u6b65\u4e0d\u6210\u529f\uff0c\u8bf7\u67e5\u770berr\u65e5\u5fd7\u67e5\u660e\u539f\u56e0\u3002<\/p>\n<p>\u9644\uff1a<br \/>\n\u00a0\u00a0\u00a0 Mysql5\u6e90\u4ee3\u7801\u5b89\u88c5\u7b80\u4ecb<br \/>\n\u00a0\u00a0\u00a0 \u4ee55.0.22 \u7248\u672c\u4e3a\u4f8b\uff1a<br \/>\n\u00a0\u00a0 # mkdir \/data<br \/>\n\u00a0\u00a0\u00a0 # tar -zxvf mysql-5.0.22.tar.gz<br \/>\n\u00a0\u00a0\u00a0 # cd mysql-5.0.22<br \/>\n\u00a0\u00a0\u00a0 #.\/configure --prefix=\/usr\/local\/mysql-5.0.22 --with-charset=gbk --with-extra-charsets=all --localstatedir=\/data\/mysql5.0.22<br \/>\n\u00a0\u00a0\u00a0 # make<br \/>\n\u00a0\u00a0\u00a0 # make install<br \/>\n\u00a0\u00a0\u00a0 # cp support-files\/my-small.cnf \/etc\/my5.0.22.cfg<br \/>\n\u00a0\u00a0\u00a0 \u5b89\u88c5Mysql\u6570\u636e\u5e93<br \/>\n\u00a0\u00a0\u00a0 # \/usr\/local\/mysql-5.0.22\/bin\/mysql_install_db<br \/>\n\u00a0\u00a0\u00a0 \u4fdd\u8bc1\u6570\u636e\u76ee\u5f55mysql\u53ef\u8bfb\u5199<br \/>\n\u00a0\u00a0\u00a0 # chown -R mysql.mysql \/data\/mysql5.0.22\/<\/p>\n<p>\u6765\u6e90\uff1a<a target=\"_blank\" href=\"http:\/\/hi.baidu.com\/8hours\/blog\/item\/f68c73f01ba063afa50f5225.html\">http:\/\/hi.baidu.com\/8hours\/blog\/item\/f68c73f01ba063afa50f5225.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9e\u73b0\u4e00\u4e2aMaster\u5bf9\u4e24Slave\uff0c\u5f53Master\u4e0d\u80fd\u5de5\u4f5c\u65f6\uff0c\u5176\u4e2d\u4efb\u4e00Slave\u53ef\u4ee5\u8f6c\u4e3aMaster\u3002 \u6d4b\u8bd5\u73af [&hellip;]<\/p>... ","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-129","post","type-post","status-publish","format-standard","hentry","category-5"],"_links":{"self":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/129","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=129"}],"version-history":[{"count":0,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/129\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}