[Pgcluster-general] standalone postmaster

[At.Mitani]

Hi Ryan,

I recommend to use the read_write mode in the single master/(multi) slave structure.

When you want to use multi master structure as your mail,
I recommend to set read_only mode.
Since, it is impossible to merge each server's own data.
In order to sync data, the master DB is required.

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

On Fri, 4 Apr 2008 09:40:15 +0700
"Ryan Fabella" <ryanthe at gmail.com> wrote:

> Thank you for fast reply,
> 
> if let say i just have 1 replication server is down, then i need to
> copy data directory ?
> 
> if i have scenario
> computer A has replication+ cluster +LB
> computer B has replication+ cluster +LB
> computer C only cluster
> 
> A and C in the same subnet and same network infrastructure.
> while B is on other site. there is case B is lost connection with A and C
> i want to ask is it possible to set cluster on A to read_write and
> cluster B to read_write
> and also cluster C
> then how to sync between all ?
> 
> thank you
> 
> 
> Best regards,
> 
> Ryan Fabella
> 
> 
> 
> On Fri, Apr 4, 2008 at 9:02 AM, At.Mitani <mitani at sraw.co.jp> wrote:
> > > 1. if my replicator is down, is it possible i just copy data directory
> >  > from cluster then preparing new replicator ?
> >
> >  Does the replicator mean replication server?
> >  If so, there is not need to copy data directory to new replication server.
> >  When you prepared two replication servers, second replication server takes over automatically if master replication server failed down.
> >
> >  If you means Cluster DB.
> >  When you re-start the cluster DB with -R option,
> >  it sync db data directory from master Cluster DB automatically.
> >
> >
> >  >
> >  > 2. is there any trial on 5 cluster. is it running well as 3 cluster ?
> >
> >  I tested with more than 5 cluster DBs.
> >  However, performance point of view, the suitable number of cluster db is depend on the hardware/network and variety of query types.
> >
> >  When you want to provide db service even during recovery/add a cluster db, three or more cluster dbs are required (and one or more load balancer) in your system.
> >  But this is a different story from performance.
> >
> >
> >  Regards,
> >  --
> >  At.Mitani <mitani at sraw.co.jp>
> >
> >
> > _______________________________________________
> >  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


-- 
At.Mitani <mitani at sraw.co.jp>