Hi Pushkar, 1. How does the initial data sync of node3 with node2 takes place? 2. For node3 and replication data to/from node2, does node2 needs a restart or it is not required?
Have you looked at? https://wiki.postgresql.org/wiki/BDR_Administration HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2015-03-17 10:01 GMT+01:00 Deole, Pushkar (Pushkar) <pde...@avaya.com>: > Hi, > > > > I just tried a POC with PostgreSQL’s streaming replication for the use > case of my product. Since streaming replication is master-slave, when > failover occurs there are some configuration changes required to promote > slave to master. Also, my requirement is to failback to old master again > after the old master is started back (i.e. when old master is started back, > it should become the master rather than the slave), which is bit tricky and > is not straight forward to achieve without restarting any of the nodes. > > > > I am also evaluating BDR which is asynchronous master-master replication. > Since both nodes will be master, I don’t need to worry about promoting > slave to master etc. However, I have a query regarding adding a new node to > the BDR. Suppose I have a BDR setup done with 2 nodes (Node1 and Node2). > Let’s assume node1 goes down. Node2 is up and running. I now add a new node > say node3 and setup BDR with node2. > > In this scenario… > > 1. How does the initial data sync of node3 with node2 takes place? > > 2. For node3 and replication data to/from node2, does node2 needs a > restart or it is not required? > > > > I would appreciate if you can give any information on this scenario as > that would give me an understanding of BDR. I would be trying a POC soon > however not able to find time since stuck up with another task at the > moment. > > > > Thanks a lot… > > Pushkar >
