Monitoring Open Source databases with BIG-IP
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