On 10/2/06, Stuart Clarke <[EMAIL PROTECTED]> wrote: > > Thanks for the reply Kevin... > > > > I want to ask some questions, however, about scalability. I'm > > > developing a web system (the pages of which will be customised on a > > > per-user basis), that may grow to be quite popular. I need to > > > implement this, such that it's horizontally scalable in an indefinite > > > manner. > > > > > > OK, so web server replication and load balancing is easy. My problem > > > is with the DB. I can find several good-looking master-slave DB > > > replicators (Slony for PG, for example), but I can't find a suitable > > > load-balancing mechanism, especially one that integrates with > > > SQLObject > > > or SQLAlchemy. > > > > I'm not sure what you mean here. In what way is the ORM involved with > > the database replication? Do you mean from the standpoint of having > > some collection of web servers talk to some specifically collection > > of database servers? > > *** As I see it, there are two problems in using a distributed > master-slave arrangement for the DB: replication (i.e. mirroring data > from the master to the slaves) and load balancing (i.e. balancing the > "DB-read" load across the slaves). > > Replication is handled by tools such as Slony. What I need from the ORM > (or whatever) is a mechanism for load balancing. I need to be able to > say: here's my master server (for writing) and here is my list of slave > servers (for reading). Please balance the system load appropriately, > across these servers. Or I need a hook where I can insert code of my > own to do this. > > I have a sneaking suspicion that it might be possible in SQLAlchemy, but > I don't think it will integrate out of the box with TG's Identity > implementation. > > Plus, I would like to do it in SQLObject, so I can have Catwalk. > > Any suggestions?
Why don't you do load balancing at the DB layer with pgpool or something? -bob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
