Voltar
-
Título
MySQL_InnoDBCluster alarm email notification does not include agent name or hostname -
Descrição
MySQL_InnoDBCluster alarm email notification does not include the agent name or the hostname.
Subject: null: InnoDB Cluster Health: FatalFMS server SERVERNAME reports: InnoDB Cluster MMDevVACluster is currently offline because it cannot tolerate the number of offline members. This cluster currently has 0.00 of 3 members online.: InnoDB Cluster Health -
Causa
On a distributed cluster it is likely to be on multiple hosts and monitored by multiple agents. There are other alarms like the server availability alarm that contain this information, this is specifically for the cluster being able to operate with less than the full number of nodes available. -
Resolução
WORKAROUND
Import the attached innodb_cluster_health.xml file into the Foglight Management Server which includes an update to the rule
The file can be imported on the Foglight Management Server using the fglcmd command similar to the following, where "foglight" represents the user and password of the Foglight administrator, $FGLHOME is the Foglight Management Server folder, and
$FGLHOME/bin/fglcmd.{.sh or .bat} -usr foglight -pwd foglight -cmd util:configimport -f $FGLHOME/innodb_cluster_health.xmlSTATUS
Enhancement ID FOGMYSQL-131 has been created to add the non-online members to the alarm message of the InnoDB Cluster Health rule. This was included in the 6.0.1 release of the MySQL cartridge.
-
ID do defeito
FOGMYSQL-131 -
Anexos