Can you have a slave of a slave?
Basically set up
A --> B --> C
also
A --> D --> E
if A goes down, promote B which is protected by C
If B goes down, D is your protection for A
If C goes down, who cares.
It takes 5 machines, but would give great protection.
Evan.
Nicholson, Brad (Toronto, ON, CA) wrote:
*From:* pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] *On Behalf Of *Chris Hoover
*Sent:* Wednesday, December 07, 2011 12:05 PM
*To:* pgsql-admin@xxxxxxxxxxxxxx Admin
*Subject:* Question about multiple slaves and Master loss.
I'm pretty sure that the answer to this question is no, but I wanted to
verify.
Given the following scenario (pg 9.0):
Server A (Master), Server B (A's streaming replication Slave), Server C
(A's streaming replication Slave)
If you lose Server A, is there anyway to promote Server B to master and
keep Server C as B's slave without having to rebuild C from a backup of B?
Basically, I'd like to be able to have 2 slaves running so that when the
master goes down, we can bring one slave online, and still have the
ability to very quickly recover if the new master where to fail before
server A could be recovered.
Thanks,
Chris
Not that I am aware of. In practice though, C and B should me more or
less equivalent so as long as you are using a differential copy like
rsync you should be able to bring C up as a replica of B very quickly.
There is of course a small window though where you are not protected.
Brad.
--
Evan Rempel erempel@xxxxxxx
Senior Systems Administrator 250.721.7691
Unix Services, University Systems, University of Victoria
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
