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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings