On Fri, Oct 9, 2009 at 4:01 PM, Stefan de Konink <[email protected]> wrote:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA512 > > Atif Ghaffar schreef: > > I agree with you and that is how I understood it. > > > > You have the cherokee-dbslayer_handler and then there is a database. > > I was expecting that the connections from the dbslayer will stay open on > > the dbserver. > > > > but this does not seem to be the case or I have done some mistake in my > > setup. > > > > where to look next? > > should I have had compiled with some different settings? > > What happens: > > - - you send a request to cherokee keepalive or not > - - this query is sent to one of the dbmachines in the loadbalancer > - - the connection between cherokee and the databases are 'persistent' > Stefan, how can I verify it? For example: When write a normal SCGI app and start 5 instances of it and make a few requests to the loadbalancer (Cherokee+SCGI_handler), I see five open connections in mysql process list. I was expecting the same behaviour from the dbslayer but its not doing the same. At the moment we are running 20 instances of SCGI app running as 10 instance on each Cherokkee host. Here the dbuser name is "xcmsbl" I see in mysql user list 20 connections from this user. I am doing the same now with the dbslayer 2 machines running cherokee_dbslayer getting atleast 10 queries per second. Here the dbusername is "dbslayer". I see zero connections from this user. If I keep refreshing madly the processlist, I see from time to time that the dbslayer connected, made the request and disconnected. thanks again for the help. > - - the result returns as normal http request to the client > > > > Stefan > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.11 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEAREKAAYFAkrPQjsACgkQYH1+F2Rqwn0KIACeKjXhYSm9lF2giwFsggh/JQ/Z > Z3oAoINK1km+e4k3waO1sjWmh17ewyIw > =evlu > -----END PGP SIGNATURE----- > -- best regards Atif Ghaffar
_______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
