Mysql \u914d\u7f6e\u4e92\u4e3a\u4e3b\u4ece\u540c\u6b65<\/p>\n
\r\nA Server 1.1.1.1 (\u62e5\u6709\u5b8c\u6574\u6570\u636e)\r\nB Server 2.2.2.2\r\n\r\n\u4fee\u6539my.cnf [mysqld] \u4e0b\u9762\u589e\u52a0\u9879\u76ee\uff1a\r\n\r\nA\u670d\u52a1\u5668\u5982\u4e0b\uff1a\r\n\r\nlog-bin=mysql-bin\r\nserver-id= 1\r\nbinlog-do-db=database \/\/ \u4fee\u6539\u4e3a\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\u540d\u79f0\r\nreplicate-do-db=database \/\/ \u4fee\u6539\u4e3a\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\u540d\u79f0\r\nlog-slave-updates\r\nslave-skip-errors= 1062,1060,1032\r\nauto_increment_increment=2\r\nauto_increment_offset=1\r\nrelay-log=mysqld-relay-bin<\/code>\r\n\r\nB\u670d\u52a1\u5668\u5982\u4e0b\uff1a\r\n\r\nlog-bin=mysql-bin\r\nserver-id= 2\r\nbinlog-do-db=database \/\/ \u4fee\u6539\u4e3a\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\u540d\u79f0\r\nreplicate-do-db=database \/\/ \u4fee\u6539\u4e3a\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\u540d\u79f0\r\nlog-slave-updates\r\nslave-skip-errors= 1062,1060,1032\r\nauto_increment_increment=2\r\nauto_increment_offset=2\r\nrelay-log=mysqld-relay-bin<\/code>\r\n<\/pre>\n\r\n\u5206\u522b\u5728AB\u670d\u52a1\u5668\u521b\u5efa\u540c\u6b65\u7528\u6237shadow , \u5bc6\u7801shadowpass\r\n\r\nuse mysql\r\ngrant replication slave on *.* to 'shadow'@'%' identified by 'shadowpass';\r\nflush privileges;<\/code>\r\n<\/pre>\n\r\nuse\u6570\u636e\u5e93\u540e\u9501\u5b9aA\u670d\u52a1\u5668\u6570\u636e\u5e93\r\n\r\nFLUSH TABLES WITH READ LOCK;<\/code>\r\n\r\n\u5907\u4efdA\u670d\u52a1\u5668\u6570\u636e\u5e93 mysqldump \u4e3asql\u6587\u4ef6\u3002\r\n\r\n\u5bfc\u5165sql\u6587\u4ef6\u5907\u4efd\u5230B\u670d\u52a1\u5668\u3002\r\n\r\n\u5728AB\u4e24\u53f0\u670d\u52a1\u5668\u4e0a\u5206\u522b\u91cd\u7f6emaster\u548cslave\r\n\r\nreset master;\r\nreset slave;<\/code>\r\n\r\n\u68c0\u67e5AB\u670d\u52a1\u5668\u4e0amaster_log_pos\uff0c\u5e94\u8be5\u90fd\u4e3a79\uff0c\u5982\u679c\u4e0d\u662f\u6839\u636e\u5b9e\u9645\u503c\u4fee\u6539\u3002mysql-bin.000001\u4e5f\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u4fee\u6539\u3002\r\n\r\nmysql\r\nshow master status;<\/code>\r\n\r\n+------------------+----------+--------------+------------------+\r\n\r\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |\r\n\r\n+------------------+----------+--------------+------------------+\r\n\r\n| mysql-bin.000001 | 79 | | |\r\n\r\n+------------------+----------+--------------+------------------+\r\n\r\n1 row in set (0.00 sec)\r\n\r\n\u5728A\u670d\u52a1\u5668\u4e0a\u6267\u884c\uff1a\r\n\r\nchange master to master_host='2.2.2.2',master_user='shadow',master_password='shadowpass',master_log_file='mysql-bin.000001',master_log_pos=79;<\/code>\r\n\r\n\u5728B\u670d\u52a1\u5668\u4e0a\u6267\u884c\uff1a\r\n\r\nchange master to master_host='1.1.1.1',master_user='shadow',master_password='shadowpass',master_log_file='mysql-bin.000001',master_log_pos=79;<\/code>\r\n\r\n\u5206\u522b\u89e3\u95012\u53f0\u670d\u52a1\u5668\u6570\u636e\u5e93\u5e76\u4e14\u542f\u52a8slave\r\n\r\nUNLOCK TABLES;\r\nstart slave;<\/code>\r\n<\/pre>\n\u914d\u7f6e\u5b8c\u6210\uff0cshow slave status\\G \u68c0\u67e5\u662f\u5426\u540c\u6b65\u6210\u529f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"