Thread: PostgreSQL cluster solution

For a while now I am looking for a suitable cluster solution.

I want a multi-master solution since that would best spread the write load.

I looked into pgpool, pgcluster, cybercluster
They all seem very suiotable.

I had a strong preference towards pgpool until I read in the docs that
serial values aren't equal unless table-loking is enabled.
> Replicating a table with SERIAL data type, the SERIAL column value may differ between the backends. This problem is
avoidableby locking the table explicitly (although, 
> transactions' parallelism will be lost). To achieve this, however, the following change must be made:

Does anyone here have a good idea which would be best?

What I want
Mutli master
Failover and failback (if that makes sense for a multimaster solution...)
Synchronize after downtime
Load-balancing
Once a client is connected it stays connected to that server (possibly
through LVS)

Thanks a lot in advance

Regards,

Serge Fonville


--
http://www.sergefonville.nl

Convince Google!!
They need to support Adsense over SSL
https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en

There is no single solution for your requirement. I am also looking for the same since last 3 years. Recently I got a mail from Continuent Tungsten Enterprise, they said they have the solution. This is their link http://www.continuent.com/solutions/overview/tungsten-for-postgresql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> I want a multi-master solution since that would
> best spread the write load.
...
> What I want

> Mutli master

Might also look at Bucardo

> Failover and failback (if that makes sense for a multimaster solution...)

No, not really. :(

> Synchronize after downtime

Everything should do that.

> Load-balancing
> Once a client is connected it stays connected to that server (possibly
> through LVS)

That's generally handled by something else.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200912231301
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAksyWw8ACgkQvJuQZxSWSsheYQCgyxG5U/xzFzzUmaNVAEF5hb7q
fp4AoP6YSfACBCdVQziw9MKKfJGTLTvj
=BeBe
-----END PGP SIGNATURE-----