[chef] Re: Re: postgres master/slave replication and failover to hot standby

[Matt Ray < >]

If you're interested in a corosync/pacemaker cookbook I started (but
have yet to finish), here you go:
https://github.com/mattray/barclamp_ha_service/tree/pacemaker_service/chef/cookbooks/pacemaker

It installs pacemaker and configures the master/server, it just
doesn't actually manage the services yet. I wanted to get fancy and
let Chef think it was still managing services even when Pacemaker was
managing them, but I got a little blocked and other stuff took
precedence. Even though it's in a Crowbar barclamp, I was testing it
with just Chef and hadn't touched the other Crowbar stuff (so just
grab that cookbook). There's also an existing drbd cookbook that works
on the community site.

Thanks,
Matt Ray
Senior Technical Evangelist | Opscode Inc.

 
 | (512) 731-2218
Twitter, IRC, GitHub: mattray



On Mon, Jan 23, 2012 at 7:46 PM, Adam Jacob 
<
 >
 wrote:
> Think about using traditional HA tools, like Heartbeat/Corosync and
> Pacemaker to do the actual promotion. No need to re-invent the wheel.
>
> Adam
>
> ---
> Opscode, Inc.
> Adam Jacob, Chief Customer Officer
> T: (206) 619-7151 E: 
> 
 
>
> On Jan 22, 2012, at 11:30 PM, Bryan Berry wrote:
>
> I am starting to work on master/slave streaming replication for postgres,
> based on the database cookbook
> https://github.com/opscode/cookbooks/tree/master/database
>
> Please note that I am a total n00b to postgres.
>
> I have to figure out to manage failover from master to slave. I imagine that
> I can do it w/ some kind of script to check whether master is available or
> not, then promote a slave. However, then I have make sure that a promoted
> slave is not demoted on the next chef run.
>
> If anyone has experience w/ these issues, I would much appreciate your
> advice.
>
> If anyone is working on a similar cookbook or has already written something
> that fulfills my requirements, please let know!
>
> Cheers
>
> BryanWB
>
>
>
>
>