Re: 9.2 Observer node for streaming replication

From: Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 9.2 Observer node for streaming replication
Date: 2013-07-15 16:38:11
Message-ID: CACut7uQ=2dv1F9pZ1bjm1xEiwhFn9DjMq=K5zHt-x_7jtRObHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joshua,

We are running centos 6.2. Could you provide some insight or point in the
direction of your methodology for such implementation?

Thanks

JT

On Mon, Jul 15, 2013 at 9:15 AM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

>
> On 7/15/2013 8:55 AM, Jorge Torralba wrote:
>
>> I have a master and a slave running streaming replication between the two
>> servers. I would like to setup some kind of third machine to play the role
>> of observer node to monitor the replication and do the automatic fail over.
>> However, I can't find any documentation or suggestions on such an
>> implementation. Is it possible to do with 9.2.4 or will I need to rely on
>> some sort of F5 load balancer to handle the auto failover?
>>
>
> Depends on your OS. We do this all the time with our HAC setups and we
> don't need any kind of load balancer to pull it off.
>
> JD
>
>

--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and
delete the copy you received. Thank You.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sergey Konoplev 2013-07-15 16:52:59 Re: pg_upgrade (9.1 to 9.2) bombing on casts
Previous Message Joshua D. Drake 2013-07-15 16:15:44 Re: 9.2 Observer node for streaming replication