On 12-06-20 12:28 PM, Raghav wrote:
> Hi Steve,
>
> Below is the scenario I want to achieve.
>
>
>                        Warm-Standby
> Master  ------------------------------------------------ DR-Master
>      |
>      |    Replication built on  Slony 2.1.
>      |
>     V
> Slave
>
> Given is actually setup of production, master/slave replication with log
> archive shipping using slony 2.1. And, Master with DR setup on same data
> center as DR-Master with Warm Standby configuration running fine with
> minimal lag.
>
> Q: What I want to achieve ?
> A:  Swap the Masters. Means, now slave should receive events from
> DR-Master once it get promoted to Master as shown below

Have you read 'Controlled Switchover' 
http://www.slony.info/documentation/2.1/failover.html

I think the MOVE SET command is what you want.

You setup 'DR Master' as a subscriber to your sets just like 'slave' 
was.  You then MOVE SET to make 'DR Master' the new origin.  'slave' 
will receive updates from 'DR Master' instead of 'Master' , assuming you 
have a complete path network in place.



>
>             Master   DR Master
>
>                  |            |
>                 X           |    Replication built on  Slony 2.1.
>
>                  |            |
>
>                 V            |
>
>             Slave <------|
>
>
> I believed, the DR-Master will have the same _slonyschema except the
> primary hostname. So, I have changed on both DR-Master & Slave of
> sl_path of primary hostname as fix.
> Assuming that, I have tested on my local box with below steps.
>
> 1. Stop slony between master,slave.
> 2. Take the _slonyschema dump of Master (In case any problem).
> 3. Promote the DR-Master.
> 4. update the _slonyschem.sl_path of column pa_conninfo with primary
> hostname on DR-Master & Slave.
> 5. Start slony daemons on DR-Master & Slave.
>
> Above steps won't work all the time, I did many times, very few times I
> could able to send events from DR-master to Slave with proper numbering
> of .SQL files.(log archives).
> I would request to recommend the correct procedure for swapping providers.
>
> --
> Regards
> Raghav
> Blog: htt://raghavt.blogspot.com/ <http://raghavt.blogspot.com/>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general