Shulou(Shulou.com)06/01 Report--

1. Environment description

MHA

MariaDB 10.1

2. Error message

The error message of MHA management is as follows:

Tail-f / var/log/masterha/manager.log

CRITICAL: VIP 192.168.1.100 not found on Master!

Mon Sep 10 10:08:01 2018-[error] [/ usr/local/share/perl5/MHA/MasterMonitor.pm, ln226] Failed to get master_ip_failover_script status with return code 1:0.

Mon Sep 10 10:08:01 2018-[error] [/ usr/local/share/perl5/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. At / usr/local/bin/masterha_manager line 50

Mon Sep 10 10:08:01 2018-[error] [/ usr/local/share/perl5/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.

Mon Sep 10 10:08:01 2018-[info] Got exit code 1 (Not master dead).

3. Treatment method

Check the interface of the network card, confirm VIP, and execute the following command.

Ip addr add 192.168.56.105/32 dev eth2

4. Check the log again

Tail-f / var/log/masterha/manager.log

Part of it is slightly.

Mon Sep 10 10:16:05 2018-[info] Slaves settings check done.

Mon Sep 10 10:16:05 2018-[info]

Master (192.168.56.101) (current master)

+-- slave1 (192.168.56.102)

+-- slave2 (192.168.56.103 purl 3306)

Mon Sep 10 10:16:05 2018-[info] Checking master_ip_failover_script status:

Mon Sep 10 10:16:05 2018-[info] / usr/local/bin/master_ip_failover-command=status-ssh_user=root-orig_master_host=master-orig_master_ip=192.168.56.101-orig_master_port=3306

Inet 192.168.56.105/32 scope global eth2

INFO: VIP 192.168.1.100 found on Master

Mon Sep 10 10:16:05 2018-[info] OK.

Mon Sep 10 10:16:05 2018-[warning] shutdown_script is not defined.

Mon Sep 10 10:16:05 2018-[info] Set master ping interval 1 seconds.

Mon Sep 10 10:16:05 2018-[warning] secondary_check_script is not defined. It is highly recommended setting it to check master reachability from two or more routes.

Mon Sep 10 10:16:05 2018-[info] Starting ping health check on master (192.168.56.101 Starting ping health check on master 3306)

Mon Sep 10 10:16:05 2018-[info] Ping (CONNECT) succeeded, waiting until MySQL doesn't respond..

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.