DBA實(shí)戰(zhàn)

告警規(guī)則URL地址訪問不了

Prometheus架構(gòu)從入門到實(shí)踐(10) --告警規(guī)則創(chuàng)建

1.prometheus相關(guān)配置說明 # cat /root/prometheus-2.25.0.linux-amd64/prometheus.yml # my glob...

負(fù)笈在線

521 3 1

DBA實(shí)戰(zhàn)

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
請(qǐng)問這個(gè)是什么原因，已經(jīng)把event關(guān)閉了

Mysql之mha手動(dòng)離線切換和手動(dòng)在線切換

1.當(dāng)主掛了海渊，然后手動(dòng)通過mha進(jìn)行主從切換 masterha_stop --conf=/etc/mha/mysql_mha.cnf （在mha離線的情況下執(zhí)行的） mast...

君子愁

1232 2 0