What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication:

1. Master-Master开发者_JS百科 replication.
2. Master, 1 Primary Slave, 1 Secondary slave.

I am planning to analyze these two approaches and prepare a comparison report with a recommendation.Currently, I have setup the replication environment using Master-Master replication.

Please provide me some pointers with details analysis.

---

I put together a long, canonical answer to general replication questions at Postgresql replication in rails with data-fabric gem

This being said the general advice is worth noting here again. Master-master replication is incredibly complex and requires that you think through conflict resolution to a very high level of detail. It may require programming to do that.

If at all possible go with master-slave. Many solutions may "just work" here. Master-master can never be guaranteed to "just work." It requires a lot of additional complexity to make it work the way you want it to.