当前位置：网站首页>Replication监控及自动故障切换

Replication监控及自动故障切换

2022-08-08 11:07:00 【51CTO】

Replication监控及自动故障切换_mysql

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

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';

 

Replication监控及自动故障切换_ide_02

 

Replication监控及自动故障切换_ide_03

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

 

Replication监控及自动故障切换_mysql_04

mysqlfailover --master=replm:[email protected] --discover-slaves-login=replm:replm --force

Replication监控及自动故障切换_mysql_05



原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://blog.51cto.com/u_13753753/5554575

边栏推荐

猜你喜欢

随机推荐