0

we have two approaches to achieve DB Replication:

  1. Master-Master 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.

vijay.shad
  • 2,444
  • 6
  • 27
  • 33
  • You might target www.serverfault.com for this. You stand a greater chance of getting this particular question answered there, IMO. – Jagmag Dec 03 '10 at 03:06
  • Is this a question anyways? I would like to see how much locking affects the performance. – chris polzer Mar 26 '11 at 00:28

1 Answers1

0

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.

Community
  • 1
  • 1
Chris Travers
  • 25,424
  • 6
  • 65
  • 182