\n
![\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/08\/20250810033752-6898141054601.png\")
<\/p>\n\u5982\u679c\u662f\u8ba1\u5212\u6027\u505c\u5e93，\u5efa\u8bae\u4e8b\u5148\u505a\u4ee5\u4e0b\u64cd\u4f5c：<\/p>\n
1.1 \u6682\u505c\u4ece\u5e93\u590d\u5236<\/p>\n
STOP SLAVE;<\/p>\n
1.2 \u8bb0\u5f55\u4e3b\u5e93\u7684\u5f53\u524d\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4f4d\u70b9<\/p>\n
SHOW MASTER STATUS;<\/p>\n
1.3 \u4ece\u5e93\u8bb0\u5f55\u5f53\u524d\u7684\u590d\u5236\u72b6\u6001（\u53ef\u9009\u5907\u4efd）<\/p>\n
SHOW SLAVE STATUS\\\\G;<\/p>\n
\u4e3b\u4ece\u90fd\u505c\u4e86\u4e4b\u540e\u7684 \u91cd\u542f\u987a\u5e8f\u63a8\u8350\u5982\u4e0b：<\/p>\n
2.1 \u5148\u542f\u52a8\u4e3b\u5e93（Master）<\/p>\n
systemctl start mysqld
\n# \u6216
\nservice mysqld start<\/p>\n
\u67e5\u770b\u542f\u52a8\u72b6\u6001:<\/p>\n
sudo systemctl status mysqld<\/p>\n
\u786e\u4fdd\u4e3b\u5e93\u542f\u52a8\u540e：<\/p>\n
\u767b\u5f55 MySQL \u68c0\u67e5\u662f\u5426\u6b63\u5e38\u8fd0\u884c：<\/p>\n
mysql -u root -p<\/p>\n
\u67e5\u770b\u4e3b\u5e93\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u72b6\u6001：<\/p>\n
SHOW MASTER STATUS;<\/p>\n
2.2 \u518d\u542f\u52a8\u4ece\u5e93（Slave）<\/p>\n
systemctl start mysqld<\/p>\n
\u542f\u52a8\u540e，\u767b\u5f55\u4ece\u5e93 MySQL，\u786e\u8ba4\u590d\u5236\u914d\u7f6e\u662f\u5426\u8fd8\u5728：<\/p>\n
SHOW SLAVE STATUS\\\\G;<\/p>\n
\u5982\u679c Slave_IO_Running \u548c Slave_SQL_Running \u90fd\u4e3a No，\u6267\u884c：<\/p>\n
START SLAVE;<\/p>\n
\u518d\u68c0\u67e5\u72b6\u6001：<\/p>\n
SHOW SLAVE STATUS\\\\G;<\/p>\n
\u786e\u8ba4\u4ee5\u4e0b\u51e0\u4e2a\u5b57\u6bb5\u503c：<\/p>\n
Slave_IO_Running: Yes
\nSlave_SQL_Running: Yes
\nSeconds_Behind_Master: 0 \u6216\u8f83\u5c0f<\/p>\n
mysql> SHOW SLAVE STATUS\\\\G<\/p>\n
\u7ed3\u679c\u663e\u793a:<\/p>\n
Slave_IO_Running: Yes
\n Slave_SQL_Running: No<\/p>\n
\u8fd9\u8bf4\u660e\u4ece\u5e93\u5df2\u7ecf\u6210\u529f\u8fde\u63a5\u4e3b\u5e93（IO \u7ebf\u7a0b\u6b63\u5e38），\u4f46 SQL \u7ebf\u7a0b\u672a\u8fd0\u884c，\u8fd9\u901a\u5e38\u662f\u56e0\u4e3a\u590d\u5236\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u4e86 SQL \u6267\u884c\u9519\u8bef（\u4f8b\u5982\u4e3b\u5e93\u7684 DML \u5728\u4ece\u5e93\u65e0\u6cd5\u6267\u884c）\u3002<\/p>\n
2.1 \u5206\u6790\u9519\u8bef\u539f\u56e0
\nSHOW SLAVE STATUS\\\\G \u8f93\u51fa\u7ed3\u679c\u4e2d\u7684\u4e3b\u8981\u5b57\u6bb5\u542b\u4e49\u8bf4\u660e\u5982\u4e0b:<\/p>\n
\u5b57\u6bb5\u540d\u8bf4\u660e
\nMaster_Host \u4e3b\u5e93 IP \u6216\u4e3b\u673a\u540d
\nMaster_User \u7528\u4e8e\u590d\u5236\u7684\u7528\u6237\u540d
\nMaster_Port \u4e3b\u5e93\u7aef\u53e3\u53f7（\u9ed8\u8ba4 3306）
\nMaster_Log_File \u5f53\u524d\u6b63\u5728\u8bfb\u53d6\u7684 binlog \u6587\u4ef6\u540d
\nRead_Master_Log_Pos binlog \u6587\u4ef6\u7684\u8bfb\u53d6\u4f4d\u7f6e
\nRelay_Master_Log_FileSQL \u7ebf\u7a0b\u6b63\u5728\u6267\u884c\u7684\u4e3b\u5e93 binlog \u6587\u4ef6
\nExec_Master_Log_Pos SQL \u7ebf\u7a0b\u6267\u884c\u5230\u7684\u4f4d\u7f6e
\nMaster_UUID \u4e3b\u5e93\u7684 UUID
\nAuto_Position \u662f\u5426\u542f\u7528 GTID \u590d\u5236（1 \u8868\u793a\u5f00\u542f）
\nMaster_SSL_Allowed \u662f\u5426\u542f\u7528 SSL
\nMaster_Server_Id \u4e3b\u5e93 server_id
\nLast_SQL_Error \u663e\u793a SQL \u7ebf\u7a0b\u4e3a\u4ec0\u4e48\u505c\u6b62（\u6700\u5173\u952e）
\nLast_SQL_Errno \u663e\u793a\u9519\u8bef\u4ee3\u7801
\nRelay_Log_File \u9519\u8bef\u53d1\u751f\u7684\u4f4d\u7f6e
\n Relay_Log_Pos \u9519\u8bef\u53d1\u751f\u7684\u4f4d\u7f6e
\nSeconds_Behind_Master \u5ef6\u8fdf\u60c5\u51b5<\/p>\n
\u672c\u4f8b\u4e2d,Last_SQL_Error\u5b57\u6bb5\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b:<\/p>\n
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master\u2019s binary log is corrupted (you can check this by running\u2019mysqlbinlog\u2019 on the binary log), the slave\u2019s relay log is corrupted (you can check this by running \u2018mysqlbinlog\u2019 on the relay log), a network problem, or a bug in the master\u2019s or slave\u2019sMySQL code. If you want to check the master\u2019s binary log or slave\u2019s relay log, you will be able to know their names by issuing \u2018SHOW SLAVE STATUS\u2019 on this slave.<\/p>\n
2.2 \u5904\u7406\u8fc7\u7a0b
\n\u6b65\u9aa4 1：\u505c\u6b62\u590d\u5236\u7ebf\u7a0b<\/p>\n
mysql> STOP SLAVE;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\u6b65\u9aa4 2：\u91cd\u8bbe relay log（\u5173\u952e\u6b65\u9aa4）<\/p>\n
mysql> RESET SLAVE;
\nQuery OK, 0 rows affected (0.35 sec)<\/p>\n
\u8fd9\u4e2a\u547d\u4ee4\u4f1a\u6e05\u9664 relay log \u548c \u590d\u5236\u914d\u7f6e\u4fe1\u606f（\u5982\u4e3b\u5e93 IP\u3001\u8d26\u53f7\u7b49）
\n\u6240\u4ee5\u4f60\u9700\u8981\u91cd\u65b0\u914d\u7f6e CHANGE MASTER TO<\/p>\n
\u6b65\u9aa4 3：\u67e5\u770b\u662f\u5426\u542f\u7528\u4e86GTID
\n\u53ef\u80fd\u7ed3\u679c1:<\/p>\n
mysql> SHOW VARIABLES LIKE 'gtid_mode';
\n+—————+——-+
\n| Variable_name | Value |
\n+—————+——-+
\n| gtid_mode | OFF |
\n+—————+——-+
\n1 row in set (0.00 sec)<\/p>\n
\u5f53Value\u503c\u4e3a OFF \u65f6,\u8bf4\u660e\u672a\u542f\u7528 GTID\u3002<\/p>\n
\u53ef\u80fd\u7ed3\u679c2:<\/p>\n
mysql> SHOW VARIABLES LIKE 'gtid_mode';
\n+—————+——-+
\n| Variable_name | Value |
\n+—————+——-+
\n| gtid_mode | ON |
\n+—————+——-+
\n1 row in set (0.00 sec)<\/p>\n
\u5f53Value\u503c\u4e3a ON \u65f6,\u8bf4\u660e\u542f\u7528\u4e86 GTID\u3002
\n\u5f53\u542f\u7528\u4e86 GTID（\u5373 gtid_mode = ON \u4e14 MASTER_AUTO_POSITION = 1），MySQL \u4e0d\u518d\u4f7f\u7528 binlog \u6587\u4ef6\u548c\u4f4d\u7f6e\u6765\u63a7\u5236\u590d\u5236，\u800c\u662f\u4f7f\u7528 GTID \u6765\u81ea\u52a8\u5b9a\u4f4d\u4e8b\u52a1\u540c\u6b65\u70b9\u3002<\/p>\n
\u8865\u5145:\u56db\u79cd\u6a21\u5f0f\u7684\u4f7f\u7528\u573a\u666f\u5bf9\u6bd4
\n<\/p>\n
\u6b65\u9aa4 4：\u91cd\u65b0\u914d\u7f6e\u590d\u5236（\u5728\u4ece\u5e93\u6267\u884c）
\n\u82e5\u672a\u542f\u7528GTID,\u914d\u7f6e\u5982\u4e0b:<\/p>\n
CHANGE MASTER TO
\n MASTER_HOST='192.128.10.91',
\n MASTER_USER='user1',
\n MASTER_PASSWORD='Pasd1',
\n MASTER_LOG_FILE='mysql-bin.000001',
\n MASTER_LOG_POS=12345;<\/p>\n
\u5176\u4e2dMASTER_LOG_FILE\u548cMASTER_LOG_POS\u7684\u503c\u53ef\u901a\u8fc7\u5728\u4e3b\u5e93\u6267\u884c\u5982\u4e0b\u547d\u4ee4\u83b7\u5f97:
\nmysql> SHOW MASTER STATUS;<\/p>\n
\u82e5\u542f\u7528\u4e86GTID,\u914d\u7f6e\u5982\u4e0b:<\/p>\n
mysql> CHANGE MASTER TO
\n -> MASTER_HOST='192.128.10.91',
\n -> MASTER_USER='user1',
\n -> MASTER_PASSWORD='Pasd1',
\n -> MASTER_AUTO_POSITION=1;<\/p>\n
\u6b65\u9aa4 5：\u91cd\u65b0\u542f\u52a8\u590d\u5236\u7ebf\u7a0b<\/p>\n
mysql> START SLAVE;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\u6b65\u9aa4 6：\u786e\u8ba4\u590d\u5236\u662f\u5426\u6062\u590d<\/p>\n
mysql> SHOW SLAVE STATUS\\\\G<\/p>\n
\u5e94\u8be5\u770b\u5230：<\/p>\n
Slave_IO_Running: Yes
\nSlave_SQL_Running: Yes
\nLast_SQL_Error: <\u7a7a>
\nSeconds_Behind_Master: 0 — \u6216\u4e00\u4e2a\u5408\u7406\u7684\u5ef6\u8fdf<\/p>\n
\u8865:\u5982\u679c\u6b64\u65f6\u4f9d\u7136\u6709\u7c7b\u4f3c\u5982\u4e0b\u9519\u8bef
\nLast_IO_Error: error connecting to master \u2018user1@192.128.10.91:3306\u2019 – retry-time: 60 retries: 1
\n\u53ef\u80fd\u662f\u56e0\u4e3auser1\u7684\u5bc6\u7801\u5e76\u975ePasd1,\u6b64\u65f6\u5728\u786e\u5b9a\u53ef\u4ee5\u4fee\u6539user1\u5bc6\u7801(\u65e0\u5176\u4ed6\u91cd\u8981\u7a0b\u5f0f\u4f7f\u7528\u8be5\u7528\u6237)\u7684\u60c5\u51b5\u4e0b,\u53ef\u5c06\u5bc6\u7801\u4fee\u6539\u4e3aPasd1 \u3002<\/p>\n
\u518d\u6b21\u6267\u884cSHOW SLAVE STATUS\\\\G\u67e5\u770b,\u7ed3\u679c\u5e94\u5982\u4e0b:<\/p>\n
Slave_IO_Running: Yes
\nSlave_SQL_Running: Yes<\/p>\n
mysql> SHOW SLAVE STATUS\\\\G<\/p>\n
\u7ed3\u679c\u663e\u793a:<\/p>\n
Slave_IO_Running: No
\n Slave_SQL_Running: No<\/p>\n
\u8bf4\u660e\u590d\u5236\u7ebf\u7a0b\u672a\u542f\u52a8\u3002<\/p>\n
\u6b65\u9aa4 1：\u542f\u52a8\u590d\u5236\u7ebf\u7a0b<\/p>\n
START SLAVE;<\/p>\n
\u6b65\u9aa4 2：\u518d\u6b21\u67e5\u770b\u590d\u5236\u72b6\u6001，\u786e\u8ba4\u662f\u5426\u6210\u529f<\/p>\n
SHOW SLAVE STATUS\\\\G<\/p>\n
\u5e94\u770b\u5230:<\/p>\n
Slave_IO_Running: Yes
\nSlave_SQL_Running: Yes
\nSeconds_Behind_Master: 0 — \u6216\u4e00\u4e2a\u5408\u7406\u7684\u5ef6\u8fdf<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb851\u6b21\uff0c\u70b9\u8d5e10\u6b21\uff0c\u6536\u85cf12\u6b21\u3002\u5f53\u542f\u7528\u4e86 GTID\uff08\u5373 gtid_mode = ON \u4e14 MASTER_AUTO_POSITION = 1\uff09\uff0cMySQL \u4e0d\u518d\u4f7f\u7528 binlog \u6587\u4ef6\u548c\u4f4d\u7f6e\u6765\u63a7\u5236\u590d\u5236\uff0c\u800c\u662f\u4f7f\u7528 GTID \u6765\u81ea\u52a8\u5b9a\u4f4d\u4e8b\u52a1\u540c\u6b65\u70b9\u3002\u8fd9\u8bf4\u660e\u4ece\u5e93\u5df2\u7ecf\u6210\u529f\u8fde\u63a5\u4e3b\u5e93\uff08IO \u7ebf\u7a0b\u6b63\u5e38\uff09\uff0c\u4f46 SQL \u7ebf\u7a0b\u672a\u8fd0\u884c\uff0c\u8fd9\u901a\u5e38\u662f\u56e0\u4e3a\u590d\u5236\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u4e86 SQL \u6267\u884c\u9519\u8bef\uff08\u4f8b\u5982\u4e3b\u5e93\u7684 DML \u5728\u4ece\u5e93\u65e0\u6cd5\u6267\u884c\uff09\u3002\u53ef\u80fd\u662f\u56e0\u4e3auser1\u7684\u5bc6\u7801\u5e76\u975ePasd1,\u6b64\u65f6\u5728\u786e\u5b9a\u53ef\u4ee5\u4fee\u6539user1\u5bc6\u7801(\u65e0\u5176\u4ed6\u91cd\u8981\u7a0b\u5f0f\u4f7f\u7528\u8be5\u7528\u6237)\u7684\u60c5\u51b5\u4e0b,\u53ef\u5c06\u5bc6\u7801\u4fee\u6539\u4e3aPasd1\u3002_mysql\u91cd\u542fslave<\/p>\n","protected":false},"author":2,"featured_media":50653,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,100,44],"topic":[],"class_list":["post-50654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-100","tag-44"],"yoast_head":"\n