pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed9.2 Observer node for streaming replication
3+ messages / 2 participants
[nested] [flat]
* 9.2 Observer node for streaming replication
@ 2013-07-15 15:55 Jorge Torralba <jorge.torralba@gmail.com>
2013-07-15 16:15 ` Re: 9.2 Observer node for streaming replication Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jorge Torralba @ 2013-07-15 15:55 UTC (permalink / raw)
To: pgsql-admin
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?
--
Thanks,
Jorge Torralba
----------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 9.2 Observer node for streaming replication
2013-07-15 15:55 9.2 Observer node for streaming replication Jorge Torralba <jorge.torralba@gmail.com>
@ 2013-07-15 16:15 ` Joshua D. Drake <jd@commandprompt.com>
2013-07-15 16:38 ` Re: 9.2 Observer node for streaming replication Jorge Torralba <jorge.torralba@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joshua D. Drake @ 2013-07-15 16:15 UTC (permalink / raw)
To: Jorge Torralba <jorge.torralba@gmail.com>; +Cc: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 9.2 Observer node for streaming replication
2013-07-15 15:55 9.2 Observer node for streaming replication Jorge Torralba <jorge.torralba@gmail.com>
2013-07-15 16:15 ` Re: 9.2 Observer node for streaming replication Joshua D. Drake <jd@commandprompt.com>
@ 2013-07-15 16:38 ` Jorge Torralba <jorge.torralba@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jorge Torralba @ 2013-07-15 16:38 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: 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@commandprompt.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-07-15 16:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-15 15:55 9.2 Observer node for streaming replication Jorge Torralba <jorge.torralba@gmail.com>
2013-07-15 16:15 ` Joshua D. Drake <jd@commandprompt.com>
2013-07-15 16:38 ` Jorge Torralba <jorge.torralba@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox