Greetings. I am about 75% through creating a django application as a
new section of my company's site, www.etsy.com. It's basically a CMS,
something that I know django is especially well suited to (tho I can
tell it would work for nearly any domain).
Recently, my site ops team started asking me questions about
reliability with the database and such. After asking around in the irc
channel and doing some google searches, and even trying to browse
through the source a bit, I still have some questions:
1) Is there some way to tell django to talk to two different databases
(sort of a fail-over system), eg, behaviour matching the pseudo-code:
#where django makes a connection
attempts = 0
try:
con = Connection(server1)
except DBConnectionError:
attempts += 1
if attempts >= some_max:
con = Connection(server2)
That is the behaviour they were looking for, and they said there were
reasons that they prefer not to do it at the configuration level, eg
with pgpool.
Is there some way to activate this functionality? As far as I can
tell, the answer is "no"; in that case, can you suggest how I might go
about adding it myself? Where in the django source I would have to
tinker to get this behaviour?
2) Site ops might be able to handle database fail-over at the network
configuration level, but I need to know whether the django orm, when
using postgress, keeps a pool of persistent connections. If so, and if
the connections fail or are disconnected, will it automatically
attempt to reconnect them upon future requests?
Again, I don't mind writing the code myself to handle this if it is
not already handled. If I must write it myself, can you point me in
the direction of where I would handle this. Is monkeypatching a class
or method considered superior to editing the source locally? Coming
from a Ruby background, that would be my natural response.
Thanks so much for taking the time to read this. My thanks in advance
for your responses.
- Jay
ps On an unrelated and less important note, I need to add full-text
indexed search to my application, and I am required to support
postgresql. Any advice regarding that would also be appreciated.
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
