Re: [GENERAL] PostgreSQL clustering with DRBD

On Tue, Mar 3, 2009 at 3:57 AM, Tim Uckun wrote: > >> >> >> Again, this is a lot of work to avoid master / slave with failover. >> Are you sure it's really needed for your situation? >> > > What is the most straightforward and simple way to achieve master slave with > failover? We use Slony at wo

Re: [GENERAL] PostgreSQL clustering with DRBD

> > > Again, this is a lot of work to avoid master / slave with failover. > Are you sure it's really needed for your situation? > > What is the most straightforward and simple way to achieve master slave with failover? Preferably a solution that would have decent monitoring, alerting and failback

Re: [GENERAL] PostgreSQL clustering with DRBD

On Mon, Feb 23, 2009 at 2:27 AM, Serge Fonville wrote: > Thanks all for the responses, >> >> We're very happy with pgpool-II for load-balancing and multi-master >> >> usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to >> >> avoid a SPOF, e.g. with heartbeat). > > I could not de

Re: [GENERAL] PostgreSQL clustering with DRBD

> > I think I start to have an idea about what the best suitable solution is > for my situation. > I was hoping there would be some sort of patch for the PostgreSQL download > instead of an entire rebuild of the sources. > > I'll post any updates I find. > Hey Serge. Any update on this? I can't

Re: [GENERAL] PostgreSQL clustering with DRBD

Thanks all for the responses, We're very happy with pgpool-II for load-balancing and multi-master usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to avoid a SPOF, e.g. with heartbeat). I could not determine whether pgpool-II is suitable for what I want. It does not seem to

Re: [GENERAL] PostgreSQL clustering with DRBD

> > We're very happy with pgpool-II for load-balancing and multi-master > usage of PostgreSQL (keep in mind to enable HA for pgpool-II itself to > avoid a SPOF, e.g. with heartbeat). > > Thanks. I am going to see which one has better documentation and try that one first.

Re: [GENERAL] PostgreSQL clustering with DRBD

Hello, the pgfoundry project seems to be the initial start of cybercluster offered by CyberTec from Austria (German page: http://www.postgresql-support.de/pr_cybercluster.html). As far as I know this is a modified/adapted pgcluster solution. We're very happy with pgpool-II for load-balancing and

Re: [GENERAL] PostgreSQL clustering with DRBD

On Wed, Feb 11, 2009 at 11:24 PM, Serge Fonville wrote: > Hi, > I am in the process of setting up a two node cluster. > Can PostgreSQL use DRBD as its storage? > Since the in-memory database would be synchronized with the on-disk > database. > If this would be done with every query, this would gre

Re: [GENERAL] PostgreSQL clustering with DRBD

> > Serge Fonville wrote: > >> So, DRBD dual primary and Cybercluster multimaster, cannot be combined? >> > > If you have questions on Cybercluster, you should perhaps ask there for > details. For normal PostgreSQL, using DRBD dual primary is not possible. > You are right, thanks > My e

Re: [GENERAL] PostgreSQL clustering with DRBD

Serge Fonville wrote: So, DRBD dual primary and Cybercluster multimaster, cannot be combined? If you have questions on Cybercluster, you should perhaps ask there for details. For normal PostgreSQL, using DRBD dual primary is not possible. My endgoal is a two node cluster with load

Re: [GENERAL] PostgreSQL clustering with DRBD

Hi, Thanks a lot for the reply > Since the cluster will be multi-master/dual-primary, do I need to have a >> separate block device for each PostgreSQL instance or can it use the DRBD >> device? >> > > I don't understand how you want to have a multimaster PostgreSQL setup with > DRBD. DRBD can

Re: [GENERAL] PostgreSQL clustering with DRBD

Serge Fonville wrote: Can PostgreSQL use DRBD as its storage? Yes, many deployments use this. Since the in-memory database would be synchronized with the on-disk database. If this would be done with every query, this would greatly impact performance. Performance with DRBD is usually accept