Thanks for the replies. I'll have to take a while to digest the
comments and suggestions to see how I'm going to proceed.
I'm sort of in an initial trial mode working a few hours here and
there to get an idea if using sqlalchemy is feasible. I'm expecting
it will be and I'll probably just
On Jun 6, 12:34 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Jun 6, 2008, at 2:29 PM, qhfgva wrote:
We have (what I think of as) a moderately complicated database
configuration and I'm hoping there will be a way to configure
sqlalchemy to deal with it. The basic scenario is like
u're talking about full replication...
what's the possiblity of local-readonly DB to have different (older)
data than that of the master? and how this should be tackled?
theoreticaly from what i get of the multi-sessions/engine approach,
then your two sessions (one writeable:master, one
On Jun 9, 2008, at 2:22 PM, qhfgva wrote:
Thanks I'll take a look. I left out what I think is an important part
of this scenario (or maybe it's trivial - I don't have a good
perspective on this yet). In any case, I would like to use the ORM
component of sqlalchemy and completely hide
we're also assuming that you've exhausted these approaches (which
would be a lot more appropriate for this sort of thing):
http://forge.mysql.com/wiki/MySQL_Proxy
http://dev.mysql.com/doc/refman/5.0/en/replication.html
On Jun 9, 2008, at 2:22 PM, qhfgva wrote:
On Jun 6, 12:34 pm,
Michael Bayer wrote:
Thanks I'll take a look. I left out what I think is an
important part of this scenario (or maybe it's trivial - I don't
have a good perspective on this yet). In any case, I would like
to use the ORM component of sqlalchemy and completely hide the
fact that the read/
On Jun 9, 2008, at 4:57 PM, Jonathan LaCour wrote:
Michael Bayer wrote:
Thanks I'll take a look. I left out what I think is an
important part of this scenario (or maybe it's trivial - I don't
have a good perspective on this yet). In any case, I would like
to use the ORM component of
On Jun 6, 2008, at 2:29 PM, qhfgva wrote:
We have (what I think of as) a moderately complicated database
configuration and I'm hoping there will be a way to configure
sqlalchemy to deal with it. The basic scenario is like this:
There are N mysql servers in different geographical regions