[sqlalchemy] Re: Replicating a transaction

2007-03-20 Thread sdobrev
On Tuesday 20 March 2007 07:47:53 Benno Rice wrote: Hi, I'm wondering if it would be possible to have a situation where transactions coming in from the ORM system could be sent to multiple database servers at once. If I were to look into adding this, where would be the best place to

[sqlalchemy] Re: Replicating a transaction

2007-03-20 Thread Michael Bayer
SessionTransaction will start transactions across any number of databases, as different engines come into its querying scope. when SessionTranasction commits, it commits all underlying transacitons. so if you want to start all transactions at once, you can create a new

[sqlalchemy] Re: Replicating a transaction

2007-03-20 Thread Michael Bayer
On Mar 20, 2007, at 11:52 AM, Michael Bayer wrote: however, this is not using two phase commit, which means that if one commit fails, all previous commit's stay committed. if you want true two phase commit I'd look into Zalchemy which has this feature. actually i should correct myself -