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 avoidable by 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
Failover and failback (if that makes sense for a multimaster solution...)
Synchronize after downtime
Once a client is connected it stays connected to that server (possibly
Thanks a lot in advance
They need to support Adsense over SSL
pgsql-novice by date
|Next:||From: Pushpendra Singh Thakur||Date: 2009-12-23 14:31:38|
|Subject: Re: PostgreSQL cluster solution|
|Previous:||From: Damian Carey||Date: 2009-12-22 11:41:10|
|Subject: Re: SQL Syntax for ordering a sequence|