{"id":115,"date":"2016-04-26T22:29:12","date_gmt":"2016-04-26T14:29:12","guid":{"rendered":"http:\/\/pony.blog.myhz.com\/?p=115"},"modified":"2016-04-26T22:29:12","modified_gmt":"2016-04-26T14:29:12","slug":"mysql%e5%8f%8c%e5%90%91%e7%83%ad%e5%a4%87%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/lnmp.ivan.xin\/?p=115","title":{"rendered":"MYSQL\u53cc\u5411\u70ed\u5907\u914d\u7f6e"},"content":{"rendered":"

192.168.34.10<\/p>\n

\u4e3b\u7684\/etc\/my.cnf\u7684[mysqld]\u4e2d\u914d\uff1a
\nserver-id=1
\nlog-bin=\/tmp\/mysql.log
\nbinlog-do-db=ponyhk_zyj \/\/\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\uff0c\u5982\u679c\u6ca1\u6709\u672c\u884c\uff0c\u5373\u8868\u793a\u540c\u6b65\u6240\u6709\u7684\u6570\u636e\u5e93
\nbinlog-ignore-db=mysql \/\/\u88ab\u5ffd\u7565\u7684\u6570\u636e\u5e93<\/p>\n

\u4e3b\u7684mysql\u6267\u884c\uff1agrant replication slave on *.* to 'root'@'192.168.34.11' identified by 'root';<\/p>\n

\u4e3b\u7684\u91cd\u542f\uff1aservice mysqld restart
\n\u68c0\u67e5\u4e3b\u7684\u60c5\u51b5\uff1ashow master status;
\n192.168.34.11<\/p>\n

\u4e3b\u7684\/etc\/my.cnf\u914d\uff1a
\nserver-id=2
\nlog-bin=\/tmp\/mysql.log
\nbinlog-do-db=ponyhk_zyj \/\/\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\uff0c\u5982\u679c\u6ca1\u6709\u672c\u884c\uff0c\u5373\u8868\u793a\u540c\u6b65\u6240\u6709\u7684\u6570\u636e\u5e93
\nbinlog-ignore-db=mysql \/\/\u88ab\u5ffd\u7565\u7684\u6570\u636e\u5e93<\/p>\n

\u4e3b\u7684mysql\u6267\u884c\uff1agrant replication slave on *.* to 'root'@'192.168.34.10' identified by 'root';<\/p>\n

\u4e3b\u7684\u91cd\u542f\uff1aservice mysqld restart
\n\u68c0\u67e5\u4e3b\u7684\u60c5\u51b5\uff1ashow master status;<\/p>\n

192.168.34.10 \u4f5c\u4e3a\u8f85<\/p>\n

\/etc\/my.cnf\u7684[mysqld]\u4e2d\u914d\uff1a
\nmaster-host=192.168.34.11
\nmaster-user=root
\nmaster-password=root
\nmaster-port=3306
\n# replicate-ignore-db=mysql \u5ffd\u7565\u7684\u6570\u636e\u5e93
\n# master-connect-retry=60 \u5982\u679c\u4ece\u670d\u52a1\u5668\u53d1\u73b0\u4e3b\u670d\u52a1\u5668\u65ad\u6389\uff0c\u91cd\u65b0\u8fde\u63a5\u7684\u65f6\u95f4\u5dee(\u79d2)
\n#replicate-do-db=ponyhk_zyj \/\/\u540c\u6b65\u7684\u6570\u636e\u5e93(\u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d)\uff0c\u4e0d\u5199\u672c\u884c \u8868\u793a \u540c\u6b65\u6240\u6709\u6570\u636e\u5e93
\nmysql>stop slave;
\n\u5728192.168.34.11\u4e2d\u6267\u884cmysql>show master status;\u8bb0\u5f55File\u6570\u636e\u548cPosition\u6570\u636e
\n\u5728192.168.34.10\u6267\u884c\uff1amysql>change master to master_host='174.34.138.240', master_user='www', master_password='Pqh88883814',master_log_file='mysql.000001', master_log_pos=506;
\nmysql>start slave;
\nmysql>show slave status\\G; \u5982\u679c\u6ca1\u6709\u62a5\u9519\uff0c\u57fa\u672c\u5c31\u914d\u7f6e\u5b8c\u6210\u4e86\u3002Slave_IO_Running: Yes\u548cSlave_SQL_Running: Yes\u90fd\u9700\u8981\u4e3aYes
\n192.168.34.11 \u4f5c\u4e3a\u8f85<\/p>\n

\/etc\/my.cnf\u7684[mysqld]\u4e2d\u914d\uff1a
\nmaster-host=192.168.34.10
\nmaster-user=root
\nmaster-password=root
\nmaster-port=3306
\n# replicate-ignore-db=mysql \u5ffd\u7565\u7684\u6570\u636e\u5e93
\n# master-connect-retry=60 \u5982\u679c\u4ece\u670d\u52a1\u5668\u53d1\u73b0\u4e3b\u670d\u52a1\u5668\u65ad\u6389\uff0c\u91cd\u65b0\u8fde\u63a5\u7684\u65f6\u95f4\u5dee(\u79d2)
\n#replicate-do-db=ponyhk_zyj \/\/\u540c\u6b65\u7684\u6570\u636e\u5e93(\u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d)\uff0c\u4e0d\u5199\u672c\u884c \u8868\u793a \u540c\u6b65\u6240\u6709\u6570\u636e\u5e93(\u591a\u4e2a\u7528,)
\nmysql>stop slave;
\n\u5728192.168.34.10\u4e2d\u6267\u884cmysql>show master status;\u8bb0\u5f55File\u6570\u636e\u548cPosition\u6570\u636e
\n\u5728192.168.34.11\u6267\u884c\uff1amysql>change master to master_host='192.168.34.10', master_user='root', master_password='root',master_log_file='File\u6570\u636e', master_log_pos=Position\u6570\u636e;
\nmysql>start slave;
\nmysql>show slave status\\G; \u5982\u679c\u6ca1\u6709\u62a5\u9519\uff0c\u57fa\u672c\u5c31\u914d\u7f6e\u5b8c\u6210\u4e86\u3002Slave_IO_Running: Yes\u548cSlave_SQL_Running: Yes\u90fd\u9700\u8981\u4e3aYes
\n\u8fd9\u4e2a\u65f6\u5019\u518d\u770b\u4e0b192.168.34.10\u7684show slave status\\G;\u786e\u8ba4\u662f\u4e0d\u662f\u6b63\u5e38\u7684<\/p>\n","protected":false},"excerpt":{"rendered":"

192.168.34.10 \u4e3b\u7684\/etc\/my.cnf\u7684[mysqld]\u4e2d\u914d\uff1a server-id=1 log...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15330],"tags":[],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115"}],"version-history":[{"count":0,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}