Re: postgresql scalability, active-active cluster

brian stone wrote:
> I never considered MySQL because I really DO need transactions.  MySQL
> also lacks many enterprise features we need; well they say they have
> them but from my testing they are a bit under-cooked.
>
> I need atomic actions across an N number of application servers.  The
> goal here is scalability, which is why I brought up clustering.
> Unfortunately, we really do need those transactions :(

Maybe two-phase commit can help you here?  (see the COMMIT PREPARED
docs)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.