[Pgcluster-general] recommendations needed

[a.mitani at sra-europe.com]

Hi,

If there are only two servers in your system, there is no need to use the
Load balancer.
I recommend that run Cluster DB and replication server in each server.
And please set the "When_Stand_Alone" tag to "read_write" in each
cluster.conf.
Even if one server was down, a system can provide service continuously by
this server composition and configuration.

Regards,
------------------
At.Mitani



> 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
>