On Jun 16, 2007, at 11:13 AM, Perrin Harkins wrote:

300 is nothing for MySQL.  You should be able to handle a few thousand
on a machine with enough RAM.

agreed. MySQL connections are cheap. Postgres ones consume RAM and kernel resources, and more than 50 sucks on a box.

If you already have a frontend proxy, you shouldn't have a lot of idle
servers holding db connections.  Assuming that your application uses
the database on every mod_perl request, only processes that are
actually sleeping will not be using their connection.

you can also look for db proxies/pools

i use/used pgpool , because i only use pg

i tested out sqlrelay a while back on mysql, and it seemed great

http://sqlrelay.sourceforge.net/

Reply via email to