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

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