Dear Graham, Thanks for the quick answer! Basicly, I would like to handle this problem from the app, so I can't modify the underlying architecture. Your suggestion needs some changes in the apache configuration, I guess. The only thing I have access to is the source of the webapp. Thanks, anyway, and if you have hints for the single instance solution too, please share.
Thanks, Daniel On Feb 13, 12:42 pm, Graham Dumpleton <graham.dumple...@gmail.com> wrote: > On Feb 13, 7:43 am, PDani <pekdan...@gmail.com> wrote: > > > > > Hi! > > > I would like to set up some database servers in Django 1.2, and then > > use them in this way: when a new request comes, i choose a server > > manually, and then use this ONLY ONE server in that request. I don't > > want to pass around parameters, which server i chosen, so somehow, i > > would like to make the chosen server the "default" server for that > > request. > > Here's an example: > > - somebody gets a page > > - based on who is the person, and what page, i decide which db server > > should i use > > - i select it (how?) > > - then every query will be routed to this server without having to use > > explicitly using(), and friends, until the end of that concrete > > request > > Any idea how should I do this? > > How many databases do you have? > > If it is a small number, then you could be a bit tricky with Apache/ > mod_wsgi and create multiple daemon process groups where the Django > configuration for the database changed based on the name of the > process group a request was handled in. You could then use cookies and/ > or in conjunction with session information, to dynamically control to > which daemon process group mod_wsgi delegated the request. > > In other words, rather than try and switch a single instance to > different databases on the fly, you have one instance per database and > control to which the request actually gets passed to. > > A can explain more later if that would at all be practical. > > Graham -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.