{"id":5434,"date":"2020-08-18T15:59:40","date_gmt":"2020-08-18T07:59:40","guid":{"rendered":"http:\/\/39.97.231.10\/?p=5434"},"modified":"2020-08-18T15:59:40","modified_gmt":"2020-08-18T07:59:40","slug":"mysql-replication-%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6%e5%85%a8%e6%96%b9%e4%bd%8d%e8%a7%a3%e5%86%b3%e6%96%b9%e6%a1%88","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=5434","title":{"rendered":"MySQL Replication \u4e3b\u4ece\u590d\u5236\u5168\u65b9\u4f4d\u89e3\u51b3\u65b9\u6848"},"content":{"rendered":"
<\/header>\n
\n
1.1 \u4e3b\u4ece\u590d\u5236\u57fa\u7840\u6982\u5ff5<\/span><\/div>\n
\n\u3000\u3000\u3000\u3000\u5728\u4e86\u89e3\u4e3b\u4ece\u590d\u5236\u4e4b\u524d\u5fc5\u987b\u8981\u4e86\u89e3\u7684\u5c31\u662f\u6570\u636e\u5e93\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7(binlog),\u4e3b\u4ece\u590d\u5236\u67b6\u6784\u5927\u591a\u57fa\u4e8e\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8fdb\u884c\uff0c<\/p>\n

1.1.1 \u4e8c\u8fdb\u5236\u65e5\u5fd7\u7ba1\u7406\u8bf4\u660e<\/span><\/h3>\n

\u3000\u3000\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5728\u54ea\uff1f\u5982\u4f55\u8bbe\u7f6e\u4f4d\u7f6e\u548c\u547d\u540d\uff1f<\/strong><\/p>\n

\n

\u3000\u3000\u3000\u3000\u5728my.cnf\u6587\u4ef6\u4e2d\u4f7f\u7528 log-bin = \u6307\u5b9a\uff1b\u547d\u540d\u89c4\u5219\u4e3a mysql-bin.000000 \uff08\u540e\u4e3a6\u4f4d\u6570\u5b57\uff09<\/p>\n<\/div>\n

\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4f4d\u7f6e<\/p>\n

\n
\n
mysql> show variables like \\'%log_bin%\\' ;\n+---------------------------------+-----------------------------------------+\n| Variable_name                   | Value                                   |\n+---------------------------------+-----------------------------------------+\n| log_bin                         | ON                                      |\n| log_bin_basename                | \/application\/mysql\/data\/mysql-bin       |\n| log_bin_index                   | \/application\/mysql\/data\/mysql-bin.index |\n| log_bin_trust_function_creators | OFF                                     |\n| log_bin_use_v1_row_events       | OFF                                     |\n| sql_log_bin                     | ON                                      |\n+---------------------------------+-----------------------------------------+\n6 rows in set (0.06 sec)<\/pre>\n<\/div>\n<\/div>\n
\u65e5\u5fd7\u547d\u540d<\/p>\n
\n
\n
mysql> show binary logs;\n+------------------+-----------+\n| Log_name         | File_size |\n+------------------+-----------+\n| mysql-bin.000001 |      2979 |\n| mysql-bin.000002 |       120 |\n+------------------+-----------+\n2 rows in set (0.00 sec)<\/pre>\n<\/div>\n
\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55\u4ec0\u4e48\uff1f<\/strong>\n<\/div>\n
\n
\u3000\u3000\u3000\u3000\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d\u8bb0\u5f55\u7684\u662f\u4e00\u4e2a\u4e2a\u5b8c\u6210\u7684\u4e8b\u4ef6<\/p>\n<\/div>\n
\u3000\u3000\u4e8c\u8fdb\u5236\u65e5\u5fd7\u683c\u5f0f\u662f\u600e\u6837\u7684\uff1f<\/strong><\/p>\n
\n
\u3000\u3000\u3000\u3000\u63a8\u8350\u4f7f\u7528row\u683c\u5f0f<\/p>\n<\/div>\n
\u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u65e5\u5fd7 \u683c\u5f0f\u3002<\/p>\n
\n
\n
mysql> show variables like \\'%format%\\';\n+--------------------------+-------------------+\n| Variable_name            | Value             |\n+--------------------------+-------------------+\n| binlog_format            | ROW               |\n| date_format              | %Y-%m-%d          |\n| datetime_format          | %Y-%m-%d %H:%i:%s |\n| default_week_format      | 0                 |\n| innodb_file_format       | Antelope          |\n| innodb_file_format_check | ON                |\n| innodb_file_format_max   | Antelope          |\n| time_format              | %H:%i:%s          |\n+--------------------------+-------------------+\n8 rows in set (0.00 sec)<\/pre>\n<\/div>\n
\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5982\u4f55\u6eda\u52a8\uff1f<\/strong>\n<\/div>\n
\n
\u3000\u3000\u3000\u3000\u6bcf\u6b21\u91cd\u542f\u90fd\u4f1a\u5237\u65b0\u65e5\u5fd7\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u8fdb\u884c\u5237\u65b0 \u00a0reset master;<\/p>\n<\/div>\n
\u3000\u3000\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7528\u6765\u5e72\u561b\uff1f<\/strong><\/p>\n
\n
\u3000\u3000\u3000\u3000\u5907\u4efd\u6062\u590d<\/p>\n
\u3000\u3000\u3000\u3000\u8d77\u59cb\u70b9\u7684\u5907\u4efd\u6062\u590d<\/p>\n<\/div>\n
\u3000\u3000\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u64cd\u4f5c\u547d\u4ee4\uff1f<\/strong>
\n\u67e5\u770b\u90fd\u6709\u54ea\u4e9b\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/p>\n
\n
\n
mysql> show binary logs;\n+------------------+-----------+\n| Log_name         | File_size |\n+------------------+-----------+\n| mysql-bin.000001 |      2979 |\n| mysql-bin.000002 |       167 |\n| mysql-bin.000003 |       120 |\n+------------------+-----------+\n3 rows in set (0.00 sec)<\/pre>\n<\/div>\n
\u67e5\u770b\u5f53\u524d\u4f7f\u7528\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\n<\/p><\/div>\n
\n
\n
mysql> show master status;\n+------------------+----------+--------------+------------------+-------------------+\n| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |\n+------------------+----------+--------------+------------------+-------------------+\n| mysql-bin.000003 |      120 |              |                  |                   |\n+------------------+----------+--------------+------------------+-------------------+\n1 row in set (0.00 sec)<\/pre>\n<\/div>\n
binlog<\/em>\u76f8\u5173\u8be6\u60c5\u53c2\u7167\uff1ahttp:\/\/www.cnblogs.com\/clsn\/p\/8087678.html#_label6<\/em>\n<\/div>\n
1.1.2 mysql\u4f20\u7edf\u5907\u4efd\u65b9\u5f0f\u548c\u7f3a\u9677<\/span><\/h3>\n
1\u3001\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5907\u4efd
\n2\u3001mysqldump<\/p>\n
\n
\u00a0\u00a0 \u3000\u3000\u3000\u3000a)\u5fc5\u987b\u6709\u6570\u636e\u5e93\u670d\u52a1\u5668\u5b8c\u6210\u903b\u8f91\u5de5\u4f5c\uff0c\u9700\u8981\u66f4\u591a\u5730cpu\u5468\u671f<\/p>\n
\u3000\u3000\u3000\u3000\u00a0 \u00a0b)\u903b\u8f91\u5907\u4efd\u8fd8\u539f\u901f\u5ea6\u6162\uff1a\u9700\u8981MySQL\u52a0\u8f7d\u548c\u89e3\u91ca\u8bed\u53e5\u3001\u8f6c\u5316\u5b58\u50a8\u683c\u5f0f\u3001\u91cd\u5efa\u5f15\u64ce<\/p>\n<\/div>\n
3\u3001xtrabackup<\/p>\n
\n
\u00a0\u3000\u3000\u3000\u3000\u00a0\u00a0a)\u6587\u4ef6\u5927<\/p>\n
\u3000\u3000\u3000\u3000\u3000b)\u4e0d\u603b\u662f\u53ef\u4ee5\u8de8\u5e73\u53f0\u3001\u64cd\u4f5c\u7cfb\u7edf\u548cMySQL\u7248\u672c<\/p>\n<\/div>\n
1.1.3 MySQL\u4e3b\u4ece\u590d\u5236\u80fd\u4e3a\u6211\u4eec\u505a\u4ec0\u4e48<\/span><\/h3>\n
\u9ad8\u53ef\u7528\u3001\u8f85\u52a9\u5907\u4efd\u3001\u5206\u62c5\u8d1f\u8f7d<\/p>\n
1.2 MySQL\u4e3b\u4ece\u590d\u5236\u4ecb\u7ecd<\/span><\/h2>\n
1.2.1 \u590d\u5236\u6280\u672f<\/span><\/h3>\n
\u4f5c\u7528<\/strong><\/p>\n
\n
\n
\u3000\u30001.\u4fdd\u8bc1\u6570\u636e\u5b89\u5168(\u5f02\u673a\u5b9e\u65f6\u5907\u4efd)<\/p>\n
\u3000\u30002.\u4fdd\u8bc1\u670d\u52a1\u6301\u7eed\u8fd0\u884c\uff08\u5b95\u673a\u63a5\u7ba1\uff09<\/p>\n<\/blockquote>\n<\/div>\n
\u4e3b\u4ece\u590d\u5236\u5b9e\u73b0\u57fa\u672c\u539f\u7406<\/strong><\/p>\n
\n
\n
\u3000\u30001.\u81ea\u5e26\u529f\u80fd\uff0c\u590d\u5236\u662f MySQL \u7684\u4e00\u9879\u529f\u80fd\uff0c\u5141\u8bb8\u670d\u52a1\u5668\u5c06\u66f4\u6539\u4ece\u4e00\u4e2a\u5b9e\u4f8b\u590d\u5236\u5230\u53e6\u4e00\u4e2a\u5b9e\u4f8b\u3002<\/p>\n
\u3000\u30002.\u4e3b\u670d\u52a1\u5668\u5c06\u6240\u6709\u6570\u636e\u548c\u7ed3\u6784\u66f4\u6539\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d\u3002<\/p>\n
\u3000\u30003.\u4ece\u5c5e\u670d\u52a1\u5668\u4ece\u4e3b\u670d\u52a1\u5668\u8bf7\u6c42\u8be5\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5e76\u5728\u672c\u5730\u5e94\u7528\u5176\u5185\u5bb9\u3002\u5373\u901a\u8fc7\u628a\u4e3b\u5e93\u7684binlog\u4f20\u9001\u5230\u4ece\u5e93\uff0c\u4ece\u65b0\u89e3\u6790\u5e94\u7528\u5230\u4ece\u5e93\u3002<\/p>\n<\/blockquote>\n<\/div>\n
1.2.2 \u590d\u5236\u67b6\u6784<\/span><\/h3>\n
mysql\u590d\u5236\u7684\u5e94\u7528\u5e38\u89c1\u573a\u666f\uff1a<\/p>\n
\n
\n
\n
\u5e94\u7528\u573a\u666f1\uff1a\u4ece\u670d\u52a1\u5668\u4f5c\u4e3a\u4e3b\u670d\u52a1\u5668\u7684\u5b9e\u65f6\u6570\u636e\u5907\u4efd<\/p>\n
\u5e94\u7528\u573a\u666f2\uff1a\u4e3b\u4ece\u670d\u52a1\u5668\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\uff0c\u4ece\u670d\u52a1\u5668\u5b9e\u73b0\u8d1f\u8f7d\u5747\u8861<\/p>\n
\u5e94\u7528\u573a\u666f3\uff1a\u628a\u591a\u4e2a\u4ece\u670d\u52a1\u5668\u6839\u636e\u4e1a\u52a1\u91cd\u8981\u6027\u8fdb\u884c\u62c6\u5206\u8bbf\u95ee<\/p>\n<\/div>\n<\/blockquote>\n<\/div>\n
1.2.2.1\u00a0\u00a0<\/strong>\u4e3b\u2013\u4ece\u590d\u5236<\/strong><\/span><\/h4>\n
\u4f20\u7edf\u7684 MySQL \u590d\u5236\u63d0\u4f9b\u4e86\u4e00\u79cd\u7b80\u5355\u7684\u4e3b\u2013\u4ece\u590d\u5236\u65b9\u6cd5\u3002 \u6709\u4e00\u4e2a\u4e3b\uff0c\u4ee5\u53ca\u4e00\u4e2a\u6216\u591a\u4e2a\u4ece\u3002 \u4e3b\u8282\u70b9\u6267\u884c\u548c\u63d0\u4ea4\u4e8b\u52a1\uff0c\u7136\u540e\u5c06\u5b83\u4eec\uff08\u5f02\u6b65\u5730\uff09\u53d1\u9001\u5230\u4ece\u8282\u70b9\uff0c\u4ee5\u91cd\u65b0\u6267\u884c\uff08\u5728\u57fa\u4e8e\u8bed\u53e5\u7684\u590d\u5236\u4e2d\uff09\u6216\u5e94\u7528\uff08\u5728\u57fa\u4e8e\u884c\u7684\u590d\u5236\u4e2d\uff09\u3002 \u8fd9\u662f\u4e00\u4e2a shared-nothing \u7684\u7cfb\u7edf\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u6240\u6709 server \u6210\u5458\u90fd\u6709\u4e00\u4e2a\u5b8c\u6574\u7684\u6570\u636e\u526f\u672c\u3002<\/p>\n
\u00a0\\\"MySQL<\/p>\n
(\u56fe)MySQL \u5f02\u6b65\u590d\u5236<\/p>\n
\u3000\u3000\u8fd8\u6709\u4e00\u4e2a\u534a\u540c\u6b65\u590d\u5236\uff0c\u5b83\u5728\u534f\u8bae\u4e2d\u6dfb\u52a0\u4e86\u4e00\u4e2a\u540c\u6b65\u6b65\u9aa4\u3002 \u8fd9\u610f\u5473\u7740\u4e3b\u8282\u70b9\u5728\u63d0\u4ea4\u65f6\u9700\u8981\u7b49\u5f85\u4ece\u8282\u70b9\u786e\u8ba4\u5b83\u5df2\u7ecf\u63a5\u6536\u5230\u4e8b\u52a1\u3002\u53ea\u6709\u8fd9\u6837\uff0c\u4e3b\u8282\u70b9\u624d\u80fd\u7ee7\u7eed\u63d0\u4ea4\u64cd\u4f5c\u3002<\/p>\n
\\\"MySQL<\/p>\n
(\u56fe)MySQL \u5f02\u6b65\u590d\u5236<\/p>\n
\u3000\u3000\u5728\u4e0a\u9762\u7684\u4e24\u4e2a\u56fe\u7247\u4e2d\uff0c\u53ef\u4ee5\u770b\u5230\u4f20\u7edf\u5f02\u6b65 MySQL \u590d\u5236\u534f\u8bae\uff08\u4ee5\u53ca\u534a\u540c\u6b65\uff09\u7684\u56fe\u5f62\u5c55\u793a\u3002 \u84dd\u8272\u7bad\u5934\u8868\u793a\u5728\u4e0d\u540c server \u4e4b\u95f4\u6216\u8005 server \u4e0e client \u5e94\u7528\u4e4b\u95f4\u7684\u4fe1\u606f\u4ea4\u4e92\u3002<\/p>\n
1.2.3 MySQL\u4e3b\u4ece\u590d\u5236\u539f\u7406\u4ecb\u7ecd<\/span><\/h3>\n
\u590d\u5236\u8fc7\u7a0b\uff1a<\/strong><\/p>\n
\n
\n
\n
1\u3001\u5f00\u542fbinlog\u65e5\u5fd7\uff0c\u901a\u8fc7\u628a\u4e3b\u5e93\u7684binlog\u4f20\u9001\u5230\u4ece\u5e93\uff0c\u4ece\u65b0\u89e3\u6790\u5e94\u7528\u5230\u4ece\u5e93\u3002<\/p>\n
2\u3001\u590d\u5236\u9700\u89813\u4e2a\u7ebf\u7a0b\uff08dump\u3001io\u3001sql\uff09\u5b8c\u6210\uff0c5.6\u4ece\u5e93\u591a\u4e2asql\u3002<\/p>\n
3\u3001\u590d\u5236\u662f\u5f02\u6b65\u7684\u8fc7\u7a0b\u3002\u4e3b\u4ece\u590d\u5236\u662f\u5f02\u6b65\u7684\u903b\u8f91\u7684SQL\u8bed\u53e5\u7ea7\u7684\u590d\u5236\u3002<\/p>\n<\/div>\n<\/blockquote>\n<\/div>\n
\u590d\u5236\u524d\u63d0\uff1a<\/strong><\/p>\n
\n
\n
\n
1\u3001\u4e3b\u670d\u52a1\u671f\u4e00\u5b9a\u8981\u6253\u5f00\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/p>\n
2\u3001\u5fc5\u987b\u4e24\u53f0\u670d\u52a1\u5668\uff08\u6216\u8005\u662f\u591a\u4e2a\u5b9e\u4f8b\uff09<\/p>\n
3\u3001\u4ece\u670d\u52a1\u5668\u9700\u8981\u4e00\u6b21\u6570\u636e\u521d\u59cb\u5316<\/em><\/strong><\/p>\n
\u00a0 \u00a0\u00a0\u00a03.1\u5982\u679c\u4e3b\u4ece\u670d\u52a1\u5668\u90fd\u662f\u65b0\u642d\u5efa\u7684\u8bdd\uff0c\u53ef\u4ee5\u4e0d\u505a\u521d\u59cb\u5316<\/p>\n
\u00a0 \u00a0 \u00a03.2\u5982\u679c\u4e3b\u670d\u52a1\u5668\u5df2\u7ecf\u8fd0\u884c\u4e86\u5f88\u957f\u65f6\u95f4\u4e86\uff0c\u53ef\u4ee5\u901a\u8fc7\u5907\u4efd\u5c06\u4e3b\u5e93\u6570\u636e\u6062\u590d\u5230\u4ece\u5e93\u3002<\/p>\n
4\u3001\u4e3b\u5e93\u5fc5\u987b\u8981\u6709\u5bf9\u4ece\u5e93\u590d\u5236\u8bf7\u6c42\u7684\u7528\u6237\u3002<\/p>\n
5\u3001\u4ece\u5e93\u9700\u8981\u6709relay-log\u8bbe\u7f6e\uff0c\u5b58\u653e\u4ece\u4e3b\u5e93\u4f20\u9001\u8fc7\u6765\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u00a0show variables\u00a0 like \\’%relay%\\’;<\/em><\/p>\n
6\u3001\u5728\u7b2c\u4e00\u6b21\u7684\u65f6\u5019\uff0c\u4ece\u5e93\u9700\u8981change master to \u53bb\u8fde\u63a5\u4e3b\u5e93\u3002<\/p>\n
7\u3001change master\u4fe1\u606f\u9700\u8981\u5b58\u653e\u5230master.info\u4e2d \u00a0show variables\u00a0 like \\’%master_info%\\’;<\/em><\/p>\n
8\u3001\u4ece\u5e93\u600e\u4e48\u77e5\u9053\uff0c\u4e3b\u5e93\u53d1\u751f\u4e86\u65b0\u7684\u53d8\u5316?\u901a\u8fc7relay-log.info\u8bb0\u5f55\u7684\u5df2\u7ecf\u5e94\u7528\u8fc7\u7684relay-log\u4fe1\u606f\u3002<\/p>\n
9<\/strong>\u3001\u5728\u590d\u5236\u8fc7\u7a0b\u4e2d\u6d89\u53ca\u5230\u7684\u7ebf\u7a0b<\/strong><\/p>\n
\u00a0 \u00a0 \u00a0 \u4ece\u5e93\u4f1a\u5f00\u542f\u4e00\u4e2aIO thread(\u7ebf\u7a0b)\uff0c\u8d1f\u8d23\u8fde\u63a5\u4e3b\u5e93\uff0c\u8bf7\u6c42binlog\uff0c\u63a5\u6536binlog\u5e76\u5199\u5165relay-log\u3002<\/p>\n
\u00a0 \u00a0 \u00a0 \u4ece\u5e93\u4f1a\u5f00\u542f\u4e00\u4e2aSQL thread(\u7ebf\u7a0b)\uff0c\u8d1f\u8d23\u6267\u884crelay-log\u4e2d\u7684\u4e8b\u4ef6\u3002<\/p>\n
\u00a0 \u00a0 \u00a0 \u4e3b\u5e93\u4f1a\u5f00\u542f\u4e00\u4e2adump thrad(\u7ebf\u7a0b)\uff0c\u8d1f\u8d23\u54cd\u5e94\u4eceIO thread\u7684\u8bf7\u6c42\u3002<\/p>\n<\/div>\n<\/blockquote>\n<\/div>\n
\u4e3b\u4ece\u600e\u4e48\u5b9e\u73b0\u7684\uff1f<\/strong><\/p>\n
1\u3001\u901a\u8fc7\u4e8c\u8fdb\u5236\u65e5\u5fd7
\n2\u3001\u81f3\u5c11\u4e24\u53f0\uff08\u4e3b\u3001\u4ece\uff09
\n3\u3001\u4e3b\u670d\u52a1\u5668\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u201c\u62ff\u201d\u5230\u4ece\u670d\u52a1\u5668\u4e0a\u518d\u8fd0\u884c\u4e00\u904d\u3002
\n4\u3001\u901a\u8fc7\u7f51\u7edc\u8fde\u63a5\u4e24\u53f0\u673a\u5668\uff0c\u4e00\u822c\u90fd\u4f1a\u51fa\u73b0\u5ef6\u8fdf\u7684\u72b6\u6001\u3002\u4e5f\u53ef\u4ee5\u8bf4\u662f\u5f02\u6b65\u7684\u3002<\/p><\/blockquote>\n
\u00a0\\\"MySQL<\/p>\n
1.2.4 \u6267\u884c\u539f\u7406–\u7b2c\u4e00\u6b21\u5f00\u542f\u4e3b\u4ece\u8fc7\u7a0b<\/span><\/h3>\n
\n
\n
1\u3001 \u4ece\u5e93\u901a\u8fc7\u624b\u5de5\u6267\u884cchange master to \u8bed\u53e5\u8fde\u63a5\u4e3b\u5e93\uff0c\u63d0\u4f9b\u4e86\u8fde\u63a5\u7684\u7528\u6237\u4e00\u5207\u6761\u4ef6<\/p>\n
\uff08user<\/em>\u3001password<\/em>\u3001port<\/em>\u3001ip<\/em>\uff09<\/em><\/p>\n
\u00a0\u00a0\u00a0\u00a0\u5e76\u4e14\u8ba9\u4ece\u5e93\u77e5\u9053\uff0c\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u8d77\u70b9\u4f4d\u7f6e\uff08file<\/em>\u540d\u00a0 position<\/em>\u53f7\uff09<\/em><\/p>\n
\u00a0\u00a0\u00a0\u00a0start slave<\/em><\/p>\n
2\u3001\u4ece\u5e93\u7684IO\u548c\u4e3b\u5e93\u7684dump\u7ebf\u7a0b\u5efa\u7acb\u8fde\u63a5<\/p>\n
3\u3001\u4ece\u5e93\u6839\u636echange master to \u8bed\u53e5\u63d0\u4f9b\u7684file\u540d\u548cposition\u53f7\uff0cIO\u7ebf\u7a0b\u5411\u4e3b\u5e93\u53d1\u8d77binlog\u7684\u8bf7\u6c42<\/p>\n
4\u3001\u4e3b\u5e93dump\u7ebf\u7a0b\u6839\u636e\u4ece\u5e93\u7684\u8bf7\u6c42\uff0c\u5c06\u672c\u5730binlog\u4ee5events\u7684\u65b9\u5f0f\u53d1\u7ed9\u4ece\u5e93IO\u7ebf\u7a0b<\/p>\n
5\u3001\u4ece\u5e93IO\u7ebf\u7a0b\u63a5\u6536binlog evnets\uff0c\u5e76\u5b58\u653e\u5230\u672c\u5730relay-log\u4e2d\uff0c\u4f20\u9001\u8fc7\u6765\u7684\u4fe1\u606f\uff0c\u4f1a\u8bb0\u5f55\u5230master.info\u4e2d\u3002<\/p>\n
6\u3001\u4ece\u5e93SQL\u7ebf\u7a0b\u5e94\u7528relay-log\uff0c\u5e76\u4e14\u628a\u5e94\u7528\u8fc7\u7684\u8bb0\u5f55\u5230relay-log.info,\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5df2\u7ecf\u5e94\u7528\u8fc7\u7684relay\u4f1a\u81ea\u52a8\u88ab\u6e05\u7406purge\u3002<\/p>\n
\u5230\u6b64\u4f4d\u7f6e\uff0c\u4e00\u6b21\u4e3b\u4ece\u590d\u5236\u5c31\u5b8c\u6210<\/strong><\/p>\n<\/blockquote>\n<\/div>\n
\u3000\u3000\u4e00\u65e6\u4e3b\u4ece\u8fd0\u884c\u8d77\u6765\uff1a<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u3000\u3000\u3000\u3000\u5c31\u4e0d\u9700\u8981\u624b\u5de5\u6267\u884cchange master to\uff0c<\/p>\n
\u00a0\u3000\u3000\u00a0\u00a0\u3000\u3000 \u56e0\u4e3a\u4fe1\u606f\u90fd\u4f1a\u88ab\u5b58\u653e\u5230master.info<\/p>\n
\u3000\u3000\u3000\u3000\u3000\u3000\uff08user\u3001password\u3001port\u3001ip\uff0c\u4e0a\u6b21\u83b7\u53d6\u8fc7\u7684binlog\u4fe1\u606ffile\u548cposition\uff09\u4e2d<\/p>\n
\u00a0\u00a0\u00a0\u3000\u3000\u3000\u3000\u00a0\u5176\u4ed6\u7684\u8fc7\u7a0b\u90fd\u662f\u4e00\u6837\u7684<\/p>\n
1.2.4.1\u00a0\u00a0<\/strong>\u8be6\u7ec6\u7684mysql replication\u00a0<\/strong>\u8fc7\u7a0b\u00a0\u00a0<\/strong><\/span><\/h4>\n
\\\"MySQL<\/p>\n
1.3 \u4e3b\u4ece\u642d\u5efa\u914d\u7f6e<\/span><\/h2>\n
\u672c\u6b21\u4e3b\u4ece\u642d\u5efa\u4f7f\u7528mysql\u591a\u5b9e\u4f8b\u8fdb\u884c\u5b9e\u9a8c\u3002\u591a\u5b9e\u4f8b\u914d\u7f6e\u53c2\u8003\u6587\u6863\u8fdb\u884c\u914d\u7f6e\uff1a<\/em>http:\/\/www.cnblogs.com\/clsn\/p\/8038964.html#_label8<\/em><\/i><\/a><\/p>\n
1.3.1 \u591a\u5b9e\u4f8b\u6570\u636e\u5e93slave\u914d\u7f6e<\/span><\/h3>\n
\u7cfb\u7edf\u73af\u5883\u8bf4\u660e\uff1a<\/em><\/strong><\/p>\n
\n
\n
[root@db02 ~]# cat \/etc\/redhat-release\nCentOS release 6.9 (Final)\n[root@db02 ~]# uname -r\n2.6.32-696.el6.x86_64\n[root@db02 ~]# \/etc\/init.d\/iptables status\niptables: Firewall is not running.  # \u6ce8\u610f\uff1a\u52a1\u5fc5\u5173\u95ed\u9632\u706b\u5899\uff08iptables  selinux\uff09\n[root@db02 ~]# getenforce\nDisabled\n[root@db02 ~]# mysql --version\nmysql  Ver 14.14 Distrib 5.6.36, for Linux (x86_64) using  EditLine wrapper<\/pre>\n<\/div>\n<\/div>\n
1<\/strong>\u3001\u542f\u52a8\u591a\u5b9e\u4f8b\u6570\u636e\u5e93<\/strong><\/p>\n
\n
\n
[root@db02 ~]# \/data\/3306\/mysql start\nStarting MySQL...\n[root@db02 ~]# \/data\/3307\/mysql start\nStarting MySQL...<\/pre>\n<\/div>\n<\/div>\n
2<\/strong>\u3001\u914d\u7f6e\u6587\u4ef6\u8bf4\u660e\uff1a<\/strong>
\nmaster\u00a0<\/em><\/strong>\u914d\u7f6e\u6587\u4ef6\u8bf4\u660e\uff1a<\/em><\/strong><\/p>\n
\n
\n
[root@db02 ~]# cat \/data\/3306\/my.cnf\n[client]\nport            = 3306\nsocket          = \/data\/3306\/mysql.sock\n[mysqld]\nuser    = mysql\nport    = 3306\nsocket  = \/data\/3306\/mysql.sock\nbasedir = \/application\/mysql\ndatadir = \/data\/3306\/data\nlog-bin = \/data\/3306\/mysql-bin\nserver-id = 6  # server id \u4e0d\u80fd\u76f8\u540c\nskip_name_resolve = 0 # \u8df3\u8fc7\u57df\u540d\u89e3\u6790\u53c2\u6570\n[mysqld_safe]\nlog-error=\/data\/3306\/mysql_3306.err\npid-file=\/data\/3306\/mysqld.pid<\/pre>\n<\/div>\n<\/div>\n
slave\u00a0<\/em><\/strong>\u914d\u7f6e\u6587\u4ef6\u8bf4\u660e\uff1a<\/em><\/strong><\/p>\n
\n
\n
[root@db02 ~]# cat \/data\/3307\/my.cnf\n[client]\nport            = 3307\nsocket          = \/data\/3307\/mysql.sock\n[mysqld]\nuser    = mysql\nport    = 3307\nsocket  = \/data\/3307\/mysql.sock\nbasedir = \/application\/mysql\ndatadir = \/data\/3307\/data\nlog-bin = \/data\/3307\/mysql-bin\nserver-id = 7  # server id \u4e0d\u80fd\u76f8\u540c\nskip_name_resolve = 0  # \u8df3\u8fc7\u57df\u540d\u89e3\u6790\u53c2\u6570\nread_only = 1  # \u4ece\u5e93\u53ea\u8bfb \uff08\u975eroot\u7528\u6237 \uff09\n[mysqld_safe]\nlog-error=\/data\/3307\/mysql_3307.err\npid-file=\/data\/3307\/mysqld.pid<\/pre>\n<\/div>\n<\/div>\n
3<\/strong>\u3001\u5728\u4e3b\u5e93\u521b\u5efa\u590d\u5236\u7528\u6237<\/strong>
\n\u767b\u9646\u5230\u4e3b\u6570\u636e\u5e93\u4e2d\uff1a<\/p>\n
\n
\n
mysql -uroot -p123 -S \/data\/3306\/mysql.sock<\/pre>\n<\/div>\n<\/div>\n
\u521b\u5efa\u6388\u6743\u7528\u6237\uff0c\u6ce8\u610f\u662fslave\u7528\u6237\u3002<\/p>\n
\n
\n
grant replication slave  on *.* to repl@\\'10.0.0.%\\' identified by \\'123\\';<\/pre>\n<\/div>\n<\/div>\n
4<\/strong>\u3001\u521d\u59cb\u5316\u4ece\u5e93\u6570\u636e<\/strong>
\n\u5907\u4efd\u4e3b\u5e93\u5f53\u524d\u6570\u636e<\/p>\n
\n
\n
 mysqldump -uroot -p123 -A -B -F --master-data=2  -S \/data\/3306\/mysql.sock >\/tmp\/full.sql<\/pre>\n<\/div>\n<\/div>\n
\u00a0\u90e8\u5206<\/em>\u53c2\u6570\u8bf4\u660e\uff1a\uff08\u8be6\u7ec6\u53c2\u7167http:\/\/www.cnblogs.com\/clsn\/p\/8138015.html#_label2<\/i><\/a>\uff09<\/em>
\n-F \u5237\u65b0\u4e8c\u8fdb\u5236\u65e5\u5fd7
\n–master-data [=\uff03]\u8fd9\u4f1a\u5bfc\u81f4\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u4f4d\u7f6e\u548c\u6587\u4ef6\u540d\u88ab\u8ffd\u52a0\u5230\u8f93\u51fa\u4e2d\u3002
\n\u5982\u679c\u7b49\u4e8e1\uff0c\u5219\u5c06\u5176\u6253\u5370\u4e3aCHANGE MASTER\u547d\u4ee4; \u5982\u679c\u7b49\u4e8e2\uff0c\u90a3\u4e48\u8be5\u547d\u4ee4\u5c06\u4ee5\u6ce8\u91ca\u7b26\u53f7\u4e3a\u524d\u7f00\u3002
\n\u5230\u4ece\u5e93\u8fdb\u884c\u6062\u590d<\/p>\n
\n
\n
 mysql -uroot -p123 -S \/data\/3307\/mysql.sock<\/pre>\n<\/div>\n
# \u6062\u590d\u5907\u4efd\u7684\u6570\u636e<\/p>\n
\n
set sql_log_bin=0;\nsource \/tmp\/full.sql<\/pre>\n<\/div>\n<\/div>\n
5<\/strong>\u3001\u5f00\u542f\u4ece\u5e93\u590d\u5236<\/strong>
\n\u67e5\u770b\u5907\u4efd\u7684\u5f53\u524d\u4f7f\u7528\u7684\u6587\u4ef6\u53caPOS\u53f7<\/p>\n
\n
\n
mysql> show master status;\n+------------------+----------+--------------+------------------+-------------------+\n| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |\n+------------------+----------+--------------+------------------+-------------------+\n| mysql-bin.000012 |      120 |              |                  |                   |\n+------------------+----------+--------------+------------------+-------------------+\n1 row in set (0.00 sec)<\/pre>\n<\/div>\n<\/div>\n
\u767b\u5165\u6570\u636e\u5e93\uff0c\u8fdb\u884cslave\u914d\u7f6e\u3002<\/p>\n
\n
\n
mysql -uroot -p123 -S \/data\/3307\/mysql.sock\nCHANGE MASTER TO\n  MASTER_HOST=\\'10.0.0.52\\',\n  MASTER_USER=\\'repl\\',\n  MASTER_PASSWORD=\\'123\\',\n  MASTER_PORT=3306,\n  MASTER_LOG_FILE=\\'mysql-bin.000012\\',\n  MASTER_LOG_POS=120;\nstart  slave;  # \u542f\u52a8\u4ece\u5e93\u590d\u5236<\/pre>\n<\/div>\n<\/div>\n
\u8be5\u914d\u7f6e\u60f3\u5173\u8bf4\u660e\u53ef\u4ee5\u901a\u8fc7 help \u83b7\u5f97\u3002<\/p>\n
\n
\n
mysql> help CHANGE MASTER TO\nCHANGE MASTER TO\n  MASTER_HOST=\\'master2.mycompany.com\\',\n  MASTER_USER=\\'replication\\',\n  MASTER_PASSWORD=\\'bigs3cret\\',\n  MASTER_PORT=3306,\n  MASTER_LOG_FILE=\\'master2-bin.001\\',\n  MASTER_LOG_POS=4,\n  MASTER_CONNECT_RETRY=10;<\/pre>\n<\/div>\n<\/div>\n
1.3.2 \u6d4b\u8bd5\u4e3b\u4ece\u540c\u6b65<\/span><\/h3>\n
\u67e5\u770bslave\u5e93\u7684\u72b6\u6001
\n\u4e3b\u8981\u67e5\u770b\u00a0\u00a0 Slave_IO_Running \u4e0e Slave_SQL_Running \u662f\u5426\u90fd\u4e3aYes<\/p>\n
\n
\\\"MySQL<\/p>\n
\n
 1 mysql> show slave status\\\\G\n 2 *************************** 1. row ***************************\n 3                Slave_IO_State: Waiting for master to send event\n 4                   Master_Host: 10.0.0.52\n 5                   Master_User: repl\n 6                   Master_Port: 3306\n 7                 Connect_Retry: 60\n 8               Master_Log_File: mysql-bin.000010\n 9           Read_Master_Log_Pos: 842\n10                Relay_Log_File: 3307-relay-bin.000018\n11                 Relay_Log_Pos: 283\n12         Relay_Master_Log_File: mysql-bin.000010\n13              Slave_IO_Running: Yes\n14             Slave_SQL_Running: Yes\n15               Replicate_Do_DB:\n16           Replicate_Ignore_DB:\n17            Replicate_Do_Table:\n18        Replicate_Ignore_Table:\n19       Replicate_Wild_Do_Table:\n20   Replicate_Wild_Ignore_Table:\n21                    Last_Errno: 0\n22                    Last_Error:\n23                  Skip_Counter: 0\n24           Exec_Master_Log_Pos: 842\n25               Relay_Log_Space: 455\n26               Until_Condition: None\n27                Until_Log_File:\n28                 Until_Log_Pos: 0\n29            Master_SSL_Allowed: No\n30            Master_SSL_CA_File:\n31            Master_SSL_CA_Path:\n32               Master_SSL_Cert:\n33             Master_SSL_Cipher:\n34                Master_SSL_Key:\n35         Seconds_Behind_Master: 0\n36 Master_SSL_Verify_Server_Cert: No\n37                 Last_IO_Errno: 0\n38                 Last_IO_Error:\n39                Last_SQL_Errno: 0\n40                Last_SQL_Error:\n41   Replicate_Ignore_Server_Ids:\n42              Master_Server_Id: 6\n43                   Master_UUID: 4f344556-e0ab-11e7-9138-000c29d60ab3\n44              Master_Info_File: \/data\/3307\/data\/master.info\n45                     SQL_Delay: 0\n46           SQL_Remaining_Delay: NULL\n47       Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I\/O thread to update it\n48            Master_Retry_Count: 86400\n49                   Master_Bind:\n50       Last_IO_Error_Timestamp:\n51      Last_SQL_Error_Timestamp:\n52                Master_SSL_Crl:\n53            Master_SSL_Crlpath:\n54            Retrieved_Gtid_Set:\n55             Executed_Gtid_Set:\n56                 Auto_Position: 0\n57 1 row in set (0.00 sec)<\/pre>\n<\/div>\n
View Code \u4ece\u5e93\u72b6\u6001\u4fe1\u606f<\/span>\n<\/div>\n<\/div>\n
\u5728\u4e3b\u5e93\u8fdb\u884c\u64cd\u4f5c\uff0c\u5728\u4ece\u5e93\u9a8c\u8bc1<\/p>\n
\n
\n
[root@db02 ~]# mysql -uroot -p123  -S \/data\/3306\/mysql.sock\nmysql> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| test               |\n+--------------------+\n4 rows in set (0.00 sec)\nmysql> create database clsn;\nQuery OK, 1 row affected (0.00 sec)<\/pre>\n<\/div>\n<\/div>\n
\u5728\u4ece\u5e93\u4e0a\u53ef\u4ee5\u770b\u5230\u8be5\u6570\u636e\u5e93\u5df2\u521b\u5efa<\/p>\n
\n
\n
[root@db02 ~]# mysql -uroot -p123 -S \/data\/3307\/mysql.sock\nmysql> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| clsn               |\n| mysql              |\n| performance_schema |\n| test               |\n+--------------------+\n5 rows in set (0.00 sec)<\/pre>\n<\/div>\n
\u81f3\u6b64mysql<\/em><\/strong>\u4e3b\u4ece\u590d\u5236\u5c31\u642d\u5efa\u5b8c\u6210<\/em><\/strong>\n<\/div>\n
1.3.3 \u5fd8\u8bb0\u6570\u636e\u5e93\u5bc6\u7801\uff1f<\/span><\/h3>\n
\n
\n
shell> \/application\/mysql\/bin\/mysqld_safe  --defaults-file=\/data\/3306\/my.cnf    --skip-grant-tables --skip-networking  &\nmysql> update user set password=password(\\'123\\') where user=\\'root\\' and host=\\'localhost\\';\nmysql> flush privileges;<\/pre>\n<\/div>\n<\/div>\n
1.3.4 \u4e3b\u4ece\u590d\u5236\u72b6\u6001\u5931\u8d25\u7684\u539f\u56e0\uff1f<\/span><\/h3>\n
\n
\n
Last_IO_Error: error reconnecting to master \\'repl@10.0.0.52:3306\\' - retry-time: 60  retries: 1<\/pre>\n<\/div>\n<\/div>\n
\u539f\u56e0\uff1a<\/p>\n
\n
\n
\n
1\u3001\u4e3b\u673a\u6ca1\u542f\u52a8\uff0c\u6216\u8005\u5b95\u673a\uff0c\u68c0\u67e5\u4e3b\u5e93\u7684\u72b6\u6001\u3002<\/p>\n
2\u3001\u7f51\u7edc\u901a\u4fe1\u95ee\u9898\uff0c\u4f7f\u7528ping\u547d\u4ee4\u8fdb\u884c\u68c0\u67e5\uff1b\u6216\u4f7f\u7528mysql\u547d\u4ee4\u8fdb\u884cshell\u7aef\u767b\u9646\u6d4b\u8bd5<\/p>\n
3\u3001\u9632\u706b\u5899\uff0cselinux\uff08\u52a1\u5fc5\u68c0\u67e5\uff09\u3002<\/p>\n
4\u3001\u590d\u5236\u7528\u6237\u548c\u5bc6\u7801\u3001\u7aef\u53e3\u53f7\u3001\u5730\u5740\u6709\u95ee\u9898\uff0c\u4f7f\u7528mysql\u547d\u4ee4\u8fdb\u884cshell\u7aef\u767b\u9646\u6d4b\u8bd5\u3002<\/p>\n
5\u3001mysql\u81ea\u52a8\u89e3\u6790\uff0c\u4f1a\u5c06\u8fde\u63a5\u7684IP\u89e3\u6790\u6210\u4e3b\u673a\u540d\uff08skip-name-resolve = 0\uff09\u5199\u5165my.cnf\u6587\u4ef6\u5373\u53ef\u3002<\/p>\n
6\u3001\u4ece\u5e93IO\u5f02\u5e38\u5173\u95ed\uff0c\u901a\u8fc7show slave status \\\\G \u8fdb\u884c\u67e5\u770b\u3002<\/p>\n<\/div>\n<\/blockquote>\n<\/div>\n
1.4 MySQL\u4e3b\u4ece\u590d\u5236\u5e38\u89c1\u95ee\u9898<\/span><\/h2>\n
1.4.1 \u4ece\u5e93binlog\u843d\u540e\u4e3b\u5e93binlog\uff1f<\/span><\/h3>\n
\u4ece\u5e93\u8bb0\u5f55\u7684\u5df2\u7ecf\u4e3b\u5e93\u5df2\u7ecf\u7ed9\u6211\u4f20\u9001\u7684binlog\u4e8b\u4ef6\u7684\u5750\u6807\uff0c\u4e00\u822c\u5728\u7e41\u5fd9\u7684\u751f\u4ea7\u73af\u5883\u4e0b\u4f1a\u843d\u540e\u4e8e\u4e3b\u5e93<\/p>\n
\n
\n
show master status\\\\G  --- \u4e3b\nshow slave status \\\\G  --- \u4ece\nMaster_Log_File: mysql-bin.000007\nRead_Master_Log_Pos: 729<\/pre>\n<\/div>\n<\/div>\n
\u843d\u540e\u592a\u8fdc\u7684\u539f\u56e0\uff1a<\/strong><\/p>\n
\u786c\u4ef6\u6761\u4ef6\u6709\u5173\u7684\uff0c\u673a\u5668\u78c1\u76d8IO\u6027\u80fd\u4e0d\u8db3\u3002
\n\u4e3b\u8981\u8fd8\u662f\u7f51\u7edc\u95ee\u9898\uff0c\u7f51\u7edc\u4f20\u8f93\u7684\u6027\u80fd\u3002
\n\u4e3b\u5e93\u5b58\u653e\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u5b58\u50a8\u6027\u80fd\u592a\u4f4e\uff0c\u5efa\u8baebinlog\u65e5\u5fd7\u5b58\u548bSSD\u4e2d\u3002
\n\u4e3b\u5e93DUMP\u7ebf\u7a0b\u592a\u7e41\u5fd9\uff0c\u4e3b\u8981\u53d1\u751f\u5728\u4e00\u4e3b\u591a\u4ece\u7684\u73af\u5883\u4e0b\u3002
\n\u4ece\u5e93IO\u7ebf\u7a0b\u592a\u5fd9
\n\u4eba\u4e3a\u63a7\u5236\uff08delay\u8282\u70b9\u3001\u5ef6\u65f6\u8282\u70b9 \uff09<\/p><\/blockquote>\n
1.4.2 \u4e3b\u5e93update\uff0c\u4ece\u5e93\u8fdf\u8fdf\u7684\u6ca1\u6709\u66f4\u65b0\u3002<\/span><\/h3>\n
\u7279\u6b8a\u60c5\u51b5\uff1a<\/em><\/strong>\u65e5\u5fd7\u5df2\u7ecf\u4f20\u8fc7\u6765\u4e86\uff0c\u6570\u636e\u5e76\u6ca1\u6709\u540c\u6b65
\n\u4e00\u822c\u60c5\u51b5\uff1a<\/strong><\/em><\/p>\n
\n
\n
\n
1\u3001\u6ca1\u5f00\u542fSQL\u7ebf\u7a0b<\/p>\n
2\u3001\u4f20\u7684\u4e1c\u897f\u6709\u95ee\u9898\uff08\u4f60\u8981\u505a\u7684\u4e8b\u60c5\uff0c\u6211\u63d0\u524d\u5df2\u7ecf\u505a\u4e86\uff0c\u4e0d\u60f3\u91cd\u590d\u505a\u4e86\uff0c\u7136\u540e\u4ed6\u5c31\u6b7b\u4e86\uff09<\/p>\n
3\u3001SQL\u7ebf\u7a0b\u5fd9\u3002<\/p>\n
4\u3001\u4eba\u4e3a\u63a7\u5236\u4e86\u3010delay(\u4ece\u5e93)\u8282\u70b9\u3001\u5ef6\u65f6\u8282\u70b9\uff0c\u4e00\u822c\u751f\u4ea7\u8bbe\u7f6e\u4e3a3-6\u5c0f\u65f6\u4e4b\u95f4\uff0c\u53ef\u4ee5\u4fdd\u8bc1\u8fc7\u53bb3-6\u5c0f\u65f6\u4e4b\u95f4\u7684\u8bef\u64cd\u4f5c\uff0c\u53ef\u4ee5\u907f\u514d\u3011\u3002<\/p>\n<\/div>\n<\/blockquote>\n<\/div>\n
1.4.3 \u4e3b\u4ece\u590d\u5236\u5ef6\u65f6\u914d\u7f6e(\u4ece\u5e93\u914d\u7f6e)<\/span><\/h3>\n
\u505c\u6b62\u4ece\u5e93\u590d\u5236<\/p>\n
\n
\n
mysql>stop slave;\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n<\/div>\n<\/div>\n
\u4fee\u6539\u5ef6\u65f6\u53c2\u6570\uff0cMASTER_DELAY\uff0c\u5355\u4f4d\u4f4dS \uff08\u79d2\uff09\u3002<\/p>\n
\n
\n
mysql>CHANGE MASTER TO MASTER_DELAY = 30;\nQuery OK, 0 rows affected (0.07 sec)<\/pre>\n<\/div>\n<\/div>\n
\u542f\u52a8\u4ece\u5e93\u590d\u5236<\/p>\n
\n
\n
mysql>start slave;\nQuery OK, 0 rows affected (0.07 sec)<\/pre>\n<\/div>\n<\/div>\n
\u67e5\u770b\u914d\u7f6e\u662f\u5426\u751f\u6548<\/p>\n
\n
\n
mysql> show slave status \\\\G\n\u2026\u2026\n              SQL_Delay: 30<\/pre>\n<\/div>\n<\/div>\n
1.4.4 \u4ece\u5e93\u5b89\u5168\u914d\u7f6e\uff08\u5176\u4ed6\u7528\u6237\u53ea\u8bfb\uff09<\/span><\/h3>\n
\u4fee\u6539my.cnf\u914d\u7f6e\u6587\u4ef6\uff0c\u6dfb\u52a0\u53ea\u8bfb\u53c2\u6570<\/p>\n
\n
\n
read_only = 1    ====> \u63a7\u5236\u666e\u901a\u7528\u6237\ninnodb_read_only = 1  ====> \u63a7\u5236root\u7528\u6237\uff0c\u6b63\u5e38\u60c5\u51b5\u4e0d\u8981\u52a0<\/pre>\n<\/div>\n<\/div>\n
\u6dfb\u52a0\u5b8c\u6210\u540e\u91cd\u542f\u6570\u636e\u5e93<\/p>\n
\n
\n
mysql> show variables like \\'%read_only%\\';\n+------------------+-------+\n| Variable_name    | Value |\n+------------------+-------+\n| innodb_read_only | OFF   |\n| read_only        | ON    |\n| tx_read_only     | OFF   |\n+------------------+-------+\n3 rows in set (0.00 sec)<\/pre>\n<\/div>\n
\u5ef6\u65f6\u4ece\u5e93: delay\u8282\u70b9\u3001\u5ef6\u65f6\u8282\u70b9\n<\/p><\/div>\n
1.4.5 \u4e3b\u4ece\u590d\u5236\u6545\u969c\u53ca\u89e3\u51b3\uff08\u8df3\u8fc7\u9519\u8bef\uff09<\/span><\/h3>\n
\u547d\u4ee4\u884c\u8bbe\u7f6e<\/p>\n
\n
\n
stop slave; #<==\u4e34\u65f6\u505c\u6b62\u540c\u6b65\u5f00\u5173\u3002\nset global sql_slave_skip_counter = 1 ; #<==\u5c06\u540c\u6b65\u6307\u9488\u5411\u4e0b\u79fb\u52a8\u4e00\u4e2a\uff0c\u5982\u679c\u591a\u6b21\u4e0d\u540c\u6b65\uff0c\u53ef\u4ee5\u91cd\u590d\u64cd\u4f5c\u3002\nstart slave;<\/pre>\n<\/div>\n<\/div>\n
\u5728\u914d\u7f6e\u6587\u4ef6\u4fee\u6539\uff0c\u8bbe\u7f6e\u8981\u8df3\u8fc7\u7684pos<\/p>\n
\n
\n
\/etc\/my.cnf\nslave-skip-errors = 1032,1062,1007<\/pre>\n<\/div>\n
\u5728mysql\u4e2d\u53ef\u4ee5\u8df3\u8fc7\u67d0\u4e9b\u9519\u8bef,\u4f46\u662f\u6700\u597d\u7684\u89e3\u51b3\u529e\u6cd5\uff0c\u91cd\u65b0\u642d\u5efa\u4e3b\u4ece\u590d\u5236\u3002\n<\/p><\/div>\n
1.4.6 \u5ef6\u65f6\u8282\u70b9\u6982\u5ff5 –> SQL\u7ebf\u7a0b\u5ef6\u65f6\uff1f<\/span><\/h3>\n
\n
Last_SQL_Errno: 0\nLast_SQL_Error:<\/pre>\n<\/div>\n
\u539f\u56e0:<\/em><\/strong><\/p>\n
1\u3001\u4e3b\u5e93\u505a\u64cd\u4f5c\u7684\u5bf9\u8c61\uff0c\u5728\u4ece\u5e93\u4e0d\u5b58\u5728
\n2\u3001\u4e3b\u5e93\u505a\u64cd\u4f5c\u7684\u5bf9\u8c61\u5c5e\u6027\u4e0d\u4e00\u81f4\u3002
\n3\u3001\u4e3b\u5e93\u505a\u64cd\u4f5c\u7684\u5bf9\u8c61\uff0c\u4ece\u5e93\u5df2\u7ecf\u5b58\u5728
\n\u2026\u2026<\/p><\/blockquote>\n
1.4.7 Slave_*_Running\uff1a\uff1f<\/span><\/h3>\n
\n
\n1\u3001Slave_IO_Running I\/O \u7ebf\u7a0b\u6b63\u5728\u8fd0\u884c\u3001\u672a\u8fd0\u884c\u8fd8\u662f\u6b63\u5728\u8fd0\u884c\u4f46\u5c1a\u672a\u8fde\u63a5\u5230\u4e3b\u670d\u52a1\u5668\u3002\u53ef\u80fd\u503c\u5206\u522b\u4e3aYes\u3001No \u6216 Connecting\u3002
\n2\u3001Slave_SQL_Running SQL \u7ebf\u7a0b\u5f53\u524d\u6b63\u5728\u8fd0\u884c\u3001\u672a\u8fd0\u884c,\u53ef\u80fd\u503c\u5206\u522b\u4e3a Yes\u3001No \u4e3b\u670d\u52a1\u5668\u65e5\u5fd7\u5750\u6807\uff1a
\n3\u3001Master_Log_File \u548c Read_Master_Log_Pos \u6807\u8bc6\u4e3b\u670d\u52a1\u5668\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d I\/O \u7ebf\u7a0b\u5df2\u7ecf\u4f20\u8f93\u7684\u6700\u8fd1\u4e8b\u4ef6\u7684\u5750\u6807\u3002
\n4\u3001\u5982\u679cMaster_Log_File\u548cRead_Master_Log_Pos \u7684\u503c\u8fdc\u8fdc\u843d\u540e\u4e8e\u4e3b\u670d\u52a1\u5668\u4e0a\u7684\u90a3\u4e9b\u503c\uff0c\u8fd9\u8868\u793a\u4e3b\u670d\u52a1\u5668\u4e0e\u4ece\u5c5e\u670d\u52a1\u5668\u4e4b\u95f4\u4e8b\u4ef6\u7684\u7f51\u7edc\u4f20\u8f93\u53ef\u80fd\u5b58\u5728\u5ef6\u8fdf\u3002\n<\/div>\n<\/blockquote>\n
1.4.8 \u4e2d\u7ee7\u65e5\u5fd7\u5750\u6807<\/span><\/h3>\n
a)\u00a0 Relay_Log_File \u548c Relay_Log_Pos \u5217\u6807\u8bc6\u4ece\u5c5e\u670d\u52a1\u5668\u4e2d\u7ee7\u65e5\u5fd7\u4e2d SQL \u7ebf\u7a0b\u5df2\u7ecf\u6267\u884c\u7684\u6700\u8fd1\u4e8b\u4ef6\u7684\u5750\u6807\u3002\u8fd9\u4e9b\u5750\u6807\u5bf9\u5e94\u4e8e Relay_Master_Log_File \u548c Exec_Master_Log_Pos \u5217\u6807\u8bc6\u7684\u4e3b\u670d\u52a1\u5668\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d\u7684\u5750\u6807\u3002
\nb)\u00a0 \u5982\u679c Relay_Master_Log_File \u548c Exec_Master_Log_Pos \u5217\u7684\u8f93\u51fa\u8fdc\u8fdc\u843d\u540e\u4e8e Master_Log_File \u548cRead_Master_Log_Pos \u5217\uff08\u8868\u793a I\/O \u7ebf\u7a0b\u7684\u5750\u6807\uff09\uff0c\u8fd9\u8868\u793a SQL \u7ebf\u7a0b\uff08\u800c\u4e0d\u662f I\/O \u7ebf\u7a0b\uff09\u4e2d\u5b58\u5728\u5ef6\u8fdf\u3002\u5373\uff0c\u5b83\u8868\u793a\u590d\u5236\u65e5\u5fd7\u4e8b\u4ef6\u5feb\u4e8e\u6267\u884c\u8fd9\u4e9b\u4e8b\u4ef6\u3002<\/p><\/blockquote>\n
1.4.9 \u5355\u4e00\u4e3b\u4ece\u9700\u8981\u6539\u53d8\u7684\u5730\u65b9<\/span><\/h3>\n
\u4ece\u5e93\u7684\u4f5c\u7528<\/strong><\/p>\n
1\u3001\u76f8\u5f53\u4e8e\u5b9e\u65f6\u5907\u4efd
\n2\u3001\u4f7f\u7528\u4ece\u5e93\u5907\u4efd
\n3\u3001\u4e00\u4e3b\u591a\u4ece\u5e94\u5bf9\u8bfb\u591a\u7684\u4e1a\u52a1\u9700\u6c42<\/p><\/blockquote>\n
\u00a0 \u00a0 \u00a0<\/strong>\u00a0\u5982\u679c\uff0c\u4ece\u5e93\u53ea\u505a\u5907\u4efd\u670d\u52a1\u5668\u7528\uff0c\u90a3\u4e48\u4e3b\u5e93\u7684\u538b\u529b\u4f1a\u4e0d\u51cf\u53cd\u589e\u3002\u56e0\u4e3a\uff0c\u6240\u6709\u7684\u4e1a\u52a1\u90fd\u5728\u4e3b\u5e93\u5b9e\u73b0\uff0c\u8bfb\u548c\u5199\uff0cdump\u7ebf\u7a0b\u8bfb\u53d6\u5e76\u6295\u9012binlog
\n\u89e3\u51b3\u65b9\u6848\uff1a<\/strong><\/p>\n
\uff081\uff09\u53ef\u4e0d\u53ef\u4ee5\u632a\u8d70\u4e00\u90e8\u5206\u8bfb\u4e1a\u52a1\u5230\u4ece\u5e93\uff0c\u8bfb\u5199\u5206\u79bb
\n\uff082\uff09 \u4e00\u4e3b\u591a\u4ece\u5e94\u5bf9\u8bfb\u591a\u7684\u4e1a\u52a1\u9700\u6c42\uff0c\u4e00\u65e6\u53d1\u5c55\u6210\u8fd9\u4e2a\u67b6\u6784\uff0cdump\u7ebf\u7a0b\u6295\u9012binlog\u7684\u538b\u529b\u66f4\u5927
\n\uff083\uff09 \u591a\u7ea7\u4e3b\u4ece\uff0c\u91c7\u7528\u4e2d\u95f4\u5e93\u7f13\u89e3\u4e3b\u5e93dump\u7684\u538b\u529b\uff0c\u4f1a\u51fa\u73b0\u4e2d\u95f4\u5e93\u74f6\u9888\u7684\u95ee\u9898\uff0c\u9009\u62e9blackhole\u5f15\u64ce\uff0c\u770b\u6027\u80fd\u4e0e\u5b89\u5168\u7684\u6743\u8861
\n\uff084\uff09\u53cc\u4e3b\u6a21\u578b\uff1a\u7f13\u89e3\uff0c\u6570\u636e\u4e00\u81f4\u6027\u96be\u4fdd\u8bc1
\n\uff085\uff09\u73af\u88c5\u590d\u5236<\/p><\/blockquote>\n
1.5 \u3010\u751f\u4ea7\u6848\u4f8b\u3011\u4e3b\u4ece\u590d\u5236\u4e8b\u6545<\/span><\/h2>\n
1.5.1 \u53d1\u751f\u80cc\u666f<\/span><\/h3>\n
1\u3001\u6709\u4e00\u53f0\u5df2\u7ecf\u5de5\u4f5c\u5f88\u4e45\u7684\u5355\u673amysql\u6570\u636e\u3002\u57282017\u5e7412\u670824\u65e5\u7684\u5e73\u5b89\u591c\uff0c\u6211\u53f8\u8d2d\u7269\u7f51\u7ad9\u5b95\u673a\u4e86\u3002\u673a\u5668\u7269\u635f\u574f\uff0c\u7cfb\u7edf\u786c\u76d8\u62a5\u5e9f\u3002
\n2\u3001\u5728\u63a5\u5230\u4e00\u6761\u77ed\u4fe1\u544a\u77e5\u670d\u52a1\u5668\u5b95\u673a\uff0c\u6570\u636e\u5e93\u8fde\u4e0d\u4e0a\u3002\u5f53\u65f6\u7684\u6211\u4e00\u8138\u61f5\u903c\u7684\u8fd8\u5728\u5f00party\uff0c\u8c01\u80fd\u60f3\u5230\u5728\u8fd9\u6837\u4e00\u4e2a\u9616\u5bb6\u6b22\u4e50\u7684\u65f6\u523b\u53d1\u751f\u8fd9\u6837\u7684\u4e8b\u60c5\u3002
\n3\u3001\u968f\u4e4b\u6211\u706b\u901f\u8d76\u56de\u516c\u53f8\u5904\u7406\u4e8b\u6545\u3002\u9996\u5148\u66f4\u6362\u786c\u76d8\uff0c\u4ece\u5907\u4efd\u670d\u52a1\u5668\u4e0a\u62c9\u53d6\u5907\u4efd\u6570\u636e\uff0c\u7528\u5907\u4efd\u6062\u590d\u5b95\u673a\u7684\u65f6\u523b\u6570\u636e\uff0c\u7ecf\u538640\u5206\u949f\u540e\u6240\u6709\u5e94\u7528\u6062\u590d\u6b63\u5e38\u3002
\n4\u3001\u7ecf\u5386\u8fd9\u6b21\u4e8b\u6545\uff0c\u51b3\u5fc3\u4fee\u6539\u6570\u636e\u5e93\u67b6\u6784\uff0c\u6211\u8ddf\u9886\u5bfc\u627f\u8bfa\uff0c\u4fdd\u8bc1\u6539\u5b8c\u4e4b\u540e\uff0c\u51fa\u73b0\u7c7b\u4f3c\u6545\u969c\u80fd\u57285-10\u5206\u949f\u6062\u590d\u4e1a\u52a1\u3002\u628a\u539f\u6765\u7684\u505c\u673a\u65f6\u95f4\u7f29\u77ed4-8\u500d\u3002<\/p><\/blockquote>\n
1.5.2 \u642d\u5efa\u6d41\u7a0b<\/span><\/h3>\n
1.5.2.1\u00a0\u00a0<\/strong>\u67b6\u6784\u8bbe\u8ba1<\/strong><\/span><\/h4>\n
\u00a0\\\"MySQL<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4fee\u6539\u67b6\u6784\u91c7\u7528\u6570\u636e\u5e93\u4e3b\u4ece\u540c\u6b65\uff0c\u80fd\u4fdd\u8bc1\u6570\u636e\u7684\u5b89\u5168\uff0c\u63d0\u9ad8\u4e8b\u6545\u53d1\u751f\u7684\u6062\u590d\u901f\u5ea6\u3002<\/p>\n
1.5.2.2\u00a0\u00a0<\/strong>\u67b6\u6784\u5b9e\u65bd<\/strong><\/span><\/h4>\n
\uff081\uff09\u51c6\u5907\u4e00\u53f0\u65b0\u673a\u5668\uff0c\u914d\u7f6e\u3001\u7cfb\u7edf\u3001\u73af\u5883\u7b49\u4e0e\u539f\u6570\u636e\u5e93\u4fdd\u6301\u4e00\u81f4\u3002
\n\uff082\uff09\u5728\u4e3b\u5e93\u68c0\u67e5binlog\u5f00\u5173\uff0c\u6ca1\u6709\u5f00\u542f\u5c06\u5176\u5f00\u542f \uff0c\u68c0\u67e5server_id \u4e0e auto.cnf\u6587\u4ef6\u4e2d\u7684uuid \u662f\u5426\u552f\u4e00\u3002
\n\uff083\uff09\u4e3b\u5e93\u521b\u5efa\u6388\u6743\u590d\u5236\u7684\u7528\u6237\uff0c\u6388\u6743 replication slave\u3002
\n\uff084\uff09\u5907\u4efd\u4e3b\u5e93\u4e0a\u73b0\u6709\u6570\u636e\uff0c\u6062\u590d\u5230\u4ece\u5e93\u4e2d\uff0c\u63a8\u8350\u4f7f\u7528mysqldump\uff0c\u5728\u8bbf\u95ee\u4f4e\u8c37\u7684\u65f6\u5019\u505a\u3002
\n\uff085\uff09\u5728\u4ece\u5e93\u4e0a\u5f00\u542fbinlog\u548crelaylog,server_id\u3002
\n\uff086\uff09\u5728\u4ece\u5e93\u914d\u7f6echange master to \u4fe1\u606f\uff1a\u5728\u7b2c\u4e00\u6b21\u5f00\u542f\u4e3b\u4ece\u7684\u65f6\u5019\uff0c\u544a\u8bc9\u4ece\u5e93user password host\u00a0 port\uff0c\u590d\u5236binlog\u7684\u8d77\u70b9file\u3001position\u3002
\n\uff087\uff09start slave \u5f00\u542f\u4e3b\u4ece\u590d\u5236\u3002
\n\u5230\u6b64\u5386\u7ecf\u5343\u8f9b\u4e07\u82e6\u4e3b\u4ece\u590d\u5236\u642d\u5efa\u5b8c\u6210\u3002<\/p>\n
1.5.3 \u6d4b\u8bd5\u4e3b\u4ece\u5207\u6362<\/span><\/h3>\n
\uff081\uff09 \u4e3b\u4ece\u7684\u53ef\u7528\u6027\u6d4b\u8bd5\uff1a\u5728\u4e3b\u5e93\u4e2d\u63d2\u5165\u6570\u636e\uff0c\u5728\u4ece\u5e93\u67e5\u770b\u6709\u6ca1\u6709\u3002
\n\uff082\uff09 \u4e3b\u4ece\u5feb\u901f\u6062\u590d\u6f14\u7ec3
\na)\u00a0 \u5728\u4e00\u4e2a\u6708\u9ed1\u98ce\u9ad8\u591c\u9009\u4e00\u4e2a\u4e1a\u52a1\u4e0d\u7e41\u5fd9\u65f6\u95f4\u70b9\uff0c\u4eba\u5de5\u5b95\u6389\u4e3b\u5e93\u3002
\nb)\u00a0 \u5c06\u4ece\u5e93\u5b9a\u4e3a\u4e3b\u5e93\uff0c\u67e5\u770b\u4ece\u5e93\u7684\u65e5\u5fd7\u91cf\uff08master.info\u3001relay-log.info\uff09
\nc)\u00a0 \u5224\u65ad\u4e3b\u4ece\u65e5\u5fd7\u7684\u5dee\u8ddd\uff08master.info,show master status\uff09
\nd)\u00a0 \u6062\u590d\u540e\u53d1\u73b0\u504f\u5dee\uff0c\u5c31\u4eba\u4e3a\u767b\u5f55\u5230\u4e3b\u5e93\uff08\u5907\u4efd\u670d\u52a1\u5668\u4e5f\u884c\uff09\u4e2d\uff0c\u628a\u622a\u53d6\u5dee\u8ddd\u7684binlog\u65e5\u5fd7\uff0c\u5e76\u4f20\u9001\u5230\u4ece\u5e93\u8fdb\u884c\u6570\u636e\u8865\u507f\u3002
\ne)\u00a0 \u6b64\u65f6\u4ece\u5e93\u6570\u636e\u73b0\u5728\u5df2\u7ecf\u548c\u4e3b\u5e93\u4e00\u81f4\u3002
\nf)\u00a0 reset master\uff0creset slave
\ng)\u00a0 \u5e94\u7528\u5272\u63a5\u5230\u4ece\u5e93\uff0c\u5c06\u5e94\u7528\u6570\u636e\u5e93IP\u6307\u5411\u4ece\u5e93IP\uff0c\u6d4b\u8bd5\u5e94\u7528\u3002
\n\uff083\uff09\u5c0f\u7ed3\uff1a\u7ecf\u5386\u91cc\u8fd9\u6b21\u6d4b\u8bd5\uff0c\u4e3b\u4ece\u89c1\u7684\u5207\u6362\u5386\u65f66\u520632\u79d2\uff0c\u6bd4\u4e4b\u524d\u7f29\u77ed\u8bb8\u591a\uff0c\u4f46\u662f\u611f\u89c9\u8fd8\u5dee\u70b9\u4ec0\u4e48\uff0c\u4ee5\u540e\u518d\u8865\u5427\u3002<\/p><\/blockquote>\n
1.6 mysql\u534a\u540c\u6b65\u590d\u5236<\/span><\/h2>\n
MySQL\u590d\u5236\u9ed8\u8ba4\u662f\u5f02\u6b65\u590d\u5236\uff0c\u5b58\u5728\u4e00\u5b9a\u7684\u6982\u7387\u5907\u5e93\u4e0e\u4e3b\u5e93\u7684\u6570\u636e\u662f\u4e0d\u5bf9\u7b49\u7684,\u5982\u679cMaster\u5b95\u673a\uff0c\u4e8b\u52a1\u5728Master\u4e0a\u5df2\u63d0\u4ea4\uff0c\u4f46\u5f88\u53ef\u80fd\u8fd9\u4e9b\u4e8b\u52a1\u6ca1\u6709\u4f20\u5230\u4efb\u4f55\u7684Slave\u4e0a\uff0c\u6b64\u65f6Slave\u4e5f\u53ef\u80fd\u4f1a\u4e22\u5931\u4e8b\u52a1\u3002\u5728\u534a\u540c\u6b65\u590d\u5236\u7684\u67b6\u6784\u4e0b\uff0c\u5f53master\u5728\u5c06\u81ea\u5df1binlog\u53d1\u7ed9slave\u4e0a\u7684\u65f6\u5019\uff0c\u8981\u786e\u4fddslave\u5df2\u7ecf\u63a5\u53d7\u5230\u4e86\u8fd9\u4e2a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4ee5\u540e\uff0c\u624d\u4f1a\u8fd4\u56de\u6570\u636e\u7ed9\u5ba2\u6237\u7aef\u3002
\n\u534a\u540c\u6b65\u590d\u5236\u4ecb\u4e8e\u5f02\u6b65\u590d\u5236\u548c\u5168\u540c\u6b65\u590d\u5236\u4e4b\u95f4\uff0c\u4e3b\u5e93\u5728\u6267\u884c\u5b8c\u5ba2\u6237\u7aef\u63d0\u4ea4\u7684\u4e8b\u52a1\u540e\u4e0d\u662f\u7acb\u523b\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\uff0c\u800c\u662f\u7b49\u5f85\u81f3\u5c11\u4e00\u4e2a\u4ece\u5e93\u63a5\u6536\u5230\u5e76\u5199\u5230relay log\u4e2d\u624d\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\u3002\u76f8\u5bf9\u4e8e\u5f02\u6b65\u590d\u5236\uff0c\u534a\u540c\u6b65\u590d\u5236\u63d0\u9ad8\u4e86\u6570\u636e\u7684\u5b89\u5168\u6027\uff0c\u540c\u65f6\u5b83\u4e5f\u9020\u6210\u4e86\u4e00\u5b9a\u7a0b\u5ea6\u7684\u5ef6\u8fdf\uff0c\u8fd9\u4e2a\u5ef6\u8fdf\u6700\u5c11\u662f\u4e00\u4e2aTCP\/IP\u5f80\u8fd4\u7684\u65f6\u95f4\u3002\u6240\u4ee5\uff0c\u534a\u540c\u6b65\u590d\u5236\u6700\u597d\u5728\u4f4e\u5ef6\u65f6\u7684\u7f51\u7edc\u4e2d\u4f7f\u7528\u3002<\/p>\n
\\\"MySQL<\/p>\n
\u534a\u540c\u6b65\u590d\u5236\u7684\u539f\u7406\u56fe<\/p>\n
\u3000\u3000\u57285.6\u4e2d\u52a0\u5165\u4e86group commit\u7279\u6027\u4e4b\u540e\uff0c\u6027\u80fd\u4e0d\u6bd4\u4f20\u7edf\u7684\u5f02\u6b65\u590d\u5236\u5dee\u3002<\/p>\n
1.6.1 \u534a\u540c\u6b65\u590d\u5236\u7684\u6f5c\u5728\u95ee\u9898<\/span><\/h3>\n
\u5ba2\u6237\u7aef\u4e8b\u52a1\u5728\u5b58\u50a8\u5f15\u64ce\u5c42\u63d0\u4ea4\u540e\uff0c\u5728\u5f97\u5230\u4ece\u5e93\u786e\u8ba4\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4e3b\u5e93\u5b95\u673a\u4e86\uff0c\u6b64\u65f6\uff0c\u53ef\u80fd\u7684\u60c5\u51b5\u6709\u4e24\u79cd
\n\u4e8b\u52a1\u8fd8\u6ca1\u53d1\u9001\u5230\u4ece\u5e93\u4e0a<\/strong>
\n\u6b64\u65f6\uff0c\u5ba2\u6237\u7aef\u4f1a\u6536\u5230\u4e8b\u52a1\u63d0\u4ea4\u5931\u8d25\u7684\u4fe1\u606f\uff0c\u5ba2\u6237\u7aef\u4f1a\u91cd\u65b0\u63d0\u4ea4\u8be5\u4e8b\u52a1\u5230\u65b0\u7684\u4e3b\u4e0a\uff0c\u5f53\u5b95\u673a\u7684\u4e3b\u5e93\u91cd\u65b0\u542f\u52a8\u540e\uff0c\u4ee5\u4ece\u5e93\u7684\u8eab\u4efd\u91cd\u65b0\u52a0\u5165\u5230\u8be5\u4e3b\u4ece\u7ed3\u6784\u4e2d\uff0c\u4f1a\u53d1\u73b0\uff0c\u8be5\u4e8b\u52a1\u5728\u4ece\u5e93\u4e2d\u88ab\u63d0\u4ea4\u4e86\u4e24\u6b21\uff0c\u4e00\u6b21\u662f\u4e4b\u524d\u4f5c\u4e3a\u4e3b\u7684\u65f6\u5019\uff0c\u4e00\u6b21\u662f\u88ab\u65b0\u4e3b\u540c\u6b65\u8fc7\u6765\u7684\u3002
\n\u4e8b\u52a1\u5df2\u7ecf\u53d1\u9001\u5230\u4ece\u5e93\u4e0a<\/strong>
\n\u6b64\u65f6\uff0c\u4ece\u5e93\u5df2\u7ecf\u6536\u5230\u5e76\u5e94\u7528\u4e86\u8be5\u4e8b\u52a1\uff0c\u4f46\u662f\u5ba2\u6237\u7aef\u4ecd\u7136\u4f1a\u6536\u5230\u4e8b\u52a1\u63d0\u4ea4\u5931\u8d25\u7684\u4fe1\u606f\uff0c\u91cd\u65b0\u63d0\u4ea4\u8be5\u4e8b\u52a1\u5230\u65b0\u7684\u4e3b\u4e0a\u3002<\/p>\n
1.6.2 \u534a\u540c\u6b65\u67b6\u6784\u642d\u5efa<\/span><\/h3>\n
\u52a0\u8f7d\u4f7f\u7528\u7684\u63d2\u4ef6<\/strong><\/p>\n
\n
\n
\u4e3b\u5e93:\nINSTALL PLUGIN rpl_semi_sync_master SONAME \\'semisync_master.so\\';\n\u4ece\u4ece:\nINSTALL PLUGIN rpl_semi_sync_slave SONAME \\'semisync_slave.so\\';<\/pre>\n<\/div>\n<\/div>\n
\u67e5\u770b\u662f\u5426\u52a0\u8f7d\u6210\u529f<\/strong><\/p>\n
\n
\n
show plugins;<\/pre>\n<\/div>\n<\/div>\n
\u542f\u52a8\u534a\u540c\u6b65\u590d\u5236<\/strong><\/p>\n
\n
\n
\u4e3b\u5e93:\nSET GLOBAL rpl_semi_sync_master_enabled = 1;\n\u4ece\u5e93:\nSET GLOBAL rpl_semi_sync_slave_enabled = 1;<\/pre>\n<\/div>\n<\/div>\n
\u91cd\u542f\u4ece\u5e93\u4e0a\u7684IO<\/strong>\u7ebf\u7a0b<\/strong><\/p>\n
\n
\n
STOP SLAVE IO_THREAD;\nSTART SLAVE IO_THREAD;<\/pre>\n<\/div>\n<\/div>\n
\u67e5\u770b\u662f\u5426\u5728\u8fd0\u884c<\/strong><\/p>\n
\n
\n
\u4e3b\u5e93:\nshow status like \\'Rpl_semi_sync_master_status\\';\n\u4ece\u5e93:\nshow status like \\'Rpl_semi_sync_slave_status\\';<\/pre>\n<\/div>\n<\/div>\n
\u6d4b\u8bd5\u534a\u540c\u6b65\u590d\u5236<\/strong><\/p>\n
\n
\n
\u67e5\u770b\u5ef6\u8fdf\u65f6\u95f4:\nshow variables like \\'%rpl_semi_sync%\\';\n\u4ece\u5e93:\nstop slave;\n\u4e3b\u5e93:\ncreate database clsn;<\/pre>\n<\/div>\n
\u5982\u679c\u521b\u5efa\u5e93\u7684\u65f6\u95f4\u662f\u8bbe\u7f6e\u7684\u65f6\u95f4\u5c31\u6210\u529f\u4e86\u3002\n<\/p><\/div>\n
1.7 \u4e3b\u4ece\u590d\u5236\u67b6\u6784\u7684\u6f14\u53d8<\/span><\/h2>\n
1.7.1 \u57fa\u672c\u7ed3\u6784<\/span><\/h3>\n
\uff081\uff09\u4e00\u4e3b\u4e00\u4ece<\/p>\n
\\\"MySQL<\/p>\n
\uff082\uff09\u4e00\u4e3b\u591a\u4ece<\/p>\n
\\\"MySQL<\/p>\n
\uff083\uff09\u591a\u7ea7\u4e3b\u4ece<\/p>\n
\\\"MySQL<\/p>\n
\uff084\uff09\u53cc\u4e3b<\/p>\n
\\\"MySQL<\/p>\n
\uff085\uff09\u591a\u4e3b\u4e00\u4ece\uff085.7\u4e4b\u540e\u5f00\u59cb\u652f\u6301\uff09<\/p>\n
\u00a0\\\"MySQL<\/p>\n
\uff086\uff09\u5faa\u73af\u590d\u5236
\n\u5bf9\u4e8e\u5faa\u73af\u6570\u636e\u5e93\u955c\u50cf\uff0c\u5c31\u662f\u591a\u4e2a\u6570\u636e\u5e93A\u3001B\u3001C\u3001D\u7b49\uff0c\u5bf9\u5176\u4e2d\u4efb\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u4fee\u6539\uff0c\u90fd\u8981\u540c\u65f6\u955c\u50cf\u5230\u5176\u5b83\u7684\u6570\u636e\u5e93\u91cc\u3002\u00a0\u00a0replicate-same-server-id\u00a0=\u00a00<\/span><\/p>\n
\\\"MySQL<\/p>\n
1.7.2 \u9ad8\u7ea7\u5e94\u7528\u67b6\u6784\u6f14\u53d8<\/span><\/h3>\n
\uff081<\/strong>\uff09\u8bfb\u5199\u5206\u79bb\u2014\u2014MySQL proxy<\/strong>\u3001amoeba<\/strong>\u3001xx-dbproxy<\/strong>\u7b49\u3002<\/strong><\/p>\n
\u00a0\\\"MySQL<\/p>\n
\u3000\u3000\u4e00\u822c\u6765\u8bf4\u90fd\u662f\u901a\u8fc7\u4e3b\u4ece\u590d\u5236\uff08Master-Slave\uff09\u7684\u65b9\u5f0f\u6765\u540c\u6b65\u6570\u636e\uff0c\u518d\u901a\u8fc7\u8bfb\u5199\u5206\u79bb\uff08MySQL-Proxy\uff09\u6765\u63d0\u5347\u6570\u636e\u5e93\u7684\u5e76\u53d1\u8d1f\u8f7d\u80fd\u529b\u8fd9\u6837\u7684\u65b9\u6848\u6765\u8fdb\u884c\u90e8\u7f72\u4e0e\u5b9e\u65bd\u7684\u3002
\n\uff082<\/strong>\uff09\u5206\u5e93\u5206\u8868\u2014\u2014cobar<\/strong>\u3001\u81ea\u4e3b\u7814\u53d1\u7b49\u3002<\/strong><\/p>\n
\\\"MySQL<\/p>\n
\u3000\u30001) \u7cfb\u7edf\u5bf9\u5916\u63d0\u4f9b\u7684\u6570\u636e\u5e93\u540d\u662fdbtest,\u5e76\u4e14\u5176\u4e2d\u6709\u4e24\u5f20\u8868tb1\u548ctb2\u3002
\n2) tb1\u8868\u7684\u6570\u636e\u88ab\u6620\u5c04\u5230\u7269\u7406\u6570\u636e\u5e93dbtest1\u7684tb1\u4e0a\u3002
\n3) tb2\u8868\u7684\u4e00\u90e8\u5206\u6570\u636e\u88ab\u6620\u5c04\u5230\u7269\u7406\u6570\u636e\u5e93dbtest2\u7684tb2\u4e0a\uff0c\u53e6\u5916\u4e00\u90e8\u5206\u6570\u636e\u88ab\u6620\u5c04\u5230\u7269\u7406\u6570\u636e\u5e93dbtest3\u7684tb2\u4e0a\u3002
\n\uff083<\/strong>\uff09MMM<\/strong>\u67b6\u6784\u2014\u2014mysql-mmm<\/strong>\uff08google<\/strong>\uff09-<\/strong>\u4f7f\u7528\u6781\u5c11<\/strong><\/p>\n
\u00a0\\\"MySQL<\/p>\n
\u3000\u3000MMM\uff08Master-Master replication manager for MySQL\uff09\u662f\u4e00\u5957\u652f\u6301\u53cc\u4e3b\u6545\u969c\u5207\u6362\u548c\u53cc\u4e3b\u65e5\u5e38\u7ba1\u7406\u7684\u811a\u672c\u7a0b\u5e8f\u3002MMM\u4f7f\u7528Perl\u8bed\u8a00\u5f00\u53d1\uff0c\u4e3b\u8981\u7528\u6765\u76d1\u63a7\u548c\u7ba1\u7406MySQL Master-Master\uff08\u53cc\u4e3b\uff09\u590d\u5236\uff0c\u53ef\u4ee5\u8bf4\u662fmysql\u4e3b\u4e3b\u590d\u5236\u7ba1\u7406\u5668\u3002
\n\u867d\u7136\u53eb\u505a\u53cc\u4e3b\u590d\u5236\uff0c\u4f46\u662f\u4e1a\u52a1\u4e0a\u540c\u4e00\u65f6\u523b\u53ea\u5141\u8bb8\u5bf9\u4e00\u4e2a\u4e3b\u8fdb\u884c\u5199\u5165\uff0c\u53e6\u4e00\u53f0\u5907\u9009\u4e3b\u4e0a\u63d0\u4f9b\u90e8\u5206\u8bfb\u670d\u52a1\uff0c\u4ee5\u52a0\u901f\u5728\u4e3b\u4e3b\u5207\u6362\u65f6\u523b\u5907\u9009\u4e3b\u7684\u9884\u70ed\uff0c\u53ef\u4ee5\u8bf4MMM\u8fd9\u5957\u811a\u672c\u7a0b\u5e8f\u4e00\u65b9\u9762\u5b9e\u73b0\u4e86\u6545\u969c\u5207\u6362\u7684\u529f\u80fd\uff0c\u53e6\u4e00\u65b9\u9762\u5176\u5185\u90e8\u9644\u52a0\u7684\u5de5\u5177\u811a\u672c\u4e5f\u53ef\u4ee5\u5b9e\u73b0\u591a\u4e2aslave\u7684read\u8d1f\u8f7d\u5747\u8861\u3002
\n\u5173\u4e8emysql\u4e3b\u4e3b\u590d\u5236\u914d\u7f6e\u7684\u76d1\u63a7\u3001\u6545\u969c\u8f6c\u79fb\u548c\u7ba1\u7406\u7684\u4e00\u5957\u53ef\u4f38\u7f29\u7684\u811a\u672c\u5957\u4ef6\uff08\u5728\u4efb\u4f55\u65f6\u5019\u53ea\u6709\u4e00\u4e2a\u8282\u70b9\u53ef\u4ee5\u88ab\u5199\u5165\uff09\uff0c\u8fd9\u4e2a\u5957\u4ef6\u4e5f\u80fd\u5bf9\u5c45\u4e8e\u6807\u51c6\u7684\u4e3b\u4ece\u914d\u7f6e\u7684\u4efb\u610f\u6570\u91cf\u7684\u4ece\u670d\u52a1\u5668\u8fdb\u884c\u8bfb\u8d1f\u8f7d\u5747\u8861\uff0c\u6240\u4ee5\u4f60\u53ef\u4ee5\u7528\u5b83\u6765\u5728\u4e00\u7ec4\u5c45\u4e8e\u590d\u5236\u7684\u670d\u52a1\u5668\u542f\u52a8\u865a\u62dfip\uff0c\u9664\u6b64\u4e4b\u5916\uff0c\u5b83\u8fd8\u6709\u5b9e\u73b0\u6570\u636e\u5907\u4efd\u3001\u8282\u70b9\u4e4b\u95f4\u91cd\u65b0\u540c\u6b65\u529f\u80fd\u7684\u811a\u672c\u3002
\n\u5bf9\u4e8e\u90a3\u4e9b\u5bf9\u6570\u636e\u7684\u4e00\u81f4\u6027\u8981\u6c42\u5f88\u9ad8\u7684\u4e1a\u52a1\uff0c\u975e\u5e38\u4e0d\u5efa\u8bae\u91c7\u7528MMM\u8fd9\u79cd\u9ad8\u53ef\u7528\u67b6\u6784\u3002
\n\uff084<\/strong>\uff09MHA<\/strong>\u67b6\u6784\u2014\u2014mysql-master-ha<\/strong>\uff08\u65e5\u672cDeNa<\/strong>\uff09<\/strong><\/p>\n
\\\"MySQL<\/p>\n
\u3000\u3000MHA\uff08Master High Availability\uff09\u76ee\u524d\u5728MySQL\u9ad8\u53ef\u7528\u65b9\u9762\u662f\u4e00\u4e2a\u76f8\u5bf9\u6210\u719f\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u5b83\u7531\u65e5\u672cDeNA\u516c\u53f8youshimaton\uff08\u73b0\u5c31\u804c\u4e8eFacebook\u516c\u53f8\uff09\u5f00\u53d1\uff0c\u662f\u4e00\u5957\u4f18\u79c0\u7684\u4f5c\u4e3aMySQL\u9ad8\u53ef\u7528\u6027\u73af\u5883\u4e0b\u6545\u969c\u5207\u6362\u548c\u4e3b\u4ece\u63d0\u5347\u7684\u9ad8\u53ef\u7528\u8f6f\u4ef6\u3002\u5728MySQL\u6545\u969c\u5207\u6362\u8fc7\u7a0b\u4e2d\uff0cMHA\u80fd\u505a\u5230\u57280~30\u79d2\u4e4b\u5185\u81ea\u52a8\u5b8c\u6210\u6570\u636e\u5e93\u7684\u6545\u969c\u5207\u6362\u64cd\u4f5c\uff0c\u5e76\u4e14\u5728\u8fdb\u884c\u6545\u969c\u5207\u6362\u7684\u8fc7\u7a0b\u4e2d\uff0cMHA\u80fd\u5728\u6700\u5927\u7a0b\u5ea6\u4e0a\u4fdd\u8bc1\u6570\u636e\u7684\u4e00\u81f4\u6027\uff0c\u4ee5\u8fbe\u5230\u771f\u6b63\u610f\u4e49\u4e0a\u7684\u9ad8\u53ef\u7528\u3002
\n\u8be5\u8f6f\u4ef6\u7531\u4e24\u90e8\u5206\u7ec4\u6210\uff1aMHA Manager\uff08\u7ba1\u7406\u8282\u70b9\uff09\u548cMHA Node\uff08\u6570\u636e\u8282\u70b9\uff09\u3002
\n\uff085<\/strong>\uff09MGR– 5.7\u00a0\u00a0\u00a0\u00a0\u00a0<\/strong>\u65b0\u7279\u6027\u00a0\u00a0\u00a0 MySQL\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0 replication<\/strong><\/p>\n
\u00a0\\\"MySQL<\/p>\n
\u3000\u3000\u57fa\u4e8e\u4f20\u7edf\u5f02\u6b65\u590d\u5236\u548c\u534a\u540c\u6b65\u590d\u5236\u7684\u7f3a\u9677\u2014\u2014\u6570\u636e\u7684\u4e00\u81f4\u6027\u95ee\u9898\u65e0\u6cd5\u4fdd\u8bc1\uff0cMySQL\u5b98\u65b9\u57285.7.17\u7248\u672c\u6b63\u5f0f\u63a8\u51fa\u7ec4\u590d\u5236\uff08MySQL Group Replication\uff0c\u7b80\u79f0MGR\uff09\u3002
\n\u7531\u82e5\u5e72\u4e2a\u8282\u70b9\u5171\u540c\u7ec4\u6210\u4e00\u4e2a\u590d\u5236\u7ec4\uff0c\u4e00\u4e2a\u4e8b\u52a1\u7684\u63d0\u4ea4\uff0c\u5fc5\u987b\u7ecf\u8fc7\u7ec4\u5185\u5927\u591a\u6570\u8282\u70b9\uff08N \/ 2 + 1\uff09\u51b3\u8bae\u5e76\u901a\u8fc7\uff0c\u624d\u80fd\u5f97\u4ee5\u63d0\u4ea4\u3002\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u75313\u4e2a\u8282\u70b9\u7ec4\u6210\u4e00\u4e2a\u590d\u5236\u7ec4\uff0cConsensus\u5c42\u4e3a\u4e00\u81f4\u6027\u534f\u8bae\u5c42\uff0c\u5728\u4e8b\u52a1\u63d0\u4ea4\u8fc7\u7a0b\u4e2d\uff0c\u53d1\u751f\u7ec4\u95f4\u901a\u8baf\uff0c\u75312\u4e2a\u8282\u70b9\u51b3\u8bae(certify)\u901a\u8fc7\u8fd9\u4e2a\u4e8b\u52a1\uff0c\u4e8b\u52a1\u624d\u80fd\u591f\u6700\u7ec8\u5f97\u4ee5\u63d0\u4ea4\u5e76\u54cd\u5e94\u3002
\n\uff086\uff09PXC\u3001MySQL Cluster\u3001galera cluster\u67b6\u6784<\/p>\n
\u00a0\\\"MySQL<\/p>\n
\u5728PXC\u4e2d\uff0c\u4e00\u6b21\u6570\u636e\u5199\u5165\u5728\u5404\u4e2a\u8282\u70b9\u95f4\u7684\u9a8c\u8bc1\/\u56de\u6eda\u6d41\u7a0b<\/p>\n
PXC<\/em><\/strong>\u67b6\u6784\u7684\u4f18\u70b9\uff1a<\/em><\/strong><\/p>\n
a)\u00a0 \u670d\u52a1\u9ad8\u53ef\u7528\uff1b
\nb)\u00a0 \u6570\u636e\u540c\u6b65\u590d\u5236(\u5e76\u53d1\u590d\u5236)\uff0c\u51e0\u4e4e\u65e0\u5ef6\u8fdf\uff1b
\nc)\u00a0 \u591a\u4e2a\u53ef\u540c\u65f6\u8bfb\u5199\u8282\u70b9\uff0c\u53ef\u5b9e\u73b0\u5199\u6269\u5c55\uff0c\u4e0d\u8fc7\u6700\u597d\u4e8b\u5148\u8fdb\u884c\u5206\u5e93\u5206\u8868\uff0c\u8ba9\u5404\u4e2a\u8282\u70b9\u5206\u522b\u5199\u4e0d\u540c\u7684\u8868\u6216\u8005\u5e93\uff0c\u907f\u514d\u8ba9galera\u89e3\u51b3\u6570\u636e\u51b2\u7a81\uff1b
\nd)\u00a0 \u65b0\u8282\u70b9\u53ef\u4ee5\u81ea\u52a8\u90e8\u7f72\uff0c\u90e8\u7f72\u64cd\u4f5c\u7b80\u5355\uff1b
\ne)\u00a0 \u6570\u636e\u4e25\u683c\u4e00\u81f4\u6027\uff0c\u5c24\u5176\u9002\u5408\u7535\u5546\u7c7b\u5e94\u7528\uff1b
\nf)\u00a0 \u5b8c\u5168\u517c\u5bb9MySQL\uff1b<\/p><\/blockquote>\n
1.7.3 \u5206\u5e93\u5206\u8868\u7b80\u5355\u5b9e\u8df5<\/span><\/h3>\n
\u5b9e\u8df5\u4e2d\u4f7f\u7528\u7684\u4e3aworld\u6570\u636e\u5e93\uff0c\u4e3amysql\u5b98\u65b9\u63d0\u4f9b\uff0c\u8be6\u60c5\u53c2\u7167\uff1ahttp:\/\/www.cnblogs.com\/clsn\/p\/8087417.html#_label0<\/i><\/a>
\n\u7b2c\u4e00\u4e2a\u91cc\u7a0b\u7891:\u521b\u5efa\u65b0\u8868<\/strong><\/p>\n
\n
\n
CREATE TABLE `country_1` (\n  `Code` char(3) NOT NULL DEFAULT \\'\\',\n  `Name` char(52) NOT NULL DEFAULT \\'\\',\n  `Continent` enum(\\'Asia\\',\\'Europe\\',\\'North America\\',\\'Africa\\',\\'Oceania\\',\\'Antarctica\\',\\'South America\\') NOT NULL DEFAULT \\'Asia\\',\n  PRIMARY KEY (`Code`),\n  KEY `name_idx` (`Name`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1<\/pre>\n<\/div>\n<\/div>\n
\u7b2c\u4e8c\u4e2a\u91cc\u7a0b\u7891\uff1a\u4ece\u65e7\u8868\u5bfc\u5165\u6570\u636e\u5230\u65b0\u8868<\/strong><\/p>\n
\n
\n
insert into country_1(code,name,continent) select code,name,continent from country;<\/pre>\n<\/div>\n<\/div>\n
\u7b2c\u4e09\u4e2a\u91cc\u7a0b\u7891\uff1a\u6a2a\u5411\u62c6\u8868<\/strong>
\n\u521b\u5efa\u4e0e\u5bfc\u51fa\u8868\u76f8\u540c\u683c\u5f0f\u7684\u65b0\u88681<\/p>\n
\n
\n
create table country_1_p1 like country_1;<\/pre>\n<\/div>\n<\/div>\n
\u5c06\u6570\u636e\u7684\u524d100\u884c\u63d2\u5165\u5230\u65b0\u88681\u4e2d<\/p>\n
\n
\n
insert into country_1_p1 select code,name,continent from country_1 order by code limit 100;<\/pre>\n<\/div>\n<\/div>\n
\u521b\u5efa\u4e0e\u65b0\u88681\u76f8\u540c\u683c\u5f0f\u7684\u65b0\u88682<\/p>\n
\n
\n
create table country_1_p2 like country_1;<\/pre>\n<\/div>\n<\/div>\n
\u5c06100\u884c\u4e4b\u540e\u7684139\u884c\u5bfc\u5165\u88682.<\/p>\n
\n
\n
insert into country_1_p2 select code,name,continent from country_1 order by code limit 139 offset 100;<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
1.1 \u4e3b\u4ece\u590d\u5236\u57fa\u7840\u6982\u5ff5 \u3000\u3000\u3000\u3000\u5728\u4e86\u89e3\u4e3b\u4ece\u590d\u5236\u4e4b\u524d\u5fc5\u987b\u8981\u4e86\u89e3\u7684\u5c31\u662f\u6570\u636e\u5e93\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7(binlog),\u4e3b\u4ece\u590d …<\/p>\n
  MySQL Replication \u4e3b\u4ece\u590d\u5236\u5168\u65b9\u4f4d\u89e3\u51b3\u65b9\u6848<\/span> \u67e5\u770b\u5168\u6587 »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90,88],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"1.1 \u4e3b\u4ece\u590d\u5236\u57fa\u7840\u6982\u5ff5 \u3000\u3000\u3000\u3000\u5728\u4e86\u89e3\u4e3b\u4ece\u590d\u5236\u4e4b\u524d\u5fc5\u987b\u8981\u4e86\u89e3\u7684\u5c31\u662f\u6570\u636e\u5e93\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7(binlog),\u4e3b\u4ece\u590d…","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5434"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5434"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5434\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5434"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}