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/