Mailing List Archive: Linux-HA: Users

Question about pacemaker + heartbeat + postgres in active/passive configuration

Index | Next | Previous | View Threaded

riffee42 at gmail

Aug 15, 2012, 5:25 AM

Post #1 of 6 (435 views)
Permalink

Question about pacemaker + heartbeat + postgres in active/passive configuration

Hello everyone,

Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.

The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync. Does anyone know of a recipe or tutorial that goes through what his presentation shows?

Kind regards,
-Renee

_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

andrew at beekhof

Aug 15, 2012, 4:40 PM

Post #2 of 6 (419 views)
Permalink

Re: Question about pacemaker + heartbeat + postgres in active/passive configuration [In reply to]

On Wed, Aug 15, 2012 at 10:25 PM, Renee Riffee <riffee42 [at] gmail> wrote:
> Hello everyone,
>
> Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.
>
> The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync.

Assuming pacemaker was built with heartbeat support, simply install
heartbeat and add:

crm respawn

to ha.cf

Start heartbeat, job done.
Resource configuration is unchanged from what you see in Clusters from Scratch

> Does anyone know of a recipe or tutorial that goes through what his presentation shows?
>
> Kind regards,
> -Renee
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

md2610 at att

Aug 15, 2012, 4:54 PM

Post #3 of 6 (418 views)
Permalink

Re: Question about pacemaker + heartbeat + postgres in active/passive configuration [In reply to]

Hi, Andrew. Where can I find the presentation by Keisuke? Btw, I use heartbeat in combo with pacemaker also...but with MySQL...was just a decision based on an impression at the time that most of the documentation content was about heartbeat...and that heartbeat had a more stability. And it seemed that there was nothing negative being posted that would deter me about the choice. After being on this distribution list for a while, I now think it's time for me to move to Corosync.

- Mike

-----Original Message-----
From: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] On Behalf Of Andrew Beekhof
Sent: Wednesday, August 15, 2012 7:40 PM
To: General Linux-HA mailing list
Subject: Re: [Linux-HA] Question about pacemaker + heartbeat + postgres in active/passive configuration

On Wed, Aug 15, 2012 at 10:25 PM, Renee Riffee <riffee42 [at] gmail> wrote:
> Hello everyone,
>
> Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.
>
> The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync.

Assuming pacemaker was built with heartbeat support, simply install
heartbeat and add:

crm respawn

to ha.cf

Start heartbeat, job done.
Resource configuration is unchanged from what you see in Clusters from Scratch

> Does anyone know of a recipe or tutorial that goes through what his presentation shows?
>
> Kind regards,
> -Renee
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

andrew at beekhof

Aug 15, 2012, 8:09 PM

Post #4 of 6 (421 views)
Permalink

Re: Question about pacemaker + heartbeat + postgres in active/passive configuration [In reply to]

On Thu, Aug 16, 2012 at 9:54 AM, DENNY, MICHAEL <md2610 [at] att> wrote:
> Hi, Andrew. Where can I find the presentation by Keisuke?

No idea sorry. Renee seems to know though, maybe he can help.

> Btw, I use heartbeat in combo with pacemaker also...but with MySQL...was just a decision based on an impression at the time that most of the documentation content was about heartbeat...and that heartbeat had a more stability. And it seemed that there was nothing negative being posted that would deter me about the choice. After being on this distribution list for a while, I now think it's time for me to move to Corosync.
>
> - Mike
>
> -----Original Message-----
> From: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] On Behalf Of Andrew Beekhof
> Sent: Wednesday, August 15, 2012 7:40 PM
> To: General Linux-HA mailing list
> Subject: Re: [Linux-HA] Question about pacemaker + heartbeat + postgres in active/passive configuration
>
> On Wed, Aug 15, 2012 at 10:25 PM, Renee Riffee <riffee42 [at] gmail> wrote:
>> Hello everyone,
>>
>> Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.
>>
>> The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync.
>
> Assuming pacemaker was built with heartbeat support, simply install
> heartbeat and add:
>
> crm respawn
>
> to ha.cf
>
> Start heartbeat, job done.
> Resource configuration is unchanged from what you see in Clusters from Scratch
>
>> Does anyone know of a recipe or tutorial that goes through what his presentation shows?
>>
>> Kind regards,
>> -Renee
>>
>>
>> _______________________________________________
>> Linux-HA mailing list
>> Linux-HA [at] lists
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

riffee42 at gmail

Aug 15, 2012, 8:49 PM

Post #5 of 6 (417 views)
Permalink

Re: Question about pacemaker + heartbeat + postgres in active/passive configuration [In reply to]

His presentation is here:
http://www.slideshare.net/ksk_ha/linuxconfauhaminiconfpgsql9120120116

Click on the "Save File" button in the bar...

On Aug 15, 2012, at 4:54 PM, DENNY, MICHAEL wrote:

> Hi, Andrew. Where can I find the presentation by Keisuke? Btw, I use heartbeat in combo with pacemaker also...but with MySQL...was just a decision based on an impression at the time that most of the documentation content was about heartbeat...and that heartbeat had a more stability. And it seemed that there was nothing negative being posted that would deter me about the choice. After being on this distribution list for a while, I now think it's time for me to move to Corosync.
>
> - Mike
>
> -----Original Message-----
> From: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] On Behalf Of Andrew Beekhof
> Sent: Wednesday, August 15, 2012 7:40 PM
> To: General Linux-HA mailing list
> Subject: Re: [Linux-HA] Question about pacemaker + heartbeat + postgres in active/passive configuration
>
> On Wed, Aug 15, 2012 at 10:25 PM, Renee Riffee <riffee42 [at] gmail> wrote:
>> Hello everyone,
>>
>> Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.
>>
>> The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync.
>
> Assuming pacemaker was built with heartbeat support, simply install
> heartbeat and add:
>
> crm respawn
>
> to ha.cf
>
> Start heartbeat, job done.
> Resource configuration is unchanged from what you see in Clusters from Scratch
>
>> Does anyone know of a recipe or tutorial that goes through what his presentation shows?
>>
>> Kind regards,
>> -Renee
>>
>>
>> _______________________________________________
>> Linux-HA mailing list
>> Linux-HA [at] lists
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems

_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

keisuke.mori+ha at gmail

Aug 19, 2012, 10:58 PM

Post #6 of 6 (389 views)
Permalink

Re: Question about pacemaker + heartbeat + postgres in active/passive configuration [In reply to]

Hi,

2012/8/16 Renee Riffee <riffee42 [at] gmail>:
> His presentation is here:
> http://www.slideshare.net/ksk_ha/linuxconfauhaminiconfpgsql9120120116
>
> Click on the "Save File" button in the bar...

Yes, that is it. Thank you for finding and sharing it :).

The developer's wiki page provides more up-to-date information for
pgsql RA after it has included to the upstream:
https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication

As for the configuration for heartbeat, documents from linux-ha.org might help:
http://www.linux-ha.org/doc/users-guide/_creating_an_initial_heartbeat_configuration.html

Regards,
Keisuke MORI

>
> On Aug 15, 2012, at 4:54 PM, DENNY, MICHAEL wrote:
>
>> Hi, Andrew. Where can I find the presentation by Keisuke? Btw, I use heartbeat in combo with pacemaker also...but with MySQL...was just a decision based on an impression at the time that most of the documentation content was about heartbeat...and that heartbeat had a more stability. And it seemed that there was nothing negative being posted that would deter me about the choice. After being on this distribution list for a while, I now think it's time for me to move to Corosync.
>>
>> - Mike
>>
>> -----Original Message-----
>> From: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] On Behalf Of Andrew Beekhof
>> Sent: Wednesday, August 15, 2012 7:40 PM
>> To: General Linux-HA mailing list
>> Subject: Re: [Linux-HA] Question about pacemaker + heartbeat + postgres in active/passive configuration
>>
>> On Wed, Aug 15, 2012 at 10:25 PM, Renee Riffee <riffee42 [at] gmail> wrote:
>>> Hello everyone,
>>>
>>> Apologies if this is not the correct group for this question, but I am seeking information on how to set up pacemaker with heartbeat and postgres in an active/passive streaming (pg 9.1) configuration. I would prefer to use heartbeat and not corosync, although most of the good tutorials like the Cluster_from_scratch document use corosync with pacemaker, but I don't have any shared storage to use it with on my machines.
>>>
>>> The presentation by Keisuke Mori of Linux-HA Japan is beautiful and exactly what I really want to do, but I need more information on how to use pacemaker with heartbeat instead of corosync.
>>
>> Assuming pacemaker was built with heartbeat support, simply install
>> heartbeat and add:
>>
>> crm respawn
>>
>> to ha.cf
>>
>> Start heartbeat, job done.
>> Resource configuration is unchanged from what you see in Clusters from Scratch
>>
>>> Does anyone know of a recipe or tutorial that goes through what his presentation shows?
>>>
>>> Kind regards,
>>> -Renee
>>>
>>>
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads