Wed Nov 17 15:17:24 PST 2004
- Previous message: [Slony1-general] Re: [Pgreplication-general] swithover script
- Next message: [Slony1-general] How to Rebuild after Failover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I am in the process of testing the Slony replication , I am replicating a table from Node 1 (master) to Node 2 (slave). In order to test the failover scenario, i ran the failover command on Node 2 (slave) and made Node 2 master now after running the failover command and also i ran the "drop node" command which will take out the Node 1 completely from replication. Now, I want to make Node 1 as master and make Node 2 as slave, assuming the Node 1 was offline while i was running the failover and drop commands on Node 2 , also assuming that some of the last transactions didnt get replicated over to Node 2. After few hours if the Node 1 comes up with all the data and everything is in place as it was before it went down. What should I do now ? do i have to drop all the table data even the data which was not replicated to Node 2 and take a backup from Node 2 restore on Node 1 and start the whole replication allover again with initializing cluster, running slon daemons and subscribing the replication sets ? or can I keep the table data on Node 1 as it is and start the replication allover again , will this keep my tables in sync with same data on both the nodes ? Thanks! Pallav
- Previous message: [Slony1-general] Re: [Pgreplication-general] swithover script
- Next message: [Slony1-general] How to Rebuild after Failover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list