Bug #76319 MySQL Fabric Service - Monitoring from external monitoring software
Submitted: 13 Mar 2015 19:36 Modified: 16 Mar 2015 20:32
Reporter: SASTRY Vedantam Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Fabric Severity:S4 (Feature request)
Version:1.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: Monitoring

[13 Mar 2015 19:36] SASTRY Vedantam
Description:
To setup any monitoring software to monitor MySQL Fabric service and looking to find if there is some way to know if the mysqlfabric is activated or not?
 
The command ‘mysqlfabric group health’ returns the exact same output if the fabric is activated or deactivate. It would be helpful to monitor if the fabric is accidentally deactivated and thus fails to automatically failover.

[root@h-mysql-fabric-store ~]# mysqlfabric group deactivate mygroup1
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1
 
                                uuid finished success result
------------------------------------ -------- ------- ------
14558b15-df9b-4e7d-ad8e-b092cae5c78c        1       1      1
 
state success          when                                                   description
----- ------- ------------- -------------------------------------------------------------
    3       2   1.42542e+09 Triggered by <mysql.fabric.events.Event object at 0x1f571d0>.
    4       2   1.42542e+09                         Executing action (_deactivate_group).
    5       2   1.42542e+09                          Executed action (_deactivate_group).
 
[root@h-mysql-fabric-store ~]# mysqlfabric group health mygroup1
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1
 
                                uuid is_alive    status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------- ---------
18659f0d-b92b-11e4-bfa4-0050568e1c77        1 SECONDARY              0                 0              0               0    False     False
3bbeb3ea-b93b-11e4-800e-0050568e132f        1   PRIMARY              0                 0              0               0    False     False
ab581aff-b92f-11e4-bfc2-0050568e476f        1 SECONDARY              0                 0              0               0    False     False
 
issue
 
 
[root@h-mysql-fabric-store ~]# mysqlfabric group activate mygroup1
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1
 
                                uuid finished success result
------------------------------------ -------- ------- ------
58ccb406-2957-4f3d-a9df-242c6a55c601        1       1      1
 
state success          when                                                   description
----- ------- ------------- -------------------------------------------------------------
    3       2   1.42542e+09 Triggered by <mysql.fabric.events.Event object at 0x1f570d0>.
    4       2   1.42542e+09                           Executing action (_activate_group).
    5       2   1.42542e+09                            Executed action (_activate_group).
 
 
[root@h-mysql-fabric-store ~]# mysqlfabric group health mygroup1
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1
 
                                uuid is_alive    status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------- ---------
18659f0d-b92b-11e4-bfa4-0050568e1c77        1 SECONDARY              0                 0              0               0    False     False
3bbeb3ea-b93b-11e4-800e-0050568e132f        1   PRIMARY              0                 0              0               0    False     False
ab581aff-b92f-11e4-bfc2-0050568e476f        1 SECONDARY              0                 0              0               0    False     False

How to repeat:
This is a feature request for monitoring the fabric service from external monitoring software
[16 Mar 2015 20:32] Mats Kindahl
Hi Venkata,

Thank you for a very reasonable request. Verified as described. 

For monitoring, it might be valuable to have the output in specific formats, so any information on what format is suitable? Is the current format OK, or is some other format better?
[6 Jul 2017 19:19] Bugs System
Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)