Re: mysql proxy - every other query

[Mark Smith]

I'm getting the exact same issue. The proxy is being run the same way: configuring the backend as the master and the read-only backend as the slave, then sending queries.

I'm seeing the same pattern: 10 queries work, then it starts failing on every other query.

I did some investigation, and the problem happens when it uses a pooled connection. The first 10 queries go through okay because it is spawning new connections to the backends (it goes up to 5 idle per backend), then the 11th query tries to re-use an idle backend and it fails.

This is easily reproduced as above. I'm using 0.6.1 as downloaded from the web site on this past Wednesday.

I'm attempting to use this in production as a proof of concept for Mozilla's Bugzilla-EU installation. We have a slave database in Amsterdam that would be great to send read traffic to for serving up a local Bugzilla instance.

Thanks for your help.