Hi again On Mon, Jan 19, 2009 at 4:54 PM, nick loeve <[email protected]> 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 _______________________________________________ Mailing list: https://launchpad.net/~mysql-proxy-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~mysql-proxy-discuss More help : https://help.launchpad.net/ListHelp
