On Thu, Aug 19, 2010 at 05:40:21AM +0200, Adrian von Bidder wrote:
> On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> > This way we can be sure that either all the databases are in synch, or
> > that we need to rollback the program patch/update.
>
> I guess this might be more a hack than a solution: do the updates in batches
> and use 2pc: first connect to batches of databases, but instead of commit,
> you "prepare to commit". Prepared commits like this are persistent accross
> connections, so you can come back later and commit or rollback.
Rather than being a hack, 2PC sounds like it's needed for correctness;
how do you handle the case of only some databases receiving the COMMIT
command otherwise?
--
Sam http://samason.me.uk/