Re: postgresql scalability, active-active cluster

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: brian stone <skye0507(at)yahoo(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql scalability, active-active cluster
Date: 2007-01-22 20:37:19
Message-ID: 20070122203719.GS26006@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-01-22 20:41:20 Re: Installing Postegres side-by-side with M$ SQL server]]
Previous Message Bruce Momjian 2007-01-22 20:34:02 Re: [ANNOUNCE] == PostgreSQL Weekly News - January