MySQL Forums
Forum List  »  Router & Proxy

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

Options: ReplyQuote


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


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.