MySQL Forums
Forum List  »  Replication

Multi-Master Replication
Posted by: Sabine Miehlbradt
Date: February 02, 2011 01:42AM

I want to set up replication to deploy data to and from a central store.

In one direction it is one master and multiple slaves. The slaves will not have to write those tables so there is no risk of conflicts.

In the other direction it is multiple masters returning data to the store. That can be done with separate tables or even DBs for each node so there is again no risk of conflicts.

Can this be done in mysql? The docs say it isn't but this forum seems to indicate multi-master is indeed possible.

I was thinking about going PostgreSQL for this, since I'm afraid Oracle will kill MySQL for anything but the most trivial of applications.

Options: ReplyQuote


Subject
Views
Written By
Posted
Multi-Master Replication
3204
February 02, 2011 01:42AM
1893
February 05, 2011 07:39PM
978
April 20, 2011 07:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.