Teaching Slony replication to select slave nodes
2
votes
2
answers
338
views
There is a system with up to 256 nodes in db cluster. We need to replicate some data from one of them across to all others. But for every row to replicate there is a list of nodes where it must be replicated while on other nodes same row becomes orphan without one of parent table keys. To filter them out, or to prevent them from replicating needlessly, I'm trying to find a way to teach Slony to select nodes for replication however can't find such feature readily available. Has anyone tried it (customizing source code of its functions, etc.)?
_id,_text,_nodes
----------------
1 'one' {1,101}
2 'two' {2,102}
256 '...' {0,256}
Row id=1 is then replicated to node 1 and 101, etc.
Similar discussion https://dba.stackexchange.com/questions/20616/replicating-only-significant-records-to-specific-database however doesn't point in the right direction yet.
Asked by Gonki
(121 rep)
Oct 4, 2012, 06:48 AM
Last activity: Dec 6, 2012, 02:47 PM
Last activity: Dec 6, 2012, 02:47 PM