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? Thanks, Stuart --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
