[Pacemaker] Load Balancing & Failover with Pacemaker

[Sachin Gokhale]

Where I get active/active setup document for postgres? I searched on
clusterlabs site...but didn't get any help.

sachin

On Fri, 20 May 2011 08:12:09 -0600
Serge Dubrouski <sergeyfd at gmail.com> wrote:

> On Fri, May 20, 2011 at 7:56 AM, Daniel Bozeman <
> daniel.bozeman at americanroamer.com> wrote:
> 
> > Sachin,
> >
> > Check out pgpool-II (http://pgpool.projects.postgresql.org/). Using
> > pgpool, you can use postgres 9.0 streaming replication to set up a master
> > server and a hot-standby which can accept read-only queries. pgpool will
> > automatically send read-only transactions to the hot-standby, while writes
> > will be sent to the master database and replicated to the standby using
> > postgres streaming replication. Pgpool will also manage failover and online
> > recovery of your postgres instances. You can then use Pacemaker to make
> > pgpool and a virtual IP pointing to it highly available.
> >
> > That being said, implementing a reliable active/passive cluster with
> > Pacemaker is not trivial. I am currently using LSB to manage pgpool, but I
> > plan to write my own OCF resource or test/modify the one provided with the
> > older pgpool-ha project.
> >
> 
> Depends on what you call  active/passive. Active/Passive can be easily
> implemented with DRBD replication and there is at least 2 HOW-TO documents
> on clusterlabs web site. Streaming replication is more like Active/Active
> and this one isn't trivial at all. And not because of Pacemaker but because
> of the way how Streaming replication is implemented in PostgreSQL. If it was
> close to Oracle DataGuard for example it would be much easier.
> 
> 
> > Take care,
> >
> > Daniel
> >
> > On May 20, 2011, at 7:37 AM, Serge Dubrouski wrote:
> >
> >
> >
> > On Thu, May 19, 2011 at 11:07 PM, Sachin Gokhale <
> > sysadmin at indicussoftware.com> wrote:
> >
> >> Hello,
> >>
> >> I have two nodes active/passive cluster created using documentation from
> >> clusterlabs. Replication is working fine on my setup. I am using this
> >> for Postgresql database.
> >>
> >> But, I am getting how I configure or test Faileover scenario & how can I
> >> add load balancing feature for my Postgres database.
> >>
> >
> > Do you need read only load balancing or read/write? First one is possible
> > with PGSQL hot-standby databases, second one isn't possible in PGSQL AFAIK.
> >
> >
> >>
> >> Looking for your kine help.
> >> Thanks in advance.
> >>
> >> Regards,
> >>
> >> Sachin
> >> ******************************************************
> >> Sachin  N. Gokhale
> >> System Administrator
> >> <sysadmin at indicussoftware.com>
> >> Indicus Software Pvt. Ltd.
> >> 28' Varshanand Society.
> >> Sinhgad Road Pune - 411038
> >> Tel. No. -  91-20-24341287/88
> >> Fax No. - 91-20-24341289
> >> ******************************************************
> >>
> >>
> >> _______________________________________________
> >> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> >> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >>
> >> Project Home: http://www.clusterlabs.org
> >> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> >> Bugs:
> >> http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
> >>
> >
> >
> >
> > --
> > Serge Dubrouski.
> > _______________________________________________
> > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >
> > Project Home: http://www.clusterlabs.org
> > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > Bugs:
> > http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
> >
> >
> >
> >
> >
> > _______________________________________________
> > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >
> > Project Home: http://www.clusterlabs.org
> > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > Bugs:
> > http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
> >
> >
> 
> 
> -- 
> Serge Dubrouski.

******************************************************
Sachin  N. Gokhale 
System Administrator
<sysadmin at indicussoftware.com>
Indicus Software Pvt. Ltd.
28' Varshanand Society.
Sinhgad Road Pune - 411038
Tel. No. -  91-20-24341287/88
Fax No. - 91-20-24341289
******************************************************