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
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