DBA实战

告警规则URL地址访问不了

Prometheus架构从入门到实践(10) --告警规则创建

1.prometheus相关配置说明 # cat /root/prometheus-2.25.0.linux-amd64/prometheus.yml # my glob...

負笈在线

524 3 1

DBA实战

Fri Sep 13 22:19:16 2019 - [error][/usr/local/share/perl5/MHA/MasterRotate.pm, ln161] We should not start online master switch when one of connections are running long updates on the current master(mysql2(192.168.75.140:3306)). Currently 2 update thread(s) are running.
Details:
{'Time' => '25371','Command' => 'Binlog Dump GTID','db' => undef,'Id' => '32','Info' => undef,'User' => 'gtid','State' => 'Master has sent all binlog to slave; waiting for more updates','Host' => '192.168.75.136:56555'}
{'Time' => '24674','Command' => 'Binlog Dump GTID','db' => undef,'Id' => '33','Info' => undef,'User' => 'gtid','State' => 'Master has sent all binlog to slave; waiting for more updates','Host' => '192.168.75.128:57452'}
Fri Sep 13 22:19:16 2019 - [error][/usr/local/share/perl5/MHA/ManagerUtil.pm, ln178] Got ERROR: at ./masterha_master_switch line 53
请问这个是什么原因，已经把event关闭了

Mysql之mha手动离线切换和手动在线切换

1.当主挂了，然后手动通过mha进行主从切换 masterha_stop --conf=/etc/mha/mysql_mha.cnf （在mha离线的情况下执行的） mast...

君子愁

1232 2 0