sqlobject-discuss

OK, so SQLObject is really cool, because it removes icky SQL details
from application programming, and implements a nice object-relational
mapping system.
BUT, how well does it scale? I'm looking to use SQLObject (as part of
TurboGears) to run a high-volume website that's customised on a per-user
basis. Whatever solution I do end up implementing, I need to know that
each part of the system can be distributed across multiple machines.
And that includes the DB.
I need to be able to use a master-slave replicated DB with my site, and
have read requests load-balanced across the slaves.
SQLObject supports connection pools to a single server. My question is
this: does SQLObject support pooling connections to multiple servers?
And does it support separate connections for read and write? If not,
how could one typically implement the above-mentioned horizontal scaling
with SQLObject and a popular free RDBMS (PG, MySQL)?
Thanks,
Stuart
--
Stuart Clarke <sjclarke@...>

Stuart Clarke a =E9crit :
> OK, so SQLObject is really cool, because it removes icky SQL details
> from application programming, and implements a nice object-relational
> mapping system.
>
> BUT, how well does it scale? I'm looking to use SQLObject (as part of
> TurboGears) to run a high-volume website that's customised on a per-use=
r
> basis. Whatever solution I do end up implementing, I need to know that
> each part of the system can be distributed across multiple machines.
> And that includes the DB.
>
> I need to be able to use a master-slave replicated DB with my site, and
> have read requests load-balanced across the slaves.
>
> SQLObject supports connection pools to a single server. My question is
> this: does SQLObject support pooling connections to multiple servers?
> And does it support separate connections for read and write? If not,
> how could one typically implement the above-mentioned horizontal scalin=
g
> with SQLObject and a popular free RDBMS (PG, MySQL)?
>
> Thanks,
>
> Stuart
>
> =20
Have you looked at mysql cluster?
Make mysql cluster node on every node, with each of your web server
instances pointing to the local sql cluster node (all read/write)
In theory, it should works out of the box... (not tested but will use it
for my future HA cluster)
Don't know if there is an equivalent for postgres

On Mon, Oct 02, 2006 at 03:43:38PM +1000, Stuart Clarke wrote:
> OK, so SQLObject is really cool, because it removes icky SQL details
> from application programming, and implements a nice object-relational
> mapping system.
On the other hand it presents its own problems and limitations. ;)
> SQLObject supports connection pools to a single server. My question is
> this: does SQLObject support pooling connections to multiple servers?
It doesn't.
> And does it support separate connections for read and write?
It doesn't.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.

Community

Help

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

I agree to receive quotes, newsletters and other information from sourceforge.net and its partners regarding IT services and products. I understand that I can withdraw my consent at any time. Please refer to our Privacy Policy or Contact Us for more details