mysql-proxy-discuss team mailing list archive

[nick loeve <trickie@xxxxxxxxx>]

Hi again

On Mon, Jan 19, 2009 at 4:54 PM, nick loeve <trickie@xxxxxxxxx> wrote:
>
> So, my question:
>
> Does mysqlproxy require a backend connection from the connection pool
> for every query coming in the front-end or can it also handle a
> 'backlog'? My lua script to do the query funneling is currently
> returning 'Lost connection to MySQL server during query' errors to the
> client if I have more clients connected and sending queries than I
> have back-end connections open.


This might also be useful:

For every client lost connection error, mysqlproxy reports:

(critical) proxy-plugin.c.1087: I have no server backend, closing connection
(critical) network-mysqld.c.1181: plugin_call(CON_STATE_READ_QUERY) failed

Yet i do not define a read_query_result in my lua script (and so I do
not play with backends/connections/proxy.* return status etc), which
leads me to ask if you need a connection available in the pool for a
back-end for every query coming in the front-end.


Cheers
-- 
Nick Loeve