How can add a simple monitor to proxy status and check last proxy errors ?
Posted by:
Mario Toro
Date: October 15, 2008 11:29PM
Hello,
I have a monitor server (hobbitd) reading status from Admin Proxys Ports.
Exist any way where we can pass last errors to Admin Proxy ?
By example in proxy log this error :
network-mysqld-proxy.c.2927: I have no server backend, closing connection
network-mysqld.c.1121: plugin_call(CON_STATE_READ_QUERY) failed
May be , If Admin Proxy can show last 3 proxy errors in one query, example :
select * from proxy_config; /* Or select * from proxy_errors */
+----------------------------+----------------------------------------------------------------------+
| option | value |
+----------------------------+----------------------------------------------------------------------+
| admin.address | 10.0.0.12:4065 |
| proxy.address | 10.0.0.12:4064 |
| proxy.lua_script | mysql-proxy/share/mysql-proxy/pools.lua |
| proxy.backend_addresses[0] | 127.0.0.1:3306 |
| proxy.fix_bug_25371 | 1 |
| proxy.profiling | 1 |
| proxy.lasterror1 | network-mysqld-proxy.c.2927: I have no server backend, closing connection |
| proxy.lasterror2 | network-mysqld.c.1121: plugin_call(CON_STATE_READ_QUERY) failed |
| proxy.lasterror3 | |
+----------------------------+----------------------------------------------------------------------+
( /* Or select * from proxy_errors */ )
With that info we can notify to monitor server with a alarm.
Any another idea about how can monitor server status and proxy errors ?
Thanks in advance
Mario
Subject
Views
Written By
Posted
How can add a simple monitor to proxy status and check last proxy errors ?
4451
October 15, 2008 11:29PM
2536
January 01, 2009 05:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.