Jacob Kaplan-Moss wrote:
I just today ran across sqlrelay (http://sqlrelay.sourceforge.net/)
which looks *extremely* promising for this type of use. Does anyone
have any experience with it, and is there any interest in me writing
a sqlrelay backend?
We did :-). We tried to squeze it between PHP and Oracle. PHP was
written in MySQL-style, opening DB connection whenever it felt it might
require some tiny chunk of data. And this bit us hard when we gained a
bit more users and learned that opening connection in Oracle is not
exactly cheap operation...
Some sad history aside, we tried SQLRelay following recomendation from
Oracle's OSDN forums but it didn't work out very well. Under havy load
it sometimes just SEGFAULTed without any explanation in logs (oh, those
verbose logs where single event that happend to use several physical
connection was spread across several files with helpful names like
2684). We considered it to be not acceptable for a production server.
To be honest, may be those problems were related to PHP or Oracle's part
of SQLRelay, and won't affect other environments, and it was like a year
ago, so may be it was fixed since... But now for me it doesn't look very
promising.
- Re: Limiting database connections? Maniac
-
