On Tue, Feb 17, 2009 at 6:26 AM, proteus...@gmail.com <proteus...@gmail.com>wrote:
> > I've been following the discussion about supporting multiple > databases within one project (primarily on a per-app or per-model > basis) with interest and look forward to the feature getting > solidified and implemented into the trunk one day. That doesn't appear > to be a near term event, however, so I was curious what people are > doing to address database scalability issues on a practical basis > currently. > > For example, the Django Auth and Sessions models could absolutely > be deployed onto their own database servers as we do no foreign key > joins to any of those and they have a lot of traffic that I'd like to > not be on my other app db servers. Certain models in my apps warrant > similar divisions and would significantly ease my capacity improvement > efforts if I could just point them to their own db servers. > > Specifically we're running Postgres (and loving it). We know how > to use Slony but it's not real-time enough for most of our > requirements. I'm curious what people in our situation are doing to > relieve the pressure on their database servers. Appreciate any > insights. > > -- Ben Scherrey > > > > > Though there is no public API for multidb there are low level hooks for it and I know many people are just using those, combined with custom managers/queryset subclasses. You can find quite a few blog posts on this strategy. I'd also be remiss if I didn't note the fact that it's my intention to apply for the Google Summer of Code to work on multidb. Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@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 -~----------~----~----~----~------~----~------~--~---