Andrew, Then from what you said. Data within the tables between old master and new master will be different? then original master has all the data but now after failover Node 1 (original master ) got dropped and Node 2 is the new master. if node 2 don't have all the up-to-date data for ALL tables (from #12345 tables) then where does slaves getting data from?? This is the part where I want to get straight with.
Also, Node 2 the new master but originally the slave 1 has table set for 1 and 2. After failover which slave is the provider for table set 1 and 2 ??? Regard, Huang Andrew Sullivan-8 wrote: > > On Sun, Aug 23, 2009 at 10:59:13PM -0700, roctaiwan wrote: >> >> Hi Andrew, >> >> If I understand the slony replication correct, is that after I do >> switchover >> or failover what it can do is promote another node to replace its origin >> node. > > Hold on: switchover and failover are completely different. Failover > abandons the former origin. Switchover does not. Switchover is > intelligent about this, but failover just takes over at the new node > at whatever stage that node is in. This works on a _set_, and not on > the node as such. > >> If lets say failover, after origin node failed and another node >> replaced it, all other slave nodes in group will seek for sets from new >> master, basically failover script will change the "provider" from >> subscribe >> set command to the new master node. Therefore, new master should first >> sync >> with old master with all the data and having all sets isn't it? > > Not for failover, no. Switchover does this in a controlled manner, > and therefore moves the set at a logical point in time for that set. > >> Let's say Old master(node 1) has five tables (table 1,2,3,4,5) and new >> master (node 2) has only (table 1 and 2). After switch over or failover >> to >> the new master (node 2), will node 2 sync with old master and has all 5 >> tables? > > I don't think so, no. > > A > > -- > Andrew Sullivan > [email protected] > > -- View this message in context: http://www.nabble.com/How-exactly-replication-works-for-different-sets-on-different-nodes--tp25056529p25127095.html Sent from the Slony-I -- General mailing list archive at Nabble.com. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
