Gavin Wahl <gwahl@fusionbox.com> writes:
> Hello,
>
> I've read the documentation for two-phase commit and it sounds interesting, but
> I'm having trouble thinking of how to actually put it into production. How are
> people using it? Do you use a XA transaction manager or something custom built?
> How dos the reconciliation work when a component crashes between PREPARE and
> COMMIT? Is anyone using it in the open-source world where transaction managers
> are unheard of?
>
> Looking forward to hearing about how two-phase commit has helped you.
I use it for holding an advisory lock the duration of any of our several
environment mangling frameworks.
We have fairly complex 1-touch provisioning, decom,
upgrade... rename/relocate/snapshot frameworks.
The lock is used to enforce cooperatively that no one else launches any
of those systems concurrently due to some interesting potential
conflicts.
>
> Thanks
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800