MySQL Forums
Forum List  »  Replication

Re: Multiple masters to single slave
Posted by: Lee Wood
Date: April 07, 2009 05:58PM

You might be able to achieve what you want by using confederated tables. i.e. multiple "master" servers, each with table "A" defined as a confederate of table "A" on the "slave". (NB If the table-in-question contains an auto_increment column, you will need to ensure that each of those "masters" avoid auto-increment collisions, by giving them each a different offset, as one would with circular replication.)

Options: ReplyQuote


Subject
Views
Written By
Posted
8463
December 12, 2008 09:37AM
4239
December 19, 2008 12:30AM
3813
March 02, 2009 05:57PM
Re: Multiple masters to single slave
3840
April 07, 2009 05:58PM
8533
April 07, 2009 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.