Replication监控及自动故障切换

Replication监控及自动故障切换

首先在相应的机器上增加授权

GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.108' IDENTIFIED BY 'repl';GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.109' IDENTIFIED BY 'repl';GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.110' IDENTIFIED BY 'repl';

report-host=192.168.1.110master-info-repository=TABLErelay-log-info-repository=TABLE

mysqlfailover --master=replm:replm@192.168.1.108 --discover-slaves-login=replm:replm --force

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。