\n
mysql failover\u65e0\u6cd5\u8bc6\u522bslave\u670d\u52a1\u5668<\/h3>\n
\u6211\u7684\u5b9e\u9a8c\u73af\u5883\u4e3a\u4e00\u53f0\u4e3b\u670d\u52a1\u5668\u4e24\u53f0\u4ece\u670d\u52a1\u5668\uff0c\u4ece\u670d\u52a1\u5668\u53ef\u4ee5\u6b63\u5e38\u4ece\u4e3b\u670d\u52a1\u5668\u4e0a\u540c\u6b65\u6570\u636e\uff0c\u4f46\u662f\u6211\u5728\u914d\u7f6efailover\u529f\u80fd\u4e4b\u540e\uff0cfailover\u53ea\u80fd\u8bc6\u522b\u5230\u4e3b\uff0c\u65e0\u6cd5\u8bc6\u522b\u5230slave\u3002\u542f\u52a8\u4fe1\u606f\u5982\u4e0b\uff0c\u770b\u4e0d\u51fa\u539f\u56e0\u3002<\/p>\r\n\r\n
\u6211\u5df2\u7ecf\u786e\u8ba4\u8fc7\u5df2\u4e0b\u51e0\u70b9
\r\n\u6240\u6709\u670d\u52a1\u5668\u4e0a\u7684iptables\u9632\u706b\u5899\u5df2\u7ecf\u5173\u95ed\u00a0
\r\n\u6240\u6709master\u4ee5\u53caslave\u4e0a\u5747\u5df2\u521b\u5efa\u8d26\u6237\u5e76\u6388\u6743failover\u6240\u5728ip\u8fde\u63a5\uff0c\u5982\u4e0b\u6240\u793a , \u00a0 failover\u7684\u9519\u8bef\u65e5\u5fd7\u5728\u54ea\u770b\u4e5f\u4e0d\u77e5\u9053\u3002<\/p>\r\n\r\n
mysql> show grants for replm@192.168.77.4\\G;
\r\n*************************** 1. row ***************************
\r\nGrants for replm@192.168.77.4: GRANT SELECT, INSERT, CREATE, DROP, RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'replm'@'192.168.77.4' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION<\/p>\r\n\r\n
\u00a0<\/p>\r\n\r\n
\u00a0<\/p>\r\n\r\n
\u00a0<\/p>\r\n\r\n
# Discovering slaves for master at 192.168.77.1:3306
\r\nError connecting to a slave as replm@192.168.77.4: Cannot connect to the slave server.
\r\nError Host '192.168.77.4' is not allowed to connect to this MySQL server
\r\nError connecting to a slave as replm@192.168.77.4: Cannot connect to the slave server.
\r\nError Host '192.168.77.4' is not allowed to connect to this MySQL server<\/p><\/p>\n <\/div>\n