For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Monitoring Open Source databases with BIG-IP

One of the nice features that was added in the 10.1 release of our BIG-IP software was the addition of native monitors for both PostgreSQL and MySQL. These new monitors allow you to more accurately mo...
Published May 25, 2010
Version 1.0
management
monitoring
us
Haluk_Yildirim_'s avatar
Haluk_Yildirim_
Icon for Nimbostratus rankNimbostratus
Mar 14, 2017

Hello:

 

I am trying to configure more intelligent Galera monitoring. This is a typical output from the query I am after.

 

MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_status'; SHOW GLOBAL STATUS LIKE 'wsrep_ready'; +----------------------+---------+ | Variable_name | Value | +----------------------+---------+ | wsrep_cluster_status | Primary | +----------------------+---------+

 

I did play with the receive column and row but we are getting weird results (F5 takes a member down when it is not down). In the thomas Jefferson example, Is row 3 where ID is 3 or is the 3rd in the resultset? I am assuming headers of the columns are not taken into account.

 

In my monitor that I was testing with, receive column was two and receive column was one.

 

I read that we can debug these but requires newer code.

 

Thanks in advance

 

Luke