Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Jeff Davis
On Sun, 2007-01-21 at 06:55 -0800, brian stone wrote: Are there any built in tools or 3rd party tools for distributing a postgresql database? I need an active active configuration; master- master with fail over. The project I am working needs to support a very large number of transactions a

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread brian stone
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,

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Alvaro Herrera
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

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Jeff Davis
On Mon, 2007-01-22 at 17:37 -0300, Alvaro Herrera wrote: 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

[GENERAL] postgresql scalability, active-active cluster

2007-01-21 Thread brian stone
Are there any built in tools or 3rd party tools for distributing a postgresql database? I need an active active configuration; master-master with fail over. The project I am working needs to support a very large number of transactions a second. It will eventually require a main frame, or some

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-21 Thread Jim C. Nasby
On Sun, Jan 21, 2007 at 06:55:56AM -0800, brian stone wrote: Are there any built in tools or 3rd party tools for distributing a postgresql database? I need an active active configuration; master-master with fail over. The project I am working needs to support a very large number of