[Pgcluster-general] recommendations needed

[Diego Gutierrez]

Hi David.

I think you have to address 2 different problems here:
1. How to avoid losing the database state if a server goes down
2. How to keep the application active if the database it's connected to goes 
down

For the first problem, you could both use pgcluster or a native postgresql WAL 
active/passive schema (try browsing the postgresql docs regarding WAL 
recovery, and http://www.linux-ha.org for the automatic failover 
configuration).

As for the second issue, I don't know anything about your application, but 
there's probably some kind of connection pooling technology that you can 
apply there.

Cheers,

DiegoG

On Friday 19 January 2007 02:57, David Koski wrote:
> I need a master-master solution for postgresql and I am not
> sure pgcluster is the right choice.  The application is for
> mission critical server that is required to keep a network of
> wireless access points on line. I have recently installed a
> backup server for failover. When the primary server goes down
> the backup takes over. But it is necessary that the two servers
> have their databases synchronized. I am considering the following
> solution: Server1 (the primary server) will have a Cluster DB
> and Load Balancer. Server2 (the backup failover server) will
> have a Cluster DB and the Replicator. In case Server1 fails,
> server2 will have the current database state. To bring server1 on
> line after failure, the database of server2 will be exported and
> imported to server1. The problem is if server1 goes down then
> server will not be able to function because the Load Balancer
> will be down. And no matter what server the Load Balancer is on,
> the system will fail if it goes down. What is needed is redundance
> not just of the Cluster DB but of the access mechanism---in this
> case the Load Balancer.
>
> Your input is appreciated.
>
> Regards,
> David Koski
> david at kosmosisland.com
>
>
>
>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general