Re: [sqlalchemy] Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-15 Thread JonathanQ
Thanks Michael - I think I am starting to see where we have gone wrong with our session handling. Looks like calling remove() on the session at the end of a unit of work is probably the best approach. Here is a bit more detail on what these applications are doing - and perhaps you can commen

Re: [sqlalchemy] Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread Michael Bayer
On Nov 14, 2012, at 2:38 PM, JonathanQ wrote: > We have some code running against MySQL running in Amazon RDS. During an > outage or the maintenance window - Amazon issues an automatic failover of our > RDS instance. However our code doesn't failover with it. > > We are having issues with 2

[sqlalchemy] Problems handling an Amazon RDS Multi-AZ failover with SqlSoup and SqlAlchemy 0.7.8

2012-11-14 Thread JonathanQ
We have some code running against MySQL running in Amazon RDS. During an outage or the maintenance window - Amazon issues an automatic failover of our RDS instance. However our code doesn't failover with it. We are having issues with 2 of our applications (2 different issues): First one: Unab