[Pacemaker] Load Balancing & Failover with Pacemaker

[Serge Dubrouski]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110520/a316e4df/attachment.htm>