[Pacemaker] Load Balancing & Failover with Pacemaker

Serge Dubrouski sergeyfd at gmail.com
Mon Jun 6 12:43:19 UTC 2011


Such documentation does not exists because such configuration does not
exists. What do you exactly mean b=y "active/active" in this case?


On Sun, Jun 5, 2011 at 11:31 PM, Sachin Gokhale <
sysadmin at indicussoftware.com> wrote:

> 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
> ******************************************************
>
>
> _______________________________________________
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110606/8cb39db8/attachment.htm>


More information about the Pacemaker mailing list