[Pgcluster-general] recommendations needed

[David Koski]

Thank you for the clarification.

David

On Wednesday 24 January 2007 04:46, a.mitani at sra-europe.com wrote:
> 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
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general