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@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
