\u51c6\u59072\u53f0\u670d\u52a1\u5668\uff0c\u670d\u52a1\u56681\u4f5c\u4e3a\u4e3b\u6570\u636e\u5e93\uff0c\u670d\u52a1\u56682\u4f5c\u4e3a\u4ece\u6570\u636e\u5e93\u3002<\/p>\n
1.\u4fee\u6539\u4e3b\u5e93\u7684\u914d\u7f6e
\n\u8fd9\u91cc\u4f7f\u7528\u7684\u662fubuntu\u4e0b\u7684MYSQL\uff0c\u7248\u672c\u4e3a5.6.30\uff0c\u4f7f\u7528apt-get\u65b9\u5f0f\u5b89\u88c5\u3002
\n1)\u9996\u5148\u4fee\u6539\/etc\/mysql\/conf.d\/mysql.cnf
\n[mysqld]
\nbind-address = 0.0.0.0
\nlog-bin=mysql-bin
\nserver-id=1
\n2)\u7136\u540e\u4fee\u6539\/etc\/mysql\/mysql.conf.d\/mysqld.cnf\u3002
\nbind-address = 0.0.0.0
\n\u6ce8\u610f\uff1a\u5c06\u4e0a\u97622\u4e2a\u6587\u4ef6\u7684bind-address\u90fd\u8bbe\u7f6e\u62100.0.0.0\uff0c\u662f\u4e3a\u4e86\u8ba9\u4ece\u5e93\u80fd\u591f\u8fde\u63a5\u4e3b\u5e93\u3002
\n3)\u91cd\u542fmysql\u4f7f\u4ee5\u4e0a\u4fee\u6539\u751f\u6548: service mysql restart<\/p>\n
2.\u5728\u4e3b\u6570\u636e\u5e93\u521b\u5efa\u7528\u6237
\nCREATE USER ‘repl’@’10.99.%.%’ IDENTIFIED BY ‘slavepassword’;
\nGRANT REPLICATION SLAVE ON *.* TO ‘repl’@’10.99.%.%’;
\n\u4ee5\u4e0aip\u5730\u5740\u8981\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8bbe\u7f6e\u3002<\/p>\n
3.\u83b7\u53d6\u4e3b\u6570\u636e\u5e93\u590d\u5236\u6587\u4ef6\u540d\u79f0\u548c\u590d\u5236\u70b9\u4f4d\u7f6e
\n\u9996\u5148\u7ed9\u6570\u636e\u5e93\u4e0a\u9501\uff0c\u9632\u6b62\u6570\u636e\u5199\u5165\uff1aFLUSH TABLES WITH READ LOCK;
\n\u83b7\u53d6\u4e3b\u5e93\u72b6\u6001\uff1aSHOW MASTER STATUS;
\n\u5f97\u5230File\u548cPotision2\u4e2a\u5b57\u6bb5\u7684\u503c\uff1a
\n+——————+———-+————–+——————+——————-+
\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
\n+——————+———-+————–+——————+——————-+
\n| mysql-bin.000002 | 120 | | | |
\n+——————+———-+————–+——————+——————-+
\n\u8bb0\u4e0b2\u4e2a\u503c\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u89e3\u9501\u4e86\uff1aUNLOCK TABLES;<\/p>\n
4.\u914d\u7f6e\u4ece\u6570\u636e\u5e93
\n1)\u7f16\u8f91\u4ece\u6570\u636e\u5e93\u7684\/etc\/mysql\/conf.d\/mysql.cnf
\n[mysqld]
\nserver-id=2
\n\u6ce8\u610f\uff1a\u5982\u679c\u53ea\u60f3\u590d\u5236\u67d01\u4e2a\u5e93\uff0c\u8fd8\u8981\u6dfb\u52a0\u4ee5\u4e0b\u914d\u7f6e\u9879
\nreplicate-wild-do-table=dbname.%
\n\u8fd9\u91cc\u7684dbname\u662f\u60f3\u590d\u5236\u7684\u4e3b\u5e93\u7684\u67d0\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u540d\u5b57\u3002<\/p>\n
2)\u91cd\u542fmysql: service mysql restart<\/p>\n
3)\u8bbe\u7f6e\u590d\u5236\u914d\u7f6e:
\nCHANGE MASTER TO
\n MASTER_HOST=’10.99.0.10′,
\n MASTER_USER=’repl’,
\n MASTER_PASSWORD=’slavepassword’,
\n MASTER_LOG_FILE=’mysql-bin.000002′,
\n MASTER_LOG_POS=120;
\n\u8fd9\u91ccMASTER_HOST\u662f\u4e3b\u5e93\u7684ip\u5730\u5740\uff0c\u8981\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u6307\u5b9a\u3002
\n4)\u542f\u52a8\u590d\u5236\uff1aSTART SLAVE;<\/p>\n
5.\u8bd5\u9a8c
\n\u4e3b\u5e93\u4e0a\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93: create database hello
\n\u7a0d\u7b49\u4e00\u4f1a\u513f\uff0c\u5728\u4ece\u5e93\u4e0a\u4f1a\u770b\u5230\u591a\u4e86hello\u6570\u636e\u5e93\uff0c\u8bf4\u660e\u4ee5\u4e0a\u914d\u7f6e\u6210\u529f\u3002
\n\u53ef\u4ee5\u7528\u4ee5\u4e0b\u547d\u4ee4\u5728\u4ece\u5e93\u4e0a\u67e5\u770b\u590d\u5236\u7684\u72b6\u6001\uff1ashow slave status;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u51c6\u59072\u53f0\u670d\u52a1\u5668\uff0c\u670d\u52a1\u56681\u4f5c\u4e3a\u4e3b\u6570\u636e\u5e93\uff0c\u670d\u52a1\u56682\u4f5c\u4e3a\u4ece\u6570\u636e\u5e93\u3002 1.\u4fee\u6539\u4e3b\u5e93\u7684\u914d\u7f6e … \u7ee7\u7eed\u9605\u8bfb